Course curriculum

1. Segment - 01 - Introduction to the Course

2. Segment - 02 - Introduction of the Instructor

3. Segment - 03 - Course Requirements

4. Segment - 04 - How to get Excel

1. Segment - 05 - What will we learn in this section

2. Segment - 06 - Create an if() Function

3. Segment - 07- nest and() and or() Functions within Reference Functions

4. Segment - 08 - Work with choose() , vlookup() ,Index() ,and match() Functions

5. Segment - 09 - Create a vlookup() function

6. Segment - 10 - Section Summary

1. Segment - 11 - What will we learn in this section

2. Segment - 12 - Aggregate Data using both the Sum and Subtotal Functions

3. Segment - 13 - Calculate Minimums, Maximums and Averages from Data sets

4. Segment - 14 - Use the Forecast Function to Forecast numbers along a Trend

5. Segment - 15 - Generate a Net Present Value using a Formula

6. Segment - 16 - Section Summary

1. Segment - 17 - What will we learn in this section

2. Segment - 18 - Work with Excel’s Date Manipulation Functions

3. Segment - 19 - Build a Holiday Date Calculator

4. Segment - 20 - Section Summary

1. Segment - 21 - What will we learn in this section

2. Segment - 22 - Split Textual Data Apart

3. Segment - 23 - Manipulate Textual Data

4. Segment - 24 - Replace Portions of Textual Data

5. Segment - 25 - Put Textual Data Back Together With Formulae

6. Segment - 26 - Work with Key Informational Functions For Evaluating and Responding Correctly to Errors in Routine Excel Calculations

7. Segment - 27 - Use the Hyperlink Function to Build Navigational Menus Inside an Excel Worksheet

8. Segment - 28 - Section Summary

1. Segment - 29 - What will we learn in this section

2. Segment - 30 - How to Filter Items in a List

3. Segment - 31 - Sorting List Without Messing up the Data

4. Segment - 32 - How to Freeze Rows or Columns

5. Segment - 33 - Remove Duplicates from a List

6. Segment - 34 - Section Summary