Data Analysis and Visualization with Microsoft Excel
Use Excel Tables, PivotTables, Power Pivot, maps and AI-assisted analysis to turn raw data into an interactive dashboard.
$795.00
Use Excel Tables, PivotTables, Power Pivot, maps and AI-assisted analysis to turn raw data into an interactive dashboard.
$795.00
Use Excel Tables, PivotTables, Power Pivot, maps and AI-assisted analysis to turn raw data into an interactive dashboard.
This course takes you from a raw dataset to a connected, interactive Excel report. You prepare data with Tables and formulas, analyze trends with PivotTables, build a Data Model with Power Pivot, add geospatial and statistical views, and use AI-assisted analysis while checking its work. You finish by building a dashboard that a manager can filter and read on one screen.
This course is for analysts, coordinators and managers who build recurring reports in Excel. It also suits anyone who already uses formulas and wants to move from static spreadsheets to connected reports.
Baseline Excel skills, including building workbooks with formulas and functions (Excel Level 1 or equivalent)
Excel for Microsoft 365 on a Windows desktop
Requires a Windows PC
Excel for Microsoft 365 desktop for Windows, part of a paid Microsoft 365 subscription; Power Pivot and the Data Model are not available in Excel for Mac
Copilot in Excel, a paid Microsoft 365 Copilot feature, is used in the AI-assisted analysis module where your subscription includes it; otherwise you complete the same lab with an AI assistant your employer approves
3D Maps is missing or unreliable in some Microsoft 365 installations, so the geospatial lab can be completed with a map chart instead
Converting ranges to Tables, Structured references, Sorting, filtering and removing duplicates, SUMIFS, COUNTIFS and AVERAGEIFS, XLOOKUP against Tables.
Building and grouping PivotTables, Value field settings, PivotCharts, Slicers and timelines.
Loading Tables to the Data Model, Creating relationships, Simple DAX measures, PivotTables from the Data Model.
Map charts, Introduction to 3D Maps, Descriptive statistics with the Analysis ToolPak.
Asking questions about your data, AI-generated formulas and PivotTables, Checking AI output against source data, Writing clear prompts.
Dashboard layout for readers, Connecting slicers across PivotCharts, Labels and formatting, Final review checklist.
One-on-one or small-group coaching, scheduled with your coach.
On-demand asynchronous training with online support, plus 1 hour of coaching.
Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.
Data Analysis and Visualization with Microsoft Excel
Reimbursement applies only to the credential approved in your TechCred application, so use the exact credential name shown on this page.
Ohio's TechCred program may reimburse eligible Ohio employers up to $1,000 per person, per credential, and up to $30,000 per application, for eligible costs such as tuition and certification costs.
This price is within TechCred's maximum of $1,000 per person, per credential.
The current application period opens at 9:00 a.m. on October 1, 2026 and closes at 3:00 p.m. on October 30, 2026.
Training must start no earlier than the first day of the application period and be completed within 12 months of the award date.
For each learner, We Can Code IT provides an itemized per-person invoice that shows the exact credential name, and a certificate that shows the learner's name, the credential and the date earned (or the vendor's exam record for certifications). We can also send a written quote to include with your TechCred application.
Pricing is the same for all customers, whether or not you use TechCred.
We Can Code IT is an independent training provider. Being listed as an eligible TechCred provider is not an endorsement by the State of Ohio and does not guarantee funding. The Ohio Department of Development makes all TechCred decisions, so check the state's current program guidelines before you apply. Program details: the State of Ohio’s TechCred page.
Choose the number of seats, add the course to your cart and check out.
Send the form below for group enrollment or a written quote to include with your TechCred application. We reply within one business day. You can also email admissions@wecancodeit.org.
We Can Code IT, LLC, 26300 Cedar Rd, Suite 1105, Beachwood, OH 44122. Registered with the Ohio State Board of Career Colleges and Schools, Registration No. 15-03-2064T.
