Illinois Tech
Mastering Excel Essentials to Enhance Business Value
Illinois Tech

Mastering Excel Essentials to Enhance Business Value

Liz Durango-Cohen

Instructor: Liz Durango-Cohen

2,701 already enrolled

Included with Coursera Plus

Gain insight into a topic and learn the fundamentals.
4.4

(17 reviews)

Beginner level

Recommended experience

Flexible schedule
Approx. 82 hours
Learn at your own pace
Build toward a degree
Gain insight into a topic and learn the fundamentals.
4.4

(17 reviews)

Beginner level

Recommended experience

Flexible schedule
Approx. 82 hours
Learn at your own pace
Build toward a degree

What you'll learn

  • Effectively input data and efficiently navigate large spreadsheets.

  • Employ various "hacks" and expertly apply (the most appropriate) built-in functions in Excel to increase productivity and streamline workflow.

  • Apply the "what-if" analysis tools in Excel to conduct break-even analysis, conduct sensitivity analysis and support decision-making.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

3 quizzes, 26 assignments

Taught in English

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

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 4 modules in this course

Welcome to Mastering Excel Essentials to Enhance Business Value. In this course we will cover the topics of: Excel Foundations, Essential Excel Tools for Professional Success, and Presenting Information in Excel. In this module, students will establish a solid understanding of Excel’s interface and worksheet anatomy. They will become familiar with the Excel Ribbon, common tab features, and various navigation techniques. The module also covers data entry basics and introduces the concept of formulas. Students will gain proficiency in copying, moving, and hiding worksheets and cells, as well as entering basic formulas. Even if students have used Excel before, this module will teach them shortcuts and little-known features that will help boost their productivity. In Lesson 2 of the module, students will explore time-saving features such as Flash Fill, which uses predictive technology to transform messy data into proper data sets efficiently. They will learn how to leverage date functions and discover how defining custom lists and applying paste functionality can enhance their efficiency. The lesson also covers how to use Excel’s data validation functionality to reduce user input errors, and improve the report interface by displaying screen tips and comments. Additionally, students will dive into must-know formulas and functions, and learn how to handle errors and format outputs effectively in Lesson 3. Students will also learn about relative, mixed and absolute cell references. By understanding these different types of cell referencing, students can create robust and reliable reports, models, and data analyses. They can build spreadsheets that that require less manual effort and that minimize the risk of costly errors.

What's included

30 videos14 readings1 quiz8 assignments1 discussion prompt

In Module 2, students will gain the necessary skills to build models that accurately represent work situations and enable effective decision-making. Models enable us to test our assumptions, enhance our understanding, and make better-informed decisions. Students will develop an understanding that improved decision-making is a result of gaining deeper insights rather than solely relying on output values from a model. Students will learn how to apply logical functions (IF and Nested IF Statements) and utilize the “What-If Analysis” tools in Excel to perform break-even analysis and scenario management. By the end of this module, students will have a solid foundation in using Excel as a powerful tool for decision modeling and sensitivity analysis. In Lesson 1, students will explore essential modeling functions in Excel – IF statements, nested IFstatements, and logical functions are powerful functions for building models that abstract from real-world problems and capture the essence of business operational and planning problems. These functions allow students to dynamically update calculations based on changing conditions. For example, we can use IF statements to calculate different pricing strategies based on sales volume or apply different discount rates depending on customer types. In Lesson 2, students will delve into decision modeling and explore the “What-if Analysis” functionality in Excel. Students will learn how to create named cells and ranges to improve spreadsheet and model readability, which provide clarity and simplicity when working with complex models. Furthermore, students will learn how to use Goal Seek to determine the input value needed to achieve a specific goal or target output. For example, you can use it to find out what sales volume is required to reach a certain profit level. Students will become proficient in using Data Tables to analyze how changes in input values affect multiple formulas or calculations. And, finally, students will learn about Scenario Manager, which allows you to define different sets of input values and compare the resulting outputs, helping you evaluate various possibilities and make informed decisions

What's included

24 videos14 readings1 quiz11 assignments

In this module, students will learn how to present information effectively using Excel. They will discover best practices for designing spreadsheets and explore techniques to define the look-and-feel of their work. The module also introduces Excel Tables as a time-saving feature. Students will explore the power of conditional formatting, as well as master custom rules, to create impactful reports. Student will also develop the knowledge to create effective graphs and visuals that effectively convey information. In Lesson 1, students will learn best practices for spreadsheet design. Students will learn about Cell Styles and how they can enhance the visual appeal and consistency of spreadsheets. This lesson also includes video segments focusing on formatting and referencing for Excel Tables. Additionally, students will master the use conditional formatting to create impactful reports, with videos covering different aspects and examples of conditional formatting. By the end of the lesson, students will have the skills and knowledge to design visually appealing spreadsheets and create compelling reports. Lesson 2 covers the art of communicating insights through Excel charts. Students will gain an understanding of the different types of charts available, including scatter plots, lines, slope graphs, bar charts, sparklines and more. Beyond mastering how to use Excel’s graphing functionality, students will learn will learn how to select the most appropriate chart type to effectively present their data, as well as how to actively declutter visuals, removing unnecessary elements that don't aid understanding, to convey data effectively and drive meaningful insights. By completing the "Mastering Excel Essentials to Enhance Business Value" course, students will acquire the necessary skills to leverage Excel as a problem-solving tool in a corporate setting. They will enhance their analytical skills, become fluent in using spreadsheets, and develop the ability to present information in a compelling and organized manner. Whether it's data analysis, modeling, or creating impactful reports, this course equips students with the essential Excel toolbox needed to excel in their professional endeavors.

What's included

20 videos11 readings1 quiz6 assignments

This module contains the summative course assessment that has been designed to evaluate your understanding of the course material and assess your ability to apply the knowledge you have acquired throughout the course. Be sure to review the course material thoroughly before taking the assessment.

What's included

1 assignment

Instructor

Liz Durango-Cohen
Illinois Tech
2 Courses9,086 learners

Offered by

Illinois Tech

Recommended if you're interested in Business Essentials

Build toward a degree

This course is part of the following degree program(s) offered by Illinois Tech. If you are admitted and enroll, your completed coursework may count toward your degree learning and your progress can transfer with you.¹

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 17

4.4

17 reviews

  • 5 stars

    77.77%

  • 4 stars

    5.55%

  • 3 stars

    5.55%

  • 2 stars

    0%

  • 1 star

    11.11%

BG
5

Reviewed on Oct 4, 2023

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