This is for demonstration purpose. We can always customize the contents based on student requirement

1 -Course Introduction

11 -Pasting Values, Formulas and Formats with Paste Special

21 -Learn How to Assign Dynamic Names within a Model

31 -Excel 2016 Functions

41 -Excel's Dynamic & Interactive Tables: Pivot Tables

2 -A Quick Introduction to the Basics of Excel

12 -Excel Best Practices: Useful Tips & Tools

22 -Excel Formulas that Make Sense - Named Ranges

32 -Key Functions in Excel: Count, Counta, Countif, Countifs

42 -Create Flexible Financial Models with the Choose Function

3 -Overview of Excel 2016

13 -This Is How You Can Start Formatting Your Sheets in a Professional Way

23 -Assigning Custom Formats to Specific Cells (Ex. Multiples)

33 -Key Functions in Excel: Sum, Sumif, Sumifs

43 -Find the Result that You Are Looking For with Goal Seek

4 -The Excel 2016 Ribbon

14 -Fast Scrolling That Would Allow You to Be 3x Faster

24 -Execute 50 Commands with a Single Click - Excel Macros

34 -Key Excel Functions: Average & Averageif

44 -Include Sensitivity Analysis In Your Model Through Data Tables

5 -Working with Rows & Columns

15 -Fixing Cell References Properly

25 -Create a Drop-Down List by Using Data Validation

35 -Working with Text in Excel: Left, Right, Mid, Upper, Lower, Proper, Co

45 -Create Professional Charts in Microsoft Excel 2016

6 -Data Entry in Excel

16 -Using the Alt plus Enter combination

26 -Using Custom Sort in Order to Sort Multiple Columns within a Table

36 -Find the Highest and the Lowest Values in a Range: Max & Min

46 -Introduction to Charts in Excel 2016

7 -Introduction to Formatting

17 -Learn How to Organize Your Excel Data with Text to Columns

27 -Create a Great Index Page at the Beginning of Your Financial Models

37 -Include Round in Your Financial Models

47 -Inserting Charts in Excel & Learning About the Various Chart Types

8 -Creating Formulas in Excel

18 -Wrapping Text in Excel

28 -Freeze the Title Row of Your Table - Freeze Panes

38 -Transferring Data Efficiently: Vlookup & Hlookup

48 -Formatting of Excel Charts

9 -Microsoft Excel at Its Best - Functions

19 -Create Easily Printable Documents by Using Set Print Area

29 -Excel's "Tell Me" Search Bar

39 -Use Index & Match as a Substitute of Vlookup

49 -Creating a Bridge Chart in Excel 2016 - As Easy As It Gets

10 -Work Efficiently By Using Cut, Copy & Paste

20 -Find and Select Special Types of Cells with Select Special (F5)

30 -Keyboard Shortcuts in Excel

40 -Iferror Allows You to Deal Easily with Error Mesages

50 -An Easy Way to Create a Treemap and Sparkline