Ready to learn more?
Next Cohort: Jul 5-Jan 5
Jul 5-Jan 5
Aug 2 - Feb 2 2022
Sep 6 - Mar 6 2022
Oct 4 - Apr 4 2022
This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio.
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’ll 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.
Ready to get started?
Next Cohort: Jul 5-Jan 5
Student Reviews (24)
This course provided some basic insights on Microsoft Excel including the pivot table, pivot chart, histogram etc. One who's completely new to Excel can enroll in this course and learn a lot. The quiz questions were very much up to the mark and one rea...
This course provided some basic insights on Microsoft Excel including the pivot table, pivot chart, histogram etc. One who's completely new to Excel can enroll in this course and learn a lot. The quiz questions were very much up to the mark and one really needs to understand each lesson clearly to answer those questions. Overall, it was a nice course!
I would class myself as quite a competent Excel user, but (as most probably like most!), all self taught with little or no 'formal' qualifications. So I wanted to follow a specialization route to gain these 'approved competencies). Having followed othe...
I would class myself as quite a competent Excel user, but (as most probably like most!), all self taught with little or no 'formal' qualifications. So I wanted to follow a specialization route to gain these 'approved competencies). Having followed other online training before, I can honestly say that the presentation both in terms of delivery and content is as good as I've ever seen. Really well constructed, with a plan and focus to take you from week 1 to week 6. Great structure that builds upon the previous weeks knowledge and also contains detailed examples with enough data content that allows you to 'play' around and practice. It delivers on it's essentials tagline, as the topics are relevant and focused to provide a great base to 'overcome' any fears of using Excel, so that you can build upon good knowledge in the workplace. From start to finish one of the best online courses that i've ever seen and participated in.