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

Other Books You May Enjoy

If you enjoyed this book, you may be interested in these other books by Packt:

Efficiency Best Practices for Microsoft 365

Dr. Nitin Paranjape

ISBN: 9781801072267

Understand how different MS 365 tools, such as Office desktop, Teams, Power BI, Lists, and OneDrive, can increase work efficiency
Replace the content with the following bullet list:
Identify time-consuming processes and understand how to work through them more efficiently
Create professional documents quickly with minimal effort
Work across multiple teams, meetings, and projects without email overload
Automate mundane, repetitive, and time-consuming manual work
Manage work, delegation, execution, and project management

Hands-On Financial Modeling with Excel for Microsoft 365 - Second Edition

Shmuel Oluwa

ISBN: 9781803231143

Identify the growth drivers derived from...

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