Excel Essentials and Formulas Course
Course Content for Excel Part 1
Module 1: Getting Started with Excel 2016
- Navigate the Excel User Interface
- Use Excel Commands
- Create and Save a Basic Workbook
- Enter and Edit Cell Data
- Fill Cells with Series of Data (fill handle)
Module 2: Performing Calculations
- Create Worksheet Formulas
- Insert Functions and use Autocomplete
- Reuse Formulas and Functions
- Create an Absolute Reference
Module 3: Modifying a Worksheet
- Insert, Delete, and Adjust Cells, Columns, and Rows
- Move and Copy Data between Cells
- Search for and Replace Data • Use Spellcheck and Proofing
Module 4: Formatting a Worksheet
- Apply Text Formats
- Apply Number Formats
- Align Cell Contents
- Apply Cell Styles
Module 5: Printing Workbooks
- Preview and Print a Workbook
- Controlling Page Layout
- Adding Headers and Footers
- Set Print Titles and Print Ranges
Module 6: Managing Workbooks
- Manage Worksheets
- Insert and Delete Worksheets
- Worksheet Views (freeze pane)
This course will run on the 6th February 2020
Subsidised Cost €140 which is more than 50% less than RRP
