Description
Duration: 2 days
This course covers advanced data analysis and reporting techniques in Microsoft Excel. Students will work with tools such as PivotTables, Power Pivot, and geospatial charts to examine datasets and surface meaningful insights. The course also addresses data preparation, dashboard construction, and connecting to external data sources. It is intended for users who already have a working knowledge of Excel and want to develop more sophisticated analytical skills.
Target Audience
- Professionals with a foundational Excel background who want to perform advanced data and statistical analysis
- Users looking to work with PivotTables and Excel’s more advanced data tools
- Professionals responsible for reporting, forecasting, or decision support
- Anyone who needs to build advanced charts and dashboards in Excel to communicate data findings
Prerequisites
- Excel – Part 1 & 2 or equivalent experience
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing – (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Code Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Code Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 5/25/2026 | 5/26/2026 | ||||
| 6/15/2026 | 6/16/2026 | ||||
| 7/6/2026 | 7/7/2026 | ||||
| 7/27/2026 | 7/28/2026 | ||||
| 8/17/2026 | 8/18/2026 | ||||
| 9/7/2026 | 9/8/2026 | ||||
| 9/28/2026 | 9/29/2026 | ||||
| 10/19/2026 | 10/20/2026 | ||||
| 11/9/2026 | 11/10/2026 | ||||
| 11/30/2026 | 12/1/2026 | ||||
| 12/21/2026 | 12/22/2026 | ||||
| 1/11/2027 | 1/12/2027 | ||||
| 2/1/2027 | 2/2/2027 | ||||
| 2/22/2027 | 2/23/2027 | ||||
| 3/15/2027 | 3/16/2027 | ||||
| 4/5/2027 | 4/6/2027 | ||||
| 4/26/2027 | 4/27/2027 |
Learning Objectives
- Clean and prepare data using tables, formulas, and functions
- Identify trends and patterns using PivotTables and PivotCharts
- Create interactive dashboards with slicers and timelines
- Apply geospatial and statistical tools to extend data analysis
- Build data models using Power Pivot and work with multiple connected data sources
Course Outline
Module 1: Foundations of Data Analysis
Overview of data science concepts; building and modifying tables; sorting and filtering data.
Module 2: Creating Data Visualizations in Excel
Building charts to display trends and comparisons; formatting visuals for readability; following chart design best practices.
Module 3: Working with Formulas and Functions for Analysis
Applying formulas and named ranges to streamline analysis; using logical and lookup functions; setting up forms, data validation, and automated input methods.
Module 4: Data Analysis with PivotTables
Constructing PivotTables from source data; filtering, grouping, and summarizing data to draw conclusions.
Module 5: Dashboard Development in Excel
Using PivotCharts to display dynamic data; incorporating slicers and timelines for user interaction; assembling multiple visual components into a cohesive dashboard.
Module 6: Map-Based Data Visualizations
Building map charts to display location-based data; adjusting and reading map visuals effectively.
Module 7: Statistical Analysis in Excel
Using sparklines and trendlines to highlight data patterns; running statistical analyses with the Data Analysis ToolPak.
Module 8: Importing and Shaping Data
Connecting to external data sources using queries; transforming and consolidating raw data to prepare it for analysis.
Module 9: Data Modeling with Power Pivot
Setting up Power Pivot and importing data models; writing DAX formulas for complex calculations; defining relationships across multiple datasets.
Module 10: Building Excel Reports for Stakeholders (Optional)
Designing and formatting Excel reports to present findings to an audience.
