This course is built for anyone ready to treat Excel as a serious data analytics tool instead of just a place to keep simple spreadsheets. You'll dig into real data sets and project based work that demonstrates how Excel can sort, filter, group, and visualize information in ways that actually mean something. With the freedom to move through the material on your own schedule, you'll discover how to apply core functions and formulas that organize data efficiently and transform raw numbers into clear, usable insights.
As you move forward, you'll develop sharper skills for analyzing and presenting your findings. You'll build and customize charts, put logical statements and database functions to work on large data sets, and rely on Pivot Tables to summarize information in seconds. You'll also get introduced to tools like named ranges, date calculations, macro recording, and auditing features, all of which help you tighten your workflow and produce spreadsheets that are more dependable and polished.
What You Will Learn
- Apply Excel functions and formulas to organize, calculate, and summarize data with efficiency
- Design and tailor visual charts, including line, column, and pie charts, to present data clearly
- Work with logical statements, database functions, and data validation to manage and filter large datasets
- Construct and adjust PivotTables to quickly summarize, sort, and group information
- Discover advanced tools such as named ranges, date calculations, and macro recording for custom reporting
- Use auditing techniques, cell locking, and Excel hot keys to streamline 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 use 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
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.
