Build practical Excel table skills: organize and filter data, create clear reports, and use structured references with guided lessons, workbooks, and quizzes.
Turn everyday lists into useful Excel tables with Billy “Mr. Aloha” Wigley. Learn to create and format tables, add and remove records, sort and filter with slicers, and summarize data with formulas and PivotTables.
Practice reusable templates, conditional formatting, and importing web data with Power Query. Then build structured references that adjust as your tables change and combine table data with VSTACK.
The course includes 19 teaching lessons, an introduction and conclusion, 19 class workbooks, five three-question section quizzes, and a 10-question final challenge. Follow the demonstrations, practice with the workbooks, and use the quizzes to check your understanding.
Build practical skills for organizing, analyzing, and maintaining data in Excel.
Topics Covered:
AI & Excel Productivity Expert
Billy “Mr. Aloha” Wigley is a practical AI and Excel productivity expert, Microsoft Certified Trainer, and the educator behind DontGetMadGetSkills.com. Teaching online since 2013, Billy helps individuals and businesses turn learning into practical skills they can use at work. His warm Aloha spirit, clear explanations, and hands-on approach make learning approachable and engaging. Through Don’t Get Mad…Get Skills!, he helps learners work smarter, build confidence, and achieve their potential through careful planning, training, and inspiration.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.
