Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications 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 Certification Network & Security Hardware Operating Systems 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 Design Thinking 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 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 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 Yoga Mental Health Dieting 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 Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Excel

Essential Excel for Business Analysts and Consultants

Master the formulas and tricks that will save you time and make you as efficent as consultants in McKinsey, BCG, Bain
Rating: 4.0 out of 54.0 (606 ratings)
4,548 students
Created by Asen Gyczew
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • You will master the most crucial functions and features of Excel
  • Understand the main challenges in analyzing data in Excel
  • Get ready made analyses in Excel
  • Analyze complex business problems in Excel
  • You will master essential Excel shortcuts that will help you drastically speed up your work in Excel
  • You will learn how to structure Analysis in Excel for your work as Management Consultant or Business Analyst

Requirements

  • Basic Excel
  • Basic knowledge of economics or finance

Description

What is the aim of this course?  

Excel is the most often used first-choice tool of every business analyst and consultant. Maybe it is not the most fancy or sophisticated one,  yet it is universally understood by everybody especially your boss and your customers.  

Excel is still pretty advanced tool with countless number of features and functions. I have mastered quite a lot of them during my studies and while working. After some time in consulting I discovered that most of them are not that useful; some of them bring more problems than solutions. On top of that there are features that we are taught at university that are not flexible and pretty time consuming.  While working as a business analyst I developed my own set of tricks to deal with Excel  I learned how to make my analyses idiot-proven and extremely universal.  

I will NOT teach you the entire Excel as it is simply not efficient (and frankly you don’t need it). This course is organized around 80/20 rule and I want to teach you the most useful (from business analyst / consultant perspective) formulas as fast as possible. I want you also to acquire thanks to the course good habits in Excel that will save you loads of time.  

If done properly, this course will transform you in 1 day into pretty good business analyst that knows how to use Excel in the smart way. It is based on my 12 years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement and turn-arounds in biggest companies from FMCG, SMG, B2B sector that I worked for.  On the basis of what you will find in this course I have trained over 100 business analysts who now are Investment Directors, Senior Analyst, Directors in Consulting Companies, Board Members etc.  

I teach step by step on the basis of Excel files that will be attached to the course. To make the best out of the course you should follow my steps and repeat what I do with the data after every lecture. Don’t move to the next lecture if you have not done what I show in the lecture that you have gone through.  

 I assume that you know basic Excel so the basic features (i.e. how to write formula in Excel) are not explained in this course. I concentrate on intermediate and advanced solutions and purposefully get rid of some things that are advanced yet later become very inflexible and useless (i.e. naming the variables). At the end, I will show 4 full blown analyses in Excel that use the tricks that I show in the lectures.  

To every lecture you will find attached  (in additional resources) the Excel shown in the Lecture 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 in your work.  

   

Why I decided to create this course?  

I have done number of courses showing you how to analyze data in Excel. Yet, I have noticed that some students lack the fluency of operations in Excel. This course is designed to fill in the gap and help you fully appreciate my other courses for business analysts and consultants. It can be used also as standalone course that will help you to be smart in Excel  

   

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 with which you do the analyses as well as the quality of the conclusions coming out of available in your company data. 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 know:  

  1. How to use Excel in a smart way to be able to analyses data fast and efficiently

  2. How to draw conclusions from analyses – chosen examples of analyses

  3. How to be efficient in your work as analyst?

  4. How to build Excels that it is understandable for you and your team, even after some time

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

   

How the course is organized?  

The course is divided currently in 6 sections and will be adding new section to address other important issues. Currently you will find the following sections:  

  • Introduction. We begin with little intro into the course  

  • How to merge data from different sources. Quite often as an analyst you will have to combine data from different sources. In this section I will show you how to do it using VLOOKUP function and others to make sure that you can easily combine data from different tables into the desired analysis   

  • Cleaning and unifying data.  50% of your time will be lost on setting the data right so it can be used for analyses. In this section you will      learn how to clean and unify data fast   

  • How to use IF function and what you can do instead? Most of analyses require you to make them dependable on something. For this you can use IF function which gets messy with more complicated formulas. I will show you how to avoid the mess and in most cases not use IF function   

  • Pivot Tables. As a business analyst you will have to look at data on different levels. I will show you how to do it with Pivot Tables, Pivot Charts and what to do instead.   

  • Other useful functions. In this section I will show you other useful function that you should master   

  • Example of analysis. Here we show full analysis from start to end including drawing conclusions. This will show you want should be the end result   

  • Tools for analyzing data. On top of Excel function you have available other tools in Excel that we will discuss in section. Most of them save you a lot of trouble in analyzing data   

  • Being faster with Excel. If you spend 6-8 hours a day with Excel you have to be fast not to waste your valuable time. Here I will show you  how to do it   

  • Visual Basic – main things you should know. Sometimes it is much easier to do something in Visual Basic than go via typical Excel formulas. For some cases Visual Basics creates new opportunities. Here I will show you the most useful elements of Visual Basic.   

 

You will be able also to download many additional resources  

  • Excels with analyses shown in the course

  • Links to additional presentations and movies

  • Links to books worth reading

    

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

  • You will master the most crucial functions and features of Excel

  • Understand the main challenges in analyzing data in Excel

  • Perform the analyses in a very effective manner

Who should take this course? Who should not?   

  • Business analysts

  • Researchers

  • Controllers

  • Consultants

  • Small and medium business owners

  • Startups founders

    

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

  • Basic Excel

  • Basic knowledge of economics or finance


Who this course is for:

  • Business analysts
  • Consultants
  • Researchers
  • Controllers
  • Small and medium business owners
  • Startups founders

Featured review

Gina Galligan
Gina Galligan
30 courses
2 reviews
Rating: 5.0 out of 510 months ago
I couldn't recommend this excellent course more highly. You'll acquire important excel skills prior to deep diving into Asen's more comprehensive modeling courses. I've enrolled in several of his courses and am mid-way through and have found I'm already using what I've learned on a daily basis. Asen is a talented instructor and this course is unique. He is also extremely helpful, answering questions and genuinely wants you to succeed. You wont regret it!

Course content

12 sections • 99 lectures • 4h 59m total length

  • Preview04:15
  • Preview01:51
  • Preview01:38
  • What to do if a blurry image appears
    02:04
  • How to find additional resources
    01:05

  • Preview01:19
  • Preview01:37
  • Preview03:20
  • Preview01:58
  • Preview02:58
  • How to use HLOOKUP?
    01:37
  • Preview03:52
  • Assigning categories based on 2 criteria using HLOOKUP and VLOOKUP function
    02:44
  • Assigning categories based on 2 criteria using VLOOKUP only?
    04:16
  • How to assign categories based on 3 and more criteria using VLOOKUP?
    04:46
  • How to assign categories using SUMIFS function – Basic Usage
    04:50
  • Assigning customers to segments – Case Introduction
    03:03
  • Assigning customers to segments – Data Available
    01:56
  • Assigning customers to segments – Solution
    04:38

  • Preview03:45
  • Fuel usage analysis using the vlookup function - tips
    05:04
  • Fuel usage analysis using the vlookup function - solution
    02:31

  • Preview02:19
  • How to assign categories using string related functions?
    03:11
  • How to divide 1 data into 2?
    02:54
  • How to join 2 data into 1?
    01:23
  • How you can standarize data?
    04:01
  • Example of unifying data - Saturating existing markets – Introduction
    01:11
  • Saturating existing markets – Data for the case study
    03:12
  • Saturating existing markets – Number of Stores
    03:09
  • Saturating existing markets – Stores by concepts
    03:04
  • Saturating existing markets – Concept & Space
    03:46
  • Saturating existing markets – Solution in Power Point
    01:57
  • Saturating existing markets – WaterFall Graph
    03:44

  • Preview01:56
  • How to use IF function?
    01:42
  • Preview03:45
  • How to use IFERROR function?
    02:11
  • How to use MAX and MIN instead of IF function
    04:08

  • Preview01:24
  • How to use pivot tables?
    05:28
  • How to use pivot charts?
    02:39
  • How to combine pivot tables with regular calculations?
    02:17
  • How to use slicers?
    02:07
  • How to replace pivot tables with SUMIFS and COUNTIFS
    03:17
  • Going from general to specific with pivots
    01:57
  • Example of analyses using pivot tables- Analysis of sales channels for FMCG
    03:06

  • Other useful functions and tools in Excel
    01:41
  • Conditional Formating
    04:42
  • How to use indirect function
    03:12
  • Histograms
    02:49
  • Regression - introduction
    02:23
  • Regression - example
    06:03
  • Data validation
    03:01
  • How to use SUMPRODUCT function
    05:45
  • Using solver – Planning the flow of finished goods – Introduction
    00:33
  • Using solver – Planning the flow of finished goods – Excel - First Option
    06:13
  • Using solver – Planning the flow of finished goods – Excel - Second Option
    03:01
  • When can I retire – Introduction
    01:23
  • When can I retire – No passive income – Excel Basic
    05:17
  • When can I retire – No passive income – Go seek function
    03:05
  • When can I retire – With passive income
    02:17
  • What will be the effect of the price increase – Introduction
    02:09
  • What will be the effect of the price increase – Solution – Impact on coffee only
    04:01
  • What will be the effect of the price increase – Solution – Full impact
    02:34

  • Examples of analyses in Excel
    01:21
  • Sales channel analysis - case in FMCG
    03:06
  • Efficiency of marketing activities
    08:19
  • Preview09:10
  • Expansion strategy into other countries – Case Introduction
    02:17
  • Expansion strategy into other countries – Data for the case study
    03:44
  • Expansion strategy into other countries – Which function to use
    04:53
  • Expansion strategy into other countries – Solution in Excel
    03:32
  • Expansion strategy into other countries – Solution in Power Point
    02:30
  • How to create a waterfall chart
    03:44

  • Logistics system simulation - introduction
    04:28
  • Logistic system simulation - tips how to do it
    08:23
  • Logistic system simulation - final solution
    08:33

  • Excel shortcuts - Why it makes sense to learn them
    01:05
  • Essential shortcuts – Introduction
    01:52
  • No mouse rule
    01:27
  • How to format cells using shortcuts – Text – Part 1
    01:45
  • How to format cells using shortcuts – Text – Part 2
    02:37
  • How to format cells using shortcuts – Numbers
    03:11
  • Copying of cells with shortcuts
    02:31
  • Selecting rows and selecting columns
    02:38
  • Adding and removing rows and columns
    02:17
  • Grouping rows and columns
    03:12
  • How to preserve your results or go back to previous ones
    02:39
  • Going fast around the Excel with shortcuts
    02:19
  • Selecting area with shortcuts
    01:22
  • Search and replace data
    01:00
  • Shortcuts test
    10 questions

Instructor

Asen Gyczew
Expert in performance improvement, turnaround and startups
Asen Gyczew
  • 4.3 Instructor Rating
  • 13,586 Reviews
  • 87,934 Students
  • 50 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. On top of that my courses on Udemy were already taken by more than 84 000 students including people working in McKinsey, EY, Walmart, Alvarez & Marsal, Bain, PwC, Deloitte, Accenture, Dell, Adidas, Naspers, Walgreens, Orange, Citigroup, Cisco, IBM, and many others.


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) 

Countries: Poland, Serbia, Russia, Ukraine 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.