Master the VLOOKUP

Everything you need to know to master the VLOOKUP What is a VLOOKUP Function? Whenever you keep track of anything with spread sheets, there’ll come a time when you want to find information without having to scroll through a list or Table. That’s when the...

How to use the SUM Function in Microsoft Excel

How to use the SUM Function in Microsoft Excel This quick video explains how to use the SUM Function in Excel. Learn how to add rows and columns of data quickly and easily using Excel’s built-in SUM function – use the ribbon or type the function directly into a cell....

Sorting data alphabetically

Sorting Data Alphabetically This quick video explains how to sort Data Alphabetically in Excel Sorting data alphabetically is the most common way of sorting textual data in Excel – usually in Ascending going from A – Z or in descending Z – A order. Learn how to Sort...

Importing Web Data

Importing Web Data This quick video explains how to easily Import Data from the Web. More frequently we can find data we need to feed our spreadsheet online – learn how to import and link to web data using Excel. [et_social_follow icon_style="slide"...

Applying a Filter

Applying a Filter This quick video explains how to Apply a Filter in your Excel worksheet. Once a Filter has been enabled on a list or table – we can turn on or off a filter and use it to select a range of cells that matches the filter selected. [et_social_follow...

Importing MS Access Data

Importing MS Access Data This quick video will show you how to Import File Information from Access. Access tables can be imported and linked to Excel so that we can run reports or build charts based on that data. Learn how to link and import data from Microsoft...