Top 10 Excel Tricks You Probably Didn't Know
Learn 10 less known excel tricks in 10 minutes.
🚀 Learn Excel here: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/634959...
In this video you'll learn 10 less known excel tricks from most common at level 1 all the way to top secret at level 5.
In Level 1 we go over filter by cell value and moving rows and columns by simply holding the shift key and dragging.
In Level 2 we learn to make synchronised changed across sheets and creating new windows to compare sheets.
In Level 3 we learn to import data from the internet and learn the excel data types feature.
In Level 4 we learn sparklines and how to save a pre-designed chart as a template.
In Level 5 we learn to format numbers in thousands or millions as is often the case in accountinng and finance. Lastly, we use trace precedents to see how formulas are being linked.
LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Leve 1
1:41 - Level 2
3:13 - Level 3
5:00 - Level 4
7:30 - Level 5
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Пікірлер: 77
🚀 Learn Excel here: www.careerprinciples.com/courses/excel-for-business-finance 📚 See all our courses here: www.careerprinciples.com/courses
@simowafula-vu7gm
Жыл бұрын
am need of this
I am in statistics and data analysis classes now. These videos will help a lot. May the Force be with you, Master of Excel.
I learned more from watching 3 of your videos than I did from taking an Excel class + Book. Seriously thank you. Subscribed!
@nomatusi7514
Жыл бұрын
I went to the library and got excel books. Read for one day and then discovered youtube has very good tutorial. I took back the books to the library.
Your videos are a treasure trove. Thanks for all of the great info!
Thank you Kenji. I can start using that chart template trick immediately, and I hope it will save me a lot of time.
thanks man! you have put lot of work for this. I love how you teach
Lot of guidance and information from you, thanks for sharing Sir !
Short, crisp and clean video...liked it
Your teaching skills are better than others, It helps to improve excel skills GREATE WORK👍
Nice tricks for everyone, they are a must know! Cheers!
Always nice to find these kind of videos. Every time I learn something new
Thank you. These tips were very helpful. Cheers 👍😎🇦🇺
I improved a lot my excel skills! Thanks kenji!!
@KenjiExplains
Жыл бұрын
Great to hear!
Thank you Kenji It was very helpful
Thanks for all of the great info 🙏👍
Another great vid.....love your channel
You are doing phenomenal job keep posting videos
I just learn the best tricks👍🥰 tks dude
Very useful, Thank you
These Tricks are just awesome......thank you sooo much this lesson.
@KenjiExplains
Жыл бұрын
Thanks for watching!
wow I didnt know you could do that... thanks kenji for the great video ONCE AGAIN
@KenjiExplains
Жыл бұрын
Happy to help!
thank you Kenji for this great video.
@KenjiExplains
Жыл бұрын
Glad you enjoyed it!
thanks for making knowledgeable videos ! i'm planning on taking the cfa level 1 exam in november of 23 any tips ?
Really insightful!!
@KenjiExplains
Жыл бұрын
Cheers!
Helpful tricks
Definitely saving this video
@KenjiExplains
Жыл бұрын
Let's go!
@Goddibaba
Жыл бұрын
Happy for you, bro.
Oh no, that data type info is just brilliant, I'm always having to lookup animal classifications, now if only it would tell me the correct order.
Love your show
Great 👍
Thanks Kenji. Can you please provide a link to download the excel file? I can only see a link to courses
Informative thanks
@KenjiExplains
Жыл бұрын
Glad it was helpful!
Thank you!
@KenjiExplains
Жыл бұрын
You're welcome!
thank you Kenji 🥰🥰
@KenjiExplains
Жыл бұрын
Thanks for watching Oscar!
Thank you Kenji
@KenjiExplains
Жыл бұрын
You got it!
You never disappoint
@KenjiExplains
Жыл бұрын
Thanks for watching Chebo!
Glad I subscribe.
@KenjiExplains
Жыл бұрын
Lets go!
Thanks
Top tier
Which version of Office supports moving of columns to the left or right ? I have tried to execute the tip to move the column but instead it is asking do you want replace the selected column content on another column.
El mago de Excel!
Hey can you share some tips to connect to one folder where you have 10 excel file . I want to connect to the folder so that all the data automatically gets connected to the master Excel and in different sheets. Like 10 workbooks in a folder to merge with 1 excel as 10 sheets. I tried to get data from a folder but it does not work
Spark lines tip is awesome
@KenjiExplains
Жыл бұрын
It really is!
an even more faster way to filter by selected cells value is to - Add Autofilter to your quick access toolbar and you'll be able to filter with just one click :)
question: would you say that it is best to have a pc or macbook in finance. Something that works in a company in person or remote or as an independent contractor.
@stan9011
10 ай бұрын
PC
good video, but I didn't see the "geography", can you explain?Thanks.
Hi to reconcile quickly. How to find out if the reference ID and amount not matching?
can you make one on unknown formulas?
@KenjiExplains
Жыл бұрын
Noted thank you :)
How to remove the old columns which contain the unformatted data? Deleting them does not work as it shows #REF! in the formatted columns.
When trying to put a url in and load the data, I tried it with a 50 states url and excell didn’t load anything is there any specifications I’m missing
@Kenji Explains please can I get a way to reach you personally
How do I paste values only from clipboard?
How to colum A1, 01 automatic 01 Bottle and 02 Bottles Come written yah condition formatting and format cell In excel please help me
ok got it
You should have started that you need to make your data into a table
Wealth and riches are measured by the amount of investments a person has, that's why I invest all the time.
MY EXCEL does not have data type , so i can not choose geography option, why is that so?
Hi
The philosophy of the rich and the poor is this:the rich invest their money and spend what is left. The poor spend their money and invest what is left.
🗿