Microsoft Private

Data Analysis in Microsoft Excel (EXC500)

2 days
Microsoft Excel

Go beyond basic spreadsheet operations to master the tools professional analysts rely on daily.

Request Private Class

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal turnaround within 1–2 business days
Request Proposal

Course Overview

Go beyond basic spreadsheet operations to master the tools professional analysts rely on daily. Topics include essential functions, list management, conditional formatting, PivotTables with slicers and timelines, dynamic array functions, Power Query, What-If Analysis, chart creation, workbook auditing, and collaboration features. This course combines our Intermediate and Advanced Microsoft Excel curricula into a focused, analyst-oriented track.

Course Benefits

  • Import and consolidate data from multiple sources and apply cleaning techniques such as Text to Columns, Flash Fill, Remove Duplicates, and data validation.
  • Write and combine analytical functions including IF/IFS, COUNTIF/SUMIF, VLOOKUP, XLOOKUP, INDEX/MATCH, and dynamic array formulas (SORT, FILTER, UNIQUE) to manage and summarize large datasets.
  • Apply conditional formatting rules, sorting, and filtering to highlight patterns and direct attention to key findings.
  • Create and customize PivotTables with grouping, calculated fields, slicers, and timeline filters to explore data interactively.
  • Build PivotCharts and visual dashboards to communicate analytical results clearly.
  • Use Power Query to connect to external data sources, reshape data, and automate repeatable transformation workflows.
  • Perform scenario analysis using What-If Analysis and Goal Seek, and audit workbooks by tracing precedents and dependents.

Delivery Methods

Private Class
Delivered for your team at your site or online.

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner. We design and deliver training that aligns directly with Microsoft's official technologies, standards, and learning objectives.

Microsoft Certified Partner

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Contact us
}