Take your data analysis abilities to the next level with our Excel for Data Analytics course. You'll master key functions, formulas, and powerful techniques such as Pivot Tables and VLOOKUP. Through practical, real-world exercises, you'll build the skills to streamline your workflow and handle data with greater speed and confidence.
Overview
Syllabus
Excel Level I: Fundamentals
- Learn how to use functions to speed up your workflow
- Add formatting and other visual effects
- Turn data into visual charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management
Excel Level II: Intermediate
- Learn to split and join text, add data validation, and named ranges
- Use database functions and logical statements
- Create Pivot Tables to quickly summarize large databases
- Create advanced combo charts from multiple charts
Excel Level III: Advanced
- Cell management, including cell locking, auditing, and hot keys
- Special formatting for calculating dates
- Use advanced functions and advanced analytical tools
- Record macros and relative reference macros for ad hoc reporting
Taught by
Garfield Stinvil, Colin Jaffe, and Brian McClain
