Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Data Analysis Data Warehouse Business Intelligence Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Email Marketing Google Analytics Startup Advertising Strategy

Finance & AccountingFinanceDecision Making

Decision Making with Excel for Managers

A practical guide on how to use Excel to make data-driven, rational choices
Highest rated
Rating: 4.5 out of 54.5 (105 ratings)
5,102 students
Created by Asen Gyczew
Last updated 6/2022
English
English [Auto]

What you'll learn

  • Make much better decisions as a Manager
  • Master data driven approach to decision making
  • Analyze any decision in Excel using data driven approach
  • Carry out make-or-buy analysis
  • Analyze different scenarios in Excel
  • Analyze in Excel potential investments, strategic decision and pick the best option for your business

Requirements

  • Basic or intermediate Excel
  • Basic knowledge of economics or finance

Description

What is the aim of this course?

As a manager, you will be tempted to trust your guts and use your experience to decide what and how to do it. Quite often this approach may be misleading. It is much better to use a data-driven approach and before you make the decision look at the potential consequences. In this course, I will show you how to make more rational choices as a manager using Excel. We will go through a lot of case studies that will help you master this skill.

In the course you will learn the following things:

  1. How to be data-driven in solving problems

  2. How to make better decisions using Excel

  3. How to handle uncertainty when you are making decisions

  4. Which method, framework you should use in a specific situation

This course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms from Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried or supervised over 90 different performance improvement projects in different industries that generated in total 2 billion of additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who now are Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that my courses on Udemy were already taken by more than 124 000 students including people working in EY, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.

I teach through case studies, so you will have a lot of lectures showing examples of analyses, tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, materials shown in the lectures so as a part of this course you will also get a library of ready-made analyses that can, with certain modification, be applied by you or your team in your work.

Why have I decided to create this course?

I had the pleasure to support numerous Managers, Directors, COOs, CEOs, and I have noticed that making decisions is a complicated process that requires a lot of data and the right approach to balancing the pros and cons. You also have to take into account the uncertainty that managers have to deal with on daily basis. When you transition from a specialist to a manager or a director usually nobody shows you how to make decisions using a data-driven approach. We will try to fix this gap. This course will help you master numerous techniques that will make your life easier and help you make the right decisions.

To sum it up, I believe that if you want to be a successful manager and CEO you should master techniques and frameworks that will help you make better decisions. I will show in this course numerous useful methods and will teach how to use them in practice. That is why. I highly recommend this course not only to young managers, entrepreneurs but also to senior managers who want to learn a data-driven approach to decision-making.

In what way will you benefit from this course?

The course is a practical, step-by-step guide loaded with tones of analyses, tricks, hints that will significantly improve the speed of analyzing and making decisions. There is little theory – mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will learn:

  1. How to be data-driven in solving problems

  2. How to make better decisions using Excel

  3. How to handle uncertainty when you are making decisions

  4. Which method, framework you should use in a specific situation

You can also ask me any question either through the discussion field or by messaging me directly.

How the course is organized?

The course is divided currently into  the following sections:

  • Introduction. We begin with a little intro to the course as well as some general info on how the course is organized

  • Basic tools to make decisions. In the second section, I will show you the essential tools that we will use to make decisions. I will show you what NPV, IRR, time value of money is. Later on, we will go through 5 cases where we will apply this framework to make specific decisions on whether the investment makes sense or not

  • Option comparison. In this section, I will show you how to compare different options. We will go through 3 cases: how to shorten the lifespan of a product, whether it makes sense to transition from selling a product to selling a service (SMCG), what is a better choice to rent or to buy an apartment?

  • Rankings. In this section, I will how to use rankings in practice. In one case we will analyze entering foreign markets. In the second example, we will use the framework to pick the perfect boyfriend for a friend

  • Make-or-buy Analysis. As a manager, you will quite often have to decide whether to do something internally or buy it from 3rd party supplier. In these cases, you have to perform a make-or-buy analysis. We will discuss this in detail in this section

  • What to do when there is a lot of uncertainty. As a manager quite often you will have to somehow take into account the uncertainty. In this section, we will see how we can take it into account to make better decisions. We will discuss here: voting models, backward logic, strategic alignment framework, value proposition framework, portfolio decision framework

You will be able also to download many additional resources

  1. Ready-made analyses that you can use for your firm

  2. Tools that you can use for your firm

  3. List of useful resources

  4. Links to additional presentations, articles, and movies

  5. Links to books worth reading

At the end of my course, students will be able to…

  • Make much better decisions as a Manager

  • Master a data-driven approach to decision making

  • Analyze any decision in Excel using a data-driven approach

  • Carry out make-or-buy analysis

  • Analyze different scenarios in Excel

  • Analyze in Excel potential investments, strategic decisions and pick the best option for your business

Who should take this course? Who should not?

  • Managers who want to make better decisions

  • Owners of small and mid-sized businesses

  • Management Consultants and Business Analysts

  • Startup Founders

What will students need to know or do before starting this course?

  • Basic or intermediate Excel

  • Basic knowledge of economics or finance

Who this course is for:

  • Managers who want to make better decisions
  • Owners of small and mid-sized businesses
  • Management Consultants and Business Analysts
  • Investment Analysts working in PE or VC
  • Startup Founders

Instructor

Asen Gyczew
Expert in performance improvement, turnaround and startups
Asen Gyczew
  • 4.5 Instructor Rating
  • 31,017 Reviews
  • 147,567 Students
  • 64 Courses

Expert in performance improvement, scaling businesses, and turning-around companies with significant experience both in management as well as in supervision of medium size companies (EUR 20 – 500 million) and startups. I have trained in person over 100 consultants, business analysts, and managers who now are Investment Directors, CEO, Partners in PE and VC funds, Sales and Marketing Directors, Operational  Directors, COO, Directors in Consulting Companies, Supply Chain Directors, Board Members, etc.


Functional experience:
performance improvement, strategy development, startups, intrapreneurship, post-merger integration and cost reduction, due diligence, turn-arounds, PMO; 

 Industry experience: SMCG (domestic appliances, furniture, ceramic tiles), FMCG (cosmetics, juice, meat), retail (electronics, convenience shops, pharmaceuticals, DIY, vending, fashion, toys), B2B (aluminum system, plywood, alcohol, reagents, loading systems), services (MRO, consulting, outsourcing), foodtech, marketplaces

Countries: Poland, Serbia, Russia, Ukraine 

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.