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.
Offered By
About this Course
Learner Career Outcomes
20%
20%
Skills you will gain
Learner Career Outcomes
20%
20%
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.
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
TOP REVIEWS FROM EXCEL SKILLS FOR BUSINESS: INTERMEDIATE I
The length of the video lectures are just right and the numbers of exercises or quizzes are just right. Learned a lot of new things about Excel's functionality. A huge step from the Essentials course.
Amazing course. I am amazed by the value provided by the instructors. The Pivot Tables in Week 6 is a must for everyone working with Excel. I am glad I chose this course over the other online courses.
I love this course a lot! Thank you very much for this course. It is easy to understand and follow. The practice challenges are so fun to do. Looking forward to the next course in this specialization.
Great course. I have learned lots of good techniques creating pivot tables, slicer. Now i am very confident to make a dashboard for the management. I am looking forward to learn next courses in Excel.
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.