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
There are 7 modules in this course
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 the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digitals skills lead to higher income and better employment opportunities at a time when digital skills job are growing much faster than non-digital jobs.
In this second course of our Excel specialization Excel Skills for Business you will build on the strong foundations of the Essentials course. Intermediate Skills I will expand your Excel knowledge to new horizons. You are going to discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These key techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel.
Once again, we have brought together a great teaching team that will be with you every step of the way. Prashan and Nicky will guide you through each week (and I am even going to make a guest appearance in Week 5 to help you learn about my favourite tool in Excel - shh, no spoilers!). Work through each new challenge step-by-step and in no time you will surprise yourself by how far you have come. This time around, we are going to follow Uma's trials and tribulations as she is trying to find her feet in a new position in the fictitious company PushPin. For those of you who have done the Essentials course, you will already be familiar with the company. Working through her challenges which are all too common ones that we encounter everyday, will help you to more easily relate to the skills and techniques learned in each week and apply them to familiar and new contexts.
This module is all about working with multiple worksheets and workbooks. Learn how you can combine data, manage datasets and perform calculations across multiple sources. And don't forget the Toolbox with handy shortcuts and ninja tips.
What's included
8 videos8 readings6 assignments
Show info about module content
8 videos•Total 37 minutes
Week 1 Introduction•2 minutes
Week 1 Discussion•5 minutes
Practice Video: Multiple Worksheets•6 minutes
Practice Video: 3D Formulas•5 minutes
Practice Video: Linking Workbooks•7 minutes
Practice Video: Consolidating by Position•6 minutes
Practice Video: Consolidating by Category (Reference)•4 minutes
Week 1 Wrap-Up•1 minute
8 readings•Total 135 minutes
Welcome to Excel Skills for Business: Intermediate I•10 minutes
Course Goals and Weekly Learning Objectives•10 minutes
Read me before you start: Quizzes and Navigation•10 minutes
Download the Week 1 workbooks•5 minutes
Read me before you start: Versions and regions•10 minutes
Week 1: Practice Challenge•30 minutes
Week 1: Advanced Practice Challenge•30 minutes
Keyboard Shortcuts, Excel Terminology and Ninja Tips•30 minutes
6 assignments•Total 180 minutes
Multiple Worksheets•30 minutes
3D Formulas•30 minutes
Linking Workbooks•30 minutes
Consolidating by Position•30 minutes
Consolidating by Category (Reference)•30 minutes
Test your Skills: Working with Multiple Worksheets & Workbooks•30 minutes
Text and Date Functions
Module 2•5 hours to complete
Module details
By the end of this module, you will be an expert in Date and Text functions. This module discusses ways you can extract information and manipulate data to fulfil specific business requirements.
Practice Video: Combining Text (CONCAT, &)•4 minutes
Practice Video: Changing Text Case (UPPER, LOWER, PROPER)•5 minutes
Practice Video: Extracting Text (LEFT, MID, RIGHT)•4 minutes
Practice Video: Finding Text (FIND)•5 minutes
Practice Video: Date Calculations (NOW, TODAY, YEARFRAC)•4 minutes
Week 2 Wrap-Up•1 minute
3 readings•Total 65 minutes
Download the Week 2 workbooks•5 minutes
Week 2: Practice Challenge•30 minutes
Keyboard Shortcuts, Excel Terminology and Ninja Tips•30 minutes
6 assignments•Total 180 minutes
Combining Text (CONCAT, &)•30 minutes
Changing Text Case (UPPER, LOWER, PROPER)•30 minutes
Extracting Text (LEFT, MID, RIGHT)•30 minutes
Finding Text (FIND)•30 minutes
Date Calculations (NOW, TODAY, YEARFRAC)•30 minutes
Test your Skills: Text and Date Functions•30 minutes
1 discussion prompt•Total 10 minutes
Excel - how, when, where, why•10 minutes
Named Ranges
Module 3•4 hours to complete
Module details
Learn how you can create, manage and apply Named Ranges to enhance your calculations.
What's included
8 videos3 readings6 assignments
Show info about module content
8 videos•Total 31 minutes
Week 3 Introduction•2 minutes
Week 3 Discussion•3 minutes
Practice Video: Introducing Named Ranges•5 minutes
Practice Video: Creating Named Ranges•5 minutes
Practice Video: Managing Named Ranges•4 minutes
Practice Video: Named Ranges in Formulas•5 minutes
Practice Video: Apply Names•5 minutes
Week 3 Wrap-Up•1 minute
3 readings•Total 35 minutes
Download the Week 3 workbooks•5 minutes
Week 3: Practice Challenge•20 minutes
Keyboard Shortcuts, Terminology and Ninja Tips•10 minutes
6 assignments•Total 180 minutes
Introducing Named Ranges•30 minutes
Creating Named Ranges•30 minutes
Managing Named Ranges•30 minutes
Named Ranges in Formulas•30 minutes
Apply Names•30 minutes
Test your Skills: Named Ranges•30 minutes
Summarising Data
Module 4•5 hours to complete
Module details
Graduate to advanced formulas in this module. Learn how you can use functions like COUNTIFS to extract information from data, as well as generate graphical representations of it.
What's included
9 videos3 readings7 assignments
Show info about module content
9 videos•Total 37 minutes
Week 4 Introduction•2 minutes
Week 4 Discussion•4 minutes
Practice Video: COUNT functions•4 minutes
Practice Video: Counting with Criteria (COUNTIFS)•5 minutes
Practice Video: Adding with Criteria (SUMIFS)•6 minutes
Practice Video: Sparklines•4 minutes
Practice Video: Advanced Charting•5 minutes
Practice Video: Trendlines•4 minutes
Week 4 Wrap-Up•1 minute
3 readings•Total 55 minutes
Download the Week 4 workbooks•5 minutes
Week 4: Practice Challenge•20 minutes
Keyboard Shortcuts, Excel Terminology and Ninja Tips•30 minutes
7 assignments•Total 210 minutes
COUNT functions•30 minutes
Counting with Criteria (COUNTIFS)•30 minutes
Adding with Criteria (SUMIFS)•30 minutes
Sparklines•30 minutes
Advanced Charting•30 minutes
Trendlines•30 minutes
Test your Skills: Summarising Data•30 minutes
Tables
Module 5•3 hours to complete
Module details
Tables, tables, tables. Start with creating, formatting and managing tables and then move on to sorting and filtering tables to get the data you need. Finally, wrap up this module automating your tables to make your work more efficient.
What's included
8 videos3 readings6 assignments
Show info about module content
8 videos•Total 36 minutes
Week 5 Introduction•2 minutes
Week 5 Discussion•4 minutes
Practice Video: Creating and Formatting Tables•5 minutes
Practice Video: Working with Tables•6 minutes
Practice Video: Sorting and Filtering in Tables•6 minutes
Practice Video: Automation with Tables•5 minutes
Practice Video: Converting to Range and Subtotaling•5 minutes
Week 5 Wrap-Up•1 minute
3 readings•Total 35 minutes
Download the Week 5 workbooks•5 minutes
Week 5: Practice Challenge•20 minutes
Keyboard Shortcuts, Excel Terminology and Ninja Tips•10 minutes
6 assignments•Total 80 minutes
Creating and Formatting Tables•10 minutes
Working with Tables•10 minutes
Sorting and Filtering in Tables•10 minutes
Automation with Tables•10 minutes
Converting to Range and Subtotaling•10 minutes
Test your Skills: Tables•30 minutes
Pivot Tables, Charts and Slicers
Module 6•4 hours to complete
Module details
This module deep dives into the popular (and very useful) pivot tables. Learn how you can create and modify them to solve a variety of business problems. Then gain skills to create interactive dashboards with pivot charts and slicers.
What's included
9 videos3 readings7 assignments
Show info about module content
9 videos•Total 42 minutes
Week 6 Introduction•2 minutes
Week 6 Discussion•3 minutes
Practice Video: Creating and Modifying a Pivot Table•6 minutes
Practice Video: Value Field Settings•6 minutes
Practice Video: Sorting and Filtering a Pivot Table•5 minutes
Practice Video: Reporting Filter Pages•7 minutes
Practice Video: Pivoting Charts•6 minutes
Practice Video: Pivoting Slicers•6 minutes
Week 6 Wrap-Up•1 minute
3 readings•Total 35 minutes
Download the Week 6 workbooks•5 minutes
Week 6: Practice Challenge•20 minutes
Keyboard Shortcuts, Excel Terminology and Ninja Tips•10 minutes
7 assignments•Total 190 minutes
Creating and Modifying a Pivot Table•30 minutes
Value Field Settings•30 minutes
Sorting and Filtering a Pivot Table•10 minutes
Report Filter Pages•30 minutes
Pivoting Charts•30 minutes
Pivoting Slicers•30 minutes
Test your Skills: Pivot Tables, Charts and Slicers•30 minutes
Final Assessment
Module 7•1 hour to complete
Module details
What's included
1 assignment
Show info about module content
1 assignment•Total 60 minutes
Final Assessment•60 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructors
Instructor ratings
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world. Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society.
"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.9
17,653 reviews
5 stars
90.26%
4 stars
8.84%
3 stars
0.58%
2 stars
0.11%
1 star
0.18%
Showing 3 of 17653
M
MK
5·
Reviewed on Jan 5, 2021
I have learned a lot of important and useful excel secrets those will play a vital role in my career. I am very thankful to my instructors. Every lesson is so amazing. I have updated my excel skills.
M
MB
5·
Reviewed on May 4, 2020
Awesome course, the videos are very easy going and if you practice along, it won,t be hard to pass all the exams with more than 905 marks. Thanks to faculties and the University offering the course.
M
MT
5·
Reviewed on Oct 16, 2020
Just WoW !!! I really happy that i take these courses . I learn a lot but need to learn more. Thanks to all teachers specially Nicky mam for excellent teaching style. Getting ready for next task.
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.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.
What will I get if I subscribe to this Specialization?
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.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.