Introduction to the Course
  • Excel 2016 Introduction - What You'll Learn in the Course
  • How to Get the Most Out of This Course
  • Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon
  • Using Excel Templates to Save Time and Effort
  • Test Your Knowledge
Creating Your First Excel Document
  • Saving Your Document Where You Can Find It
  • Entering Data and Navagating Around the Cells
  • Creating Simple Formulas to Do Powerful Calculations
  • Working with Workbooks and Worksheets
  • Put Your Knowledge to Work - Create Your First Excel Document
Create a Kitchen Remodel Cost Worksheet
  • Introduction - Creating and Formatting Your Heading
  • Formatting Subheadings and Columns and Alphabetizings Lists
  • Entering and Formatting Numbers
  • Create Formulas to Quickly Calculate Your Costs
  • Formatting - Grids and Spacing
  • Test Your Knowledge
Introduction to Excel Formulas and Functions
  • Introduction to Excel Formulas and Functions
  • What is a Formula and What Can It DO for You?
  • What is a Function and What Does IT Do?
  • Test Your Knowledge
3 Things to Know Before You Start Using Functions
  • The Anatomy of a Formula
  • Quickly Select Cells to Use in Your Formula
  • Absolute vs. Relative Cell References
  • Test Your Knowledge
How to Use the 7 Most Popular Excel Functions
  • How to Use the Downloads to Learn Functions Faster
  • AVERAGE and AVERAGEA Functions
  • COUNT, COUNTA and COUNTBLANK Functions
  • IF Functions
  • SUMIF and SUMIFS Functions
  • COUNTIF and COUNTIFS Functions
  • VLOOKUP Function
  • LEFT, RIGHT and MID Functions
Other Popular Excel Functions
  • CONCATENATE - Combining Text
  • LEN - Length of Text
  • FIND and SEARCH
  • MIN and MAX
  • AND and OR
  • ROUND, CEILING and FLOOR
  • Conditional Formatting
Creating Charts From Your Spreadsheet
  • Charts Download
  • Introduction - How to Create a Chart
  • Format Your Chart
  • Create a Bar Chart
  • Create a Pie Chart
  • Create a Line Chart
Pivot Tables and Pivot Charts
  • Pivot Tables Download
  • Introduction to Pivot Tables - Preparing Your Data
  • How to Create a Pivot Table
  • Put Your Pivot Table to Work
  • Pivot Charts Download
  • Pivot Charts
New Features for Excel 2016
  • What's New in Excel 2016?
  • 6 New Chart Types for 2016
  • "Tell Me What You Want To Do" - The New Help Feature
  • 1-Click Forecasting
  • 3D Maps
Saving Your Work
  • Saving as CSV, Text and PDF
  • Saving Backups of Your Excel Files
  • Using the AutoRecover Feature
Importing and Printing Your Work
  • Import from Web, Copy/Paste, and Cleaning Up Data
  • Import from CSV file and Excel Workbook
  • Import from Access Database
  • Print Your Excel Document
Keyboard Shortcuts
  • Excel Keyboard Shortcuts
  • ALT Key Shortcuts
TEXT Functions in Excel
  • TEXT
  • REPT - Repeat
  • UPPER, LOWER and PROPER
  • TRIM - Remove Extra Spaces
  • Combining LEFT, MID, FIND and TRIM
  • HYPERLINK - Create a Table of Contents for Your Worksheets
MATH Functions
  • RAND and RANDBETWEEN - Random Numbers
  • ROUND
  • INT - Integer
  • MOD - Remainder
DATE and TIME Functions
  • DATE and DATEVALUE
  • TIME
  • TODAY and NOW
  • YEAR, MONTH, DAY, HOUR, MINUTE and SECOND
  • WEEKDAY and WEEKNUM
LOGIC Functions
  • IFERROR
  • LARGE and SMALL
Nested Functions