Learn Excel Skills for Business. Master Excel to add a highly valuable asset to your employability portfolio.
About this Specialization
In this Specialization, learners develop advanced Excel Skills for Business. Upon completing the four courses in this Specialization, learners can design sophisticated spreadsheets, including professional dashboards, and perform complex calculations using advanced Excel features and techniques.
Learners have acquired the skills to manage large datasets efficiently, extract meaningful information from datasets, present data and extract information effectively. In addition, learners have mastered the skills needed to validate data and prevent errors in spreadsheets, create automation, apply advanced formulas and conditional logic to help make decisions and create spreadsheets that help forecast and model data.
WHAT YOU WILL LEARN
Be comfortable navigating the Excel user interface, entering, manipulating and formatting data.
Use formulas and functions to perform calculations on data. Automate choices and data lookups using functions.
Analyze data and present the results in a user-friendly way. Create charts and tables that effectively summarize raw data.
Create easy-to-use spreadsheets. Validate data, find and correct errors. Create navigation aids for large workbooks.