Microsoft Excel Masterclass

Create a Workbook in Microsoft Excel

• Start a Microsoft Excel
• Create a Workbook
• Save a Workbook
• Describe the Status Bar
• Add and Delete Worksheets
• Copy and Move Worksheets
• Transform the Order of Worksheets
• Split the Worksheet Window
• Close a Workbook

Work with the Backstage View (The File Menu)

• Overview of the Backstage View
• Open a Workbook
• Select, Open and Save a Template
• Explore new Workbooks and Excel Templates
• Print Worksheets
• Add your Name to Microsoft Excel
• Personalize your Copy
• Manage Workbook Versions

Enter Data in Microsoft Excel Worksheets

• Enter Text
• Expand Data across Columns
• Add and Delete Cells in Worksheets
• Enter Numbers and Dates
• Add a Hyperlink
• Add an Outline
• Add WordArt to a Worksheet
• Use AutoComplete
• Use the Fill Handle

Work with Rows and Columns

• Insert lesson titles in a bulleted list
• Add Rows and Columns
• Delete Rows and Columns
• Change Row Height and Column Width
• Transpose Rows and Columns
• Hide and Unhide Rows and Columns
• Freeze Panes

Format Microsoft Excel Worksheets

• Hide Worksheets
• Add Color to Worksheet Tabs
• Add a Watermark
• Add Themes to Workbooks
• Add Borders to Cells
• The Font Group
• Change Font and Font Size
• The Alignment Group
• Wrap and Indent Text
• Merge and Center Text
• The Number Group
• Change Date Formats
• Change Number Formats

Create Pivot Tables

• Create Pivot Tables
• Amend the Fields in a PivotTable
• Work with Pivot Tables
• Format Pivot Tables
• Add Calculations to a PivotTable
• Create Pivot Charts
• Add Grouping to a PivotTable
• Insert Slicers
• PivotTable Timelines
• More Pivot Table Functionality
• Create PivotTables from Tables and Related Tables

Create Macros

• Create a Macro
• Compare Relative and Absolute Macros
• Assign Shortcuts to Macros
• Macro Security
• Enable Macros in the Backstage View
• Copy a Macro between Workbooks
• Describe Document Properties and the Document Inspector

Advanced Lookup and Reference Functions

• GETPIVOTDATA
• MATCH
• INDIRECT
• ROW / COLUMN
• INDEX
• VLOOKUP
• OFFSET
• LOOKUP (Array format)
• LOOKUP (Vector format)

Array Functions

• Define an Array Formula
• Understand Array Functions
• FREQUENCY
• Define Single Cell or Multiple Cell Arrays
• Single Cell Array Functions
• Multiple Cell Array Functions TRANSPOSE