Introduction
- Introduction
- About Me
- How to make the most out of the course
- What to do if a blurry image appears
- How to find additional resources
How to merge data from different sources
- How to merge data from different sources
- What you can use the VLOOKUP for?
- Basic VLOOKUP usage
- Some comments on basic VLOOKUP
- How to assign categories using VLOOKUP?
- How to use HLOOKUP?
- Assigning categories based on 2 criteria using MATCH and VLOOKUP function?
- Assigning categories based on 2 criteria using HLOOKUP and VLOOKUP function
- Assigning categories based on 2 criteria using VLOOKUP only?
- How to assign categories based on 3 and more criteria using VLOOKUP?
- How to assign categories using SUMIFS function – Basic Usage
- Assigning customers to segments – Case Introduction
- Assigning customers to segments – Data Available
- Assigning customers to segments – Solution
Example of analysis requiring merging data
- Fuel usage analysis using the vlookup function - intro
- Fuel usage analysis using the vlookup function - tips
- Fuel usage analysis using the vlookup function - solution
Cleaning and unifying data
- What problems you may face with data
- How to assign categories using string related functions?
- How to divide 1 data into 2?
- How to join 2 data into 1?
- How you can standarize data?
- Example of unifying data - Saturating existing markets – Introduction
- Saturating existing markets – Data for the case study
- Saturating existing markets – Number of Stores
- Saturating existing markets – Stores by concepts
- Saturating existing markets – Concept & Space
- Saturating existing markets – Solution in Power Point
- Saturating existing markets – WaterFall Graph
How to use IF function and what you can do instead?
- Why NOT to use IF function
- How to use IF function?
- How to use VLOOKUP instead of IF function?
- How to use IFERROR function?
- How to use MAX and MIN instead of IF function
Pivot Tables
- Pivot tables - introduction
- How to use pivot tables?
- How to use pivot charts?
- How to combine pivot tables with regular calculations?
- How to use slicers?
- How to replace pivot tables with SUMIFS and COUNTIFS
- Going from general to specific with pivots
- Example of analyses using pivot tables- Analysis of sales channels for FMCG
Other useful functions and tools in Excel
- Other useful functions and tools in Excel
- Conditional Formating
- How to use indirect function
- Histograms
- Regression - introduction
- Regression - example
- Data validation
- How to use SUMPRODUCT function
- Using solver – Planning the flow of finished goods – Introduction
- Using solver – Planning the flow of finished goods – Excel - First Option
- Using solver – Planning the flow of finished goods – Excel - Second Option
- When can I retire – Introduction
- When can I retire – No passive income – Excel Basic
- When can I retire – No passive income – Go seek function
- When can I retire – With passive income
- What will be the effect of the price increase – Introduction
- What will be the effect of the price increase – Solution – Impact on coffee only
- What will be the effect of the price increase – Solution – Full impact
Examples of analyses
- Examples of analyses in Excel
- Sales channel analysis - case in FMCG
- Efficiency of marketing activities
- Model of E-commerce
- Expansion strategy into other countries – Case Introduction
- Expansion strategy into other countries – Data for the case study
- Expansion strategy into other countries – Which function to use
- Expansion strategy into other countries – Solution in Excel
- Expansion strategy into other countries – Solution in Power Point
- How to create a waterfall chart
Basic VBA usage - example
- Logistics system simulation - introduction
- Logistic system simulation - tips how to do it
- Logistic system simulation - final solution
Essential Excel shortcuts
- Excel shortcuts - Why it makes sense to learn them
- Essential shortcuts – Introduction
- No mouse rule
- How to format cells using shortcuts – Text – Part 1
- How to format cells using shortcuts – Text – Part 2
- How to format cells using shortcuts – Numbers
- Copying of cells with shortcuts
- Selecting rows and selecting columns
- Adding and removing rows and columns
- Grouping rows and columns
- How to preserve your results or go back to previous ones
- Going fast around the Excel with shortcuts
