Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Exploring Microsoft Excel's Hidden Treasures

You're reading from Exploring Microsoft Excel's Hidden Treasures Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features

Product type Paperback

Published in Sep 2022

Publisher Packt

ISBN-13 9781803243948

Length 444 pages

Edition 1st Edition

Languages

Power Query

Tools

Excel

Concepts

Programming Language

Author (1):

David Ringstrom

View More author details

Table of Contents (18) Chapters

Preface

1. Part 1: Improving Accessibility

2. Chapter 1: Implementing Accessibility FREE CHAPTER

3. Chapter 2: Disaster Recovery and File-Related Prompts

4. Chapter 3: Quick Access Toolbar Treasures

5. Chapter 4: Conditional Formatting

6. Part 2:Spreadsheet Interactivity and Automation

7. Chapter 5: Data Validation and Form Controls

8. Chapter 6: What-If Analysis

9. Chapter 7: Automating Tasks with the Table Feature

10. Chapter 8: Custom Views

11. Chapter 9: Excel Quirks and Nuances

12. Part 3: Data Analysis

13. Chapter 10: Lookup and Dynamic Array Functions

14. Chapter 11: Names, LET, and LAMBDA

15. Chapter 12: Power Query

16. Index

Why subscribe?

17. Other Books You May Enjoy

Part 2:Spreadsheet Interactivity and Automation

This chapter will empower you with interactivity and automation techniques. Data validation provides interactivity, documentation, and internal control, but can be bypassed by savvy users. The Form Controls feature provides more controlled interactivity when necessary. Many users fail to notice the potential of Excel’s What-If Analysis features, which can eliminate manual guesswork in a flash. The Table feature offers more automation potential than I could fit into the chapter. Custom Views is one of my favorite code-free automation solutions in Excel that can save you time in several ways. The final chapter, Excel Quirks and Nuances, explains how to avoid getting snared by tricky pitfalls in Excel.

The following chapters are included in this part:

Chapter 5, Data Validation and Form Controls
Chapter 6, What-If Analysis
Chapter 7, Automating Tasks with the Table Feature
Chapter 8, Custom Views
Chapter...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

David Ringstrom

David Ringstrom

David Ringstrom exclaimed “Well, this is a stupid program, you can't do anything with it” the first time that he launched Lotus 1-2-3 in 1987, unaware that pressing the slash key displayed the menu. That moment sealed his fate as he is now a nationally recognized spreadsheet expert. In 1991, David started a spreadsheet consulting practice that he still runs today. David has taught over 2,000 webinars and published hundreds of articles, all on Excel, and he imparts spreadsheet skills to thousands of college students each year. He is the author or coauthor of five books and the technical editor of over 40 books. He is a certified public accountant and a graduate of Georgia State University and has served in the United States Navy.

See other products by David Ringstrom

Personalised recommendations for you

Based on your interests and search pattern

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Mastering Python Design Patterns

Mastering Python Design Patterns

Unlock the power of design patterns to build maintainable and scalable software and applications using Python. Authored by Python veterans, this book is your guide to mastering design patterns in Python.

May 2024 9h 52m

Mastering Python Design Patterns

Mastering Python Design Patterns

Unlock the power of design patterns to build maintainable and scalable software and applications using Python. Authored by Python veterans, this book is your guide to mastering design patterns in Python.

May 2024 9h 52m