Preloader

Course Details

img img img img img
img

Advanced Microsoft Excel

Course Description

Description

This self-paced course takes you beyond basic spreadsheets into the powerful world of data analysis, automation, and reporting using Microsoft Excel. Designed for professionals who work with data daily, this course helps you build advanced Excel capabilities including dynamic dashboards, data modeling, and Excel automation using Power Query and VBA.

Aligned with 2025 analytics trends, this course includes AI-powered Excel features (Copilot), Office 365 integrations, and tools for real-time collaboration. By the end of this program, learners will confidently perform complex tasks and drive smarter decisions using Excel.

What You Will Learn

  • Use advanced functions: INDEX, MATCH, XLOOKUP, IFERROR, IFS, and dynamic arrays

  • Analyze data using PivotTables, slicers, timelines, and Power Pivot

  • Automate workflows with Power Query (Get & Transform)

  • Build interactive dashboards using form controls, charts, and named ranges

  • Create custom reports with conditional formatting and data validation

  • Use Excel Copilot (AI) to summarize, analyze, and generate insights

  • Understand Excel’s role in data visualization, forecasting, and modeling

  • Write basic macros using Visual Basic for Applications (VBA)

  • Integrate Excel with Power BI and cloud platforms

  • Apply Excel best practices for speed, accuracy, and presentation

Course Curriculum

  • Excel Power Functions

    • Logical & nested IFs, IFS, SWITCH

    • Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH

    • TEXT, DATE, and dynamic array functions

  • Data Analysis with PivotTables

    • Advanced PivotTables: slicers, timelines, calculated fields

    • Grouping and summarizing complex data sets

    • Using Power Pivot for large data models

  • Data Cleaning & Automation

    • Power Query for data extraction and transformation

    • Automating recurring tasks with queries

    • Removing duplicates, fixing formats, unpivoting data

  • Charts and Dashboards

    • Combo charts, waterfall, Gantt, and sparkline charts

    • Interactive dashboards with slicers, scrollbars, and form controls

    • Using camera tool and linking cells for live updates

  • Forecasting & What-If Analysis

    • Scenario manager, goal seek, data tables

    • Trendlines and forecast sheets

    • Sensitivity analysis for decision-making

  • Excel Automation with VBA (Intro)

    • Basics of macro recording

    • Writing and editing simple VBA scripts

    • Automating reports and workflows

  • Excel in the Modern Workplace (2025)

    • Excel Copilot and AI-enhanced analysis

    • Integration with Power BI, SharePoint, Google Sheets

    • Real-time collaboration via Office 365

  • Final Project + Certification

    • Create a dynamic, automated Excel dashboard

    • Submit workbook for review

    • Complete 90-minute exam (theory + hands-on tasks)

    • Earn Certificate of Excellence in Advanced Excel

img

Chronolearn

Developer

I am a web developer with a vast array of knowledge in many different front end and back end languages, responsive frameworks, databases, and best code practices

Reviews

0.0
0 Ratings
5
0
4
0
3
0
2
0
1
0
Title From Date To Date Cost
No data found!
This Course Fee:

₹24,999.00

₹40,000.00
Course includes:
  • img Level
      Beginner Intermediate
  • img Duration 6h
  • img Passing Marks 75
  • img Exam Duration 1h 30m
  • img Certifications Yes
  • img Language
      English German Arabic French Spanish
  • img Access 90 days
Add To Cart