Excel Essentials for Staff Accountants - Part 6
Excel is ubiquitous in the accounting and financial professionals’ workplace, but some of the best functions and features for accounting and financial professionals are unknown or underutilized. Leverage Tables, shortcuts, and best practices to increase efficiency. Master the functions such as VLOOKUP, INDEX & MATCH, Dynamic Array Formulas. As well as Formulas and uses such as Depreciation, Amortization, Interest, Payment, and more. In this course, we will even take you deeper into statistical analysis with formulas for everything from median, most, and standard deviation and regression analysis.
Are you a CPA?? Are you a Financial Professional?? Earn CPE Credits for Today's Podcast. Check out https://cpe.cx/EESA6/. Take a quick 5 question quiz and get your certificate today. Super Easy!
Presented by Stephen M. Yoss, CPA, MS (https://yoss.io)
Produced by Alicia Yoss & Alanna Regalbuto
Graphics By Flaticon.com and iStock
Music by Bensound.com
Education and Compliance By K2 Enterprises (https://k2e.com)
Copyright. All product names, logos, and brands are the property of their respective owners. All company, product, and service names used in this website are for identification purposes only. The use of these names, logos, and brands does not imply endorsement.
Educational Use Only. The information presented in this presentation is for educational use only. The presenter will make specific recommendations, but the participant is highly recommended to do their own due diligence before making any investment decision.
Previous Video(s)
Part 1 - • Excel Essentials for Staff Accountants - P...
Part 2 - https://www.youtube.com/live/g6wyphnrSaw
Part 3 - • Excel Essentials for Staff Accountants - P...
Part 4 - • Excel Essentials for Staff Accountants - P...
Part 5 - • Excel Essentials for Staff Accountants - P...
------ Contents of this video ---------
00:00 - Intro
08:38 - What is the difference between IF and IFs in Excel?
09:58 - What is an example of SUMIFs?
11:48 - What does the $ sign mean in a Formula?
12:45 - How would you use SUMIFs with a Table in Excel?
14:26 - What's a drawback with Tables and this SUMIFs formula and how to fix it?
15:41 - What's an easier way of using this SUMIFs formula with a Table?
16:32 - How to use SUMIFs to calculate between two dates?
19:30 - What does Data Validation do?
20:57 - How to add Data Validation in Excel?
21:10 - What does Data Validation allow us to do?
25:02 - Where is Text to Column located in Excel?
25:14 - What does Text to Column do?
25:18 - What are the two other ways to split apart data?
27:13 - What are the two ways Text to Column splits apart data?
28:50 - What's a big issue with Text to Column?
31:00 - How do you turn the text back to a value?
33:47 - What are two reasons you might not use XLOOKUP?
35:21 - What are the four operators that you need to know about VLOOKUP?
38:07 - Why should VLOOKUP be avoided whenever possible?
40:45 - What does Match do?
41:35 - What does Index do?
44:29 - What is Index and Match?
45:05 - What are the three arguments for XLOOKUP?
46:24 - What are the different ways that XLOOKUP can look up data?