Graphs, tables, a lot of things on the slide - the rate is 23,500 rubles. from BONNIE&SLIDE, training 4 weeks, date November 6, 2023.
Miscellaneous / / November 28, 2023
PowerPoint + Excel
KILLER COMBINATION AND LOTS OF PRACTICE
Charts
The most useful information about different types of graphs in presentations + basic approaches to data visualization
Tables
Tables and charts in the most boring, but most powerful tool. Basic features and settings that speed up work
Lots of stuff on the slide
Killer slides at the intersection of Excel and PowerPoint. Working with a lot of text and numbers, as well as processes, roadmap and onepager
From the heart of industries
THE COURSE IS BASED ON REAL PRESENTATIONS AND REPORTS
FMCG + RETAIL
Slides from sales reports: turnover, plan/actual, market share, sell out, off-take, on-trade and a hundred more figures.
FINANCE + BANKS
Slides from annual reports: asset structure, capital dynamics, loan portfolio and a couple more diagrams.
MEDIA + MARKETING
Slides from media plans and reports on advertising campaigns: CPC, CTR, CPV, KPI and a dozen more abbreviations.
Types of graphs and tables
WHAT YOU WILL LEARN TO DRAW ON THE COURSE
- Column Charts - What the fact?
- Stack Charts - There's room for improvement
- Waterfall diagrams - Waterfall without water
- Pie Charts - What's Your Share?
- Processes and Roadmap - Step by Step
- Onepager - Beware, few letters
- Gantt Chart - Defeat the Giant
- Text Tables - Get Out of the Cage
- Number tables - 1000 and one digit
Block 1 - Warm-up
Lessons 1-4
In the starting block we will look at the basic principles of working with graphs and tables, as well as common mistakes that are found on slides
Block 2 - Graphs
Lesson 5. Column Charts
How to show plan-fact? How to show sales by region? How far are we behind the KPIs?
Lesson 6. Stack charts
Which product is driving growth? How much has E-Commerce grown? Which direction is it time to close?
Lesson 7. Pie charts
What market share do we occupy? What is the product segmentation? How much has the market grown?
Lesson 8. Waterfall charts
How did we reduce operating expenses? What influenced the growth? What about last year?
BONUS! TRUNK OF KNOWLEDGE
In this lesson we will answer the most frequently asked questions about charts.
Unit 3 - Tables
Lesson 9. EXCEL Basics
The most useful and relevant techniques for working with tables
Lesson 10. Numeric tables
How to show numbers beautifully when “nothing can be removed and everything is important”?
Lesson 11. Text tables
Love a lot of text inside tables, but feel like it doesn't work? This lesson is for you
Lesson 12. Gantt chart
A lesson for those planning project launches
BONUS! TRUNK OF KNOWLEDGE
In this lesson we will answer the most frequently asked questions about the table.
Block 4 - Lots and lots of things
Lesson 13. Linear process
How to beautifully present information step-by-step on one slide
Lesson 14. Roadmap
How to stay on track when making a roadmap
Lesson 15. Text slides
How to visualize text if you have absolutely no ideas
Lesson 16. Onepager
A special lesson for those who like “everything on one slide. And this should also be added."
EXAM
You will draw a KILLER report for your project, and we will give detailed feedback