Module 1
1.1 Definitions, Birth and Evolution of the Electronic Spreadsheet
1.2 Open XML Format and Filename Extensions
Module 2
2.1 Excel Start Options
2.2 The Backstage View
2.2.1 Excel Options Dialog Box
2.3 Exploring the Excel Worksheet Screen
2.4 The Ribbon
2.5 Contextual tabs; Customizing the Ribbon
2.2 The Backstage View
2.2.1 Excel Options Dialog Box
2.3 Exploring the Excel Worksheet Screen
2.4 The Ribbon
2.5 Contextual tabs; Customizing the Ribbon
Module 33.1 Important Excel Specifications |
Module 4
4.1 Basic Navigation in an Excel Worksheet – Practice Exercise 1
4.2 Basic Data Entry & Editing in an Excel Worksheet – Practice Exercise 2
4.2.1 Column Width/Row Height Adjustments – Practice Exercise 3 and 4
4.2.2 Inserting and Deleting Columns & Rows – Practice Exercise 5 and 6
4.3 Apply Formatting Controls to Worksheet Data – Practice Exercise 7
4.4 Use Formulas with AutoFill & AutoSum Features – Practice Exercise 8
4.4.1 Use Absolute Referencing to Calculate – Practice Exercise 9
4.1 Basic Navigation in an Excel Worksheet – Practice Exercise 1
4.2 Basic Data Entry & Editing in an Excel Worksheet – Practice Exercise 2
4.2.1 Column Width/Row Height Adjustments – Practice Exercise 3 and 4
4.2.2 Inserting and Deleting Columns & Rows – Practice Exercise 5 and 6
4.3 Apply Formatting Controls to Worksheet Data – Practice Exercise 7
4.4 Use Formulas with AutoFill & AutoSum Features – Practice Exercise 8
4.4.1 Use Absolute Referencing to Calculate – Practice Exercise 9
Module 5
5.1 Creating a Chart – Practice Exercise 10
5.2 Formatting Numbers – Practice Exercise 11
5.3 Saving Your Workbook – Practice Exercise 12
5.4 Add a Header/Footer to a Worksheet – Practice Exercise 13
5.5 Preparing a Workbook for Printing – Practice Exercise 14
5.1 Creating a Chart – Practice Exercise 10
5.2 Formatting Numbers – Practice Exercise 11
5.3 Saving Your Workbook – Practice Exercise 12
5.4 Add a Header/Footer to a Worksheet – Practice Exercise 13
5.5 Preparing a Workbook for Printing – Practice Exercise 14
To begin the course, go to Module 1, Section 1.1 Definitions, Birth and Evolution of the Electronic Spreadsheet