Course Information
Data Analytics with Excel
Course Description
Students will learn advanced functions and cleanup tools to help structure their data in a more meaningful way to be analyzed. Students will be introduced to Power Query and learn how to connect to data and use the Power Query platform to transform their data and load it into Excel, and use Pivot tables on connected data. The session will also include recommended practices for Pivot tables and Power Query.
Course Objectives
Excel Exclusive Features (2 hours)
Flash Fill
Concatenation Function
Xlookup Function
Dynamic Array Functions
Best Practices with PivotTables
Power Query with Excel (2 hours)
QUICK DEMO: Power Query with Power BI
Connecting to Data
Transforming DataExcel
Merge and Append Queries
Adding Columns
Loading and Refreshing Queries
Prerequisites
Basic to Intermediate knowledge of Excel is helpful.
Instructors
Steve Blaylock is a seasoned Microsoft Excel and data analytics instructor with over 20 years of experience teaching Microsoft technologies to enterprise and professional audiences. A Microsoft-certified Excel expert, Steve has delivered hands-on training for leading organizations including Comcast, NBC Studios, and Wawa, helping teams turn data into actionable insight.
Steve brings deep, real-world expertise in data analytics using Excel, with a particular focus on Power Query for data transformation and analysis. He has traveled extensively across the United States delivering Power Query training to organizations such as Ernst and Young, where he guided professionals in transforming and analyzing complex financial and operational datasets.
Having taught learners across a wide range of industries, Steve is known for his ability to adapt examples and exercises to align with each organization’s business context. His interactive teaching style encourages questions throughout the session, ensuring participants not only understand the tools, but also how to apply them immediately in their day-to-day work.