Become an Excel Expert in Less Than 20 Hours – Complete Excel Course Beginner to Expert

Do you want to learn:
• the basics of Excel spreadsheets
• how to navigate Excel
• how to print Excel files
• how to do math calculations in Excel
• how to use formatting to highlight key points
• how to connect to data from different sources including databases, text, websites, stocks, geographical information
• how to create dynamic Excel charts which automatically expand when new data is included
• how to use array formula
• how to restrict user permissions by adding security and protection
• how to use keyboard shortcuts to save time
• how to use Excel functions and formulas
• how to create tables, pivottables and pivotcharts
• how to customise the look and feel of spreadsheets
• how to use templates and ad-ins

This Excel course is suitable even for complete beginners. There is video specifically for people who have never used Excel before. But this does not mean that this course is not suited for advance users. This online class covers everything, including the most advanced formulas and features. There are plenty of examples to help you every step of the way.

Course Contents

  1. Fundamentals
  2. Formatting
  3. Working with Data
  4. Formulas & Functions
  5. Pivottables
  6. Charts
  7. Print, Page Set & View
  8. Proofing, Sharing & Protection
  9. Shortcuts
  10. Other Useful Tips
  11. File, Ribbon & Quick Access Toolbar

The whole course consist of 120 videos which are 19 hours long, and all course materials are available for download.

Here are more descriptions of the course content:

  1. Fundamentals
    • Excel for Complete Beginners
    • Basic Math
    • Referencing Cells
    • Fixed & Relative Cell References
  2. Formating
    • Formatting Basics
    • Number Formatting
    • Custom Formatting
    • Cell Styles
    • Conditional Formatting
  3. Working with Data
    • Sorting
    • Filtering
    • Advance Filter
    • Hiding, Grouping & Subtotals
    • Text to Columns
    • Flash Fill
    • Data Validation
    • Connecting to an External Workbook
    • Connecting to a Text File
    • Connecting to a Website
    • Stocks & Geography
    • Data Tables
    • Forecasting
    • Name Ranges
    • Booleans
  4. Formulas & Functions
    • Logical Functions
    • Errors
    • INDIRECT
    • Basic Functions on Ranges
    • OFFSET
    • SUM/COUNT/AVERAGE IF(S)
    • SUMPRODUCT
    • More Math Functions
    • More Text Functions
    • VLOOKUP, HLOOKUP & LOOKUP
    • INDEX & MATCH
    • Formula Auditing & Formula Ribbon Tab
    • Date & Time Functions
    • SUBTOTAL & AGGREGATE
    • CHOOSE
    • FREQUENCY
    • Financial Functions
    • Array Formulas
  5. Pivottables
    • Pivotable Examples
    • Manual Sort, Multible Filter & Pivottable Options
    • Drill Down
    • Conditional Formatting in Pivottables
    • Grouping Dates
    • Slicers
    • Analyse & Design
    • Calculated Fields
    • GETPIVOTDATA Formula
    • Pivotcharts
    • Powerpivot
  6. Charts
    • Dynamic Chart Ranges
    • Column vs Bar Charts
    • Line Charts
    • Pie Charts
    • Scatter & Bubble Charts
    • Histogram



Scroll Up