Course curriculum

  • 1

    Welcome to the course!

    • Instructor bio - John Bura
    • Key pointers for this program
    • Joining the Alumni Community
  • 2

    Module One

    • Segment - 01 - Introduction to the Course
    • Segment - 02 - Introduction of the Instructor
    • Segment - 03 - Course Requirements
    • Segment - 04 - How to get Excel
  • 3

    Module Two

    • 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
  • 4

    Module Three

    • 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
  • 5

    Module Four

    • 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
  • 6

    Module Five

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

    Module Six

    • 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
  • 8

    Module Seven

    • 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