Midlands Microsoft Office Provider

Modules – Intro to Excel 2016

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

Module 3

3.1 Important Excel Specifications
3.2 Mouse Symbols in Excel
3.3 Quick Access Toolbar
3.3.1 The Mini Toolbar
  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
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

​

To begin the course, go to Module 1, Section 1.1 Definitions, Birth and Evolution of the Electronic Spreadsheet