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

Index

As this ebook edition doesn't have fixed pagination, the page numbers below are hyperlinked for reference only, based on the printed edition of this book.

Symbols

#CALC! errors 290

#SPILL! errors

about 290, 318

conditions 318, 319

A

Access database

linking, in Excel for Windows 402, 403

Accessibility Checker feature

about 25, 26

errors 25

tips 26

warnings 26

Accessibility Reminder add-in

about 26

commands 26, 27

ActiveX Controls 153

Advanced Formula Environment 354, 355

aged receivables report 376

alt-number pad nuance 63, 64

Always create backup setting 45, 46

amortization table

about 313

arguments 314, 315

Application Programming Interface (API) 404

array 302

array formulas 182

AutoFilter command 69

automatic report cleanup

about 375

analytical obstacles 376

Power Query connection, breaking 385

Power Query connection, updating with new data 384

reports...

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