GRAPHIC PLANS in Excel
Today's practical case: modifying a meal plan.
An example submitted by one of the Support Group forum members - MS Excel practical advice.
There are many solutions - I decided on PowerQuery.
I also converted the tables into tables - plus a few other tricks.
We train - design - implement Excel, SQL, VBA
www.magiaexcela.pl
LIST:
0:00 Introduction
1:35 Challenge description: summing in graphics
3:01 Check Box - is it worth using?
5:31 Building a new layout
9:12 Converting to a Table
11:22 Sums in a table
13:48 Naming an area
14:32 PowerQuery
15:23 Filter in PowerQuery
17:45 Pivot table with results
19:36 Summary