Advanced Formulas in Excel – 1 Hour Recorded Webinar
In this one hour, recorded live webinar, Deb Ashby takes us through some Advanced Formulas in Excel.
Deb starts by looking at logical functions and two-way lookups before moving onto combining a number of more advanced functions to solve complex problems in Excel.
Here’s what she covers in detail:
- Logical Functions (IF, IFS, AND, OR)
- Two-way Lookups (INDEX, MATCH)
- Assigning Random Values (CHOOSE, RANDBETWEEN)
- Finding the Most Recent Occurrence (INDEX, MATCH, MODE, SUMPRODUCT)
- Looking up Values (XLOOKUP)
- Extracting Text Strings (LEFT, RIGHT, LEN, FIND)
- Sum and Count with Multiple Criteria (SUMIFS, COUNTIFS)
- Dynamic SUM Calculations (SUM, OFFSET, MATCH)
If you’d like to follow along with the presentation, you can do so by downloading the accompanying Excel workbook here.
Take a look at other Simon Sez IT Member Webinars
Adam Lacey
Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats.When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.
