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
Excel Skills for Business: Intermediate II
This course is part of Excel Skills for Business Specialization
Instructors: Nicky Bull
223,492 already enrolled
Included with 
Gain insight into a topic and learn the fundamentals.
4.8
(8,219 reviews)
Intermediate level
Some related experience required
Flexible schedule
Approx. 28 hours
Learn at your own pace
96%
Most learners liked this course
Skills you'll gain
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
43 assignments
Taught in English
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
This course is part of the Excel Skills for Business Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
- 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
Instructor ratings
4.8 (1,597 ratings)Offered by
Recommended if you're interested in Business Essentials
Coursera Project Network
Coursera Project Network
Coursera Project Network
Macquarie University
Why people choose Coursera for their career
Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.8
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
AC
4
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.
SS
5
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.
EK
5
Reviewed on Dec 17, 2020
Thank you, dear all Prashan, Nicky and Yvonne! The teaching course has been concise, clear and very user friendly!
New to Business Essentials? Start here.
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
Frequently asked questions
In this course, we are using Microsoft Excel 2016 (Office 365) on a Windows PC with all options set to default. The Office 365 version of Excel is the latest version at the time of writing and developing this course. If you have a different version of Excel or you are using a Mac, some tools and buttons will look different, they may be located in a different spot, or some might be missing altogether. If there are any major differences, we usually point them out during the practice videos. If you cannot find a tool that we mention, you can always ask in the forums or search the Internet. Most of the functionality we demonstrate is also available in other spreadsheet programs, although the interface will look different. Most other spreadsheet software can import and export files in the Microsoft Excel format. If you are not sure which version of Excel you are using, check the Microsoft support pages for help.
If you cannot use Excel 2016 on a PC, you will be able to follow along with the videos, however, please note that some of the assessment tasks will require Excel. Where possible, we have designed assessment tasks so that users of older versions of Excel (such as 2013) can still solve them.
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.