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.
This course is part of the Excel Skills for Business Specialization
Offered By
About this Course
Skills you will gain
- Concatenation
- Microsoft Excel
- Consolization
- Pivot Table
- Pivot Chart
Offered by

Macquarie University
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.
Start working towards your Master's degree
Syllabus - What you will learn from this course
Working with Multiple Worksheets & Workbooks
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.
Text and Date Functions
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.
Named Ranges
Learn how you can create, manage and apply Named Ranges to enhance your calculations.
Summarising Data
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.
Reviews
- 5 stars90.34%
- 4 stars8.83%
- 3 stars0.56%
- 2 stars0.11%
- 1 star0.13%
TOP REVIEWS FROM EXCEL SKILLS FOR BUSINESS: INTERMEDIATE I
This is so far the best Excel course that I have encountered. By the end of the 1st week, I enrolled in the next two courses provided by the same school as well. Extremely impressive and a must-do.
Excellent course. The content is challenging for someone familiar with Excel looking to refresh and enhance skills. I definitely recommend taking the Essentials course before beginning this course.
I really enjoyed the flow of the teaching and the content provided. It made for a very smooth learning experience and helped me gain alot of knowledge which i can now apply at my job! thanks alot
I learned a lot from this course. Before starting this course I even can't plot a simple graph for my reports but then this course helped me learning mind blowing skills. Thanks Macquarie University.
About the Excel Skills for Business Specialization
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 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 digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others.

Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
What version of Excel do you teach?
More questions? Visit the Learner Help Center.