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
Access provided by Coursera Learning Team
227,944 already enrolled
(8,261 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,261 reviews
- 5 stars
84.47%
- 4 stars
13.04%
- 3 stars
1.85%
- 2 stars
0.38%
- 1 star
0.24%
Showing 3 of 8261
Reviewed on Jul 21, 2020
Practice Challenge of Week 6 is very difficult. It would be great if the team could add the step by step video on how to solve that challenge. It will be a big help for all the future learners.
Reviewed on Jul 9, 2020
The course is great. However, I was a little disappointed with the final assessment. The wordings of the question seem to be confusing a lot!! Overall, its very good in terms of teaching.
Reviewed on Jul 16, 2020
although is super tough to answer all the questions, but involved whole process until end makes me feel that I become more successful and valuable person. really encourage try this course.
Recommended if you're interested in Business
Macquarie University
Macquarie University
Macquarie University
Macquarie University

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