Advanced Pivot Table Tricks ONLY Experts Know

Amazing!! thanks

huge respect from Pakistan. LOL

Hi everyone,

I'd a small doubt, from where do we got the months column when its not present in the dataset?

Thanks Kenji.Really appreciate your efforts to equipp us with knowledge.

Great job sir

thank you, thank you, thankyou

I like this video an also I learned a lot. Thanks a lot for this great tutorial.

On a timeline slicer how can I make the quarters in line with the fiscal year the data is intended to show? CY Q4 is actually my FY Q1.

I use excel a lot in work. Your example questions are very useful. Thank you so much!!

wooaah big help🤗🤗🤗

Thank you Kenji ! you are the best :)

Use Case: I have a pivot table connected to splicers. The pivot table has 20 rows of data and multiple columns. The splicer filters between Fiscal Quarters. Is there a way to set up excel or pivots to not truncate the rows I apply a filter? For example...I have 20 rows when in Q1, but when I apply the filter for Q2 it goes down to 15 rows...hiding rows without data. Can I set up the pivot to keep the 20 rows and show rows without data as blank?

I'm in awe of these skills😅

My timeline was greyed out ?

If you want Excel work contact me

I wish you were a professor at an Undergrad Business school. These things are 100% more important than anything I learned in school. After being in the working world for + 15 yrs techy people are great in finance - not the pure finance geeks. Techies make the best files, macros and excel models and everyone deems them the "gods" of finance.

Great video as always with lots of handy tips. But at formatting I have a question. I guess it is simple, but why the accounting format and not just the financial formatting?

preparing for an excel case interview, find this very helpful! thank you!

Does anyone know how to fix the problem (or bug) where a pivot table is formatted for most of the table, but the last section the formatting is different and doesn't follow the same format as the upper part of the pivot table?

Thanks so much 🙏 namaste!

Wow.... I use pivot table a lot, but never have I explore these tricks

Very much informative, like your way of explanation in depth on each individual topics, which helps us understand very clearly.

You are just an excel genius. wow!

Timelines button will really help in for day to day work ..superb

Hi thanks for this very useful video, somehow grouping is not working for me. I have some blank rows in table also

👍💯

Super, helps me as business analyst.

Wooow i am new to pivot tables and this is excellent

Never knew about the timeline, I'd have just used a slicer, but that's really good to know.

Nice... thanks

Excellent presentation, i have learnt a lot from your channel.
best regards from Egypt

I HAVE A PIVOT TABLE. IN THIS TABLE IN THE TOP ROW & COLUMN 1 IS THE DATE RANGE AND I WANT TO USE THIS DATE RANGE COMMAND WITH VBA USER FORM. WHEN IN USER FORM I CHANGE THE DATE AND CLICK ON SHOW IN USER FORM THEN PIVOT TABLE TOP ROW & COLUMN 1 IS THE DATE RANGE IS AUTOMATIC CHANGE AND UPDATE WITH DATE DATA. IF IS IT POSSIBLE ??? PLEASE RESPONSE ME. AND MAKE A VIDEO ON IT. THANKS (AMARENDRA KUMAR)

The grouping units feature redundant endpoints, e.g. 40, 60, 80, etc. appear twice. Thus the viewer can't know if a $40.00 entry has been grouped in the 20-40 or the 40-60 bin. This suggests a round-off issue in which a value such as $40.50 may have in effect fallen between two bins, which work with integers.

Thank you… clearly explained

Why do you select the [Accounting] format over [Currency]?

Amazing, filter to sheets incredible, every day is a school day☘️❤️

Can we add RS. 10 in grand total single row for tally the adjustment amount.

These are the best videos I have seen so far, thank you. I have one question though, does anyone knows how to permanently fix the dimensions of the Pivot table and Chart that they don't resize and/or move during filtrations? Especially their width and if possible their heights? Thank you.

All of these are fairly basic? 2-3 column pivots with introductory functions..

This guy thinks people should see him all the time watching this video.. Too pathetic.. Watch "excelsfun".. Content oriented and he never takes any space of the screen for just exhibiting his face.

Excellent . Crisp and clear explanation. Thanks

Can i open all the data sheets without double clicking one by one. Is there any one option?

Best mentor ever for working professional....thank you for sharing valuable information...most effective part is you cover topic in short time.Kudos to you

Kenji, when I refresh the pivot table The field filter disappears and the data for all years are displayed, Can you help trouble shoot this type of error? Thanks, Ed

Can you support same Part code & same customer we supplied different price in past 5 five years, I want take report for this, while making pivot its coming sum value and tried max & minimum in cause of if its two different price we can use, but supplied three different prices how to take report, I failed evert time, anyone can support...!!!!!!!!!!!!!!

amazing video!

Man your explanation and editing is so clean that i got lost and distracted into thinking how clean and smooth a video can be like that.

Learnt a lot from this video