Free Online Microsoft Excel 2016 Formulas & Functions Video Tutorials

Category: Computer Software Sub Category: Productivity Brand: Microsoft Product: Excel Version: 2016 Feature: Formulas & Functions

In this demo Peter Kalmstrom shows way to analyze what happens when data changes. He uses the What-If-Analysis Tools Goal Seeker and Scenario Manager. Also refer to http://www.kalmstrom.com/Tips/Excel-2016-Course/Cupcakes-Exercise.htm where you can d...

In this demo Peter Kalmstrom shows way to analyze what happens when data changes. He uses the What-If-Analysis Tools Goal Seeker and Scenario Manager. Also refer to http://www.kalmstrom.com/Tips/Excel-2016-Course/Cupcakes-Exercise.htm where you can d...

This video explains why you should use Formulas in Excel 2016. Also refer to http://www.kalmstrom.com/Tips/Excel-2016-Course/Formulas-2.htm...

This video explains the basics of using formulas in Excel 2016. Also refer to http://www.kalmstrom.com/Tips//Excel-2016-Course/Formulas.htm...

Peter Kalmstrom shares an exercise on how to calculate percentage and sums of sub-sums in Excel 2016 and shows in a demo how to do it. He uses a conveyor bid ans an example. Also refer to http://www.kalmstrom.com/Tips/Excel-2016-Course/Conveyor-Bid-E...

Excel 2016 course, also suitable for earlier versions. In this demo Peter Kalmstrom hows how to manipulate numbers with the TRUNC and ROUND functions. Refer to http://www.kalmstrom.com/Tips/Excel-2016-Course/Numbers-Exercise.htm where you can downloa...

Peter Kalmstrom shares an exercise on how to manage formulas with relative cell references in Excel 2016 and shows in a demo how to do it. He uses stock profits calculations in his example. Also refer to http://www.kalmstrom.com/Tips/Excel-2016-Cours...

Excel 2016 course, also suitable for earlier versions. In this demo Peter Kalmstrom explains how to use the Excel IF function. Also refer to http://www.kalmstrom.com/Tips/Excel-2016-Course/IF-Function-Exercise.htm where you can download the file Pete...