Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.

Change country

Modal Close icon
Country selected Country selected
country flag United States
Country selected
country flag United Kingdom
Country selected
country flag India
Country selected
country flag Germany
Country selected
country flag France
Country selected
country flag Canada
Country selected
country flag Russia
Country selected
country flag Spain
Country selected
country flag Brazil
Country selected
country flag Australia
Country selected
country flag Argentina
Country selected
country flag Austria
Country selected
country flag Belgium
Country selected
country flag Bulgaria
Country selected
country flag Chile
Country selected
country flag Colombia
Country selected
country flag Cyprus
Country selected
country flag Czechia
Country selected
country flag Denmark
Country selected
country flag Ecuador
Country selected
country flag Egypt
Country selected
country flag Estonia
Country selected
country flag Finland
Country selected
country flag Greece
Country selected
country flag Hungary
Country selected
country flag Indonesia
Country selected
country flag Ireland
Country selected
country flag Italy
Country selected
country flag Japan
Country selected
country flag Latvia
Country selected
country flag Lithuania
Country selected
country flag Luxembourg
Country selected
country flag Malaysia
Country selected
country flag Malta
Country selected
country flag Mexico
Country selected
country flag Netherlands
Country selected
country flag New Zealand
Country selected
country flag Norway
Country selected
country flag Philippines
Country selected
country flag Poland
Country selected
country flag Portugal
Country selected
country flag Romania
Country selected
country flag Singapore
Country selected
country flag Slovakia
Country selected
country flag Slovenia
Country selected
country flag South Africa
Country selected
country flag South Korea
Country selected
country flag Sweden
Country selected
country flag Switzerland
Country selected
country flag Taiwan
Country selected
country flag Thailand
Country selected
country flag Turkey
Country selected
country flag Ukraine
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
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

Arrow left icon
Product type Paperback
Published in Sep 2022
Publisher Packt
ISBN-13 9781803243948
Length 444 pages
Edition 1st Edition
Languages
Tools
Concepts
Arrow right icon
Author (1):
Arrow left icon
David Ringstrom David Ringstrom
Author Profile Icon David Ringstrom
David Ringstrom
LinkedIn
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.
Read more
See other products by David Ringstrom
Arrow right icon
View More author details
Toc

Table of Contents (18) Chapters Close

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 17. Other Books You May Enjoy

Technical requirements

Everything that I discuss in this chapter will work in any current version of Excel, except for the Forecast Sheet feature, which requires the Windows version of Excel 2016 or later. This feature is not available in Excel for macOS or Excel for the Web. However, you can view Forecast Sheets that have been created in Excel for Windows in the macOS and online versions.

An example workbook that contains all of the formulas used in this chapter, along with work areas so that you can try the features I discuss, can be found on GitHub at https://github.com/PacktPublishing/Exploring-Microsoft-Excels-Hidden-Treasures/tree/main/Chapter6.

Let’s lead with a look at a worksheet function that enables you to calculate loan payment amounts. I’ll be using this function, and others, throughout this chapter as we work through various What-If Analysis scenarios.

lock icon The rest of the chapter is locked
arrow left Previous Section
Section 2 of 10
Next Section arrow right
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.
Sign up now
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)

Profile icon David Ringstrom
David Ringstrom
LinkedIn icon Github icon
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.
Read more
See other products by David Ringstrom

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
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.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
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.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
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.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
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.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
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.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
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.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
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.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
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.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
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.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
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.
Read more
May 2024 16h 56m
Mastering Python Design Patterns
Mastering Python Design Patterns
Read more
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.
Read more
May 2024 9h 52m
Mastering Python Design Patterns
Mastering Python Design Patterns
Read more
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.
Read more
May 2024 9h 52m
Right arrow icon