🤯 I don't know how I never knew about "convert to formula", this is going to be a game changer for me. I love pivot tables but the format feels so restrictive. This channel is so underrated!
I love your approach to teaching, it makes it sink in-depth. You are a great facilitator. I am only a new bie working with excel and I am happy being able to find your page.
Thank you Jeff. Came across this video by chance..amazing cool tips and love the way you explain excel. Real time saving tips that I can use. Surprised though that there are very few views of your video...would encourage many more to watch it. Appreciate your efforts to make using excel simple
Thank you for mentioning about Data Model and I like how you converted it to formulas. Wow, using Spreadsheets for a long time and didn't know this. I'm learning PQ currently.
Well done Jeff! This is awesome and amazing !! I have been searching for excel skills tutorials that are relevant to accounting but in vain until now. I am also an accountant by training and I found my teams are still working in the old fashion, manual excel work. Your tutorials are great and simple to understand. I have already forwarded some of your clips to my teams for study. Hope we can have more new tips and ideas from you to make us smarter accountants. Cheers.
Very informative video, thanks. I tried the various formulas out and tested a bit. With OLAP Pivot Table I got an update issue: Upon later update of the data source (tables), the amounts actually are updated in my case (grand totals). But when a new category is added (under "Row Labels" of the Pivot with Cube formulas) that does not update, though the grand total encompasses the added value.
🤯 I don't know how I never knew about "convert to formula", this is going to be a game changer for me. I love pivot tables but the format feels so restrictive. This channel is so underrated!
Thanks for your kind note, and I'm glad it was helpful :)
Great tutorial Jeff. I think every regular Excel user should watch this video. If they did the entire world's productivity would sky rocket 👍
Thank you :)
I love your approach to teaching, it makes it sink in-depth. You are a great facilitator. I am only a new bie working with excel and I am happy being able to find your page.
I thought I new alot about Pwr Q. Man 'o' man what an eye-opener Thanks
This is wonderful. You are a start. This has saved a lot of my time. I really appreciate your nuggets of wisdom.
Thank you Jeff. Came across this video by chance..amazing cool tips and love the way you explain excel. Real time saving tips that I can use. Surprised though that there are very few views of your video...would encourage many more to watch it. Appreciate your efforts to make using excel simple
Thank you for mentioning about Data Model and I like how you converted it to formulas. Wow, using Spreadsheets for a long time and didn't know this. I'm learning PQ currently.
Well done Jeff! This is awesome and amazing !! I have been searching for excel skills tutorials that are relevant to accounting but in vain until now. I am also an accountant by training and I found my teams are still working in the old fashion, manual excel work. Your tutorials are great and simple to understand. I have already forwarded some of your clips to my teams for study. Hope we can have more new tips and ideas from you to make us smarter accountants. Cheers.
Thanks Ernest ... glad it was helpful :)
Very informative video, thanks. I tried the various formulas out and tested a bit.
With OLAP Pivot Table I got an update issue: Upon later update of the data source (tables), the amounts actually are updated in my case (grand totals).
But when a new category is added (under "Row Labels" of the Pivot with Cube formulas) that does not update, though the grand total encompasses the added value.
Great. Thanks so much for the tips.
You are so welcome!
Absolutely brilliant !!
Thank you!!
Wow,
Great sir
Thank you!
perfect 👍 Sr please also share excel file for practice