A Comprehensive Excel Masterclass

Entdecken Sie neue Fähigkeiten mit 30% Rabatt auf Kurse von Branchenexperten. Jetzt sparen.

Diese kurs ist nicht verfügbar in Deutsch (Deutschland)

Wir übersetzen es in weitere Sprachen. Sehen Sie sich die Sprachen an, die wir anbieten.

A Comprehensive Excel Masterclass

Dozent: Liz Durango-Cohen

13.917 bereits angemeldet

Bei Coursera Plus enthalten

Mehr erfahren

4 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

4.8

(62 Bewertungen)

Stufe Mittel

Empfohlene Erfahrung

Flexibler Zeitplan

7 Wochen bei 10 Stunden eine Woche

In Ihrem eigenen Lerntempo lernen

Auf einen Abschluss hinarbeiten

Mehr erfahren

4 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

4.8

(62 Bewertungen)

Stufe Mittel

Empfohlene Erfahrung

Flexibler Zeitplan

7 Wochen bei 10 Stunden eine Woche

In Ihrem eigenen Lerntempo lernen

Auf einen Abschluss hinarbeiten

Mehr erfahren

Kompetenzen, die Sie erwerben

Kategorie: Data Analysis Expressions (DAX)
Kategorie: Data-Driven Decision-Making
Kategorie: Loans
Kategorie: Business Analytics
Kategorie: Excel Formulas
Kategorie: Interactive Data Visualization
Kategorie: Financial Modeling
Kategorie: Cash Flows
Kategorie: Financial Analysis
Kategorie: Business Intelligence
Kategorie: Key Performance Indicators (KPIs)
Kategorie: Microsoft Excel
Kategorie: Dashboard
Kategorie: Google Sheets
Kategorie: Data Visualization
Kategorie: Pivot Tables And Charts
Kategorie: Capital Budgeting

Wichtige Details

Zertifikat zur Vorlage

Zu Ihrem LinkedIn-Profil hinzufügen

Bewertungen

24 Aufgaben

Unterrichtet in Englisch

Erfahren Sie, wie Mitarbeiter führender Unternehmen gefragte Kompetenzen erwerben.

Weitere Informationen zu Coursera für Unternehmen

Logos von Petrobras, TATA, Danone, Capgemini, P&G und L'Oreal

In diesem Kurs gibt es 4 Module

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.

A crucial aspect of business decision-making involves understanding the time value of money. In this course, students will be exposed to time value of money principles and learn how to utilize Excel's financial functions to analyze loans, create amortization schedules, and evaluate project valuations. By leveraging functions such as PV, FV, NPV, PMT, IRR and more, students will be able to make informed financial decisions. A significant portion of the course is dedicated to creating Excel dashboards, which are effective tools for visually presenting performance data (such as KPIs). Participants will learn how to leverage Pivot Tables to create dynamic and interactive dashboards utilizing slicers, timelines, and calculated fields to enhance data exploration and create compelling dashboards. Upon successful completion of this course, you will be able to: - Utilize complex Excel functions and techniques to extract and manipulate data. - Evaluate the financial viability of loans using Excel's financial functions. - Apply the principles of Capital Budgeting for project selection and investment decisions. - Create advanced Pivot Tables and Pivot Charts for data analysis and visualization. - Develop interactive dashboards with Form Controls to enhance user experience. - Design custom charts for effective data visualization. - Apply Excel's latest features and updates in Office 365/Google Sheets for increased productivity. - Showcase key performance indicators (KPIs) to support data-driven decision-making in business intelligence.

Welcome to Mastering Excel Essentials to Enhance Business Value! In this module, you'll delve into the core concept of Time Value of Money (TVM) and its pivotal role in financial decision-making. Using Excel, you'll learn to visualize cash flows, calculate present and future values, differentiate between interest types, evaluate projects, and perform loan-related calculations. We'll explore Capital Budgeting, Equivalent Annual Worth, IRR, and incremental analysis techniques for project comparison, equipping you with essential skills to make informed financial decisions. Whether you're an investor, loan manager, or planning for your retirement, this module will empower you to excel in financial analysis and decision-making using Excel's powerful tools.

Das ist alles enthalten

26 Videos18 Lektüren10 Aufgaben1 Diskussionsthema

26 VideosInsgesamt 255 Minuten

Course Overview Video1 Minute
Module 1 Introduction1 Minute
Introduction to Time Value of Money and Cash Flow Diagrams6 Minuten
Cash Flow Diagrams in Excel4 Minuten
Types of Interest: Simple vs. Compound16 Minuten
Nominal and Effective Interest Rates16 Minuten
Terminology: Interest Vs. Discount Rates2 Minuten
The Power of Compounding7 Minuten
Basic Excel Financial functions I (FV, PV,)8 Minuten
Basic Excel Financial functions II (RATE, NPER)7 Minuten
Examples using APR, EAR, FV and PV Functions17 Minuten
Net Present Value (NPV, XNPV) Function15 Minuten
Annuity and Perpetuities14 Minuten
Calculating Loan Payments (PMT)7 Minuten
Understanding Amortization or Repayment Schedules5 Minuten
Creating an Amortization in Excel: Applying IPMT, PPMT Functions8 Minuten
Calculating Loan Balances with CUMPRINC Function10 Minuten
Calculating Total Interest and Principal Payments with CUMIPMT and CUMPRINC Functions11 Minuten
Impact of Paying Extra each Period on Loan Repayment Horizon (NPER)11 Minuten
Impact of Adjustable Rate Mortgages on Credit Card Loans11 Minuten
Introduction to Capital Budgeting2 Minuten
Evaluating One-Time Projects using Net Present Analysis9 Minuten
Capital Budgeting for Ongoing Projects – Using a specified Time Horizon7 Minuten
Capital Budgeting for Ongoing Projects – Equivalent Annual Worth15 Minuten
Internal Rate of Return Analysis (IRR, XIRR)18 Minuten
Incremental Cash Flow Analysis and MARR14 Minuten

18 LektürenInsgesamt 240 Minuten

Syllabus10 Minuten
Module 1 Lesson 1 Reading10 Minuten
Module 1 Lesson 1 Video Instructions Pt.130 Minuten
Module 1 Lesson 1 Video Instructions Pt.210 Minuten
Time Value of Money Exercise Completed Workbook10 Minuten
Basic Financial Functions Exercise Completed Workbook10 Minuten
Module 1 Lesson 2 Reading10 Minuten
Module 1 Lesson 2 Video Instructions Pt.130 Minuten
Module 1 Lesson 2 Video Instructions Pt.210 Minuten
Loan Analysis Exercise Completed Workbook10 Minuten
Mortgage Loan & Refinancing Exercise Completed Workbook10 Minuten
Module 1 Lesson 3 Reading10 Minuten
Module 1 Lesson 3 Video Instructions Pt.130 Minuten
Module 1 Lesson 3 Video Instructions Pt.210 Minuten
Capital Budgeting Exercise Completed Workbook10 Minuten
Project Evaluation and Selection Quiz - Solution Worksheet10 Minuten
Module 1 Summative Assessment Answers10 Minuten
Module 1 Summary10 Minuten

10 AufgabenInsgesamt 1.230 Minuten

Time Value of Money Exercise15 Minuten
Basic Financial Functions Exercise 15 Minuten
Loan Analysis Exercise60 Minuten
Mortgage Loan & Refinancing Exercise60 Minuten
Excel Functions Quiz (Excel Needed) 180 Minuten
Excel Functions Quiz (No Excel Needed)180 Minuten
Time Value of Money Quiz180 Minuten
Capital Budgeting Exercise180 Minuten
Project Evaluation and Selection Quiz180 Minuten
Module 1 Summative Assessment180 Minuten

1 DiskussionsthemaInsgesamt 10 Minuten

Meet and Greet Discussion10 Minuten

Welcome to Module 2! This module covers a wide array of topics from basic to advanced. You will learn not just how to set up and customize pivot tables in both Excel and Google Sheets, but also delve deep into understanding field settings, aggregation methods, layout options, and more to bring your data analysis to the next level. We'll also explore Office 365/Google Sheets' latest functions, like FILTER, SORT, UNIQUE, and dynamic arrays, equipping you with the skills to handle complex data sets efficiently. By the end of this module, you'll be able to create dynamic reports and dashboards that offer profound insights into your data, thus enhancing your decision-making capabilities.

Das ist alles enthalten

24 Videos17 Lektüren8 Aufgaben

24 VideosInsgesamt 203 Minuten

Module 2 Introduction1 Minute
Overview of Pivot Tables5 Minuten
Guidelines for Inserting Pivot Tables and Pivot Table Structure8 Minuten
Understanding Variable Types and Pivot Table Structure11 Minuten
Filtering, Organizing and Sorting Pivot Tables8 Minuten
Grouping Dates and More Filtering of Pivot Tables13 Minuten
Pivot Tables Contextual Tabs: The Design and Analyze Tabs7 Minuten
The “Show Value As” Display5 Minuten
Creating Calculated Fields6 Minuten
The Power of “Show Value As” Displays to Analyze Data17 Minuten
Pivot Table Options, Field Headers and Buttons6 Minuten
Using Slicers and Timelines in Pivot Tables13 Minuten
Creating Pivot Charts14 Minuten
Pivot Tables with different levels of granularity14 Minuten
Pivot Tables in Google Sheets: Functional Differences (Interface, Slicers, Grouping Dates)14 Minuten
Chart Interface in Google Sheets7 Minuten
Introduction to XLOOKUP – Powerful Replacement to VLOOKUP and HLOOKUP5 Minuten
XLOOKUP’s Match Mode5 Minuten
XLOOKUP’s Wildcard Mode5 Minuten
Nested XLOOKUPs Overview5 Minuten
Dropdown lists plus XLOOKUPs vs. VLOOKUP and MATCH6 Minuten
UNIQUE and SORT Functions, along with Cell Referencing in Google Sheets3 Minuten
The FILTER Function and Dependent Dropdowns3 Minuten
The FILTER Function’s Power10 Minuten

17 LektürenInsgesamt 230 Minuten

Module 2 Lesson 1 Reading10 Minuten
Module 2 Lesson 1 Video Instructions Pt.130 Minuten
Module 2 Lesson 1 Video Instructions Pt.210 Minuten
Pivot Table Exercise Completed Workbook10 Minuten
Module 2 Lesson 2 Reading10 Minuten
Module 2 Lesson 2 Video Instructions Pt.130 Minuten
Module 2 Lesson 2 Video Instructions Pt.210 Minuten
Pivot Tables II Exercise Completed Workbook10 Minuten
Module 2 Lesson 3 Readings10 Minuten
Module 2 Lesson 3 Video Instructions Pt.130 Minuten
Module 2 Lesson 3 Video Instructions Pt.210 Minuten
Basic Google Sheets Usage Exercise Completed Worksheet10 Minuten
XLOOKUP Exercise Completed Worksheet10 Minuten
Pivot Tables Exercise III Completed Worksheet10 Minuten
Pivot Tables Exercise IV Completed Worksheet10 Minuten
Module 2 Summative Assessment Answers10 Minuten
Module 2 Summary10 Minuten

8 AufgabenInsgesamt 795 Minuten

Pivot Table Exercise180 Minuten
Pivot Tables Quiz180 Minuten
Pivot Tables II Exercise180 Minuten
Basic Google Sheets Usage Exercise15 Minuten
XLOOKUP Exercise30 Minuten
Pivot Tables Exercise III15 Minuten
Pivot Tables Exercise IV15 Minuten
Module 2 Summative Assessment180 Minuten

Welcome to Module 3! In today's data-driven world, the ability to create dashboards that are both interactive and informative is absolutely crucial for effective data analysis and decision-making. In this module, we'll dive deep into the art of dashboard design, focusing on the practical application of our lessons. You'll learn how to leverage Excel's Form Controls to build dynamic and user-friendly dashboards without the need for VBA programming. But this module is about much more than Excel functions. It's about mastering the design principles that make dashboards meaningful and effective. You'll discover how to craft displays of quantitative data that facilitate managerial decision-making. We'll explore essential theories, concepts, and methodologies to visualize and analyze real-world data. From mastering data retrieval techniques with INDEX to exploring ways to create dynamic charts, this module is designed to transform you into an adept dashboard designer, capable of synthesizing and visualizing complex data in an easily digestible format.

Das ist alles enthalten

38 Videos18 Lektüren5 Aufgaben

38 VideosInsgesamt 318 Minuten

Module 3 Introduction1 Minute
Introduction to Mastering Excel Dashboards4 Minuten
Dashboard Design Checklist6 Minuten
Dashboard Design Basics – Getting Started4 Minuten
Dashboard Workbook Structure3 Minuten
Useful Shortcut Keys10 Minuten
Dashboard Design and Creation Tips9 Minuten
Static Dashboard Calculations I13 Minuten
Static Dashboard Calculations II – GETPIVOTDATA Function5 Minuten
Constructing Static Dashboard – Using Textboxes for Flexibility15 Minuten
Design Elements of Dashboards12 Minuten
Static Dashboard Formatting I -- Size, Fonts and Colors8 Minuten
Static Dashboard Formatting II – Containers and Alignment15 Minuten
Static Dashboard Formatting III – Object Properties & Final Touches6 Minuten
MATCH Function Tutorial5 Minuten
Using Slicers and Timelines in Pivot Tables13 Minuten
INDEX Function – Efficient Lookup Function14 Minuten
LARGE and SMALL – For sorting values4 Minuten
CHOOSE – An alternative to IF Statements7 Minuten
SUMIFS – A Review with Twists9 Minuten
Introduction to the Developer Tab and Form Controls3 Minuten
Combo Box – More Attractive Dropdown List8 Minuten
Check Box – Check/Uncheck Option7 Minuten
List Box – A Different Way to Selection from a List2 Minuten
Spin Button – Increase or Decrease a Value/Position in a list2 Minuten
Option Button – Choose Between Options2 Minuten
Scroll Bar – Another way to move through contents6 Minuten
OFFSET Function - Basic Usage4 Minuten
OFFSET with Arrays4 Minuten
Calculations -- Form Controls and Slicer Cell Links11 Minuten
Calculations -- Overall Metric Calculations14 Minuten
Calculations -- Monthly Charts and Dynamic Titles15 Minuten
Calculations -- Current vs. Previous Year Deltas15 Minuten
Calculations – Top 3 and Bottom 3 Products by Profitability5 Minuten
Construction and Design -- Shapes and Formatting14 Minuten
Construction and Design – Charts Edits and Shape Properties9 Minuten
Construction and Design – Linked Pictures10 Minuten
Final Touches for Dynamic Dashboard5 Minuten

18 LektürenInsgesamt 260 Minuten

Module 3 Lesson 1 Reading10 Minuten
Module 3 Lesson 1 Video Instructions Pt.130 Minuten
Module 3 Lesson 1 Video Instructions Pt.210 Minuten
Module 3 Lesson 2 Reading10 Minuten
Module 3 Lesson 2 Video Instructions Pt.130 Minuten
Module 3 Lesson 2 Video Instructions Pt.210 Minuten
Data Retrieval and Reporting Exercise Completed 10 Minuten
Module 3 Lesson 3 Reading10 Minuten
Module 3 Lesson 3 - Section 1 Video Instructions Pt.130 Minuten
Module 3 Lesson 3 - Section 1 Video Instructions Pt.210 Minuten
Module 3 Lesson 3 - Section 2 Video Instructions Pt.130 Minuten
Module 3 Lesson 3 - Section 2 Video Instructions Pt.210 Minuten
Module 3 Lesson 3 - Section 3 Video Instructions Pt.110 Minuten
Module 3 Lesson 3 - Section 3 Video Instructions Pt.210 Minuten
Module 3 Lesson 3 - Section 4 Video Instructions Pt.110 Minuten
Module 3 Lesson 3 - Section 4 Video Instructions Pt.210 Minuten
Module 3 Summative Assessment Answers10 Minuten
Module 3 Summary10 Minuten

5 AufgabenInsgesamt 750 Minuten

Dashboard Design Quiz 180 Minuten
Data Retrieval and Reporting Exercise180 Minuten
Retrieval Functions Quiz 180 Minuten
Form Controls Quiz30 Minuten
Module 3 Summative Assessment180 Minuten

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.

Das ist alles enthalten

1 Aufgabe

Erwerben Sie ein Karrierezertifikat.

Fügen Sie dieses Zeugnis Ihrem LinkedIn-Profil, Lebenslauf oder CV hinzu. Teilen Sie sie in Social Media und in Ihrer Leistungsbeurteilung.

Auf einen Abschluss hinarbeiten

Dieses Kurs ist Teil des/der folgenden Studiengangs/Studiengänge, die von Illinois Techangeboten werden. Wenn Sie zugelassen werden und sich immatrikulieren, können Ihre abgeschlossenen Kurse auf Ihren Studienabschluss angerechnet werden und Ihre Fortschritte können mit Ihnen übertragen werden.¹

Dozent

Lehrkraftbewertungen

4.7 (31 Bewertungen)

Liz Durango-Cohen

Illinois Tech

2 Kurse17.240 Lernende

von

Illinois Tech

Mehr von Business Essentials entdecken

Status: Vorschau
Board Infinity
Excel Essentials and Beyond
Kurs
Status: Kostenloser Testzeitraum
Duke University
Mastering Data Analysis in Excel
Kurs
Illinois Tech
Mastering Excel Essentials to Enhance Business Value
Kurs
Coursera Project Network
Introduction to Microsoft Excel
angeleitetes Projekt

Warum entscheiden sich Menschen für Coursera für ihre Karriere?

Felipe M.

Lernender seit 2018

„Es ist eine großartige Erfahrung, in meinem eigenen Tempo zu lernen. Ich kann lernen, wenn ich Zeit und Nerven dazu habe.“

Jennifer J.

Lernender seit 2020

„Bei einem spannenden neuen Projekt konnte ich die neuen Kenntnisse und Kompetenzen aus den Kursen direkt bei der Arbeit anwenden.“

Larry W.

Lernender seit 2021

„Wenn mir Kurse zu Themen fehlen, die meine Universität nicht anbietet, ist Coursera mit die beste Alternative.“

Chaitanya A.

„Man lernt nicht nur, um bei der Arbeit besser zu werden. Es geht noch um viel mehr. Bei Coursera kann ich ohne Grenzen lernen.“

Bewertungen von Lernenden

4.8

62 Bewertungen

5 stars
82,25 %
4 stars
16,12 %
3 stars
0 %
2 stars
1,61 %
1 star
0 %

Zeigt 3 von 62 an

Geprüft am 15. Aug. 2024

It was very comprehensive course on critical features and functions in Excel that are required for everyday use and data analysis and visualization.

Geprüft am 1. Juli 2024

Great experience and I learned more than I projected.

Geprüft am 28. Feb. 2024

Great learning experience from a wonderful professor

Weitere Bewertungen anzeigen

Neue Karrieremöglichkeiten mit Coursera Plus

Unbegrenzter Zugang zu 10,000+ Weltklasse-Kursen, praktischen Projekten und berufsqualifizierenden Zertifikatsprogrammen - alles in Ihrem Abonnement enthalten

Mehr erfahren

Bringen Sie Ihre Karriere mit einem Online-Abschluss voran.

Erwerben Sie einen Abschluss von erstklassigen Universitäten – 100 % online

Erkunden Sie die Abschlüsse

Schließen Sie sich mehr als 3.400 Unternehmen in aller Welt an, die sich für Coursera for Business entschieden haben.

Schulen Sie Ihre Mitarbeiter*innen, um sich in der digitalen Wirtschaft zu behaupten.

Mehr erfahren

Häufig gestellte Fragen

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.