Modules – Intermediate Excel 2016

Module 1
​1.1 Formatting Numbers – Practice Exercise 1
1.2 How Excel Processes Large Numbers
1.3 Format Cells – Number Tab
​1.4 Format Cells – Alignment Tab – Practice Exercises 2-4
1.5 Format Cells – Font Tab – Practice Exercise 5
1.6 Format Cells – Border Tab – Practice Exercise 6
1.7 Format Cells – Fill Tab – Practice Exercise 7
1.8 Format Cells – Protection Tab – Practice Exercise 8

​Module 2
2.1 How Table Differs From a Range of Cells
2.2 Creating a Table Using a Range of Data – Practice Exercise 9
2.3 Customizing a Table Using the Total Row Feature – Practice Exercise 10
2.4 Customizing a Table Using Formulas in Tables – Practice Exercise 11
2.5 Customizing a Table – Creating Names Using Name Box – Practice Exercise 12
2.6 Customizing a Table – Edit Names Using Name Manager – Practice Exercise 13
2.7 Customizing a Table – Using the Name Manager – Practice Exercise 14
2.8 Sorting a Table
2.9 Sorting a Table – Using Filter Buttons to Sort a Table – Practice Exercise 15
2.10 Sorting a Table – Using a Custom Sort to Sort a Table – Practice Exercise 16
2.11 Filtering a Table – Practice Exercise 17

Module 3
​3.1 Chart Basics
3.2 Create a Chart – Practice Exercise 18
3.3 Customize a Chart – Practice Exercise 19 – 22

Module 4
4.1 Determining Pivot Table Need – Create a Pivot Table – Practice Exercise 23
4.2 Customize a Pivot Table by Applying Filtering – Practice Exercise 24
4.3 Customize a Pivot Table by Changing the Form Type – Practice Exercise 25
4.4 Customize a Pivot Table by Changing Value Field Settings and Format Numbers to Currency – Practice Exercise 26
4.5 Customize a Pivot Table by Preparing it For Printing – Practice Exercise 27