Learn Microsoft Excel – Functions, Formulas, and Pivot Tables
What you’ll learn
- How to create Pivot Tables to quickly summarize data
- How to use VLOOKUP and INDEX/MATCH to pull out specific info from large data sets
- How to use basic math/statistical functions like SUM, AVERAGE, COUNTIFS, and more…
- How to build conditional statements using the IF() function
- How to organize data to be scalable and easily used other data analysts
- How to move around Excel quickly and efficiently
- How to sort and filter data based on specific criteria
- How to streamline your data analysis workflow in Excel
What’s Included
- Over two hours of instructional video
- 10 quizzes to test your knowledge throughout the course
- 3 course projects to apply your knowledge
- Instructor Q&A support
