Introduction to Microsoft Excel
- What is Excel?
- Excel File Types
- Excel Environment
- Toolbars
- Office Assistant
Workbooks and Worksheets
- Creating and Opening Workbooks
- Working with Workbooks
- Working with Worksheets
- Working with Cells
- Navigating within a Worksheet
- Navigating the Workbook
|
Spreadsheet Data
- Entering Data
- Using Time Saving Features
- Checking the Spelling
Formatting and Customising Data
- Selecting Items in Excel
- Formatting Text
- Formatting Numbers
- Manipulating Data
- Formatting Columns and Rows
- Formatting with Colours and Patterns
- Adding and Editing Borders
- Using Autoformat
|
Editing Spreadsheets
- Cutting, Copying, and Pasting
- Inserting and Deleting
- Using Find and Replace
- Using Undo and Redo
Formulas and Functions
- Entering Formulas
- Entering Functions
- Using Named Cells and Ranges in Formulas
Printing
- Using Page Setup
- Margins
- Headers and Footers
- Printing a Spreadsheet
|
