Buy Now AED 239.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Excel Skills for Business: Advanced
  • Level Professional
  • Duration 25 hours
  • Course by Macquarie University
  • Offered by

About

Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others, so keep reading. In this last course of our Specialization Excel Skills for Business you will build on the strong foundations of the first three courses: Essentials, Intermediate I + II. In the Advanced course, we will prepare you to become a power user of Excel - this is your last step before specializing at a professional level. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for our big finale, where you will learn how to build professional dashboards in Excel.

Modules

Let's get started

    • 3 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Excel: Who, Why, How?

3 Readings

  • Welcome
  • Course Structure & Assessments
  • Course goals and weekly learning objectives

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 1 Introduction
  • Week 1 Discussion

Practice Videos, Quizzes & Challenges

    • 5 Videos
    • 3 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Spreadsheet Design Principles
  • Calculations
  • Formatting
  • Documentation

5 Videos

  • Practice Video: Spreadsheet Design Principles
  • Practice Video: Calculations
  • Practice Video: Formatting
  • Practice Video: Documentation
  • Practice Video: Interface and Navigation

3 Readings

  • Read me before you start: Quizzes and navigation
  • Read me before you start: Versions and regions
  • Download the Week 1 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Terminology, and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Week 1 Final Assignment

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 2 Introduction
  • Week 2 Discussion

Practice Videos, Quizzes & Challenges

    • 5 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Tables and Structured Referencing
  • Using Functions to Sort Data
  • Introduction to Array Formulas
  • Week 2 Practice Challenge

5 Videos

  • Practice Video: Tables and Structured Referencing
  • Practice Video: Using Functions to Sort Data
  • Practice Video: Introduction to Array Formulas
  • Practice Video: Working with an Array Function (TRANSPOSE)
  • Practice Video: Solving Problems with Array Formulas

1 Readings

  • Download the Week 2 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Terminology, and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Week 2 Final Assignment

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 3 Introduction
  • Week 3 Discussion

Practice Videos, Quizzes & Challenges

    • 5 Videos
    • 1 Readings
    • 6 Assignment
Show info about module content

6 Assignment

  • Replace blanks with repeating values
  • Fix Dates (DATE, MONTH, YEAR, DAY, TEXT)
  • Remove Unwanted Spaces (TRIM, CLEAN)
  • Diagnostic Tools (ISNUMBER, LEN, CODE)
  • Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)
  • Week 3 Practice Challenge

5 Videos

  • Practice Video: Replace blanks with repeating values
  • Practice Video: Fix Dates (DATE, MONTH, YEAR, DAY, TEXT)
  • Practice Video: Remove Unwanted Spaces (TRIM, CLEAN)
  • Practice Video: Diagnostic Tools (ISNUMBER, LEN, CODE)
  • Practice Video: Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)

1 Readings

  • Download the Week 3 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Terminology, and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Week 3 Final Assignment

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 4 Introduction
  • Week 4 Discussion

Practice Videos, Quizzes & Challenges

    • 5 Videos
    • 1 Readings
    • 5 Assignment
Show info about module content

5 Assignment

  • Working with Dates (EOMONTH, EDATE, WORKDAY.INTL)
  • Financial Functions (FV, PV, PMT)
  • Loan Schedule (PMT, EDATE)
  • Net Present Value and Internal Rate of Return (NPV, IRR)
  • Depreciation Functions (SLN, SYD, DDB)

5 Videos

  • Practice Video: Working with Dates (EOMONTH, EDATE, WORKDAY.INTL)
  • Practice Video: Financial Functions (FV, PV, PMT)
  • Practice Video: Loan Schedule (PMT, EDATE)
  • Practice Video: Net Present Value and Internal Rate of Return (NPV, IRR)
  • Practice Video: Depreciation Functions (SLN, SYD, DDB)

1 Readings

  • Download the Week 4 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Excel Terminology, and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Week 4 Final Assignment

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 5 Introduction
  • Week 5 Discussion

Practice Videos, Quizzes & Challenges

    • 4 Videos
    • 1 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • INDIRECT
  • ADDRESS
  • Introduction to OFFSET

4 Videos

  • Practice Video: INDIRECT
  • Practice Video: ADDRESS
  • Practice Video: Introduction to OFFSET
  • Practice Video: Solving Problems with OFFSET

1 Readings

  • Download the Week 5 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Excel Terminology, and Ninja Tips

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Week 5 Final Assignment

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 6 Introduction
  • Week 6 Discussion

Practice Videos, Quizzes & Challenges

    • 5 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Dashboard Design

5 Videos

  • Practice Video: Dashboard Design
  • Practice Video: Prepare Data
  • Practice Video: Construct Dashboard
  • Practice Video: Creative Charting
  • Practice Video: Interactive Dashboard

1 Readings

  • Download the Week 6 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Keyboard Shortcuts, Excel Terminology, and Ninja Tips

Final Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Final Assessment

Auto Summary

Excel Skills for Business: Advanced is a professional-level course in the Data Science & AI domain, instructed by Coursera. Designed for those looking to become Excel power users, it builds on foundations from prior courses in the specialization. Learners will master advanced formulas, sophisticated lookups, data cleaning, and financial functions. The course culminates in creating professional dashboards. With a duration of 1500 minutes, subscription options include Starter, Professional, and Paid, making it accessible for a range of learners aiming to enhance their Excel proficiency for better employability.

Nicky Bull
Instructors

Nicky Bull

Dr Prashan S. M. Karunaratne
Instructors

Dr Prashan S. M. Karunaratne

Professor Yvonne Breyer
Instructors

Professor Yvonne Breyer