Take a deep dive into Excel's quirks and nuances to discover timesaving features, accessibility and internal control approaches, data integrity improvements, and spreadsheet automation techniques.
Key Features
- Get hands-on experience by carrying out techniques in detailed example workbooks
- Understand the differences between Excel for Windows and Excel for Mac
- Incorporate spreadsheet disaster recover techniques into your daily work
Book Description
David Ringstrom coined the phrase "Either you work Excel, or it works you!" after observing how many users carry out tasks inefficiently.
In this book, you'll learn how to get more done with less effort. This book will enable you to create resilient spreadsheets that are easy for others to use as well, while incorporating spreadsheet disaster preparedness techniques. Time- saving techniques include creating custom shortcuts and icons to streamline repetitive tasks, as well as automating them with features such as Tables and Custom Views. You'll see how Conditional Formatting enables you to apply colors, cell icons, and other formatting on-demand as your data changes. You'll be empowered to protect the integrity of spreadsheets and increase usability by implementing internal control, and you'll see how to solve problems with What-If Analysis features. You'll also master new features and functions such as XLOOKUP, dynamic array functions, LET and LAMBDA, as well as Power Query, while learning how to leverage quirks and nuances in Excel.
By the end of the book, you'll have a broader awareness of how to avoid pitfalls in Excel. You'll be empowered to work more effectively in Excel because you'll have a deeper understanding of the frustrating oddities that can arise daily in Excel.
What you will learn
- Learn about hidden and overlooked features that will save your time
- Implement disaster prevention and recovery techniques
- Improve spreadsheet accessibility for all users
- Bolster data integrity and spreadsheet resilience
- Craft code-free custom worksheet functions with LAMBDA
- Create code-free report automation with Power Query
- Integrate spreadsheet automation techniques with ease
Who This Book Is For
From accountants and business analysts to project managers and data specialists, the more time that you spend in Excel, the more time this book will save you. Whether you use Excel to manage lists of data, perform financial modeling, extract data from databases, or any of the countless ways that people use Excel, you'll be working smarter instead of harder after reading this book. The clear step-by-step explanations and detailed example workbooks enable beginners, intermediate users, and advanced experts alike to try out new techniques first-hand.
Table of Contents
- Implementing Accessibility
- Optimizing Excel's User Interface
- Quick Analysis Toolbar Treasures
- Conditional Formatting
- Data Validation and Form Controls
- What-If Analysis
- Automating Common Excel Tasks with the Table Feature
- Custom Views
- Excel Quirks and Nuances
- Lookup and Dynamic Array Functions
- LET and LAMBDA
- Power Query
