EXCEL SKILLS / PIVOTTABLE POWER TIPS
9 lessons · 3 practical sections · Learn at your own pace
You already work in Excel. Now learn how to turn rows of data into a report you can explore, refresh, and explain. We get straight to the practical skills.
Bring your data together and create a useful summary without manually rebuilding your report.
Use slicers, data consolidation, and Value Field Settings to find the view that answers your question.
Refresh your data while preserving formats, then go further with calculated fields.
If you use Excel regularly and want more confidence summarizing and reporting on your data, this is a practical next step. Start with the fundamentals, then work through the power tips.
Billy “Mr. Aloha” Wigley helps people build practical Excel and AI skills they can use at work and in business. A Microsoft Certified Trainer since 2013 and Microsoft Office Specialist Excel Expert, he makes complex topics easier to understand through clear explanations, real-world examples and hands-on learning.
As an instructor, course creator and consultant, Billy brings a warm Aloha spirit and a skills-first approach to every lesson. Teaching in English and Spanish, he helps learners turn frustration into confidence and put their knowledge to work. His philosophy is simple: “Don’t Get Mad…Get Skills!”
Your first PivotTable, slicers, consolidation, Value Field Settings, refreshing while keeping formats, and calculated fields. The curriculum above shows the current 9 lessons.
This course is designed for people who use Excel regularly and want to take the next step with data analysis and reporting.
No. The standalone purchase is for this PivotTables course only. Community membership is a separate option.
WANT TO KEEP BUILDING YOUR SKILLS?
This course is also included in the community course library. Membership is a separate subscription: $20 monthly or $200 annually. Explore it if you want a broader place to keep learning.
What People Are Saying About Us