Author: TheExcelTrainer

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) and Power BI. In 2012 Mike founded The Excel Trainer where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for Pluralsight and in his career delivered thousands of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

Must-Know Excel Functions to Increase Your Productivity (3 of 3)

Say goodbye to the overwhelming list of over 500 Excel functions, and focus on the core set of functions that every Excel user should master.

Must-Know Excel Functions to Increase Your Productivity (2 of 3)

Say goodbye to the overwhelming list of over 500 Excel functions, and focus on the core set of functions that every Excel user should master.

Must-Know Excel Functions to Increase Your Productivity (1 of 3)

Say goodbye to the overwhelming list of over 500 Excel functions, and focus on the core set of functions that every Excel user should master.

Why You Should Attend “Must-Know Excel Functions to Boost Your Productivity”

Explore our guide on simple yet effective project estimation strategies. Master project timelines efficiently and make informed decisions.

Harnessing the Power of Excel’s Power Pivot for Multiple Data Sets

Excel struggles with pivot tables from multiple data sets. Power Pivot offers a solution by integrating data sets within a dedicated storage area. Learn how to activate Power Pivot, build a data model, and create comprehensive pivot tables with interconnected data.

Excel Power Query & Dashboards – 3 of 3

In this session we cover calculations without formulas, Append & Merge Queries, convert a single text string into multiple rows, and unpivot.

Excel Power Query & Dashboards – 2 of 3

In this session we cover calculations without formulas, Append & Merge Queries, convert a single text string into multiple rows, and unpivot.

Excel Power Query and Dashboards - 1 of 3. PDU Code: mpug092023.

(1 of 3) Excel Power Query & Dashboards: Import and Refine Your Data Fast

Learn how Power Query (or "Get and Transform" in Excel 2016 and later) can help you easily format data for all your reports in this webinar.