
Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with Mac OSX and Mac-related software since 2006; however, his passion is for all-things-Excel and in 2012 he founded the website theexceltrainer.co.uk
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 designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
Pivot Tables are one of the strongest data analysis and business intelligence tools in Excel. Whether you're building a dashboard, analyzing data in depth or summarizing a personal project, this E…
Industry: Software Duration: 60 Minutes Time: 10:00 AM PDT | 01:00 PM EDT
You can use Excel without ever writing a formula, but you would miss much of what makes it powerful. This 60-minute Excel formulas and functions training covers the basics every user needs.
…
Industry: Software Duration: 60 Minutes
Excel is more than a calculator. This Excel lists and tables training for beginners shows how to organize and manage list-based data such as employee rosters, inventories and course catalogs.
<…Industry: Software Duration: 60 Minutes
Using ChatGPT with Excel can save time on formulas, analysis and repetitive work. This 60-minute Excel and AI webinar shows how the two fit together and how AI can extend what you do in a spreadsh…
Industry: Software Duration: 60 Minutes
In any business, a dashboard is a key communication tool, and presentation is what makes it work. Many tools can build one, but Excel is a common choice because it is powerful, flexible and alread…
Industry: Software Duration: 60 Minutes
Microsoft Outlook is the standard tool for email, calendar appointments and to-dos for most business users, with desktop and mobile versions full of features. In practice, with the average office …
Industry: Software Duration: 60 Minutes
ChatGPT can take a lot of the friction out of Excel work. This hands-on 60-minute session shows how to combine Excel and ChatGPT to speed up repetitive tasks, simplify tricky formulas, tidy messy …
Industry: Software Duration: 60 Minutes
Formulas let Excel do your calculations for you, making your work faster and more accurate. This Excel formulas for beginners training assumes no prior experience with Excel or formulas.
Any…
Industry: Software Duration: 60 Minutes
Microsoft Outlook runs on Windows, Mac, mobile and the web, yet many professionals still face email overload, missed deadlines and packed calendars. This 60-minute Outlook email management trainin…
Industry: Software Duration: 60 Minutes
Excel pivot tables are among the most useful tools for HR professionals who need to summarize data, build a dashboard or run deeper analysis. With a few clicks and no complicated formulas, you can…
Industry: Software Duration: 90 Minutes
If you repeat the same steps in your spreadsheets, it's time to automate them. VBA is the programming language built into Excel and the other Microsoft Office apps, and it automates tasks you'd ot…
Industry: Software Duration: 90 Minutes
Excel's macro recorder can automate simple tasks, but it has limits. Where the recorder stops, VBA takes over, letting you automate almost anything you do in Excel. This 90-minute Excel VBA basics…
Industry: Software Duration: 90 Minutes
Dashboards help HR teams report on the business, inform decisions, keep stakeholders up to date, track problems, present KPIs and other metrics, and manage talent. As with any communication tool, …
Industry: Software Duration: 90 Minutes
Large imported datasets quickly hit Excel's limits. Power Query, called Get & Transform in Excel 2016, gets past them by letting you import and work with datasets of over a million rows from a…
Industry: Software Duration: 90 Minutes