3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779

[@BaniMoniah]

Gloria is so lucky to find your channel!

[@excelisfun]

Go Team!!!!!! The video does have a bunch of really useful AND fun tips : ) : )

[@excelwithmark]

Great video thanks for sharing

[@excelisfun]

You are welcome for the share! That vid had a lot of fun tricks, all in one. Even I was having too much fun lol

[@simfinso858]

Pivot table last one is Amazing.

[@excelisfun]

Yes, I love that one. I have taught many of the administrators at my College that one - and they love it : )

[@chrism9037]

XLOOKUP is so amazing, I use it constantly now. One of the best functions Microsoft has introduced in years, along with FILTER. Thanks Mike!

[@excelisfun]

You got that right: XLOOKUP and FILTER!!!

[@PaulasPicks]

I'll admit that while I see the XLOOKUP advantage, I haven't used it other than to practice a bit; I'm still a VLOOKUP gal. But, this was such a quick way to see how small the differences between the two lookups were, with such cool results to boot. Thank you for teaching, Mike!

[@excelisfun]

You are welcome for the small differences, cool results and fun teaching, VLOOKUP Gal Paulas!!!! By The Way, VLOOKUP can spill all the results too if you have Microsoft 365 Excel or Excel 2021.

[@SyedMuzammilMahasanShahi]

Thanks Mike for this EXCELlent video.

[@excelisfun]

You are welcome for the video, Fellow Teacher SMM : ) : ) : ) : )

[@nadermounir8228]

Amazing 👏 Thank u Mike for this great pivot table trick !

[@excelisfun]

You are welcome for the fun PT Tricks, Nader!!!

[@aniljaggarwal60]

Excellent 👌

[@excelisfun]

Glad it is EXCELlent for you, Anil : )

[@youngmula2446]

Thank you for all your effort, we appreciate it.

[@excelisfun]

You are welcome, Young Mula!!!!

[@safiathomas]

Thank you for the excellent video. I am hoping to add more videos like this for HR reports rather then accounting, it would be appreciated.

[@FutureCommentary1]

The relationship thing... Completely new to me. I use data models and stuff but never tried to just create a relationship like this.

[@excelisfun]

It is a great way to do it!!!

[@TP014563]

Got to admit, that last trick I didn't know about. Thanks for sharing this with us. Superb explanation as always.

[@excelisfun]

It is a killer trick that has been around as long as I can remember : )

[@rmanuel67]

The Relationship was so helpful. Thank you.

[@excelisfun]

You are welcome!!!

[@christiancoronado]

Great video!

[@excelisfun]

Glad you like it, Christian!!!!!

[@Bhavik_Khatri]

Really awesome tricks 👍

[@excelisfun]

Glad you like them!!!!

[@mamadoubah3686]

Amazing content! Thank you Mike!

[@mattschoular8844]

Fantastic on all three methods. Thanks Mike

[@excelisfun]

You are welcome, Matt! The three really are fun : )

[@sachinrv1]

Fantastic video Mike :)

[@excelisfun]

Glad it is fantastic for you, Sachin Vartak!!!! What was your favorite trick in this video? Or top two triucks?

[@enuffalready1313]

Another job well done, Mike. Keep up the good fight. Looking forward to seeing your book in the near future.

[@excelisfun]

Yes!!!! Fight for what is right: fun with Excel : ) : ) : ) : ) The book is due out July 1st : )

[@enuffalready1313]

Looking forward to it Mike.

[@HusseinKorish]

Amazing Mike

[@excelisfun]

Glad you like it, Hussein!!! It sure was fun to make : )

[@Luciano_mp]

Great examples. Thanks Mike.👍

[@excelisfun]

You are welcome, Luciano!!!! It was extra fun for me too - so much fun with a project like this ; )

[@GeertDelmulle]

Great video, Mike! Learned a couple of things: • create relationship between 2 Excel tables and everything is imported directly into the data model (you may have shown that before, but I had forgotten about that), I always do it the long way. Although I find myself using the Excel pop-up interface to the data model more and more, especially for creating DAX measures. • when creating a pivot table from the data model we still have the date grouping feature (I thought we didn’t have that when working with the data model). BTW: I agree that the labels in the relationship window are confusing, here’s a little trick I use: “Related Table” is the table you refer to in DAX by using the RELATED function. Thus the dTable (dimension table). The label to the right confirms this mnemonic technique: Primary Key.

[@darylseaton6493]

This is awesome, many many thanks for this video!!!!

[@excelisfun]

Many, many you are welcomes, Daryl!!!!! There are many, many useful reporting tricks in this one video ; )

[@wayneedmondson1065]

Great stuff Mike! Slicing and dicing with new and old formulas, Pivot Tables, the Data Model. Awesome tricks! Thanks for the demo. Thumbs up!!

[@excelisfun]

You are welcome, Wayne. Too much fun in this video : ) : ) : ) : )

[@JoeNic1206]

@@excelisfun Why not do slicer you can pick each department why so many tabs? Just my thoughts.

[@pawangupta056]

THANK YOU

[@excelisfun]

You are welcome, Pawan!!!

[@Marshulin]

Thank you! Very helpful!

[@excelisfun]

You are welcome, Marcela!!! This is an action packed, must see video for anyone creating reports in Excel : )

[@sushantachoudhury7021]

Awesome Sir...

[@excelisfun]

Glad it is awesome for you, Sushanta!!!!

[@shiffamohammed5818]

Great tips as always, thank you so much Mike!!!

[@excelisfun]

You are welcome so much, Shiffa!!!!

[@darrylmorgan]

Boom!Really Fun Class With 3 Awesome Solutions...Thank You Mike :)

[@excelisfun]

You are welcome, Biker Brother darryl : ) : ) : )

[@carinabrachtl3986]

Made my day!

[@SS-xk2wx]

I have watched a lot of your videos but I have not seen one that shows getting data from SharePoint folder. I need to import multiple excel tables from SharePoint folder, clean, append then give a week by week update progress report in excel. Some files are small some are large. Keep in Excel vs. Power Query? These are employees completing specific classes and need to track their progress week over week. I really enjoy how you teach these classes and have watched you for many years. Thank you for all you do!

[@a2ainfo879]

Good Tricks

[@excelisfun]

Glad you like them, A2A Info!!!

[@shubhampawar8506]

Show report filter pages is great ..loved it ❤️🙌.. Microsoft 365 is going to play crucial role while analysing big data .Eager to get 365 😍

[@excelisfun]

I can't wait for you to get 365 either, shubham!!!!!

[@georgetosounidis5545]

Excel is Fun, surely makes it fun! Dude is a Giga-brain :)

[@gvitullib]

Great video Mike. All methods are amazing. But I'm still with Index + Match functions, these are perfect for any vlookup task. The only change is that im using Xmatch and that combination with Index is really powerful.

[@excelisfun]

Cool, Giovanni!!!! So many ways to have fun: INDEX and MATCH, XLOOKUP and even LOOKUP sometimes ; )

[@msantosh1220]

Thanks!

[@msantosh1220]

Thanks for this video, let me know if you have released ur book on "office 365" for online sale.

[@excelisfun]

Thanks Teammate Santosh!!!! Your donations is furl that helps the excelisfun channel : ) : ) : ) : )

[@excelisfun]

@@msantosh1220 The Publisher said it would be out July 1 : )

[@msantosh1220]

Eager and super excited, for your book

[@excelisfun]

@@msantosh1220 Me too. after more than two years in making...

[@johnborg6005]

Thanks mike. :) :)

[@barttitulaerexcelbart9400]

Thanks Mike. specially for the remark at 11.00. I knew the function Report Filter for a long time, but it did not work, now I know why...Actually it is a pitty a) that this function does not work in the data model and b) that it is hidden so far....

[@ramazancingor1964]

Hello mike. I have two tables, it comes and goes. How can I make the shortest formula using the data in these two tables?

[@bhaktamgb]

What to do when we want to show some show field report instead of all fields?

[@phoebenguyen3272]

Hi sir, i have a little confused, about xlookup, when i turn both data into table and do xlookup, the calculation doesnt work, errror is #SPILL!. Any wrong if using table with xlookup? Thank you.

[@einjhelle0018]

Can this be achieved using the hstack/vstack?? If yes, can you please show us??🙏🙏🙏🙏

[@excelisfun]

It can, but I might not be able to make a video soon. I already have a video that shows how to achieve what you want, but with a slightly different method. Check it out until I can make a new video later: kzbin.info/www/bejne/nnaXfqKVrterrtk

[@einjhelle0018]

@@excelisfun wow... You reply.. thank you..

[@excelisfun]

@@einjhelle0018 You are welcome!!!!

[@JoseAntonioMorato]

Dear Mike, the link to «Download Excel File» is incorrect. 🤗

[@excelisfun]

I just fixed it! Now you can download for maximum fun, Jose!!!!

[@excelisfun]

Thanks for letting me know so quickly. It helps the Team : )

[@ihaballam6971]

pls can you explain vba for excel in details

[@excelisfun]

No. As I have said many times in my videos over the last 14 years, since I am not good with VBA, I can't teach it. Sorry about that, Ihab.

[@ihaballam6971]

pls update the link of excel file link

[@excelisfun]

Sorry about that : ( I just fixed it! Now you can download for maximum fun, Ihad Allam : ) : )

[@ihaballam6971]

@@excelisfun thanks alot . i love you 💕💕💕

[@excelisfun]

@@ihaballam6971 I boomerang love right back to you!!!!

[@ChristianMiersch]

Why can I only give one Like here?

[@excelisfun]

Good question!!!! This vid does has a bunch of thumbs up worthy tips ; )

[@ihaballam6971]

excel file link isnt work

[@excelisfun]

Thanks for letting me know. I have fixed it, Ihab!!!!