TheExcelTrainer

Learn how to use Excel’s powerful FILTER function to dynamically extract specific data based on multiple conditions, perfect for creating responsive dashboards and reports.

Learn with Excel expert Mike Thomas for an interactive live Q&A session to boost your Excel skills. Watch as participants got real-time answers to their questions and learned productivity-enhancing techniques.

Join Excel expert Mike Thomas for an interactive live Q&A session to boost your Excel skills, get real-time answers to your questions, and learn productivity-enhancing techniques.

Discover three powerful Excel tips from expert Mike Thomas to boost your project management productivity: Excel Tables, Dynamic Array Functions, and XLOOKUP.

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

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.

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.

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.

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.

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.

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

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.

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

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

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.

Excels GETPIVOTDATA and Calculated Fields are powerful tools for data analysis. Learn how GETPIVOTDATA ensures accurate data extraction from pivot tables, and how Calculated Fields allow you to create new metrics without modifying the source data.

Intro to DAX (Power Pivot formula language), Lookup with DAX, DAX calculated columns v Query editor, CUBE functions

Filtering a pivot table; creating slicers, GETPIVOTDATA; “Group By”; calculated fields, the benefits of power pivot and the data model

Have you always wanted to learn how to create a pivot table or manipulate data into a pivot table? Look no further than this step-by-step!

Please find below a transcription of the audio portion of Mike Thomas’ course, Excel Data Visualization – Lesson 2, being provided by MPUG for the convenience of our members. You […]

Event Description:
Every Picture Tells a Story” is a popular saying which is true not only in everyday life but in Excel too. Behind your set of numerical data is a story waiting to be told. The telling of this story needs to be to-the-point, easy to understand and engaging.

Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insight from it.

Learning Objectives:

Learn how to select the most appropriate chart to convey your message
Learn how to create a chart from a set of data and change its appearance
Learn how to create infographic-style charts
Learn how to integrate Excel charts with other applications such as Word and PowerPoint
Project Management Institute (PMI)® Professional Development Units (PDUs):
This Webinar is eligible for 0.75 PMI® PDU in the Technical category of the Talent Triangle.

Download Files for the Course:

Please find below a transcription of the audio portion of Mike Thomas’ course, Excel Data Visualization – Lesson 1, being provided by MPUG for the convenience of our members. You […]

Event Description:Every Picture Tells a Story” is a popular saying which is true not only in everyday life but in Excel too. Behind your set of numerical data is a story […]

Event Description:Every Picture Tells a Story” is a popular saying which is true not only in everyday life but in Excel too. Behind your set of numerical data is a story […]

“Every Picture Tells a Story” is a popular saying which is true not only in everyday life, but in Excel, too. Behind every set of numerical data is a story […]

Please find below a transcription of the audio portion of Mike Thomas’ webinar, Excel – Quick Tips to Help You be More Productive, being provided by MPUG for the convenience […]

Event Description In this training you’ll learn some powerful tips, tricks, and shortcuts to help you become more productive in your use of Excel. Learn how converting list-based data into a […]