Mini Courses & Tutorial Videos
Feel free to explore our instructional videos here, or sign up to one of our mini-courses
Text Functions
Learn how to use the Excel functions LEFT, LEN, FIND & RIGHT to reverse first and last name order.VLookup
Learn how to automate looking up data using the VLOOKUP function.Index & Match
Learn how to use INDEX & MATCH to lookup values in Excel more effectively than with a VLOOKUPPivot Tables
Learn how to create and use pivot tables to summarize data on Excel.Dynamic Data Validation
Create rules to prevent users entering dates that have already been finalised with dynamic data validation.Dependent Drop-Down Lists
Learn how to create a dependent drop-down list using dynamic ranges, so that the second drop-down list will display different options depending on the item selected in the first drop-down listImport Data with a Macro
Learn how to import data from multiple source workbooks into separate worksheets in a single file - automaticallyVLookup with 2 Columns
Create a VLookup formula that uses 2 cells for the lookup value and 2 columns for the lookup range - to match both FirstName and LastName from seperate cellsCreate a Heat-Map
Check out another nifty Conditional Formatting trick that'll have you easily illustrating results in a visual display, rather than just presenting data.Flash Fill
Extract just a small part of a cell throughout an entire list, change the order of words, or join together parts of multiple cells within a large list, with just a couple of clicks!Array Formula
Create an array formula that'll extract only unique items from a large list of repeating values.