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

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!

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

🚩Let’s connect on social:

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

[johnphilippatos]

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

[jiajiaphotography]

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

[firmaevents]

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

[samquao]

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!

[jaynefranzinoromero]

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

[ahsantheanalyst]

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.

[chh]

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.

[phungquyen]

This YouTube 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.

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

[denconstutube]

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

[TP]

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.

[frankayala]

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

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

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

[ericleung]

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.

[julionunez]

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

[nasirhussain]

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 🙂

[DogaF]

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!

[salah-deansharata]

You are the solution of my working life. Many thanks

[martinekoja]

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