Wise Owl - Microsoft Excel training videos

Showing videos 1-9 (out of 9)

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.

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.

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

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.

This page has 0 threads Add post