Microsoft Excel

Macros and Basic VBA in Excel – Recorded Webinar

In this Macros and VBA in Excel Webinar we looked at how you create and edit a basic Macro in Excel. This webinar is aimed at users that are brand-new to Macros and VBA in Excel and teaches you the basics on how to use Macros to automate mundane tasks in Excel. In this 1-hour…
Importing and Cleaning Data in Excel

In this recorded, Excel webinar we look at how to import and clean data in Excel. Cleaning data is one of the most important skills you’ll need in Excel. In this session we look at various formulas and functions to help you clean data in Excel, we then move on to using Power Query to…
Compare Two Lists Using VLOOKUP

Suitable for users of Excel 2010, 2013, 2016, 2019, and Excel for Microsoft 365. OBJECTIVE Compare two lists using the VLOOKUP function in Excel. COMPARING LISTS WITH VLOOKUP EXPLAINED If you want to save yourself a huge amount of time in Excel when reconciling data, it’s worth taking the time to learn how to…
Excel Templates For More Efficient Project Management

Completing a project with minimal setbacks and hitches along the way is the ultimate goal of every project manager. This, however, is much, much easier said than done. Project managers and their teams have a lot to accomplish and keep an eye on. There’s planning, scheduling, budgeting, task delegation, and countless minute details to take…
XLOOKUP in Google Sheets

This XLOOKUP in Google Sheets tutorial is suitable for users of Google Sheets OBJECTIVE Use the equivalent functions in Google Sheets to perform an Excel XLOOKUP on a dataset. XLOOKUP IN GOOGLE SHEETS EXPLAINED XLOOKUP does not (yet!) exist in Google Sheets. XLOOKUP is a new, modern replacement for older lookup functions in Excel, such…
Excel vs Google Sheets

This Excel vs Google Sheets comparison is suitable for users of Excel for Microsoft 365 and Google Sheets OBJECTIVE In this (slightly different to normal) tutorial, we are comparing the two most popular spreadsheet applications Excel and Google Sheets against a variety of measures to determine which is the best. EXCEL VS GOOGLE SHEETS Google…
SUMIF with Multiple Columns – The SUMIFS Function in Excel

This SUMIFS Function tutorial is suitable for users Excel 2013,2016, 2019 and Excel for Microsoft 365. OBJECTIVE Use the SUMIFS function to add numbers in a range of cells based on a single or multiple criteria. SUMIFS EXPLAINED The SUMIFS function is a much welcome enhancement to an old Excel favorite, SUMIF. Part of the…