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

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

In this video we’ll cover the top Excel Features that you should know if you work in accounting. They’ll make your work life a LOT easier and they work in most Excel versions. All are great for accountants, auditors, data analysts and anyone else who’d like to use Excel more efficiently.
If you have a small business and you are busy with bookkeeping for your small business, this tutorial will help you. Some of these great features include Go To Special in Excel. With Go to Special you can quickly find cells of specific type. For example blank cells. Or cells with formulas or constants. You’ll also learn how to automatically add subtotals by using the Group option in Excel to add groupings and levels to your data. I also include number formatting shortcuts in Excel, like shortcut for date format, currency and more. You’ll learn how to remove duplicates in your data and use conditional formatting on your data. We’ll create drop-down lists with data validation and you’ll learn how to create and use Pivot Tables to analyze your data. Lots to cover. The timestamps are below.

Timestamps:
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: https://youtu.be/m_SH0TOLsIc

Link to more accounting videos: https://www.youtube.com/playlist?list=PLmHVyfmcRKywV8Bk6euT02xxtv8YVDkZs

Complete article: https://www.xelplus.com/top-excel-features-for-accountants

β˜… My Online Excel Courses β–Ί https://www.xelplus.com/courses/

βœ‰ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

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

Leave a Reply

Close Menu