Mr. Mike Thomas

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

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

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

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

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 cha ...

For many people, the holy grail of organization is a world where email overload doesn't exist and where all those sticky notes and paper notepads are magically replaced by a digital paperless system. Using OneNote, a free application that you ...

Booking forms, sales order forms, invoices, loan agreement forms and surveys. These are just a few examples of forms that can be created using Excel (although the list of examples is endless). By adding a splash of co ...

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