Training videos for learning MICROSOFT EXCEL

We have 15 Microsoft Excel videos listed below. You might also like to consider booking a place on one of our online or classroom Excel courses, where you will meet the owls behind the videos!

Protecting worksheets

Posted by Andrew Gould on 28 February 2012

Learn how to protect worksheets and cells in Excel.

Data validation

Posted by Andrew Gould on 28 February 2012

Learn how to use data validation in Microsoft Excel to control the values that can be entered into cells. Create custom error messages and fancy drop down lists with a few clicks of the mouse.

Scenarios

Posted by Andrew Gould on 27 February 2012

Learn how to use scenarios in Microsoft Excel to quickly switch between different sets of input values for your spreadsheet models. Learn how to quickly create summary reports to compare a range of scenarios side-by-side.

Goal-seeking

Posted by Andrew Gould on 24 February 2012

Learn how to use the Goal Seek tool in Microsoft Excel to find the right inputs to meet your targets.

Styles

Posted by Andrew Gould on 24 February 2012

Learn how to use styles to speed up formatting in Microsoft Excel.

Excel - Spilled Array Formulas

Posted by Andrew Gould on 19 April 2022

Spilled array formulas provide several advantages over traditional formulas in Excel. If you're working with Office 365 or Excel 2021 it's well worth learning how to use this type of formula effectively.

Conditional formatting - basic

Posted by Andrew Gould on 21 October 2011

Learn how to apply conditional formats in Microsoft Excel to highlight important values in a range of numbers.

Conditional formatting - data bars

Posted by Andrew Gould on 21 October 2011

Learn how to apply conditional formats in Microsoft Excel to grade a range of numbers using data bars and icon sets.

Conditional formatting - linked

Posted by Andrew Gould on 21 October 2011

Learn how to use formulae in conditional formats in Microsoft Excel to highlight one cell based on the value of another cell.

Custom date formats

Posted by Andrew Gould on 21 October 2011

Learn how to create custom date formats in Microsoft Excel to display your dates in exactly the way you want.

Excel - The SORT and SORTBY Functions

Posted by Andrew Gould on 08 May 2022

Learn how to use the SORT and SORTBY functions in Microsoft Excel to return dynamic spilled arrays of sorted values. You'll learn how to sort single rows and columns as well as entire tables; how to change the sort order; and how to sort by multiple values.

Excel - The UNIQUE Function

Posted by Andrew Gould on 08 May 2022

Learn how to use the UNIQUE function in Microsoft Excel to return unique values from a row, column or table.

Excel - The TRANSPOSE Function

Posted by Andrew Gould on 08 May 2022

Learn how to use the TRANSPOSE function in Microsoft Excel to convert rows into columns and columns into rows.

Excel - The SEQUENCE Function

Posted by Andrew Gould on 08 May 2022

Learn how to use the SEQUENCE function in Microsoft Excel to calculate sequences of numbers and dates

Excel - The FILTER Function

Posted by Andrew Gould on 08 May 2022

Learn how to use the FILTER function in Microsoft Excel to return filtered lists of values. You'll learn how to apply filters to numbers, dates and text; how to search for values containing text; how to find the biggest, smallest and top N values in a list; how to combine filters using logical operators; and how to use cells to create a convenient way to provide criteria to your filters.

This page has 0 threads Add post