Top 10 Excel Tricks ONLY Experts Know

[@KenjiExplains]

👉 Learn Excel for Business & Finance: www.careerprinciples.com/courses/excel-for-business-finance

[@lihelen8982]

Hello, Are the online courses live teaching? Or jus courses we go through on our own?

[@stephentodd4093]

The split to freeze panes is much harder than the easy way. Just choose the cell below the row and to the right of the column you want to freeze. Select freeze panes and you are good to go!

[@MarvelTanudjaja]

Learned more in 15 minutes than a semester finance course :) Well done Kenji!!

[@KenjiExplains]

hahahaha

[@COURSSTATSCHAMBERY]

request reimbursement from your university :-)

[@noone-td8rc]

Thanks man

[@drewwalters7392]

Macro Tip - When beginning to record a macro, after selecting the short cut key for the macro, select the drop down option to save the macro in the personal macro workbook. This will allow users to use the saved macro in the future without having to open the original workbook the macro was created it every time. Instead a blank workbook containing the saved macro will open in the background and barely noticeable.

[@imamhossain5954]

I've used all the features in 1 2 4 8 & 9 Very useful video. Thanks a lot.

[@improvemyself256]

Hey Kenji, this tutorial was great! The record macros tool can also help you learn VBA: After you recorded your macro, go to visual basic (next to macros). There, open the module for your worksheet and look at the code. You can then delete parts of the code and re-run it on an unformatted table and see what changes. That way you know exactly what part of the code does what.

[@VickiMcCorkle]

You by far have the best tutorial videos. Thank you for providing so many helpful videos.

[@hotflashfoto]

Overall, this was a good video. Freeze Panes: What you did was the long, hard way. Just click on the first row of data in column A, then click Freeze Panes. Done. The Split function does not need to be use, just takes more time, and adds complexity to the ultimate goal of freezing the header. Grouping: Nice that you included the keyboard method to select an entire row! After Grouping the 3 rows, select the next 3 with the mouse and press F4 to repeat the last command. In this case, it will be Grouping. You can continue doing that down the page so long as you don't change the command by selecting the rows with the keyboard. It works for most commands repeatedly, such as Paste Formatting or Paste Values, but works only once for a full, regular Paste. Be careful, though. It works for Delete and a lot of other commands as well. If you experiment a bit, you'll also find that you can compound the edits that you wish to repeat by using the Format Cells (Ctrl + 1), click on the various sub-tabs to modify the selected cells, and then click OK. When you press F4 after that, all of those format changes will take place. When recording a macro, 2 things that the user might want to do: 1) Place the cursor in cell A1 so it's not in the middle of the sheet. On very long sheets of data, leaving it at the bottom will cause the report to open at the bottom, forcing a manager to actually have to scroll to the top. And we all know how managers want to be spoon-fed and have everything all nice and pretty, right? 2) Learn a little bit of coding etiquette and go trim all the "fat" that Excel records so it does not include all the clicking and selecting of cells that the human has to do. The computer doesn't need to select the cells, since it can modify the contents of any cell just by saying, "Cells(3,5) = 12" or "Range("E3") = 12", and that will put a value of 12 into cell E3 (row 3, column 5). You can apply background colors, font colors, borders, formulas, and everything else, and then the display is not "blinking" all over the place while the macro is running. You don't want the Admin to go into an epileptic seizure, now, do ya? ;>\ By extension, you can directly modify cells on any tab (sheet) without having to go to that tab. The human has to go there, but the computer does not. VBA coding is really fun when you do it.

[@issamelsayd]

Thanks for your input

[@TheStoicWay110]

After watching this video Now i am working in Excel like a Pro ,,,, Thank U So Much

[@Micfri123]

I work in finance and am always trying to learn more excel tips- big thanks as usual. I knew about half of these.

[@KenjiExplains]

Great to hear!

[@easwarshankaran4426]

Hello sir am from India and pursuing Chartered Accountancy, your videos are extremely helpful to prepare financials and workings in a professional manner thanks a lot :)

[@Cfckkr]

Kenji, appreciate if you could do a video on discount rate & risk free rate, how are they determined. Learned a lot from your videos. Keep rocking!

[@KenjiExplains]

thanks for the suggestion will keep it in mind!

[@sachitbhatt2727]

All I can say is a heartfelt thank you. I wish I could pay in INR for your courses.

[@shankarnanu1323]

Became fan of u after watching this video. Such an amazing way to understand within minutes for the lifetime ..

[@KenjiExplains]

thank you!

[@5uysal]

You have such great way of explaining things! Love these short videos thanks!

[@gabgab7935]

surprisingly 10/10 however i did not master everything BEFORE but this video refreshes my idea about these tricks. Great job Kenji, such a big help!! Thanks a lot

[@KenjiExplains]

Thank you!

[@MrRvds]

Data Validation and CTRL + E were the new ones for me. Thank you

[@SabesanVaidhyanathan]

Excellent explanation and so easy to understand and follow ther Excel tips and tricks here, great job Kenji !!! THANKS A LOT !

[@Kazaaaaaak]

I knew 9 out of 10. However, I am very pleased to learn about flash fill. So thank you 🙂

[@nonoobott8602]

Very explicit video, so easy to follow. I definitely have to check out your Business and Finance modeling course. For me it was 9/10. Thanks for sharing

[@KenjiExplains]

Thank you!!!

[@lilgirllilgirl735]

Sparklines! I always thought it was just a line graph! This is so useful!

[@talitacorte2268]

Your videos are really good!! best ones so far I have seen. Grat format of presentation and tone of voice! =) Thank you

[@ahmedosama5205]

Got 10/10 , Very Helpful video tho , Thanks for the amazing content

[@KenjiExplains]

Damn you’re good! Thanks man 👍

[@chrisalynbajaro8346]

This really help me a lot, since I don't have a computer subject.

[@KenjiExplains]

Awesome to hear!

[@JeremiahCarter]

This is amazing even as a person that is knowledgeable in finance this was so helpful

[@lucholeonguerrero]

I finally know how to do macros... amazing!

[@alicenexon1381]

the tone and control of ur voice says "I know my sNice tutorialt!". Good stuff buddy.

[@harshilnagda7321]

Insightful. thank you Kenji for providing us with best possible excel content.

[@KenjiExplains]

Thank you for the nice comment! 🙌

[@mty50m1]

Thank you for all of this, it was helpful Can you do free course of excel in this great channel?

[@shahidimran5016]

Perfect way of teaching

[@saurabhshukla2622]

Amazing excel trick taught by you thank you so much

[@camlex6310]

Got 8/10...learning a lot from your videos!

[@KenjiExplains]

Wow you’re good!

[@saeer5038]

Amazing video, many things that you always need, but no one tells you about! What you showed with macros tho is just a tip of iceberg, very useful one, but just a tip. So I would put macros in 5 star plus category as they can get a lot of stuff done for you

[@HealthSmarter]

Well explained. Keep it up.

[@mohdward9505]

This was sooooooooo useful, pretty, elegant & smart. Thank you so much

[@KenjiExplains]

Thanks for the awesome comment!

[@VERTICALcube]

It's worth subscribing to your channel. I learn a lot... 🙏

[@KenjiExplains]

Welcome aboard!

[@positive-affirmation-4-suc727]

Thank you so much - Very useful tips

[@NisfiStatic]

Your video boosted my confidence. Never knew I am an expert 😂

[@RA-rh5lb]

Hi Kenji, thanks for the upload. all your videos are truly good. I would like to learn better way because most of the time i forget what i have learned from youtube( not all but yes at the right time i don't remember what I learned.) how much do you charge for the learn excel for business and finance course

[@bobtucker9082]

Great tips, learnt many new things

[@danielsmart2464]

Wow, I remember subbing to you a couple months ago when you only had a few hundred subs. Glad to see you're doing well

[@KenjiExplains]

Hey Daniel thank you for the support, especially in the early days means a lot!!! Take care :)

[@rishavtoshniwal6248]

I knew all of them, was expecting more advance things, sir.

[@willzinner8813]

Didn't realize macros were a thing. Seems quite easy as well thank you sir. Got 7/10

[@KenjiExplains]

Yes sir!

[@thulaniralo9297]

Level 4 Awesome. Great stuff😁😁😁😁

[@mkg1253]

Have to include the camera add on surely, great for model work

[@MuslimIslam01]

Amazing knowledge and skills

[@VickiMcCorkle]

Great tutorials.

[@shenay9377]

Very helpful. Thanks

[@markyzentana7540]

Very helpful. Thanks man, looking forward for more tutorials.

[@KenjiExplains]

Thank you! More to come :)

[@lolliMAN101]

I’m using excel for financial purposes too (macro- and microeconomic analyses) but I didn’t know about grouping, the rest is all very well known to me! Appreciate your videos!

[@KenjiExplains]

Thank you for watching them!!

[@davekorver9420]

Great! Do you also have a video where you explain the INDIRECT function in combination with het MATCH function?

[@MrSilenxe]

Thanks for all the lessons you provide. Im prepareing for interviews in finance and your videos are very helpful. I knew most of the 4 and 5 stars tips but all of them were very helpful. I was wondering if you can do conditional formating with the sparklines in order to change their color depending on if the trend is upward or downward. I cant check it myself because im using excel web and it doesnt support sparklines.

[@Biniyam3832]

I know 7 out of like 9 questions, thanks for your excel tips and tricks

[@varunmittal5196]

Just blown away.. 🔥❤️

[@flourishwithMJ]

Thank you so much. Amazing.❤

[@andymarci6766]

Super nice Kenji, thanks!

[@KenjiExplains]

Cheers!

[@shandhirani7559]

Brilliant Thank you

[@jeandonaldgeorges7783]

Very insightful. I love your videos. Thanks for th great content.

[@KenjiExplains]

I appreciate that!

[@bingchilling4573]

Thanks for the tips!

[@KenjiExplains]

Thanks for watching!

[@abdulrahmankhan5139]

Great excel tips, thanks for sharing.

[@KenjiExplains]

Glad you enjoyed it!

[@BostonRoger]

I'm not sure how I got this far in my career but I knew all the 2-star and above, but I didn't know how to group cells and that you can set where to freeze. So the two 1-star items helped me the most but I knew how to do the rest.

[@KenjiExplains]

Intersting! Thanks for letting me know

[@donnaassenza3025]

Trend lines 👍🏻👍🏻👍🏻👍🏻👍🏻 thank you

[@allsaka]

It's the best thing i've ever seen!

[@skoombayil]

10/10… But Great Refreshing Video

[@KenjiExplains]

Glad you enjoyed it!

[@andreugiro2807]

Great tips my friend! Keep going!

[@KenjiExplains]

Thanks so much!

[@shydidja69]

7/10.I definitely need to learn macro, every single time I delay my learning process 🤦🏾‍♀️

[@aznty5597]

Don't delay it :) it's super useful and literally would take a few hours to get it right. Best of luck! You can do it

[@KenjiExplains]

Yupp very useful!

[@ThatdudeJaden]

As a Finance student i knew 7/10. I do however consider them as the more simple features that we’ve been taught.

[@JPagan3618]

Great tutorial. Thank you. I always have issues with the Sparklines as it's always greyed out on the sheet I need it at, but I can access it on a new sheet. Does anyone have a tip?

[@manuelvega-arango599]

Really helpful, appreciate it!! 👍

[@KenjiExplains]

Glad it helped!

[@emadr5780]

Thank you very much. Could you please make a video about industry research and how we should do it in excel?

[@KenjiExplains]

Thanks for the suggestion I'll note it!

[@emadr5780]

@@KenjiExplains Realmente lo aprecio :)

[@lesliem6208]

Thank you this was great!

[@KenjiExplains]

Glad it was helpful!

[@emilehouvenaghel5299]

Great video, always appreciate your content!

[@KenjiExplains]

Thank you Emile

[@goaboi]

learning a lot from your videos!

[@KenjiExplains]

Awesome, thank you!

[@luizcristianofs]

I've watched of your videos and liked a lot. good job doing it.

[@KenjiExplains]

Glad you like them!

[@michaelquach7046]

Love the level rankings in this video!

[@KenjiExplains]

Cheers Michael!

[@YogeshSharma-ui7xx]

Nice one.Appreciatee

[@kristynakrunclova5684]

10/10, great video!:)

[@huytran6605]

so useful for me

[@ahmednooor]

9/10. Thanks any ways. Cool to learn about Macro today.

[@KenjiExplains]

Awesome thank you for the comment!

[@reelzerotuned3675]

Nice content as always. 👍🏻

[@KenjiExplains]

Glad you think so!

[@vatsal715]

These all were in dictionary way back. 10/10 easy peasy :P

[@Metalblowing]

Great vid man. I'm always joking with my friends that Excel can do it all. There was no point to develop any other type of software :D We just create a bunch of tools that do separate Excel functions ha-ha.

[@aznty5597]

10 :) Loved the video and how it's broken down into levels. Keep up the great work Kenji!

[@KenjiExplains]

Thank you! More to come, great excel skills you have though

[@aznty5597]

@@KenjiExplains honestly have been learning so much from your content. Keep it up! One of the if not the best channel out there :)

[@nickgenericusername]

Level 6: Finding out about Power Query felt like I blew open Excel's 4th wall and spilled out into a new world of potential

[@MrBrooksV]

Macros are extremely helpful - here’s another example of how it can be used: At my previous company we used an excel file to record our contractor hours for our 3-way match hour recording. We had a macro created to automatically update the work week day cells and an actual button you could click to trigger all of the previous week data to clear out. There was also a button to trigger the data to be emailed out to the contact at the contractors company, as well as our accounting team. It was extremely convenient. Macros are great tools to master!

[@KenjiExplains]

Thanks for the suggestion!

[@harigorantla3985]

Mr.Kenji let me know how can we freeze last row in excel....

[@philvuk]

Only the last one with MAcro I learnt so I'm happy to know I'm not too bad but to be honest it's because I follow your trick posts a lot ;)

[@KenjiExplains]

Great to hear!

[@vickyng1356]

Loved it

[@canoeron]

10/10. Nice video

[@KenjiExplains]

Damn nice!

[@Letslearntogetheruzh7]

9:11 11:01 12:17 Ag

[@ericbayer1001]

Could you upload a video just about macros/VBA? would be great :)!

[@KenjiExplains]

Noted! thanks for the suggestion

[@Diallo268]

I would say all those would be at most a 3. 4/5 would be better suited for power query, m functions, dax formulas, and power pivot.

[@Capris4EveR]

Know what Excell is about, used it for some project years ago and I was amazed by what it can do. Right now my Excell "skill" is below sea level 😅

[@dennisd5776]

If you are simply recording a macro, use the status bar and not the developer tab.

[@nohandlehandle274]

Level 3 was new to me I''ve used all the features in 1 2 4 & 5 Cool video 👍

[@Manishhkumar999]

Pretty easy I would say

[@JJ_TheGreat]

11:56 I would use Power Query - and split column by delimiter.

[@baqarhasan3495]

Hi there, is it possible to make a macro dynamic? For example I have weekly sales and stock which I extract in an excel sheet on a weekly basis and calculate weekly sell thru. I want to be able to do that next week for this week's data; next week. How do I record this?

[@resresres1]

don't think you need a macro for this, just use excel formulas in cell(s) to do the calculations. However, If you are extracting a new excel file every time, you can just have a master excel file that has all your formulas on sheet 1 and make a sheet 2 with your new extracted data. Personally, i've moved away from doing this kind of stuff in excel and create my own custom python programs with GUI's to extract data from excels and display results.

[@JJ_TheGreat]

What version of Excel do we need to access the "Data Types" feature? Thanks.

[@Chanda527-zn7pf]

Is the stock feature still available in excel?