Dianne Auld's Excel Tips

While the role of today's total rewards professionals has become more strategic and business-oriented, some fundamentals of the job will always hold true. One such fundamental is math. Focusing on how to use Excel for compensation work, Excel guru and WorldatWork faculty member, Dianne Auld continues to pack this latest edition full with powerful tools so you can tackle even your biggest data projects. This book includes the ever-useful compensation and benefits formulas presented in previous editions, PLUS discover how to put dynamic arrays and power query to work! This new edition reflects the most current versions of software: Excel 2019 and Microsoft 365. You'll gain tips, tricks and formulas so Excel works for you, employing ASAP utilities, array formulas, power queries, etc. when building charts, regression analyses, pivot tables and more. This book is a must-have, go-to resource for every compensation and benefits professional. Now with Power Query and Dynamic Arrays! Gain tips, tricks and formulas so Excel does the math for you when building charts, regression analyses, pivot tables and more. Reflects current versions of Excel 2019 and Microsoft 265 including Power Query and Dynamic Arrays.