Microsoft Excel 365/2019/2016 Part 2: Analyzing and Presenting Data

Microsoft Excel Part 2: Data Analysis and Presentation is an intermediate-level course designed to help users move beyond basic spreadsheet functionality and unlock Excel’s powerful data analysis capabilities. Building on foundational Excel skills, this course focuses on transforming raw data into meaningful insights that support informed decision-making. Participants learn how to work with advanced functions, analyze and organize large datasets, and present information clearly through charts and PivotTables. By the end of the course, learners will be able to extract actionable organizational intelligence from data and communicate insights effectively to stakeholders.

• Use advanced Excel functions, including logical, text, and date/time functions
• Organize and manage data effectively using lists, sorting, and filtering
• Query and summarize data using database functions, outlines, and subtotals
• Analyze datasets using tables and intermediate to advanced conditional formatting
• Create, customize, and enhance charts to visualize data clearly
• Build and analyze PivotTables to summarize and explore large datasets
• Present data insights using PivotCharts, slicers, and timelines
• Apply data analysis techniques to support informed organizational decisions

• Business professionals who regularly work with data in Excel
• Analysts in sales, finance, operations, HR, IT, or management roles
• Users with foundational Excel knowledge seeking to expand analytical skills
• Professionals responsible for analyzing and presenting data to decision-makers

• Completion of Microsoft Office Excel Part 1 or equivalent experience
• Familiarity with basic Excel concepts such as formulas, worksheets, and formatting
• Experience performing simple calculations and modifying workbooks for presentation purposes