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 third course of our Excel specialization Excel Skills for Business you will delve deeper into some of the most powerful features Excel has to offer. When you have successfully completed the course you will be able to
Excel Skills for Business: Intermediate II
This course is part of Excel Skills for Business Specialization
Instructors: Nicky Bull
Sponsored by Barbados NTI
223,464 already enrolled
(8,219 reviews)
Skills you'll gain
Details to know
Add to your LinkedIn profile
43 assignments
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There are 7 modules in this course
We kick off this course with data validation and conditional formatting. This module takes you through creating and applying data validation, as well as working with formulas in data validation. This is followed by basic and advanced conditional formatting.
What's included
8 videos6 readings7 assignments1 discussion prompt
Excel has several logical functions and this module explores some of them. Start by learning the concept of conditional logic in formulas, followed by how to conduct logic tests and use conditional operations, to your benefit. We will also look at nested IF functions to evaluate data.
What's included
8 videos2 readings7 assignments
How do you find information from different parts of a workbook? This module introduces you to functions like CHOOSE, VLOOKUP, INDEX, MATCH and other dynamic lookups to find and display data from several sources.
What's included
8 videos2 readings7 assignments
If you are worried that errors have crept into your worksheet, this module will show you how to check for errors, trace precedents and dependents, resolve circular references, and finally, protect your worksheets and workbooks from further harm.
What's included
8 videos2 readings7 assignments1 discussion prompt
This module is all about data modelling. Learn to model different scenarios based on input, assumptions and/or outcomes. Also learn the use of functionalities like Goal Seek, Data Tables and the Scenario Manager to make your models more robust.
What's included
8 videos2 readings7 assignments
We all love a bit of automation, and this module teaches you just that. By the time you have completed this module, you will be able to identify the uses of macros, as well as create, edit and manage them to increase your efficiency.
What's included
8 videos2 readings7 assignments
What's included
1 assignment
Instructors
Offered by
Why people choose Coursera for their career
Learner reviews
8,219 reviews
- 5 stars
84.48%
- 4 stars
13.06%
- 3 stars
1.82%
- 2 stars
0.38%
- 1 star
0.24%
Showing 3 of 8219
Reviewed on Aug 11, 2020
The video lectures are nice but pls improve the quality of practice excel workbooks because sometimes it did not open and excel shows that the workbook is corrupted and it is very disturbing.
Reviewed on Jul 9, 2021
More than Awesome, the level of toughness for some questions made me think outside of the box and that made my excel skills more stronger. Thank you for this course, helped me a lot to learn.
Reviewed on Dec 17, 2020
Thank you, dear all Prashan, Nicky and Yvonne! The teaching course has been concise, clear and very user friendly!
Recommended if you're interested in Business
Coursera Instructor Network
Coursera Project Network
Vanderbilt University
University of Colorado Boulder
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy