Discover Excel’s Hidden Treasures with Expert Tips and Automation Techniques

Price: $11.99
(as of May 21,2023 11:38:50 UTC – Details)

In this book, David Ringstrom shares his extensive knowledge of Microsoft Excel to help you overcome common inefficiencies and learn advanced techniques. You will discover timesaving features and accessible internal control approaches, data integrity improvements, and spreadsheet automation techniques by exploring Excel shortcuts and nuances in Microsoft 365, as well as Excel versions up to 2021.

Key Features

• Get hands-on experience by carrying out techniques in detailed example workbooks
• Reclaim portions of your day by immediately implementing data integrity and automation features
• Incorporate spreadsheet disaster recovery techniques into your daily work

Book Description

Ringstrom shows how to create resilient spreadsheets that are easy to use while incorporating spreadsheet disaster preparedness techniques. He covers time-saving techniques such as creating custom shortcuts and icons to streamline repetitive tasks, as well as automating them with features like Tables and Custom Views. You will learn how to use Conditional Formatting to apply colors and Cell icons to format your data on-demand and protect the integrity of your spreadsheets through internal controls. Additionally, you will solve problems with What-If Analysis features and will master new features like XLOOKUP, Dynamic Array functions, LET and LAMBDA, and Power Query, all while learning Excel shortcuts and nuances.

By the end of this book, you will have a broader awareness of how to avoid pitfalls in Excel, creating a deeper understanding of the frustrating oddities that can arise in daily use. This book empowers you to work more effectively in Excel, maximizing your productivity and learning spreadsheet interactivity, accessibility, and automation.

What You Will Learn

• Explore hidden and overlooked features that will save you 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

This book is for intermediate to advanced Excel users working in diverse roles, such as business users, accountants, project managers, and business analysts, among others. The more time you spend in Excel, the more time this book will save you. You will be able to maximize your productivity by learning spreadsheet interactivity, accessibility, and automation. This clear step-by-step explanation and detailed example workbook will help you to try out new techniques firsthand and leverage them for your business’s advantage in no time.

Table of Contents

• Implementing Accessibility
• Disaster Recovery, and File-Related Prompts
• Quick Analysis Toolbar Treasures
• Conditional Formatting
• Data Validation, and Form Controls
• What-If Analysis
• Automating Tasks with the Table Feature
• Custom Views
• Excel Quirks, and Nuances
• Lookup and Dynamic Array Functions
• Names, LET, and LAMBDA
• Power Query

Publisher: Packt Publishing (September 16, 2022)
Language: English
Paperback: 444 pages
ISBN-10: 1803243945
ISBN-13: 978-1803243948
Item Weight: 1.67 pounds
Dimensions: 7.5 x 1 x 9.25 inches