Home

Excel Table Talk - Episode 2

Highlighted
Olaf Hubel
Microsoft

Excel Table Talk - Episode 2

This month I talk to @Carlos Otero about Get & Transform (Power Query) and the Data Model (Power Pivot). 

 

 

 

  • Show and Tell
  • Tips and Tricks
8 Replies

Re: Excel Table Talk - Episode 2

Hi Olaf,

 

Do you in Microsoft consider the possibility to add Power Pivot to all versions of Excel? Taking into account

- you in any case has the engine inside the Excel;

- user interface to work with it is free for Power BI Desktop;

- in Excel without Power Pivot you may load data into data model (G&T or PivotTable); create relationships from UI; add measures using DAX (PivotTable); make more complex DAX calculations through Table->Edit DAX

 

All above is workaround and don't give full Power Pivot functionality, but workable. Of course, if you have statistics what quite a lot of people shifted from version like Home on Pro only due to have Power Pivot such separation could make sense. I'm not sure in that, but who knows. Only Microsoft.

RE: Excel Table Talk - Episode 2

Great Show. Looking forward to Episode 3.

Re: Excel Table Talk - Episode 2

Congratulations Ingeborg! Great Show Olaf - much better than anything on TV.

RE: Excel Table Talk - Episode 2

Good morning sir. i hope you will help me is this way: i would like to count criteria for exemple in colum j dependind on colun j, how can i do it

RE: Excel Table Talk - Episode 2

colum i depending on colum j

Re: RE: Excel Table Talk - Episode 2

Are you looking to count non-blank cells or cells with a certain value?  Or both?

Re: Excel Table Talk - Episode 2

hi

Re: Excel Table Talk - Episode 2

hiphoto_2017-09-19_17-42-45.jpgphoto_2017-09-19_17-42-41.jpg

Related Conversations
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777  in  Excel  on
43 Replies
Complex INDEX MATCH - Need assistance
Monica Bossert  in  Formulas and Functions  on
30 Replies
Cost estimator for small scale catering
Louisa Dira  in  Excel  on
12 Replies
Excel filter issues
P DS  in  Excel  on
13 Replies
Copy & Paste Issue
Jon Hall  in  Excel  on
11 Replies
Pivot table-filters?
Sophia Tsoleridou  in  Excel  on
14 Replies