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 PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation Sound Therapy CBT Cognitive Behavioral Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Podcasting

BusinessBusiness Analytics & IntelligenceExcel

Essential Excel for Business Analysts and Consultants

Master the formulas and tricks that will save you time and make you as efficient as consultants in McKinsey, BCG, Bain
Rating: 4.4 out of 54.4 (761 ratings)
5,494 students
Created by Asen Gyczew
Last updated 5/2022
English
English [Auto]

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 fanciest or sophisticated one,  yet it is universally understood by everybody especially your boss and your customers.    

Excel is still a pretty advanced tool with countless 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 the 80/20 rule and I want to teach you the most useful (from a 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 a pretty good business analyst that knows how to use Excel in a smart way.

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 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 formulas 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). In 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 modifications, be applied by you in your work.   

Why have I decided to create this course?   

I have done a 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 a 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 an analyst?

  4. How to build Excels that 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 into the following sections:   

  • Introduction. We begin with a little intro to 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 the VLOOKUP function and others to make sure that you can easily combine data from different tables into the desired analysis. You will also see how to use HLOOKUP, MATCH, SUMIFS, and INDEX functions.

  • 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 the IF function and what you can do instead? Most of the analyses require you to make them dependable on something. For this, you can use the IF function which gets messy with more complicated formulas. I will show you how to avoid the mess and in most cases not use the 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 functions 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 the Excel functions, you have available other tools in Excel that we will discuss in the 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 – the 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.   

  • Essential  Excel shortcuts. In this section, we will discuss the essential shortcuts that will help you do the analyses much faster.

 

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 G.
34 courses
2 reviews
Rating: 5.0 out of 52 years 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!

Instructor

Asen Gyczew
Expert in performance improvement, turnaround and startups
Asen Gyczew
  • 4.5 Instructor Rating
  • 27,262 Reviews
  • 135,285 Students
  • 63 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
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.