Excel Level 3 is a data analysis class for the advanced user who spends a lot of time working with large amounts of data.
The theme is high end productivity.
In this class students will learn how to use Excel pivot tables, advanced Excel productivity tools and simple macros.
In-class exercises include:
Power Query data clean up
Finally stop the redundant data clean up chores and get on to the analysis! In this class, the students will learn – in a workshop format – how to use Power Query in MS Excel, including:
- E-T-L: What it is and how it works
- Extract …from Excel Workbooks
- Transform
- Dates
- Duplicate a Column
- Conditional Columns
- Simple Calculations
- Power Query Maintenance
- Load to Excel, then Pivot or Chart the data
- Recycle and Reuse!
Pivot Tables
Data summary and Analysis of the freshly cleaned data
- Creating a PivotTable Report
- Adding Report fields
- Data Source: Change and Refresh
- Changing Number Formats
- Summarize Values
- Add, Move or Delete Fields
- Drill Down feature
- Calculated Fields
- Create a clickable Dashboard by Using Filters, Slicers, and Timelines
- Pivot Table Vital Maintenance
Additional Information
Benefits of Attending Excel Data Analysis, Level 3
The amount of data makes no difference in time-consumption if you know the tips and tricks to move-and-shake through an Excel spreadsheet. Your skills will definitely improve with this course and class applications.
Who Should Attend
Supervisors, team leaders, team members with reporting responsibilities or anyone who has already attended the first two levels. (Don’t skip the levels! It all matters!)
Dates and Times
Thursday, March 25, 2027, 9 a.m. – 4 p.m.
Fees
$275 per person, includes all materials
Location
Zoom
Presenter
Andy Lanning is a self-taught computer “nerd” and has been training individuals and groups since 1996. She has taught computer VoTech classes at both Boise State and CWI, and is the owner of a computer consulting business. In addition, she is a Certified Microsoft Office Specialist and trains most Microsoft programs. With 20+ years of experience in the computer industry, Andy focuses every class on using software to solve common workflow issues.