No more Control, Shift, Enter! No more implicit intersection! Arrays are now dynamic
Learn the new dynamic array functionality introduced to Office 365/Microsoft 365 Excel users in 2020. This online class showcases many astonishing applications of these new formulas to transform your rewards work resiliently.
PLUS, all attendees will receive the Excel spreadsheets and detailed instructions for replication of the functions demonstrated after the presentation.
Take your Excel skills to a completely new mind-blowing level
One of the smartest and most powerful tools ever developed for Excel, Power Query has amazing capabilities for extracting, transforming and loading data. In this online class, Dianne will demonstrate four applications of Power Query.
Bonus: Attendees will receive all the Excel spreadsheets demonstrated and detailed instructions for replication of the Power Query functions.
Auld Compensation Consulting
Dianne Auld, CCP, GRP, CSCP, WLCP owns a consulting practice, Auld Compensation Consulting, in Cape Town, South Africa. . She consults to a wide range of organizations globally in all areas of total rewards. She has developed and taught courses in Africa, the Middle East, Asia, Europe, and the United States.
Dianne is also a faculty member at WorldatWork and a reviewer for the WorldatWork Journal. Well respected and known as an expert in the compensation field and Excel, Dianne's skills and expertise are in high demand. In fact, her sessions at the WorldatWork Total Rewards Conference and Exhibition typically fill to capacity. She is the author of the popular Dianne Auld’s Excel Tips, third edition.
Dianne has partnered with WorldatWork to develop several educational products to assist compensation professionals with their day-to-day tasks in Excel, including "Working Smarter and Faster with Excel Formulas, Charts and ASAP Utilities,” “Regression Analysis Made Easy with Excel,” “Hello Excel Power Query, My New BFF”, "Excel Skills for Compensation Professionals," and "Advanced Excel Skills and Dashboards for Compensation Professionals."
Dianne was knowledgeable, friendly, well-prepared.
Totally worth my time and money!
Really enjoyed the real-life comp examples.
Dianne is the best Excel instructor EVER!
Absolutely fantastic – such a wealth of knowledge.
+1 877 951 9191USA and Canada
+1 480 951 9191Other Countries