Module 1: Getting started with Excel
- What is Microsoft Excel?
- Excel and the Excel environment
- Navigating and selecting cells in worksheets
- Creating a new workbook
- Saving your work
- Opening and closing workbooks
- Using Help
Module 2: Modifying a worksheet
- Cut, Copy and Paste commands
- Undo and Redo commands
- Using AutoFill
- Working with rows and columns
- Find and Replace
- Performing a spell check
Module 3: Creating calculations with formulas and functions
- Creating formulas
- AutoCalculate
- Inserting functions and using AutoSum
- Using functions to round values
- Copying a formula
- Creating an Absolute formula
- Dynamic array formulas
Module 4: Formatting an Excel worksheet
- Text formatting
- Add borders and colours to cells
- Cell alignment
- Number formatting
- Format Painter
- Cell styles and galleries
Module 5: Working with data lists
- Creating an effective list
- Applying basic sorting
- Applying basic filters
Module 6: Managing worksheets and workbooks
- Managing Worksheets
- Freezing rows and columns
- Splitting the screen
- Arrange All command
- View Side by Side