👉 Learn Excel for Business & Finance: www.careerprinciples.com/courses/excel-for-business-finance
@lihelen898211 ай бұрын
Hello, Are the online courses live teaching? Or jus courses we go through on our own?
@stephentodd40932 жыл бұрын
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!
@MarvelTanudjaja2 жыл бұрын
Learned more in 15 minutes than a semester finance course :) Well done Kenji!!
@KenjiExplains2 жыл бұрын
hahahaha
@COURSSTATSCHAMBERY2 жыл бұрын
request reimbursement from your university :-)
@noone-td8rc2 жыл бұрын
Thanks man
@drewwalters73922 жыл бұрын
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.
@improvemyself2562 жыл бұрын
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.
@VickiMcCorkle8 ай бұрын
You by far have the best tutorial videos. Thank you for providing so many helpful videos.
@hotflashfoto2 жыл бұрын
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.
@issamelsayd2 жыл бұрын
Thanks for your input
@TheStoicWay1102 ай бұрын
After watching this video Now i am working in Excel like a Pro ,,,, Thank U So Much
@Micfri1232 жыл бұрын
I work in finance and am always trying to learn more excel tips- big thanks as usual. I knew about half of these.
@KenjiExplains2 жыл бұрын
Great to hear!
@easwarshankaran44262 жыл бұрын
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 :)
@Cfckkr2 жыл бұрын
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!
@KenjiExplains2 жыл бұрын
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.
@shankarnanu13232 жыл бұрын
Became fan of u after watching this video. Such an amazing way to understand within minutes for the lifetime ..
@KenjiExplains2 жыл бұрын
thank you!
@5uysal7 ай бұрын
You have such great way of explaining things! Love these short videos thanks!
@gabgab79352 жыл бұрын
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
@KenjiExplains2 жыл бұрын
Thank you!
@MrRvds2 жыл бұрын
Data Validation and CTRL + E were the new ones for me. Thank you
@SabesanVaidhyanathan6 ай бұрын
Excellent explanation and so easy to understand and follow ther Excel tips and tricks here, great job Kenji !!! THANKS A LOT !
@Kazaaaaaak2 жыл бұрын
I knew 9 out of 10. However, I am very pleased to learn about flash fill. So thank you 🙂
@nonoobott86022 жыл бұрын
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
@KenjiExplains2 жыл бұрын
Thank you!!!
@lilgirllilgirl7352 жыл бұрын
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
@ahmedosama52052 жыл бұрын
Got 10/10 , Very Helpful video tho , Thanks for the amazing content
@KenjiExplains2 жыл бұрын
Damn you’re good! Thanks man 👍
@chrisalynbajaro83462 жыл бұрын
This really help me a lot, since I don't have a computer subject.
@KenjiExplains2 жыл бұрын
Awesome to hear!
@JeremiahCarter2 жыл бұрын
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!
@alicenexon13812 жыл бұрын
the tone and control of ur voice says "I know my sNice tutorialt!". Good stuff buddy.
@harshilnagda73212 жыл бұрын
Insightful. thank you Kenji for providing us with best possible excel content.
@KenjiExplains2 жыл бұрын
Thank you for the nice comment! 🙌
@mty50m12 жыл бұрын
Thank you for all of this, it was helpful Can you do free course of excel in this great channel?
@shahidimran50165 ай бұрын
Perfect way of teaching
@saurabhshukla2622 Жыл бұрын
Amazing excel trick taught by you thank you so much
@camlex63102 жыл бұрын
Got 8/10...learning a lot from your videos!
@KenjiExplains2 жыл бұрын
Wow you’re good!
@saeer50382 жыл бұрын
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
@HealthSmarter2 ай бұрын
Well explained. Keep it up.
@mohdward95052 жыл бұрын
This was sooooooooo useful, pretty, elegant & smart. Thank you so much
@KenjiExplains2 жыл бұрын
Thanks for the awesome comment!
@VERTICALcube2 жыл бұрын
It's worth subscribing to your channel. I learn a lot... 🙏
@KenjiExplains2 жыл бұрын
Welcome aboard!
@positive-affirmation-4-suc7272 жыл бұрын
Thank you so much - Very useful tips
@NisfiStatic2 жыл бұрын
Your video boosted my confidence. Never knew I am an expert 😂
@RA-rh5lb2 жыл бұрын
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
@bobtucker90822 жыл бұрын
Great tips, learnt many new things
@danielsmart24642 жыл бұрын
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
@KenjiExplains2 жыл бұрын
Hey Daniel thank you for the support, especially in the early days means a lot!!! Take care :)
@rishavtoshniwal62484 ай бұрын
I knew all of them, was expecting more advance things, sir.
@willzinner88132 жыл бұрын
Didn't realize macros were a thing. Seems quite easy as well thank you sir. Got 7/10
@KenjiExplains2 жыл бұрын
Yes sir!
@thulaniralo92972 жыл бұрын
Level 4 Awesome. Great stuff😁😁😁😁
@mkg12532 жыл бұрын
Have to include the camera add on surely, great for model work
@MuslimIslam012 жыл бұрын
Amazing knowledge and skills
@VickiMcCorkle8 ай бұрын
Great tutorials.
@shenay93772 жыл бұрын
Very helpful. Thanks
@markyzentana75402 жыл бұрын
Very helpful. Thanks man, looking forward for more tutorials.
@KenjiExplains2 жыл бұрын
Thank you! More to come :)
@lolliMAN1012 жыл бұрын
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!
@KenjiExplains2 жыл бұрын
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.
@Biniyam38322 жыл бұрын
I know 7 out of like 9 questions, thanks for your excel tips and tricks
@varunmittal51962 жыл бұрын
Just blown away.. 🔥❤️
@flourishwithMJ10 ай бұрын
Thank you so much. Amazing.❤
@andymarci67662 жыл бұрын
Super nice Kenji, thanks!
@KenjiExplains2 жыл бұрын
Cheers!
@shandhirani75592 жыл бұрын
Brilliant Thank you
@jeandonaldgeorges77832 жыл бұрын
Very insightful. I love your videos. Thanks for th great content.
@KenjiExplains2 жыл бұрын
I appreciate that!
@bingchilling45732 жыл бұрын
Thanks for the tips!
@KenjiExplains2 жыл бұрын
Thanks for watching!
@abdulrahmankhan51392 жыл бұрын
Great excel tips, thanks for sharing.
@KenjiExplains2 жыл бұрын
Glad you enjoyed it!
@BostonRoger2 жыл бұрын
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.
@KenjiExplains2 жыл бұрын
Intersting! Thanks for letting me know
@donnaassenza30252 жыл бұрын
Trend lines 👍🏻👍🏻👍🏻👍🏻👍🏻 thank you
@allsaka2 жыл бұрын
It's the best thing i've ever seen!
@skoombayil2 жыл бұрын
10/10… But Great Refreshing Video
@KenjiExplains2 жыл бұрын
Glad you enjoyed it!
@andreugiro28072 жыл бұрын
Great tips my friend! Keep going!
@KenjiExplains2 жыл бұрын
Thanks so much!
@shydidja692 жыл бұрын
7/10.I definitely need to learn macro, every single time I delay my learning process 🤦🏾♀️
@aznty55972 жыл бұрын
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
@KenjiExplains2 жыл бұрын
Yupp very useful!
@ThatdudeJaden2 жыл бұрын
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-arango5992 жыл бұрын
Really helpful, appreciate it!! 👍
@KenjiExplains2 жыл бұрын
Glad it helped!
@emadr57802 жыл бұрын
Thank you very much. Could you please make a video about industry research and how we should do it in excel?
@KenjiExplains2 жыл бұрын
Thanks for the suggestion I'll note it!
@emadr57802 жыл бұрын
@@KenjiExplains Realmente lo aprecio :)
@lesliem62082 жыл бұрын
Thank you this was great!
@KenjiExplains2 жыл бұрын
Glad it was helpful!
@emilehouvenaghel52992 жыл бұрын
Great video, always appreciate your content!
@KenjiExplains2 жыл бұрын
Thank you Emile
@goaboi2 жыл бұрын
learning a lot from your videos!
@KenjiExplains2 жыл бұрын
Awesome, thank you!
@luizcristianofs2 жыл бұрын
I've watched of your videos and liked a lot. good job doing it.
@KenjiExplains2 жыл бұрын
Glad you like them!
@michaelquach70462 жыл бұрын
Love the level rankings in this video!
@KenjiExplains2 жыл бұрын
Cheers Michael!
@YogeshSharma-ui7xx6 ай бұрын
Nice one.Appreciatee
@kristynakrunclova5684 Жыл бұрын
10/10, great video!:)
@huytran66053 ай бұрын
so useful for me
@ahmednooor2 жыл бұрын
9/10. Thanks any ways. Cool to learn about Macro today.
@KenjiExplains2 жыл бұрын
Awesome thank you for the comment!
@reelzerotuned36752 жыл бұрын
Nice content as always. 👍🏻
@KenjiExplains2 жыл бұрын
Glad you think so!
@vatsal7152 жыл бұрын
These all were in dictionary way back. 10/10 easy peasy :P
@Metalblowing2 жыл бұрын
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.
@aznty55972 жыл бұрын
10 :) Loved the video and how it's broken down into levels. Keep up the great work Kenji!
@KenjiExplains2 жыл бұрын
Thank you! More to come, great excel skills you have though
@aznty55972 жыл бұрын
@@KenjiExplains honestly have been learning so much from your content. Keep it up! One of the if not the best channel out there :)
@nickgenericusername2 жыл бұрын
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
@MrBrooksV2 жыл бұрын
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!
@KenjiExplains2 жыл бұрын
Thanks for the suggestion!
@harigorantla39852 жыл бұрын
Mr.Kenji let me know how can we freeze last row in excel....
@philvuk2 жыл бұрын
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 ;)
@KenjiExplains2 жыл бұрын
Great to hear!
@vickyng13562 жыл бұрын
Loved it
@canoeron2 жыл бұрын
10/10. Nice video
@KenjiExplains2 жыл бұрын
Damn nice!
@Letslearntogetheruzh72 ай бұрын
9:11 11:01 12:17 Ag
@ericbayer10012 жыл бұрын
Could you upload a video just about macros/VBA? would be great :)!
@KenjiExplains2 жыл бұрын
Noted! thanks for the suggestion
@Diallo2682 жыл бұрын
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.
@Capris4EveR2 жыл бұрын
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.
@nohandlehandle2742 жыл бұрын
Level 3 was new to me I''ve used all the features in 1 2 4 & 5 Cool video 👍
@Manishhkumar9992 жыл бұрын
Pretty easy I would say
@JJ_TheGreat2 жыл бұрын
11:56 I would use Power Query - and split column by delimiter.
@baqarhasan34952 жыл бұрын
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?
@resresres12 жыл бұрын
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_TheGreat2 жыл бұрын
What version of Excel do we need to access the "Data Types" feature? Thanks.