Excel Features You NEED to KNOW (If you work in Accounting)

Get Access to My Course "Fundamentals of Financial Analysis" HERE: www.xelplus.com/course/learn-...
Step up your accounting game with this comprehensive guide on the top 10 Excel features every accountant should master! From "Go To Special" to "Pivot Tables," this video is packed with invaluable tips to enhance your efficiency in Excel. Perfect for professionals and students alike!
Grab the file I used in the video from here 👉 pages.xelplus.com/features-ac...
In this video:
▪️ Go To Special: Quickly identify cells with specific characteristics.
▪️ Automatic Subtotals: Learn how Excel can add subtotals for you.
▪️ Number Formatting Shortcuts: Speed up your workflow with these handy shortcuts.
▪️ Formula Auditing: Easily track your formula dependencies.
▪️ Conditional Formatting: Visualize data effortlessly.
▪️ Remove Duplicates: Maintain accuracy in your datasets.
▪️ Flash Fill: Simplify data entry tasks.
▪️ AutoFilter: Filter your data with ease.
▪️ Data Validation: Ensure accuracy in data entry.
▪️ Pivot Tables: Analyze data efficiently and effectively.
00:00 Top Excel Features For Accountants
00:21 Quickly Identify Cells with Go To Special
01:56 Automatically Add Subtotals in Excel
03:45 Shortcuts for Number Formatting in Excel
04:53 Trace Precedents and Dependents in Excel Formulas
06:38 Use Conditional Formatting to Visualize Your Data in Excel
08:12 How to Remove Duplicates in Excel
09:01 Use Flash Fill to Automatically Fill in Values
10:08 Quickly Filter Your Data with AutoFilter in Excel
11:19 Create Drop Down Lists in Excel with Data Validation
13:15 Easily Analyze Your Accounting Data with Pivot Tables
15:59 Wrap Up
Top 10 Excel Functions for Accountants: • Excel for Accounting -...
Link to more accounting videos: • Unleash your inner Fin...
Complete article: www.xelplus.com/top-excel-fea...
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #excel #accounting

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/features-accountants-file

[@jiajiaphotography]

I am an accountant and use these functions all the time. But I still learned some short cuts I never knew. Thanks.

[@csullivan626]

Same. Ctrl+shift+L ... like that saves me 2 clicks x 10zillion... haha!

[@nijarulaslamkadarpackir8729]

I need dependent drop down list video

[@DS-nq5qf]

How much helpful these features for the commerce students for getting good salaried jobs? Do these really increase the skills and make the employer to pay you more?

[@denconstutube]

Excellent. I have used Excel for years. Now I know so many Excel features I have been missing. Thank you.

[@DoA121]

I'm glad I came across your channel. I have a language school and we have an accountant of course but I do the pre-accountancy by myself. You taught me a lot about Excel so thanks!

[@jaynefranzinoromero5877]

Leila teaches subjects SO well, you can learn anything when she is teaching. Thank you, Leila!!

[@gonzalofuste]

Dear Leila, I have discovered your channel and your courses and I am delighted. You are an incredible teacher, you explain everything in a clear, calm and pleasant way, the videos are excellently edited and you seem to me an incredible person. Please continue to share such interesting videos!

[@firmaevents9594]

I can't even explain how much i appreciate your hard work. You are such a great person. I have been watching you for 4 years. I can't sleep everyday without watching a random video for you. You are a master in excel. I respect your passion about providing free tutorials for all of us. Thank you alot

[@LeilaGharani]

Wow, thank you!

[@lijikumarbalan6038]

@@LeilaGharani Salute you dear Madam

[@dailylife8087]

@@LeilaGharani thanks preety lady

[@madhumitha_Raja1234]

@@LeilaGharani pls let me know about the first two images in thumbnail. Third one is pivot. Thanks in advance

[@johnphilippatos]

Wrong title. These functions are NOT just for accounting. They are life savers for almost every excel user. Thanks a ton! Stay Safe.

[@LeilaGharani]

You're welcome, John!

[@emkaramazanov2606]

Thanks for going back to basics! I needed a refresher on those short cut keys!

[@samquao2879]

You are a blessing. No ego, humility and pure class. If I were the Queen of England, I will make you a Dame for Services to Excel Users. Thank u for being there. Profound!

[@LeilaGharani]

Thank you! 😊

[@samuelkodjoe1645]

Very insightful. i love the way you explained tracing cell dependents & precedents. That was very clear!!!

[@mrCetus]

Another awesome video Leila!! I look forward every Thursday morning to your latest release and Always learn something new. I have been creating group change sub totals manually for years. Can’t wait to try it on my data. Thank you so much!!! Thank you for all that you do. It is Greatly APPRECIATED by so many!!! You ROCK!!!!

[@phungquyen3511]

This KZbin channel is almost too good to be true. Tons of great stuff in here. I've only watched a handful of videos and my productivity already skyrocketed.

[@cruzinsweetsntreats]

Yet she's a definite blessing for the rest of us as a good teacher. Should you need MS Access support, look for Richard Rost, as he's been at it since the early days (1990s). He's even going back through some of his early tutorials and redoing them, with today's standards.

[@IlaPatel811]

Love these helpful tips, Thanks Leila!

[@ahsantheanalyst7199]

People spend their free time stalking Instagram, but I enjoy watching Leila's Excel tutorials for fun. Trust me, my Excel skills have reached a whole new level thanks to the valuable knowledge I've gained from her. Every time Leila uploads a new tutorial, I learn something new from it.

[@NicksStuff]

Flash fill is incredible!

[@JohnAllanUK]

Another great video. Well done. I've been using pivots for years but still pleased to learn some new shortcuts

[@julionunez7370]

I knew and use 9/10. The subtotal is a great trick. Thanks Leila!

[@thiwankamadhawa]

Absolutely helpful!! Thanks a lot !😊👍

[@audiomemento]

Some very useful shortcuts here! Thank you!

[@IvanCortinas_ES]

Thank you for this tutorial. You are always at an excellent level Leila!

[@LeilaGharani]

Thank you so much, Iván!

[@wayneedmondson1065]

Awesome Leila! Great lesson. Thanks for sharing :)) Thumbs up!!

[@shamimhussain2925]

Thank you so much Leila! I didn't know about Flash Fill. I will definitely be using it.

[@LeilaGharani]

Glad to hear that!

[@martinekoja7504]

Leila, you are so good. Your teachings are always detailed and well explained

[@shahbazraza8605]

Such a great video! I always love to watch your videos! So helpful! 👍

[@litopalomeras7253]

Hello Leila, Thank you for sharing your expertise. It's a great help on us.

[@sweetrelax6849]

Excellent way to explain!!!! Great Work!!!

[@EXCELFOREVERYONE]

Thanks a lot Leila! I learn a lot from your lessons

[@katsophoto]

I was just looking for subtotal options! I’m in audit, and loving all the recent accounting related videos! Would appreciate to see more videos of text to excel conversion of standard ERP report (for instance, Oracle disbursement listing that comes in text format).

[@brianspiller9075]

I do not like the subtotals method. It modifies the data table and reduces flexibilty for other uses. I prefer to leave the data and build a Pivot Table providing the summary. The Pivot Table can be resorted, Filtered or changed in other ways to identify particular data points.

[@shadeburst]

@@brianspiller9075 I prefer to use SUMIFS because a) the data doesn't have to be sorted and b) the data and summary are all in one place.

[@TP014563]

While most of us know these, but also tend to forget about them when not in use. This video was a great refresh to anyone who uses excel in different manner other than accounting. Great video, always straight to point in a calm manner.

[@LeilaGharani]

Thanks 😁

[@turkeytwizzler1930]

Leila's videos are amazing, she is an absolute magician. I learn so much from them i'll be eternally grateful and i'm only an occasional user.

[@skd519]

Hi Leila I first time see your Video Thanks for being Share / Serve to people of your life Experiences, you are really have good technique to work.

[@westernugmedia.1305]

My dear lecturer! May God add u more years on this earth. I wish my siblings also have a look at you live. #Uganda

[@hmassarelli6859]

Thank you, Leila! You are the best.

[@md.mojahidulislam4884]

Great tutorial! Thanks Leila

[@jolly110383]

Leila, your videos are extremely resourceful, THANK YOU for sharing your knowledge :)

[@anagageanu7275]

Very helpful, Leila! Thank you very much for sharing this with us.

[@LeilaGharani]

You're so welcome, Ana!

[@colormile-vid8888]

As always, you put out videos that are useful in everyday tasks and make it fun and easier to accomplish. ❤

[@LeilaGharani]

Happy to hear that!

[@frankayala3950]

At work and just tried ( Ctrl,Shift ,L ) group by color, wow made things smoother! Thank you!

[@daminikoshti6683]

Hi, the learning videos are great, thank you ! Although I felt that I want to practice at the same time while watching the video, it would be nice if you could leave us a practice spreadsheet to use.

[@bubblypompom]

Super helpful . Thank you.

[@denismccarthy1]

Great clear videos, other suggestions Getting average weighted values in a sheet total and in a pivot formula Changing pivot to classic view, don't like new format Special view for selecting blanks, handy when you need it What if option Forecast option

[@chinyereezeigbo5837]

This is great! Thanks for the info. Much appreciated

[@md.ashekelahiexecutiveinte92]

so much helpful Ms. Leila ...Thanks and good day

[@SyedMuzammilMahasanShahi]

This is really helpful. Thanks for the share.

[@ericleung1520]

Thanks a lot. I didn't realize how much time I lost and how much frustration I got which is totally avoidable during all these years until I watch your video.

[@thumahet173]

Thank you so much to show short cut. I really like all your method

[@bbjanetsai]

Your channel is literally a life changer, no kidding! I’m in awe with the fact that I always learn something new from “every” tutorial of yours.

[@chh8860]

For a few years now, "Thursdays w/Leila" is calendar 'must-watch' appointment for me... it is the VERY first thing I do in the morning. But when I saw this mornings title, I disappointingly thought "... eh ... 🥱 ... probably not for me ..." and went on to deal with other pressing items. Once they were done, and because I am big fan, I half heartedly returned to watch today's video ... and within the FIRST minute found myself thinking " oh ... interesting ... I did not know that ... " ... and then repeated that same comment for the next 15 minutes. So ... I was wrong (again) to doubt Professor Leila ... mea culpa ... but I can make amends and with the recently expanded coverage, happily I do get to "see each other" more often ... which is a good thing ... a very good thing.

[@LeilaGharani]

I'm happy you decided to give the video a chance. I'm always looking forward to your feedback!

[@vickidash-slesinski746]

I work at a large firm in the consulting team implementing ERP solutions. At our weekly team meeting I have been sharing your videos.

[@rabeimahmoud9234]

Great work, thank you.

[@samantharezek4495]

Very helpful like always!!

[@salah-deansharata9059]

You are the solution of my working life. Many thanks

[@taizoondean689]

Thank you for all your help 👍👍

[@grassyhillsegw8244]

Very refreshing.

[@charlsmv]

I have to thank you for all those advice and videos, you got another subscriber

[@LuzFraterno]

Very Useful! Thanks for doing this video!

[@LeilaGharani]

Glad it was helpful!

[@sydulislam7995]

Really helpful, I'm your fan. Thanks

[@nazarkarim6473]

Thanks Leila. It was really helpful :)

[@DreamFirms]

Helpful tips Leila!

[@khandakermominur2649]

Very helpful. Carry on.Thanks

[@SasiKumar-ey7bd]

Really help for me thank you ♡

[@profha2]

Great video. I'm a CPA and these are all features that I use

[@shuttleking]

Indeed useful. Thank you

[@chrism9037]

Great video Leila!

[@ljanealburo8365]

oh my gosh you're so helpful thank you so much.

[@richarddasilva719]

Great i love your videos and learn so much as a beginner

[@jamshedrabadi807]

Excellent tutorial

[@XLcollegeUg]

Awesome explanations, thanks a lot.

[@LeilaGharani]

You are welcome!

[@markseguin2544]

These are such great tips. Thank you

[@LeilaGharani]

Glad you like them, Mark!

[@rishveersinghragoomundun9499]

Thank you very helpful

[@firandsaleh4195]

Huge thanks, Flash Fill is awesome !. I used to use Text to columns

[@LeilaGharani]

It really is! But Text to columns is also great :)

[@snickrologen]

I really like these small KZbin bursts of knowledge!

[@LeilaGharani]

Thank you 😊

[@markpodesta4605]

Thank you for the tips Leila.

[@LeilaGharani]

You're so welcome, Mark!

[@vijayarjunwadkar]

Loving this series with focus on specific features based on role! It is helping both in knowing the features in general as well as applied to particular need. Thank you Leila! Keep up the great work! 😊👍

[@LeilaGharani]

Great to hear! Especially coming from you Vijay.

[@meldalestari6]

Leila thanks a lot. Im an accountant and these kind of shortcut really helpful for me. So many thanks❤️

[@LeilaGharani]

You're most welcome 😊

[@lanfofana1973]

You are doing a great Job Laila. Keep inspiring us. Thanks.

[@LeilaGharani]

Thank you, I will do my best :)

[@subashsedhai8782]

Another great vedio, thanks

[@excelmastervba]

Very good Video. Everyone who uses Excel should try to automate and as well use shortcuts as much as possible 😃

[@lucasgrangeiro4225]

Thank you very much!!!

[@diegoc.s.8286]

Fast Fill. Today I learned something new. Thanks!

[@shashwatmishra3023]

Outstanding.. 🔥👍

[@katherinebernadas3862]

waa thanks again for a very useful video! I love it!

[@LeilaGharani]

Thanks, Katherine!

[@viddy1983]

Really appreciate your videos. I learn a lot from these informative sessions. Can you please make a short lesson on techno economics in excel. Thanks

[@olaaborode7896]

Great work, keep it up......

[@mustafahaider4329]

I don't know if I can recall or not when time to apply but your teaching style is good and motivational to learn again n again :-)

[@derranstokes8760]

Thank you Leila a very informative video once again

[@LeilaGharani]

You’re welcome 😊

[@mohamedadjal8502]

Hi, Professor, you have provide in a lot of effort for these videos, thank you, I have a question if we have for example in cell "a1" the number 10.00 m, how to have this number with the same format in cell "b1 "using the text function or some other function, thank you very much.😃👍

[@ziaglos]

Awesome Leila...

[@eKram-iz9tt]

Excellent

[@c.raghavendrakiran2797]

Mam, you are done great job. 🙏

[@ezekielagboola7405]

Thanks a lot Leila

[@robertosfsouza2043]

Cheers Leila! Great video.... please make a video features in excel for engineers! Please!💪🙏🙏

[@davebacalso9163]

thank you very much

[@saratkong6649]

Amazing...!

[@teoxengineer]

◘ Grouping instead of hiding columns or rows. (Shft+Alt+ → or ←) ◘ Special sorting (hidden property, nobody knows ►) ◘ Name Manager (My favorite, Excel heart ♥) ◘ And What-If analysis (Scenario manager+Goal Seek and data table) ◘ Tables ....☺ (I'm still trying to understand its amazing features) Good presentation. Thank you 👍

[@LeilaGharani]

Thanks for your tips, Emre!

[@WaymakerExcel]

I love teaching Excel. I Love the way you do it Leila, I follow all your videos. I hope one day, my channel will just have as much as half number of subscribers as yours. I LOVE YOU LEILA.

[@m.arsalanbabar3303]

very useful

[@rrrraaaacccc80]

Great Leila 👍

[@aksinghrtsingh1082]

Very nice video......

[@selvamsubbiah5535]

Very nicely explained

[@LeilaGharani]

Thanks for watching :)

[@hichamidahmedali6622]

woow astonishing thanks