Microsoft Excel Intermediate

Microsoft Excel Icon

Join our 6-hour Microsoft Excel Intermediate course for professionals and analysts. Elevate your data analysis skills with advanced functions, PivotTables, and interactive dashboards. Learn conditional formatting and data visualization techniques to enhance your spreadsheet management capabilities.

  • Audience

    This course is designed for individuals who possess basic Excel skills and want to elevate their proficiency to an intermediate level. It caters to professionals, analysts, administrators, and anyone seeking to enhance their data analysis and spreadsheet management capabilities using Excel.

    Pe-requisites

    Participants should have fundamental knowledge of Excel, including familiarity with basic functions, formatting, navigating worksheets, and data entry. Experience in creating simple formulas and working with basic charts is recommended.

    Duration

    6 hours

    Delivery Method

    Face to face or Virtual
  • Course Objectives

    This comprehensive one-day course aims to equip participants with intermediate Excel skills, focusing on advanced functions, data analysis, visualization, collaboration, and timesaving techniques.

    Course Outline

    Review of Excel Basics

    • Recap of Excel essentials: interface, navigation, data entry, and saving files
    • Quick review of basic formulas, functions, and formatting techniques
    • Understanding absolute cell references for advanced formula usage

    Working with Large Datasets

    • Sorting and filtering data in tables
    • Using data validation to control data input
    • Introduction to PivotTables: creating, formatting, and
    • summarizing dataAnalysing data with Pivot Charts

    Advanced Formulas and Functions

    • Exploring logical functions: IF, AND, OR, NOT
    • Nesting functions to perform complex calculations
    • Utilizing lookup functions: VLOOKUP and XLOOKUP
    • Introduction to INDEX and MATCH functions for advanced data retrieval

    Data Analysis and Visualization

    • Using conditional formatting for data visualization
    • Applying data analysis tools: Goal Seek, Solver, and Scenario Manager
    • Creating interactive charts with dynamic data ranges
    • Introduction to Sparklines for data trends at a glance

    Creating Interactive Dashboards

    • Combining charts, tables, and slicers to build a dashboard
    • Design principles for effective dashboards
    • Protecting and sharing dashboards