Mr. Mike Thomas

Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) armory. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the reports, dashboards and ...

Do you work with "Big Data"? Do you import and manipulate large datasets in Excel? If so you'll already be familiar with the limitations of Excel. Power Query, (known as Get and Transform in Excel 2016) is designed to get you past these lim ...

Power Pivot, a free add-in for Excel, written by Microsoft, puts the "power" into Pivot Tables (hence the name!). Power Pivot removes many of the limitations and frustrations that many advanced users find with Pivot Tables. For example, usi ...

"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 underst ...

Do you import data into Excel from other sources (such as CSV files, text files, web pages, databases or SharePoint)? Does the data that you import need to be "cleaned" before it can be used? (cleaning refers to things like removing duplica ...

Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is "Yes", it’s time to learn how to create a macro. VBA is the programming language that is built into Excel (and the other application ...

"How do I compare the items in these two lists and see which are missing" "How do I look up a value in list ONE and pick up a related value from list TWO" "How do I avoid my lookup formula displaying an ugly error when it can't find a mat ...

In this training, you will learn how to build Queries in Microsoft Access. Queries let you ask questions about your data. Queries allow you to select specific data from your database. Queries are the key to generating effective and powerful report ...

Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is "Yes", it’s time to learn how to create a macro. In this session you will learn how to create and edit macros, create macros that can b ...

The training will focus on 3 areas - creating summary reports using Pivot Tables; creating eye-catching charts and presenting geographic-based data. In the pivot tables section, you'll learn how to create a basic pivot table, display numbers as a ...