Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds 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.
Do you spend time each month importing data into Excel from other sources such as CSV files, text files, web pages, databases, and SharePoint? Do you spend more time than is necessary getting your data into the right format for your reports, performing repetitive "data cleaning and transforming" tasks such as removing unnecessary rows and columns, filtering out data that you don’t need, converting text to n..
Rich Data Types, first introduced into Excel in 2019, are a game-changer that takes Excel from being a tool that simply manipulates your data into a tool that really understands your data. Traditionally, a cell in an Excel worksheet has been limited to storing one of three data types - text, numbers, and dates. However, with the introduction of Rich Data Types, this is no longer the case. Converting a stati..
This is a follow-on session to "Excel - Power Query for the Everyday Excel User - Part 1" and covers the key advanced features of Excel’s Query Editor, designed to help you transform imported data quickly and without having to learn to code. The focus of this training is on how to create additional columns without complex formulas and how to combine, merge and unpivot unusable data to make it report-ready.A..
VBA is Microsoft’s programming and automation language that is built into all the MS Office applications. Although Excel’s Macro Recorder allows you to automate a task by recording a series of keystrokes and mouse clicks, that’s where its functionality and power ends. To be able to do anything more, you need to harness the power of VBA.VBA is a fully-featured programming language that includes functionality..
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. Until a few years ago it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on and we're constantly hearing words like Data Vis..
No matter what business you are in, a dashboard is a critical tool in your communication armory and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, Excel is commonly used due to its power, its flexibility, and the fact that most people have it installed on their computers. This training focuses on what you need to know to..
Power BI is an application from Microsoft that turns your raw data (loaded in from a variety of sources) into stunning interactive visual reports, providing you with real-time insights into your data and enabling you to make better business decisions.Gone are the days of submitting a request to the IT Department and waiting for them to produce a less than perfect report. With Power BI you can create those r..
Microsoft Excel contains almost 500 built-in worksheet functions. Strip away the ones nobody uses. Discount the ones that have a specialized use-case and you’re left with a small set of functions that all Excel users should know, regardless of their job function, industry, or business sector. This webinar covers ten of Excel’s most popular productivity-boosting functions.Areas coveredIF: Automate data entry..
Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) armoury. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the reports, dashboards and charts that help you to summarise, analyse, interpret and understand your data which in turn helps you to spot trends and get answers to the important questions on..
In this training session, you'll learn how to create a stunning, interactive professional-looking dashboard using Excel. This training will provide you with a solid foundation that you can use to build your own dashboards and reports.No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, a presentation is everything. Although ther..
For most business users (and many home users too), Microsoft Outlook has become the standard application for managing emails, calendar appointments, and to-dos. With an abundance of features and versions for desktop and mobile, there’s really no excuse not to be organized. Or so the theory goes.With the average office worker receiving over 100 emails per day, the reality for most people is email overload, m..
Power Pivot removes many of the limitations and frustrations that users find with creating Pivot Tables in Excel. For example, using Power Pivot you can.Create Pivot Tables from multiple lists/tables without the need to combine them into a single list first (goodbye LOOKUP and all the issues that it brings)Create Pivot Tables from large datasets without worrying about file size, performance, or needing more..
No matter what business you are in, a report is a critical tool in your communication armory. As with any communication tool, presentation is everything. Get it right and it offers the reader (typically a CEO, shareholder, or Project Manager) a valuable insight into the Key Performance Indicators (KPI’s) upon which a business or project is measured. Get it wrong and you'll end up with something that nobody ..
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 charts that help you to summarise, analyze, interpret and understand your data which in turn helps you to spot trends and get answers to the important questions on which..
Excel Charting Techniques for Infographics and Dashboards I - Unique, Fun and Dynamic Visualizations
"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 insigh..