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

https://www.youtube .com/watch?v=6gC8css__ng

Get Access to My Course “Fundamentals of Financial Analysis” HERE: https://courses.xelplus.com/p/financial-analysis 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