Course curriculum

  1. 1

    • Introduction

    • How Good Do You Need To Be At Excel?

    • 8 Reasons To Learn Excel

    • Top 10 Excel Formulas

    • VLOOKUP Formula in Detail

    • IF Formula in Detail

    • COUNTIF Formula in Detail

    • SUMIF Formula in Detail

    • Array Formulas Explained

    • How To Sort Data

    • What Are Sparklines?

    • Look Up Data With Multiple Criteria

    • Understanding Duplicate Data

    • Can Keyboard Shortcuts Be Bad For Your Career?

    • How To Create Drop Down Lists In Excel

    • How To Alphabetise Data

    • Autofilters

    • Data Validation

    • How To Use Excel To Progress Your Career