Exploring Microsoft Excel’s Hidden Treasures: Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features

Book Description

Discover timesaving features, accessibility and internal control approaches, data integrity improvements, and spreadsheet automation techniques by exploring Excel shortcuts and nuances in Microsoft 365, Excel versions till 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

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. The time-saving techniques covered in the book 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 controls, and understand how to solve problems with What-If Analysis features. In addition, you’ll master new features and functions such as XLOOKUP, Dynamic Array functions, LET and LAMBDA, and Power Query, while learning how to leverage shortcuts and nuances in Excel.

By the end of this book, you’ll have a broader awareness of how to avoid pitfalls in Excel. You’ll be empowered to work more effectively in Excel, having gained a deeper understanding of the frustrating oddities that can arise daily in Excel.

What you will learn

• Explore 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

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 that 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.

中文：

书名：Exploring Microsoft Excel’s Hidden Treasures: Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features

通过探索Microsoft 365、直到2021年的Excel版本中的Excel快捷方式和细微差别，了解节省时间的功能、可访问性和内部控制方法、数据完整性改进以及电子表格自动化技术

Key Features

• 通过在详细的示例练习册中执行技术来获得实践经验
• 通过立即实施数据完整性和自动化功能，回收您一天中的部分时间
• 将电子表格灾难恢复技术融入您的日常工作

Book Description

大卫·林斯特罗姆创造了一句话：“要么你使用Excel，要么它为你工作！”在观察到有多少用户执行任务效率低下后。

在这本书中，你将学习如何以更少的努力完成更多的工作。这本书将使您能够创建具有弹性的电子表格，便于其他人使用，同时纳入电子表格灾难准备技术。书中介绍的节省时间的技术包括创建自定义快捷方式和图标以简化重复性任务，以及使用表格和自定义视图等功能自动执行这些任务。您将看到条件格式如何使您能够在数据更改时按需应用颜色、单元格图标和其他格式。您将被授权通过实施内部控制来保护电子表格的完整性并提高可用性，并了解如何使用假设分析功能来解决问题。此外，您还将掌握XLOOKUP、动态数组函数、let和Lambda以及Power Query等新特性和功能，同时学习如何利用Excel中的快捷方式和细微差别。

到本书结束时，您将对如何避免Excel中的陷阱有更广泛的认识。在对Excel中每天可能出现的令人沮丧的奇怪情况有了更深入的了解后，您将能够更有效地在Excel中工作。

What you will learn

• 探索可节省时间的隐藏和被忽略的功能
• 实施灾难预防和恢复技术
• 提高所有用户的电子表格可访问性
• 增强数据完整性和电子表格恢复能力
• 使用Lambda创建无需代码的自定义工作表函数
• 使用Power Query创建无代码报表自动化
• 轻松集成电子表格自动化技术

Who this book is for

本书适用于从事不同角色的中高级Excel用户，如业务用户、会计、项目经理和业务分析师等。你花在EXCEL上的时间越多，这本书就会节省你越多的时间。通过学习电子表格的互动性、可访问性和自动化，您将能够最大限度地提高工作效率。这本清晰的循序渐进的解释和详细的示例工作簿将帮助您第一手尝试新技术，并立即利用它们来实现您的业务优势。