Macquarie University

Excel Skills for Business: Advanced

Nicky Bull
Dr Prashan S. M. Karunaratne
Professor Yvonne Breyer

Instructors: Nicky Bull

220,353 already enrolled

Included with Coursera Plus

Gain insight into a topic and learn the fundamentals.
4.7

(5,922 reviews)

Intermediate level
Some related experience required
Flexible schedule
Approx. 25 hours
Learn at your own pace
95%
Most learners liked this course
Gain insight into a topic and learn the fundamentals.
4.7

(5,922 reviews)

Intermediate level
Some related experience required
Flexible schedule
Approx. 25 hours
Learn at your own pace
95%
Most learners liked this course

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

29 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Placeholder

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
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 7 modules in this course

As an intermediate Excel user, you have the basics down. The first module of the Advanced course focusses on creating and maintaining accurate, flexible, responsive and user-friendly spreadsheets. You will learn how to design flexible and auditable spreadsheets, construct transparent calculations, create user-friendly navigation, and use styles, themes and formatting to tie it all up in a nice bow.

What's included

7 videos7 readings5 assignments1 discussion prompt

Excel often requires you to perform complex analysis on large sets of data. This can be made a lot easier using array formulas, which can perform multiple calculations simultaneously and ensure the accuracy of your spreadsheet. This module covers the use of array formulas, how to build them and use them effectively.

What's included

7 videos2 readings5 assignments

Been handed a messy spreadsheet? This module focuses on data cleaning and preparation. You will learn how to use dynamic and automated fixes, clean messy data, automate these processes through functions, and ensure data remains clean dynamically. We will use functions to fix dates, replaces blanks and remove unwanted characters from data – all to help us build an efficient solution that lasts.

What's included

7 videos2 readings7 assignments

This module introduces financial functions into our Excel knowledge base. Financial functions are often used in businesses and Excel has a variety of tools to help you with that. This week, you will learn to apply date formulas in calculations, create loan schedules with financial functions, as well as use depreciation functions.

What's included

7 videos2 readings6 assignments

It is always a good idea to make your spreadsheets (and work!) more automated. Automated lookups can make your work fast and efficient. This module builds on your array capabilities and explores a range of functions to create dynamic lookup ranges – INDIRECT, ADDRESS, OFFSET and INDEX.

What's included

6 videos2 readings4 assignments

To bring it home, this module guides you through the steps of building a professional dashboard. Data is meaningless unless it tells a story and can be used as business intelligence. This module will help you set up a dashboard – learn how to visualise data through graphs and charts, create data models, and add interactivity.

What's included

7 videos2 readings1 assignment

What's included

1 assignment

Instructors

Instructor ratings
4.8 (1,325 ratings)
Nicky Bull
Macquarie University
25 Courses1,363,251 learners
Dr Prashan S. M. Karunaratne
Macquarie University
28 Courses1,371,212 learners
Professor Yvonne Breyer
Macquarie University
24 Courses1,218,425 learners

Offered by

Recommended if you're interested in Business Essentials

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.7

5,922 reviews

  • 5 stars

    80.78%

  • 4 stars

    14.40%

  • 3 stars

    3.34%

  • 2 stars

    0.62%

  • 1 star

    0.84%

Showing 3 of 5922

JR
5

Reviewed on Sep 22, 2020

SD
5

Reviewed on Jul 31, 2020

D
5

Reviewed on Apr 15, 2021

New to Business Essentials? Start here.

Placeholder

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