With recent Excel updates provided through Microsoft 365/Office 365 subscriptions, Microsoft continues to pack new features into the popular spreadsheet tool. Enhancements to data analysis tools, new functions, and improved collaboration opportunities are available in more recent Excel versions. For those who know about these new features and apply them, exciting opportunities for improved productivity await. Take advantage of this opportunity to learn how you can put Excel’s best new features to work right away!

Are you a CPA?? Are you a Financial Professional?? Earn CPE Credits for Today's Podcast. Check out [ Ссылка ]. Take a quick 5 question quiz and get your certificate today. Super Easy!

Presented by Stephen M. Yoss, CPA, MS ([ Ссылка ])
Produced by Alicia Nichols
Graphics By Flaticon.com and Upsplash.com
Music by Bensound.com
Education and Compliance By K2 Enterprises ([ Ссылка ])

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.

-- Contents of this video ------------

00:00 - Intro
06:23 - How do I know what version of Excel I am operating on?
09:14 - What are the six New Functions in Excel?
09:42 - How does TEXTJOIN work?
14:50 - What is CONCAT?
17:16 - What are IFS in Excel?
24:11 - What is an IFERROR Formula and how to use it?
26:00 - What is Logical Conditional Arithmetic?
32:27 - What are the two New Charts in Excel and how to use them?
33:43 - How to create a Funnel Chart?
36:07 - What are Mapping Charts and how to use them?
37:53 - How to change the format of the Mapping chart?
42:16 - How to use Power BI with Excel?
45:25 - How to change the Default layout for Pivot Tables?
50:05 - What are the Data Types for Excel?

свернуть