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
#excel #developer
