Course description
Excel for Everyone: Data Management
This intermediate Excel course builds on the teachings of the introductory Core Foundations course, teaching you to leverage the power of data calculations and reports to make informed personal or organizational decisions.
The course is designed for learners who already have foundational knowledge and skills in Excel but wish to take advantage of some of the higher-level functionality to more effectively analyze and present data. From error prevention to forecasting andautomation, you’ll build an advanced layer of knowledge to manage larger datasets and continue developing your aptitude for data modeling.
Upcoming start dates
1 start date available
Suitability - Who should attend?
Prerequisites
None
Outcome / Qualification etc.
What you'll learn
- How to manage multiple worksheets and workbooks.
- Analyzing data with datasets and tables.
- How to manage data analysis using Pivot Tables and Pivot Charts.
- Implementing What-If Analysis and Decision-Making Tools.
- Using Date, Logical, Statistical and Financial Functions.
Course delivery details
This course is offered through University of British Columbia, a partner institute of EdX.
2-4 hours per week
Expenses
- Verified Track -$149
- Audit Track - Free
Ads