Essential Excel for Business Analysts and Consultants

Essential Excel for Business Analysts and Consultants, available at $74.99, has an average rating of 4.65, with 108 lectures, 2 quizzes, based on 1050 reviews, and has 7580 subscribers.

You will learn about 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 This course is ideal for individuals who are Business analysts or Consultants or Researchers or Controllers or Small and medium business owners or Startups founders It is particularly useful for Business analysts or Consultants or Researchers or Controllers or Small and medium business owners or Startups founders.

Enroll now: Essential Excel for Business Analysts and Consultants

Summary

Title: Essential Excel for Business Analysts and Consultants

Price: $74.99

Average Rating: 4.65

Number of Lectures: 108

Number of Quizzes: 2

Number of Published Lectures: 108

Number of Published Quizzes: 2

Number of Curriculum Items: 110

Number of Published Curriculum Objects: 110

Original Price: $79.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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 most 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 NOTteach 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 out or supervised over 90 different performance improvement projects in different industries that generated in a total of 2 billion in 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 224 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 fluency in 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 tons of analyses, tricks, and 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, and other notable examples worth mentioning. Our intention is that thanks to the course you will know:

How to use Excel in a smart way to be able to analyze data fast and efficiently
How to draw conclusions from analyses – chosen examples of analyses
How to be efficient in your work as an analyst?
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 oftenas 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, and 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 a 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 and 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. In some cases, Visual Basics create 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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: About Me

Lecture 3: What to do if a blurry image appears

Lecture 4: How to find additional resources

Lecture 5: How to make the most out of the course

Chapter 2: How to merge data from different sources

Lecture 1: How to merge data from different sources

Lecture 2: VLOOKUP – Introduction

Lecture 3: VLOOKUP with approximate match – Introduction

Lecture 4: What you can use the VLOOKUP for?

Lecture 5: Basic VLOOKUP usage

Lecture 6: Some comments on basic VLOOKUP

Lecture 7: How to assign categories using VLOOKUP?

Lecture 8: How to use HLOOKUP?

Lecture 9: The logic of MATCH function

Lecture 10: Assigning categories based on 2 criteria using MATCH and VLOOKUP function?

Lecture 11: Assigning categories based on 2 criteria using HLOOKUP and VLOOKUP function

Lecture 12: Assigning categories based on 2 criteria using VLOOKUP only?

Lecture 13: How to assign categories based on 3 and more criteria using VLOOKUP?

Lecture 14: How to assign categories using SUMIFS function – Basic Usage

Lecture 15: Assigning customers to segments – Case Introduction

Lecture 16: Assigning customers to segments – Data Available

Lecture 17: Assigning customers to segments – Solution

Lecture 18: The logic of INDEX function

Lecture 19: INDEX & MATCH function – Introduction

Lecture 20: INDEX & MATCH function – Exercise – Case Introduction

Lecture 21: INDEX & MATCH function – Exercise – Case Solution

Chapter 3: Example of analysis requiring merging data

Lecture 1: Fuel usage analysis using the vlookup function – intro

Lecture 2: Fuel usage analysis using the vlookup function – tips

Lecture 3: Fuel usage analysis using the vlookup function – solution

Chapter 4: Cleaning and unifying data

Lecture 1: What problems you may face with data

Lecture 2: How to assign categories using string related functions?

Lecture 3: How to divide 1 data into 2?

Lecture 4: How to join 2 data into 1?

Lecture 5: How you can standarize data?

Lecture 6: Example of unifying data – Saturating existing markets – Introduction

Lecture 7: Saturating existing markets – Data for the case study

Lecture 8: Saturating existing markets – Number of Stores

Lecture 9: Saturating existing markets – Stores by concepts

Lecture 10: Saturating existing markets – Concept & Space

Lecture 11: Saturating existing markets – Solution in Power Point

Lecture 12: Saturating existing markets – WaterFall Graph

Chapter 5: How to use IF function and what you can do instead?

Lecture 1: Why NOT to use IF function

Lecture 2: How to use IF function?

Lecture 3: How to use VLOOKUP instead of IF function?

Lecture 4: How to use IFERROR function?

Lecture 5: How to use MAX and MIN instead of IF function

Chapter 6: Pivot Tables

Lecture 1: Pivot tables – introduction

Lecture 2: How to use pivot tables?

Lecture 3: How to use pivot charts?

Lecture 4: How to combine pivot tables with regular calculations?

Lecture 5: How to use slicers?

Lecture 6: How to replace pivot tables with SUMIFS and COUNTIFS

Lecture 7: Going from general to specific with pivots

Lecture 8: Example of analyses using pivot tables- Analysis of sales channels for FMCG

Chapter 7: Other useful functions and tools in Excel

Lecture 1: Other useful functions and tools in Excel

Lecture 2: Conditional Formating

Lecture 3: How to use indirect function

Lecture 4: Histograms

Lecture 5: Regression – introduction

Lecture 6: Regression – example

Lecture 7: Data validation

Lecture 8: How to use SUMPRODUCT function

Lecture 9: Using solver – Planning the flow of finished goods – Introduction

Lecture 10: Using solver – Planning the flow of finished goods – Excel – First Option

Lecture 11: Using solver – Planning the flow of finished goods – Excel – Second Option

Lecture 12: When can I retire – Introduction

Lecture 13: When can I retire – No passive income – Excel Basic

Lecture 14: When can I retire – No passive income – Go seek function

Lecture 15: When can I retire – With passive income

Lecture 16: What will be the effect of the price increase – Introduction

Lecture 17: What will be the effect of the price increase – Solution – Impact on coffee only

Lecture 18: What will be the effect of the price increase – Solution – Full impact

Chapter 8: Examples of analyses

Lecture 1: Examples of analyses in Excel

Lecture 2: Sales channel analysis – case in FMCG

Lecture 3: Efficiency of marketing activities

Lecture 4: Model of E-commerce

Lecture 5: Expansion strategy into other countries – Case Introduction

Lecture 6: Expansion strategy into other countries – Data for the case study

Lecture 7: Expansion strategy into other countries – Which function to use

Lecture 8: Expansion strategy into other countries – Solution in Excel

Lecture 9: Expansion strategy into other countries – Solution in Power Point

Lecture 10: How to create a waterfall chart

Lecture 11: How to create scatter plot with Names

Lecture 12: Data Visualization

Chapter 9: Basic VBA usage – example

Lecture 1: Logistics system simulation – introduction

Lecture 2: Logistic system simulation – tips how to do it

Lecture 3: Logistic system simulation – final solution

Chapter 10: Essential Excel shortcuts

Lecture 1: Excel shortcuts – Why it makes sense to learn them

Lecture 2: Essential shortcuts – Introduction

Lecture 3: No mouse rule

Instructors

Asen Gyczew
Expert in performance improvement, turnaround and startups

Rating Distribution

1 stars: 16 votes
2 stars: 38 votes
3 stars: 149 votes
4 stars: 356 votes
5 stars: 491 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu