Great tutorial Jeff. I think every regular Excel user should watch this video. If they did the entire world's productivity would sky rocket 👍

🤯 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.

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

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.

I thought I new alot about Pwr Q. Man 'o' man what an eye-opener Thanks

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.

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.

Wow, Great sir

Absolutely brilliant !!

perfect 👍 Sr please also share excel file for practice