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.

Excel: Master the Latest & Greatest Functions

Excel: Master the Latest & Greatest Functions

Learn the newest Excel functions, including SEQUENCE, VSTACK, HSTACK, TEXTSPLIT TEXTBEFORE, TEXTAFTER, CHOOSECOLS, CHOOSEROWS and TAKE.

Excel: How to Use the SEQUENCE Function

Excel: How to Use the SEQUENCE Function

The SEQUENCE function in Excel is a powerful tool that simplifies the generation of sequential numbers, dates, or arrays, offering a flexible and efficient alternative to complex formulas or manual data entry, ultimately enhancing productivity in data management and visualization tasks.

Excel: How to Use The VSTACK Function

Excel: How to Use The VSTACK Function

VSTACK is a powerful Excel function that simplifies data management by allowing users to vertically combine multiple ranges or tables into a single, dynamic array, enhancing efficiency and reducing errors in data consolidation.

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

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)

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)

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”

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.