Excel for Data Analytics

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