Excel Functions
This course is a comprehensive overview of what effective business analysts really do - their strategies, techniques, tools and methods – all which apply to any process whether it’s a traditional large project, and Agile or DevOps project.
1
Segment - 01 - Introduction to the Course
Segment - 02 - Introduction of the Instructor
Segment - 03 - Course Requirements
Segment - 04 - How to get Excel
2
Segment - 05 - What will we learn in this section
Segment - 06 - Create an if() Function
Segment - 07- nest and() and or() Functions within Reference Functions
Segment - 08 - Work with choose() , vlookup() ,Index() ,and match() Functions
Segment - 09 - Create a vlookup() function
Segment - 10 - Section Summary
3
Segment - 11 - What will we learn in this section
Segment - 12 - Aggregate Data using both the Sum and Subtotal Functions
Segment - 13 - Calculate Minimums, Maximums and Averages from Data sets
Segment - 14 - Use the Forecast Function to Forecast numbers along a Trend
Segment - 15 - Generate a Net Present Value using a Formula
Segment - 16 - Section Summary
4
Segment - 17 - What will we learn in this section
Segment - 18 - Work with Excel’s Date Manipulation Functions
Segment - 19 - Build a Holiday Date Calculator
Segment - 20 - Section Summary
5
Segment - 21 - What will we learn in this section
Segment - 22 - Split Textual Data Apart
Segment - 23 - Manipulate Textual Data
Segment - 24 - Replace Portions of Textual Data
Segment - 25 - Put Textual Data Back Together With Formulae
Segment - 26 - Work with Key Informational Functions For Evaluating and Responding Correctly to Errors in Routine Excel Calculations
Segment - 27 - Use the Hyperlink Function to Build Navigational Menus Inside an Excel Worksheet
Segment - 28 - Section Summary
6
Segment - 29 - What will we learn in this section
Segment - 30 - How to Filter Items in a List
Segment - 31 - Sorting List Without Messing up the Data
Segment - 32 - How to Freeze Rows or Columns
Segment - 33 - Remove Duplicates from a List
Segment - 34 - Section Summary
7
Segment - 35 - What will we learn in this section
Segment - 36 - Count, Counta and Countif Functions
Segment - 37 - Create a Drop Down List
Segment - 38 - Work with Isnumber and Search Functions within Text Functions
Segment - 39 - Format Row Based on a Cell Value
Segment - 40 - Create an Invoice Template in Excel
Segment - 41 - Section Summary
Segment - 42 - Course Summary and Next Steps