Data Analysis and Visualization with Microsoft Excel

Data Analysis Fundamentals
• Introduction to data science
• Creating and modifying tables
• Sorting and filtering data

Visualizing Data with Excel
• Visualizing data with charts
• Modifying and formatting charts
• Applying best practices in chart design

Analyzing Data with Formulas and Functions
• Analyzing data with formulas and named ranges
• Analyzing data with functions
• Implementing data validation, forms, and controls
• Creating conditional visualizations with lookup functions

Analyzing Data with PivotTables
• Creating PivotTables
• Analyzing PivotTable data

Presenting Visual Insights with Dashboards in Excel
• Visualizing data with PivotCharts
• Filtering data using slicers and timelines
• Creating dashboards in Excel

Creating Geospatial Visualizations with Excel
• Creating map charts in Excel
• Customizing map charts

Performing Statistical Analysis
• Visualizing trendlines and sparklines with Excel
• Analyzing data with the Data Analysis ToolPak

Getting and Transforming Data
• Connecting to data with queries
• Cleaning and combining data
• Shaping and transforming data

Modeling and Analyzing Data with Power Pivot
• Installing Power Pivot in Excel
• Creating data models with Power Pivot
• Creating Power Pivots
• Performing advanced data analysis and visualization

Presenting Insights with Reports
• Planning a report
• Creating a report

Who Should Attend:
• Professionals who want to enhance their data analysis and visualization skills using Microsoft Excel
• Business analysts, data analysts, and anyone working with data in various industries
• Students and individuals interested in learning advanced Excel techniques for data analysis and visualization

1ST BATCH: Tuesday, March 10, 2026 — Friday, March 13, 2026.

2ND BATCH: Tuesday, June 30, 2026 — Friday, July 3, 2026.

3RD BATCH: Tuesday, October 27, 2026 — Friday, October 30, 2026.

The training methodology integrates lectures, interactive discussions, collaborative group exercises, and
illustrative examples. Participants will acquire a blend of theoretical insights and hands-on practical
experience, emphasizing the application of learned techniques. This approach ensures that attendees return
to their professional environments equipped with both the competence and self-assurance to effectively
implement the acquired skills in their responsibilities.