Excel Skills for Business: Intermediate II (Coursera)

Offered by Macquarie University,
Excel Skills for Business: Intermediate II (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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.
Course 3 of 4 in the Excel Skills for Business Specialization

Syllabus

WEEK 1
Data Validation
We kick off this course with data validation and conditional formatting. This module takes you through creating and applying data validation, as well as working with formulas in data validation. This is followed by basic and advanced conditional formatting.

WEEK 2
Conditional Logic
Excel has several logical functions and this module explores some of them. Start by learning the concept of conditional logic in formulas, followed by how to conduct logic tests and use conditional operations, to your benefit. We will also look at nested IF functions to evaluate data.

WEEK 3
Automating Lookups
How do you find information from different parts of a workbook? This module introduces you to functions like CHOOSE, VLOOKUP, INDEX, MATCH and other dynamic lookups to find and display data from several sources.

WEEK 4
Formula Auditing and Protection
If you are worried that errors have crept into your worksheet, this module will show you how to check for errors, trace precedents and dependents, resolve circular references, and finally, protect your worksheets and workbooks from further harm.

WEEK 5
Data Modelling
This module is all about data modelling. Learn to model different scenarios based on input, assumptions and/or outcomes. Also learn the use of functionalities like Goal Seek, Data Tables and the Scenario Manager to make your models more robust.

WEEK 6
Recording Macros
We all love a bit of automation, and this module teaches you just that. By the time you have completed this module, you will be able to identify the uses of macros, as well as create, edit and manage them to increase your efficiency.
Final Assessment

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

A Comprehensive Excel Masterclass (Coursera) Coursera
Illinois Tech

A Comprehensive Excel Masterclass (Coursera)

The Comprehensive Excel Masterclass is an advanced course designed to empower students with the skills and knowledge needed to maximize the potential of Microsoft Excel in a business environment. This course goes beyond the basics and explores advanced functions, and features that will enable students to perform complex calculations, retrieve and manipulate data from multiple sources, and gain valuable insights from data. The course combines theoretical concepts with practical exercises and examples to reinforce learning.

Dec 7th 2026
4 Weeks
Data Visualization and Communication with Tableau (Coursera) Coursera
Duke University

Data Visualization and Communication with Tableau (Coursera)

One of the skills that characterizes great business data analysts is the ability to communicate practical implications of quantitative analyses to any kind of audience member. Even the most sophisticated statistical analyses are not useful to a business if they do not lead to actionable advice, or if the answers to those business questions are not conveyed in a way that non-technical people can understand. In this course you will learn how to become a master at communicating business-relevant implications of data analyses.

Nov 30th 2026
5-12 Weeks
Modeling Risk and Realities (Coursera) Coursera
University of Pennsylvania

Modeling Risk and Realities (Coursera)

Useful quantitative models help you to make informed decisions both in situations in which the factors affecting your decision are clear, as well as in situations in which some important factors are not clear at all. In this course, you can learn how to create quantitative models to reflect complex realities, and how to include in your model elements of risk and uncertainty.

Nov 30th 2026
4 Weeks
Excel/VBA for Creative Problem Solving, Part 1 (Coursera) Coursera
University of Colorado Boulder

Excel/VBA for Creative Problem Solving, Part 1 (Coursera)

Excel/VBA for Creative Problem Solving, Part 1" is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).

Nov 30th 2026
5-12 Weeks
Excel Skills for Business: Essentials (Coursera) Coursera
Macquarie University

Excel Skills for Business: Essentials (Coursera)

In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.

Nov 30th 2026
5-12 Weeks
Excel Modeling for Professionals: Best Practices & Pitfalls (Coursera) Coursera
Delft University of Technology,Erasmus University Rotterdam

Excel Modeling for Professionals: Best Practices & Pitfalls (Coursera)

Through this course learners will gain the tools to decide whether or not Excel is the right software to use. They will learn how to set up good input data, format correctly, and the importance of good documentation. Learners will gain the ability to discern between different functions, to understand the pitfalls and strengths of commonly used functions, and to apply correct functions to their excel models. Those that follow the course will also gain understanding of logical spreadsheet structure, graphs and reporting, and protection and hidden information in Excel, and users will learn how to apply these things to their own models.

Dec 7th 2026
4 Weeks
Exploration et production de données pour les entreprises (Coursera) Coursera
University of Illinois at Urbana-Champaign

Exploration et production de données pour les entreprises (Coursera)

Ce cours fournit un cadre analytique afin de vous aider à évaluer les problèmes clés de manière structurée. Il vous procurera également des outils afin de mieux gérer les incertitudes qui envahissent et compliquent les processus des entreprises. Plus précisément, vous serez initié(e) aux statistiques et à la manière de résumer les données. Vous découvrirez les concepts de fréquence, de loi normale, d’études statistiques, de l’échantillonnage et des intervalles de confiance.

Dec 7th 2026
4 Weeks
Excel Essentials and Beyond (Coursera) Coursera
Board Infinity

Excel Essentials and Beyond (Coursera)

Dive into "Excel Essentials and Beyond", a comprehensive exploration of Excel, the world's leading spreadsheet tool. This course is thoughtfully crafted for both newcomers to Excel and also for those aiming for mastery. We begin by introducing Excel's robust interface and foundational features, ensuring a firm grasp of data organization techniques. As you advance, you'll delve into data visualization, transforming raw data into captivating stories.

Dec 7th 2026
5-12 Weeks
Habilidades de Excel para el negocio: Conceptos básicos (Coursera) Coursera
Macquarie University

Habilidades de Excel para el negocio: Conceptos básicos (Coursera)

En este primer curso de la especialización de habilidades de Excel para el negocio, aprenderá los conceptos básicos de Microsoft Excel. En seis semanas, podrá navegar, de forma experta, a través de la interfaz de usuario de Excel, realizar cálculos básicos con fórmulas y funciones, dar formato profesional a hojas de cálculo y crear visualizaciones de datos a través de gráficos y cuadros.

Dec 7th 2026
5-12 Weeks