Module 1: Getting Started with Microsoft Excel - Identifying Worksheet Terms
- Starting Microsoft Excel
- Navigating Spreadsheets
- Closing Workbooks
- Entering Data in a New Worksheet
- Opening a New Workbook and Entering Data
- Saving the Worksheet
- Getting Help
Module 2: Changing the Look of the Worksheet - Modifying the Worksheet
- Copying and Moving Cell Contents
- Using AutoFill
Module 3: Working with Formulas - Creating and Using Formulas
- Entering Formulas into a Worksheet
- Using AutoFill to Copy Formulas
- Using Absolute Cell References
- Changing a Relative Cell Reference to an Absolute Cell Reference
Zrece hotel bookingModule 4: Working with Functions - Creating and Using Functions
- Using AutoSum
- Using Functions to Compare Cell Values
- Using the Paste Function Command
| Module 5: Formatting Data - Formatting Text, Numbers, and Cells
- Applying Text Formatting
- Copying Formats to Other Cells
- Changing Number Formatting
- Formatting the Worksheet
Module 6: Creating Charts - Creating a Chart
- Creating Charts in a Worksheet
- Modifying Charts
- Formatting Chart Elements
- Changing the Chart Type
Module 7: Working with Workbooks - Rearranging the Workbook
- Inserting Deleting, Renaming, and Moving Worksheets
- Using Multiple Worksheets to Record Related Data
- Creating Formulas on Multiple Worksheets
- Formatting Multiple Worksheets
Module 8: Modifying Page Formatting - Changing Page Setup
- Modifying Page Setup Settings
- Modifying Headers and Footers
|
