Welcome To Our Microsoft Excel 2016 Master Class Course: Beginner To Advanced
  • Welcome To Our Course! Learn All of The Benefits Using Microsoft Excel Today!
  • Getting Started: How To Use This Course To Gain The Maximum For Our Teachings!
  • Bruce's Introduction: Getting Started with Microsoft Excel
Worksheet Basics
  • The Parts of the Excel Screen
  • The Worksheet - What Is It?
  • Navigating Worksheets with Ctrl+Arrow Keys
  • Multiple Worksheets
  • The Ribbon - How Does It Work?
  • Saving and Opening Files
  • Worksheet Basics Quiz
Manipulating Columns and Rows
  • Resizing Columns and Rows
  • Inserting, Deleting, Hiding and Unhiding Columns and Rows
  • Columns and Rows Quiz
Entering Data
  • Entering Text
  • Editing Data
  • Undoing Changes
  • Excel Data Entry Helps
  • Entering Numbers
  • Entering Dates
  • Entering Symbols
  • Entering and Editing Data Quiz
Selecting Cells and Ranges
  • Basic Selecting With The Mouse
  • Basic Selecting With The Keyboard
  • The Extend Key
  • Selecting Cells and Ranges Quiz
Formulas
  • Basic Formulas
  • Rule of Order
  • Formulas on Dates
  • Formulas with Text
  • Multi-Sheet Formulas
  • Formulas Quiz
Copying and Moving
  • Copy Cells or Ranges
  • Move Cells or Ranges
  • Copy or Move Columns and Rows
  • Copying Formulas and Absolute References
  • Using the Clipboard Task Panel
  • Move or Copy Sheets
  • Copying and Moving Quiz
The Fill Handle
  • Fill Handle Basics
  • How to Use Fill Series
  • Custom Fill Series
  • The Fill Handle Quiz
Naming Ranges
  • Overview of Naming Ranges
  • Multi-Sheet Range Names
  • Using Range Names Like Bookmarks
  • Naming Ranges Quiz
Functions
  • SUM - The Most Popular Function
  • Intro to the Quick Analysis Tool
  • The IF Function
  • Multiple Criteria in an If Statement
  • VLookup 1 - Simple Example
  • VLookup 2 - Match Within a Range
  • Vlookup 3 - Intro to Data Validation Lists
  • Vlookup 4 - Multiple VLookups Using the Validation List
  • More Functions
  • Proper, Round and Other Functions
  • Functions Quiz
Formatting Worksheet Contents
  • Basic Formatting
  • Background Fill, Patterns and Effects
  • Aligning of Cell Contents
  • Borders
  • Formatting Numbers
  • Custom Number Formats
  • Custom Number Format Exercise
  • Date Formats
  • Time Formats
  • Conditional Formatting 1
  • Conditional Formatting 2
  • Formatting Quiz
Table Filters and KEYBOARD SHORTCUTS
  • Format a Table and Use Filters
  • Using Data Slicers
  • Table Filters Quiz
Bringing It All Together PRINT Exercise
  • Looking at the Task and Getting Started
  • Use Quick Analysis and Angle Alignment on Titles
  • Create Combined Name Column and Change Margins
  • Create 6 Month Totals and Adjust Column Widths
  • Modify Print Titles and add Header and Footer
  • Final Adjustments and Print Preview
  • Print Exercise Quiz
Payment Function and What If Analysis
  • Using the PMT Function
  • Using GOAL SEEK
  • Using the SCENARIO MANAGER
  • Using 1 and 2 Variable Data Tables
  • What If Quiz
Finding and Fixing Errors
  • Using Error Checking