Key Takeways

  • Navigate Excel’s interface and tabs with ease

  • Use cell referencing and the formula bar effectively

  • Master key Excel shortcuts and productivity hacks

  • Understand data types: text, values, formulas

Who should enroll?

  • Beginners looking to build strong Excel foundations

  • Students and professionals aiming to boost productivity

  • Data enthusiasts exploring Power Query for automation

Course curriculum

  • 1
    Introduction & Basics
    • Introduction to Excel
    • Excel Interface
    • Cell Referencing
    • Formula Bar Details
    • Workbooks and Worksheet
    • Excel Limitations
  • 2
    Shortcuts, Data Types & Best Practices
    • Essential Excel Shortcuts
    • Excel Data Types
    • Excel Best Practices
  • 3
    Excel Essentials: Data, Calculations, and Visuals
    • Understanding Power Query
    • Basic Functionalities in Excel
    • Table Design in Excel with Basic Conditional Formating
    • Working with Calculations_ Dates and Cell References
    • Visualization in Excel
    • Conditional Formating and Pivot Tables
  • 4
    Core Excel Formulas and Functions
    • Finder Function
    • Match Function
    • String Functions
    • Logical Function
    • Basic Function
    • LookUp, What-if Analysis and Scenario Manager Function
    • Checklists in Excel
    • The VLOOKUP Function
    • The Consolidate Function
    • Shortcut-based Numbering
  • 5
    Advanced Excel
    • Add Data from Image
    • Circle Validation
    • Transpose in Excel
    • Advanced Pivot Functions
    • Time Related Functions
    • Calculation Shortcut in Excel
    • Auto Numbering
    • Extracting Data using Power Query Editor
    • Creating and Working with Macros
    • Visual Basic for Applications (VBA) in Excel
    • Integration of AI on Excel

FAQ

  • Do I need prior Excel experience to take this course?

    No prior knowledge is required. This course starts with the basics and progresses to advanced features like Power Query.

  • Will I learn keyboard shortcuts and productivity tips?

    Yes! The course includes essential shortcuts and practices to help you work faster and more efficiently in Excel.

  • What is Power Query and why is it useful?

    Power Query is a data transformation tool in Excel. You'll learn to import, clean, and reshape data without writing code.

  • Will I receive a certificate upon completing the course?

    Yes, the course provides a certification upon completion.