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