Module 1: Exploring Microsoft Excel
1.1. Looking at the Excel Screen
1.2. Working with the Tab and Ribbon
1.3. Using Quick Access Toolbar
1.4. Changing the Workbook Views
1.5. Using Zoom In and Zoom Out
1.6. Customizing the Status Bar
1.7. Using the Excel Online Help
1.8. Using “Tell Me” Feature
1.9. Using Insight Feature
Module 2: Navigating on the Worksheet
2.1. Understanding Mouse Symbols
2.2. Moving Around the Worksheet
2.3. Selecting Cells and Ranges
2.4. Using the Name Box
2.5. Navigate and Select Range using the Name Box
2.6. Navigate and Select using the Go To Command
2.7. Using Go To Special Dialog Box
Module 3: Creating and Saving Workbook
3.1. Entering data on Worksheet
3.2. Saving Workbook in Different Formats
3.3. Creating a New Workbook from Template
3.4. Creating and Saving Custom Template
Module 4: Modifying Worksheet
4.1. Adjusting Column Width and Row Height
4.2. Adding Cells, Rows, Columns and Sheets
4.3. Deleting Cells, Rows, Columns and Sheets
4.4. Copy & Move Columns and Rows
4.5. Add, Delete and Rename Worksheets
4.6. Move or Copy Worksheet
4.7. Hide and Unhide Worksheets
4.8. Hide & Unhide Columns and Rows
4.9. Changing Worksheet Tab Color
Module 5: Using Formulas and Basic Functions
5.1. Creating and Editing Formulas
5.2. Evaluate Formulas
5.3. Using Common Functions
5.4. Using Relative and Absolute References
5.5. Using Mixed References
5.6. Copying Formulas with Paste Options
5.7. Auto Fill Formulas
5.8. Exploring Excel Error Messages
Module 6: Formatting the Worksheets
6.1. Changing Font and Font Size
6.2. Applying Cell Borders and Colors
6.3. Formatting Numbers
6.4. Changing Cell Alignment
6.5. Merge and Unmerge Cells
6.6. Replacing Text and Formats
6.7. Applying Cell Styles and Themes
Module 7: Printing the Worksheets
7.1. Setting Margins
7.2. Changing Page Orientation
7.3. Selecting Paper Size
7.4. Setting Print Area
7.5. Printing Titles
7.6. Inserting Header & Footer
7.7. Using Page Breaks Preview
7.8. The Print Tab in Backstage View