The Complete Excel Formulas Course Excel 2013

Zenler Player

Your course is loading. Hang tight.

1.1 Excel 2013 basics formulas and auditing Preview
1.2 Excel 2013 relative and absolute cells
1.3 Excel 2013 Beefing up the basics
1.4 Excel 2013 working with errors
1.5 Excel 2014 protecting your workbooks

2.1 Excel 2013 Logical Functions
2.2 Excel 2013 IF statements Preview
2.3 Excel 2013 Net pay and dynamic labels using the IF statement
2.4 Excel 2013 Conditional formatting
2.5 Excel 2013 Data validation and random numbers

3.1 Excel 2013 Text Preview
3.2 Excel 2013 Date and time
3.3 Excel 2013 Custom formatting
3.4 Excel 2013 More Date - Age debtors

4.1 Excel 2013 Intro to arrays Preview
4.2 Excel 2015 Boolean and arrays
4.3 Excel 2013 Tables
4.4 Excel 2013 Advanced filters
4.5 Excel 2013 Pivot tables intro
4.6 Excel 2013 more pivot tables
4.7 Excel 2013 intro to power pivot
4.8 Excel 2013 powerpivot quick tip

5.1 Excel 2013 Vlookup Preview
5.2 Excel 2014 Index and Match
5.3 Excel 2013 Choose

6.1 Excel 2013 Future present and NPV Preview
6.2 excel 2013 NPV
6.3 Excel 2013 Payment function
6.4 Excel 2013 Other finance functions
6.5 Excel 2013 Consolidate data

7.1 Excel 2013 1 Variable What IF Preview
7.2 Excel 2013 2 Variable what IF
7.3 Excel 2013 Scenario Manager and goal seek
7.4 Excel 2013 Solver

8.1 Excel 2013 form controls Preview
8.2 Excel 2013 Form Control and User Interface
8.3 Excel 2013 Simple macros
8.4 Excel 2013 Editing a macro
8.5 excel 2013 Power Maps
8.6 Excel 2013 getting data from the web