Introduction to Microsoft Excel
  • Introduction
  • 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
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
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?
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
  • Excel Shortcuts for Mac
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
  • TODAY and NOW
  • CONDITIONAL FORMATTING
  • ALT Shortcut Keys for INDEX/MATCH Lecture
  • INDEX and MATCH
  • UPPER, LOWER, and PROPER
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
Importing Data from Other Sources
  • Import from Web, Copy/Paste, and Cleaning Up Data
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
Excel Quick Tips and Tricks
  • Flash Fill and Auto Fill for Fast Data Entry
  • Shortcut Keystrokes for Working Faster
  • Paste Special for Better Pasting
  • Laying Out Pages and Printing
  • Find and Delete Empty Cells Located Outside of Your Data
  • Use the Power of Tables
Conclusion
  • Conclusion
  • Learn More - Other Courses by Steve McDonald (bonus lecture)