Dianne Auld's Excel Tips
eBook - ePub

Dianne Auld's Excel Tips

Featuring Compensation and Benefits Formulas Third Edition

  1. English
  2. ePUB (mobile friendly)
  3. Available on iOS & Android
eBook - ePub

Dianne Auld's Excel Tips

Featuring Compensation and Benefits Formulas Third Edition

About this book

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.

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Dianne Auld's Excel Tips by Dianne Auld in PDF and/or ePUB format, as well as other popular books in Business & Human Resource Management. We have over one million books available in our catalogue for you to explore.

Information

Table of contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Contents
  5. Introduction
  6. Excel Tips
  7. Converting Data
  8. Converting Text
  9. Working with Dates
  10. Avoiding Column Count Errors in Lookup Formulas
  11. Statistics
  12. Pivot Tables
  13. Conditional Formatting
  14. Checking Data
  15. Subtotals and Sorting
  16. Regression Analysis
  17. Charts
  18. What-If Functions
  19. Data Consolidate
  20. Array Formulas
  21. Financial Functions
  22. Macros
  23. Form Controls
  24. Paste Options
  25. Control Key Shortcuts
  26. Function Key Shortcuts
  27. ASAP Utilities Functions
  28. Data Types (Office 365)
  29. Power Query / Get & Transform Data
  30. XLOOKUP and XMATCH Formulas
  31. Dynamic Arrays