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

[@LeilaGharani]

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

[@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!

[@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?

[@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

[@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.

[@jaynefranzinoromero5877]

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

[@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.

[@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! 😊

[@NicksStuff]

Flash fill is incredible!

[@VDash-Slesinski]

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

[@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!

[@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!

[@denconstutube]

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

[@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.

[@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 😁

[@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!

[@frankayala3950]

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

[@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

[@DogaF121]

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!

[@julionunez7370]

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

[@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.

[@martinekoja7504]

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

[@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.

[@daminipunnen]

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.

[@excelmastervba]

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

[@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.

[@maximvanmelckebeke7925]

thanks, got a job at an accounting firm and never bothered to learn excel while in college. Got a month to learn it.

[@profha2]

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

[@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

[@shamimhussain2925]

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

[@LeilaGharani]

Glad to hear that!

[@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.

[@samuelkodjoe1645]

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

[@salah-deansharata9059]

You are the solution of my working life. Many thanks

[@jayholm9504]

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!!!!

[@LeilaGharani]

Great! Thank you, Jay!

[@emkaramazanov2606]

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

[@thumahet173]

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

[@snickrologen]

I really like these small KZbin bursts of knowledge!

[@LeilaGharani]

Thank you 😊

[@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 :-)

[@nasirhussain780]

Respect for you from Pakistan. I am a huge fan of you, and got maximum knowledge from your videos of Excel and Power BI. and often surprise my seniors with new graphical techniques learned from your channel time to time. Just want to add one thing, "once the data is in Table Format, this subtotal function cannot be utilized. after applying the subtotals, the data can be converted to Table of if the data is in Table Format, convert the data into range first and then apply subtotal function.". stay blessed and please keep it up 🙂

[@LeilaGharani]

Thanks for your feedback, Nasir!

[@litopalomeras7253]

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

[@atsrikumar1307]

Explanation is more professional, one can easily understand. Hats off to your efforts. You are one of the Best Instructor for Microsoft Excel, VBA, Power Query etc.,

[@LeilaGharani]

Wow, thank you!

[@md.ashekelahiexecutiveinte92]

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

[@thebeautifulanimal]

Not an accountant but love the teaching 🙏

[@LeilaGharani]

Glad you're enjoying it!

[@IvanCortinas_ES]

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

[@LeilaGharani]

Thank you so much, Iván!

[@mcd22630]

I think there was more useful material covered in this video than what is presented in a masters accounting class. Also Ms Gharani's wardrobe and coffee mug were on point.

[@LeilaGharani]

Thank you very much for noticing 😊

[@diegoc.s.8286]

Fast Fill. Today I learned something new. Thanks!

[@charlsmv]

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

[@lanfofana1973]

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

[@LeilaGharani]

Thank you, I will do my best :)

[@deirdrefitzgerald7577]

I learn so much with every video, Leila. Can you do a video about Excel versions -- what version you are currently using, what version is widely used, what version we should request our IT department consider upgrading to, etc. I realized I don't have Xlookup and I started wondering what else I can't do. What happens if a client sends along an xls with an Xlookup function that I can't read? Thanks

[@LeilaGharani]

I'm glad you find the videos useful. The version I use is Excel for Office 365. That's the version that has XLOOKUP and all of the newest features. It's the version every company should be using.

[@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!

[@JohnAllanUK]

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

[@jebablessysalomi3451]

Please tell me how did you start studying accountant. How you improved yourself? What are the struggle you faced? Btw your English is awesome

[@LeilaGharani]

I studied Economics so I had some accounting in University. I also worked in the Finance department for many years....

[@jebablessysalomi3451]

@@LeilaGharani omg you must be genius

[@csullivan626]

@@LeilaGharani me to - undergrad in Econ and ended up working with the enemies.. the accountants... who don’t understand costs at alll!!!! Lol

[@taizoondean689]

Thank you for all your help 👍👍

[@grassyhillsegw8244]

Very refreshing.

[@venusliquit8048]

Thanks Leila, you made my life easier as Accountant😏

[@LeilaGharani]

Happy to help!

[@muhammadrizwanmatloob3723]

Excel legend teacher of this era

[@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 :)

[@richarddasilva719]

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

[@EXCELFOREVERYONE]

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

[@sydulislam7995]

Really helpful, I'm your fan. Thanks

[@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 😊

[@ivanbork4175]

You cover a lot and you do it very well. So it ‘small things, and not really fair to mention, but one option under ”Go to Special” that’s useful is Blanks, that is if you want to fill with the info in i.e. the cell above, all there is to do is typing an equal sign = and make reference to the cell above, and the list will complete without blanks. But be aware that there now are formulas in the range, and it might be best to turn them into constants. And in using the Pivot table, it can be useful to set a checkmark in the lower-left corner “Add this data to the Data Model” doing that you get the opportunity to Count distinct.

[@LeilaGharani]

I like these tips! Thank you. I use the first one quite often. Adding to the data model is also great!

[@keishrich]

I'm an accountant and these are top features that will help make your everyday work more efficient and effective.

[@LeilaGharani]

Wonderful! Thanks for your support.

[@wayneedmondson1065]

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

[@Ulson603]

Extremely useful! Makes my life easier. Auto Fill Ctrl + Shift + L did not work for me 🤔 I do Alt + A + T

[@nazarkarim6473]

Thanks Leila. It was really helpful :)

[@ljanealburo8365]

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

[@anagageanu7275]

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

[@LeilaGharani]

You're so welcome, Ana!

[@jolly110383]

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

[@isfas9073]

Very informative video and If you work in accounting and really love excel advance features, you see also ISFAS accounting. It's like an spreadsheet for its journals but it automates the ledgers up to the trial balance and fs. You can add subsidiaries to all accounts from assets to expenses including contra and adjunct accounts. It's easy and fun.

[@anthonysais2580]

I didn't know you can select a whole list first before using data validation, instead of having to type in each entry. Das war sehr hilfreich!

[@Rajiv4U]

Very helpful video... Not just for biggners but for pros too...

[@LeilaGharani]

Glad you think so!

[@andysmith5997]

Omg, and I never say that. This is like 10 excel features you need if you’re Andy Smith. Please live with me.

[@ziaglos]

Awesome Leila...

[@scotolivera8207]

Very interesting video although i am familiar with all the features mentioned but it is very useful and I hope you continue with this series by adding more unknowns tricks. Thanks

[@scotolivera8207]

Some ideas, financial reporting standards and professional statements design

[@sathyanarayanansatagopan9069]

Thanks a lot. Please explain date wise debit and credit total in two columns and balance in next line, just like in tally cash book.

[@BlondeQtie]

Flash Fill is SO useful! I sometimes have long lists of addresses and people but the street name and the house number in one cell instead of two -_- It took forever to do it manually!

[@LeilaGharani]

Then Flash Fill will soon be your best friend :)

[@knifecutfilm5543]

The only annoyance with conditional formatting is when someone paste data (without value) then it kind of screws the conditional formatting. Or when someone copy data from above cell and paste it below without value, it creates additional conditional formatting.

[@thiwankamadhawa]

Absolutely helpful!! Thanks a lot !😊👍

[@sweetrelax6849]

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

[@IlaPatel811]

Love these helpful tips, Thanks Leila!

[@nashidmadathilkandypara9160]

Great 👍 Subtotal is amazing

[@bsafridi]

Not an account, but you are really a good teacher.. Haha already thinking of learning this thing 😂

[@umanggupta6207]

Hi In the function remove duplicates how can we see the duplicates that has been removed & their values?

[@patsmith9159]

I need to create a formula for the following scenario. I have 2 columns for each month of the year (24 columns), one is "Actuals" and the other is "Forecast". Let's say I just closed the books for April, I need a formula in the 25th column that adds up the "Actual" values for January through April and the "Forecast" values for May through December which would give me a Total Year Forecast.

[@oliverscheurich9202]

=SUM(ISODD(COLUMN(A:X))*A3:X3)+SUM(ISEVEN(COLUMN(A:X))*A3:X3) You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365. Values are in range A3:X3 and "Actuals" are in columns A, C, E and "Forecast" are in columns B, D, F and so on.

[@adityapatnaik6079]

BEST CHANNEL ON YT !

[@eKram-iz9tt]

Excellent

[@arfanrasheed9941]

Great job Leila you are doing 💐💐💐, would you please give some examples to use excel in education, I have data to deal with but unable to apply power query... Waiting for your reply. Thanks

[@shahbazraza8605]

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

[@bamasmasood]

Dear Leila, Your videos helped me alot. Could you please make a video on how to prepare a dynamic prepaid expenses schedules, considering that there are additions each month and the amount should be calculated on number of days in a particular month.

[@bestscenes1469]

Use tables. Its very easy and it dynamic ranges

[@audiomemento]

Some very useful shortcuts here! Thank you!

[@SeanGHOB]

If you are using an English (Irl) keyboard layout, the shortcut for date format is Ctrl+# not Ctrl+Shift+#

[@kye3k1]

I flinched when she said pound. It's a hash isn't it? £ = pound # = hash Hash like hashtag

[@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.

[@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.😃👍

[@frankayala3950]

🤔😳🤯❤,as a full charge bookkeeper , these functions on Excel will definitely come in handy... thank you for sharing your knowledge, it'll empower for sure. I just read somewhere down in the comments you have courses, how do I direct myself to your courses ? I'd like to check out your courses.

[@LeilaGharani]

My pleasure, Frank. You can check out my courses here: www.xelplus.com/

[@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

[@cruzinsweetsntreats]

In my sleepy mode, I managed to add an object that was disliked by Excel mobile, and showed a bar that looked like a border line. Yet with traditional trial and error, it wasn't going away. Thus coming across "Special Search", allowed me to find it, and delete it, though for each individual page, as my data entry for deliveries is set for up to 31 days per workbook, for each calendar month. I also had to backtrack to my base template, and do the same thing, for future months.

[@paulboot4329]

Tip #3, format as numbers, you can also use alt+h+k

[@SEAwab]

Hmm, flash fill... didn't know you could do that. I always used something like "left" or "right" formula's in combination with ifs... Thnx!

[@m.arsalanbabar3303]

very useful

[@chinyereezeigbo5837]

This is great! Thanks for the info. Much appreciated

[@jordanchang1]

Interesting, I often used shortcut as well, but different to yours. I use alt then the subsequent hotkeys to reach the menu bar.