This training of MS Excel provides an overview of advanced functions and formulas in MS Excel. This training is ideal for anyone who is fairly new to Excel, needs a refresher or works with datasets.
In this recording we we work with larger data sets in MS Excel, and utilize functions such as SUMIF, COUNTIF, and VLOOKUP.
After watching this training, you will know how to:
- Understand common use cases for advanced functions
- Use VLOOKUPS to reference data from different sheets or workbooks
- Develop strategies to breakdown larger data sets using Excel functions
