Apply Excel to Data Analytics
If you want to learn Excel and dive into data analytics, this is the class for you.
Build Skills with Hands-On Projects
To learn efficient data analysis, you'll complete projects under the guidance of an experienced instructor.
Learn Core Functions & Formulas
Learn advanced techniques to sort, filter, group, and visualize data in Excel.
What You Will Learn
- Learn Excel functions and formulas for organizing, calculating, and summarizing data efficiently
- Create and customize visual charts, including line, column, and pie charts, to present data clearly
- Use logical statements, database functions, and data validation to manage and filter large datasets
- Build and manipulate Pivot Tables to quickly summarize, sort, and group information
- Explore advanced tools like named ranges, date calculations, and macro recording for custom reporting
- Apply auditing techniques, cell locking, and Excel hot keys to optimize your spreadsheet workflow
Course Outline
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 PivotTables 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
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
