Buy Now AED 239.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Excel Skills for Business: Intermediate II
  • Level Professional
  • المدة 29 ساعات hours
  • الطبع بواسطة Macquarie University
  • Offered by

عن

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 this third course of our Excel specialization Excel Skills for Business you will delve deeper into some of the most powerful features Excel has to offer. When you have successfully completed the course you will be able to Check for and prevent errors in spreadsheets; Create powerful automation in spreadsheets; Apply advanced formulas and conditional logic to help make informed business decisions; and Create spreadsheets that help forecast and model data. Once again, we have brought together a great teaching team that will be with you every step of the way. Nicky, Prashan and myself will guide you through each week. As we are exploring these more advanced topics, we are following Alex who is an Excel consultant called in by businesses that experience issues with their spreadsheets.

الوحدات

Let's get started

    • 2 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Excel: Who, Why, How?

2 Readings

  • Welcome to Excel Skills for Business: Intermediate II
  • 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, and Challenges

    • 6 Videos
    • 3 Readings
    • 6 Assignment
Show info about module content

6 Assignment

  • Data Validation
  • Creating Drop-down Lists
  • Using Formulas in Data Validation
  • Working with Data Validation
  • Advanced Conditional Formatting
  • Week 1 Practice Challenge

6 Videos

  • Practice Video: Data Validation
  • Practice Video: Creating Drop-down Lists
  • Practice Video: Using Formulas in Data Validation
  • Practice Video: Working with Data Validation
  • Practice Video: Advanced Conditional Formatting
  • Week 1 Wrap-Up

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, Excel 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, and Challenges

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

6 Assignment

  • Logical Functions I: IF
  • Logical Functions II: AND, OR
  • Combining Logical Functions I: IF, AND, OR
  • Combining Logical Functions II: Nested IFs
  • Handling Errors: IFERROR, IFNA
  • Week 2 Practice Challenge

6 Videos

  • Practice Video: Logical Functions I: IF
  • Practice Video: Logical Functions II: AND, OR
  • Practice Video: Combining Logical Functions I: IF, AND, OR
  • Practice Video: Combining Logical Functions II: Nested IFs
  • Practice Video: Handling Errors: IFERROR, IFNA
  • Week 2 Wrap-Up

1 Readings

  • Download the Week 2 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 2 Final Assignment

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 3 Introduction
  • Week 3 Discussion

Practice Videos, Quizzes, and Challenges

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

6 Assignment

  • Introduction to Lookups: CHOOSE
  • Approximate Matches: Range VLOOKUP
  • Exact Matches: Exact Match VLOOKUP
  • Finding a Position: MATCH
  • Dynamic Lookups: INDEX, MATCH
  • Week 3 Practice Challenge

6 Videos

  • Practice Video: Introduction to Lookups: CHOOSE
  • Practice Video: Approximate Matches: Range VLOOKUP
  • Practice Video: Exact Matches: Exact Match VLOOKUP
  • Practice Video: Finding a Position: MATCH
  • Practice Video: Dynamic Lookups: INDEX, MATCH
  • Week 3 Wrap-Up

1 Readings

  • Download the Week 3 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 3 Final Assignment

Scenario

    • 2 Videos
Show info about module content

2 Videos

  • Week 4 Introduction
  • Week 4 Discussion

Practice Videos, Quizzes, and Challenges

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

6 Assignment

  • Error Checking
  • Formula Calculation Options
  • Tracing Precedents and Dependents
  • Evaluate Formula, Watch Window
  • Protecting Workbooks and Worksheets
  • Week 4 Practice Challenge

1 Discussions

  • Find the remaining errors

6 Videos

  • Practice Video: Error Checking
  • Practice Video: Formula Calculation Options
  • Practice Video: Trace Precedents and Dependents
  • Practice Video: Evaluate Formula, Watch Window
  • Practice Video: Protecting Workbooks and Worksheets
  • Week 4 Wrap-Up

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, and Challenges

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

6 Assignment

  • Modelling Functions (SUMPRODUCT)
  • Data Tables
  • Goal Seek
  • Scenario Manager
  • Solver
  • Week 5 Practice Challenge

6 Videos

  • Practice Video: Modelling Functions: SUMPRODUCT
  • Practice Video: Data Tables
  • Practice Video: Goal Seek
  • Practice Video: Scenario Manager
  • Practice Video: Solver
  • Week 5 Wrap-Up

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, and Challenges

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

6 Assignment

  • Record a Macro
  • Run your Macro
  • Edit a Macro
  • Working with Macros
  • Relative Reference Macros
  • Week 6 Practice Challenge

6 Videos

  • Practice Video: Record a Macro
  • Practice Video: Run a Macro
  • Practice Video: Edit a Macro
  • Practice Video: Working with Macros
  • Practice Video: Relative Reference Macros
  • Week 6 Wrap-Up

1 Readings

  • Download the Week 6 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 6 Final Assignment

Final Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Final Assessment

Auto Summary

"Excel Skills for Business: Intermediate II" is an advanced course in the Data Science & AI domain offered by Coursera, led by experienced instructors Nicky and Prashan. Over approximately 29 hours, learners will master error prevention, powerful automation, advanced formulas, and data modeling in Excel. Ideal for professionals, the course enhances employability with practical, high-value Excel skills. Available via a Starter subscription, it’s perfect for those aiming to make informed business decisions with advanced spreadsheet capabilities.

Nicky Bull
Instructors

Nicky Bull

Dr Prashan S. M. Karunaratne
Instructors

Dr Prashan S. M. Karunaratne

Professor Yvonne Breyer
Instructors

Professor Yvonne Breyer