Call Me
Excel Basics

Duration: 12 Hours

Excel is by far the world’s most popular spreadsheet, useful for everything from maintaining simple household budgets to building sophisticates financial, models or designing complex dashboards. Excel in its universality is now a must have skill in every business environment. According to Microsoft Office Live Director of Marketing Michael Schultz, "roughly half a billion people use MS Office", making Excel the world’s most popular spreadsheet application by a mile.

Course Modules

  • Navigating Through Excel
    • Formatting, sorting, filter, subtotals, grouping and data validation.
  • Basic Functions
    • Text, Stat & Math Formulae and Logical
  • Advanced Functions
    • Reference " Lookups, Match and Index
    • Using Reference, Logical and Formulae functions in combination
  • Pivot Tables and Charts
    • Case Studies using Pivot Tables