What's included

  • 15+ Hours of Lessons

    Watch over 15 hours of step-by-step video lessons where I will show you everything you need to know about using excel. Using the downloadable excel files you will be able to follow along at the same time.

  • Certificate of Completion

    Boost your resume! Upon completion of the Excel Mastery you will receive a certificate certifying that you have advanced knowledge of Microsoft Excel.

  • Mac Users Welcome

    I will discuss and show you (on a Mac) the differences between Excel on Windows and Mac. No matter which operating system you use, this course is for you.

Course curriculum

  1. 1

    • Launching Excel

    • Understanding the Ribbon

    • The Structure of the Workbook and Worksheets
  2. 2

    • Entering Text

    • Entering Numbers

    • Entering Dates
  3. 3

    • Formatting Font

    • Formating Alignment

    • Formatting Borders and Colors

    • Merging Cells
  4. 4

    • Building Formulas with Cell References

    • Show Formula

    • Autofill

    • Using Excel to do Math

    • Relative and Asbolute Cell References
  5. 5

    • The Structure of a Function

    • Writing Functions with Non-Continuous Cell References

    • Using Autosum

    • Dealing with Errors

    • Common Excel Functions
  6. 6

    • Renaming your Worksheets

    • Hiding and Unhiding Rows and Columns

    • Inserting and Deleting Rows and Columns

    • How to Move your Data

    • Adjusting the Height and Width of the Cells
  7. 7

    • Inserting an Image

    • Inserting a Shape

    • Working with the Shape Format Ribbon
  8. 8

    • Inserting a Chart

    • Modifying Data in a Chart (PC)

    • Working with the Chart Design Ribbon

    • Formatting Charts with Axes
  9. 9

    • Save vs Save As

    • Print Preview

    • Working with the Page Layout Ribbon

    • Saving the Worksheet for the First Time
  10. 10

    • Using Templates
  11. 11

    • Intermediate Excel Workbook
  12. 12

    • How Excel Recognizes List

    • Sorting a List

    • Custom Sorting

    • Multi-level Sorting
  13. 13

    • Grouping

    • Subtotals
  14. 14

    • Naming Ranges

    • Using =IF

    • Nesting =IF Functions

    • Nesting =IF Functions Part 2

    • Using =IF with AND

    • Using =IF with OR

    • Using =IF with NOT

    • Using =COUNTIF and =COUNTIFS

    • Using =AVERAGEIF and =AVERAGEIFS

    • Using =SUMIF and =SUMIFS

    • Working with Wildcards
  15. 15

    • Rounding
  16. 16

    • Data Validation - Numbers

    • Data Validation - Dates

    • Data Validation - Text

    • Data Validation - Lists

    • Data Validation - Input Messages

    • Data Validation - Error Alerts

    • Validation Circles