Great tutorial Jeff. I think every regular Excel user should watch this video. If they did the entire world's productivity would sky rocket 👍
@ExcelU2 жыл бұрын
Thank you :)
@loose.electricity Жыл бұрын
🤯 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!
@ExcelU Жыл бұрын
Thanks for your kind note, and I'm glad it was helpful :)
@husseniabu35574 ай бұрын
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.
@tamiranashechorwira58435 ай бұрын
This is wonderful. You are a start. This has saved a lot of my time. I really appreciate your nuggets of wisdom.
@mailmikee20028 ай бұрын
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
@ernestwong64593 жыл бұрын
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.
@ExcelU3 жыл бұрын
Thanks Ernest ... glad it was helpful :)
@fabianmolyneux2308 Жыл бұрын
I thought I new alot about Pwr Q. Man 'o' man what an eye-opener Thanks
@Bhavik_Khatri Жыл бұрын
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.
@hasankarabektas78192 жыл бұрын
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.
@trietluong81446 ай бұрын
Great. Thanks so much for the tips.
@ExcelU6 ай бұрын
You are so welcome!
@muneebpp Жыл бұрын
Wow, Great sir
@ExcelU Жыл бұрын
Thank you!
@rajannasreedhara624 Жыл бұрын
Absolutely brilliant !!
@ExcelU Жыл бұрын
Thank you!!
@usmaniqbal18362 жыл бұрын
perfect 👍 Sr please also share excel file for practice