Live Webinar K2's Mastering Advanced Excel Functions
Overview
With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features -- some new and some legacy -- to elevate your productivity to higher levels.
In this session, you will learn about many of Excel's new tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.
Highlights
• Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays
• How to use “legacy” features and functions such as AGGREGATE
• Creating effective forecasts in Excel
Prerequisites
Fundamental knowledge of Excel 2019 and newer
Designed For
Business professionals who work with Excel and want to extend their knowledge of advanced features and functions to become more accurate, effective, and efficient with spreadsheets
Objectives
After attending this presentation you will be able to . . .
• List examples of best practices for constructing formulas in Excel spreadsheets
• Identify situations in which each of the following functions might be useful: SUMIFS, SWITCH,
and STOCKHISTORY
• Distinguish between the XLOOKUP function and legacy Excel functions such as VLOOKUP, HLOOKUP, INDEX,
and MATCH
• Cite examples of when using Dynamic Arrays would be useful
• Differentiate between Excel’s AGGREGATE and SUBTOTAL functions
• Identify conditions in which the FORECAST.ETS function is preferable to the FORECAST function
Preparation
None
Leader(s):
Leader Bios
Stephen Yoss Jr, K2 Enterprises LLC
Stephen M. Yoss, Jr., CPA, is a certified public accountant, the senior technology strategist and principal of Yossio, a continuing education instructor for financial professionals, and a licensed pyrotechnician. While his interests and skills are varied, they all share a common thread—his love for and skill in finding technology-based solutions. At age 10, Stephen began working with technology; he started his first IT company at just 13, which focused on designing web applications for local businesses. At 15, he began writing original computer code and has been designing and implementing technological solutions continuously since then. Stephen is a graduate of Loyola Marymount University, with degrees in Accountancy and International Business. While at Loyola, he served the campus as student body president and as the student representative to the Board of Trustees. He has a Master’s of Science degree in Information Systems and Technology from Claremont Graduate University with a concentration in Geographic Information Systems. In 2009, Stephen formed Yossio, a company focused on helping organizations develop technology strategies to streamline their business operations. He specializes in taking on high-difficulty, mission-critical organizational issues that require technological expertise and an ability to find solutions to problems that no one else can answer. With all of his clients, he emphasizes the need to embrace technology at every opportunity and utilize the latest technological trends and breakthroughs in order to gain a competitive advantage while increasing efficiency and productivity. Prior to starting Yossio, Stephen worked as an accountant in his family’s practice, Yoss & Allen. At Yoss & Allen, he completely redesigned the firm’s technology practices and instituted a technological infrastructure to streamline the firm’s practices and allow them strategic flexibility. Many of the technologies, strategies, and concepts that Stephen uses himself (and consults companies on how to use) were designed, perfected, and implemented to help his family’s business and their clients. In addition to his time with Yoss & Allen, Stephen worked in New Zealand as a management accountant. Since 2009, Stephen has also been teaching continuing professional education, providing written, webcast, in-house, and live instruction. He has presented to thousands of practitioners worldwide on topics such as cloud computing, mobile technology, Excel tips and best practices, data modeling and analysis, big data, information security, identity theft prevention, and more. Stephen is also a professionally licensed pyrotechnician and works on major fireworks displays throughout the nation for Pyro Spectaculars, North America’s largest full-service fireworks display production company. He’s proud to have helped produce incredible displays, including the Macy’s July 4th Spectacular in New York City, the 75th Anniversary of the Golden Gate Bridge in San Francisco, KGB Skyshow in San Diego, and many more. Whether it’s teaching in the classroom, consulting clients in a boardroom, or shooting a fireworks display, Stephen brings passion, hard work, value—and above all else—technological expertise to each of his clients. With an open, honest approach, he creates a unique strategy for each client specifically designed to benefit their needs and streamline their operations in order to create efficiency and maximize their financial potential. Stephen calls Claremont, CA, home; when he’s not at the desk, in a boardroom, at the podium, or producing a fireworks display, he spends as much time as he can pursuing his other passions. He is an avid music lover and attends multiple festivals each year. At the Burning Man, Stephen helps setup and produce pyrotechnic displays for the city. In Claremont, he regularly volunteers his time to perform various community services. He’s also an avid outdoorsman and regularly carves out time to scuba dive, camp, hike, and photograph both close to home with family and friends and on his many travels.
Non-Member Price $229.00
Member Price $179.00