Introduction
  • Introduction
  • A little bit about me
  • How the course is organized
  • How to deal with Blurry image
  • How to reach additional resources
How to merge data from different sources
  • Basic concepts used in Excel – Introduction
  • How to merge data from different sources
  • VLOOKUP – Introduction
  • VLOOKUP with approximate match – Introduction
  • 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?
  • The logic of MATCH function
  • How to assign categories based on 2 criteria using VLOOKUP and MATCH function?
  • How to assign categories based on 2 criteria using HLOOKUP and VLOOKUP function
  • 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
  • The logic of INDEX function
  • INDEX & MATCH function – Introduction
  • INDEX & MATCH function – Exercise – Case Introduction
  • INDEX & MATCH function – Exercise – Case Solution
  • SUMPRODUCT function
  • Conditional Formating
To-do lists in Excel
  • To-do lists in Excel – Introduction
  • Make to do list
  • Managing the team in practice
  • To-do list in Excel – Case Introduction
  • To-do list in Excel – Dropdown list
  • To-do list in Excel – Table with slicers
  • To-do list in Excel – Dynamic Dropdown List
  • To-do list in Excel – Additional Comments
How to estimate the costs and benefits of projects
  • Costs and benefits of the project – Introduction
  • Bottom-up approach
  • Estimating the costs of a wedding – Introduction
  • Estimating the costs of a wedding – Partial Solution
  • Estimating the costs of a wedding – Excel Part 1
  • Estimating the costs of a wedding – Excel Part 2
  • Rearranging the Office – Case Introduction
  • Rearranging the Office – Data Available
  • Rearranging the Office – Coffee Points
  • Rearranging the Office – Microwave Ovens
  • Rearranging the Office – Stairs
  • Cost reduction Investment – Ceramic Tiles – Introduction
  • Cost reduction Investment – Ceramic Tiles – Current Costs
  • Cost reduction Investment – Ceramic Tiles – Future Costs
  • Cost reduction Investment – Ceramic Tiles – NPV
  • Cost reduction Investment – Ceramic Tiles – Solution in Power Point
How to create a Project Charter using Excel
  • How to create a Project Charter using Excel – Introduction
  • Project Card / Charter – Example
  • Project Summary Tool – Example
  • Project Charter in Excel – Case Introduction
  • Project Charter in Excel – Data Available
  • Project Charter in Excel – Solution
How to create a dashboard in Excel
  • How to create a dashboard – Introduction
  • 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
  • Combining slicers with Pivot Charts
  • Building a Dashboard – Part 1
  • Building a Dashboard – Part 2
  • Look & Feel of Pivot Chart
Gantt Charts in Excel
  • Gantt Chart in Excel – Introduction
  • Gantt Chart – Case Introduction
  • Gantt Chart – What we want to get
  • Gantt Chart – Timeline
  • Gantt Chart – Chart Lines
  • Gantt Chart – Slicers
  • Gantt Chart – Final
Rankings in Excel
  • Rankings in Excel – Introduction
  • Rankings – Introduction
  • How to expand the brand – Introduction
  • How to expand the brand – Solution – Part 1
  • How to expand the brand – Solution – Part 2
  • How to expand the brand – Scatter Graph
  • Expansion strategy into other countries – Introduction
  • 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
Project selection in Excel
  • Project selection – Introduction
  • Strategic alignment framework – Introduction
  • Strategic alignment framework – Case Introduction