Macquarie University

Excel Skills for Business: Advanced

This course is part of Excel Skills for Business Specialization

Taught in English

Some content may not be translated

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

Instructors: Nicky Bull

208,158 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.7

(5,797 reviews)

|

95%

Intermediate level
Some related experience required
25 hours (approximately)
Flexible schedule
Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

29 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.7

(5,797 reviews)

|

95%

Intermediate level
Some related experience required
25 hours (approximately)
Flexible schedule
Learn at your own pace

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 quizzes1 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 quizzes

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 quizzes

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 quizzes

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 quizzes

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 quiz

What's included

1 quiz

Instructors

Instructor ratings
4.8 (1,294 ratings)
Nicky Bull
Macquarie University
25 Courses1,273,071 learners
Dr Prashan S. M. Karunaratne
Macquarie University
28 Courses1,279,521 learners
Professor Yvonne Breyer
Macquarie University
23 Courses1,145,966 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

Showing 3 of 5797

4.7

5,797 reviews

  • 5 stars

    80.87%

  • 4 stars

    14.30%

  • 3 stars

    3.34%

  • 2 stars

    0.63%

  • 1 star

    0.84%

JR
5

Reviewed on Sep 22, 2020

P
4

Reviewed on Aug 8, 2020

SD
5

Reviewed on Jul 31, 2020

New to Business Essentials? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,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