Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
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
Arrow right icon
Author (1):
Arrow left icon
David Ringstrom David Ringstrom
Author Profile Icon David Ringstrom
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

Implementing Accessibility

There’s nothing quite like breaking your arm to energize your interest in accessibility. I should know because about a month and a half into drafting this book, I broke my right arm in a mountain biking accident. Fortunately, I was able to type even before the surgery that was needed to put my arm back together, so I didn’t have to do a deep dive into voice dictation and other measures. Regardless, even before my accident, I had planned to lead off this book with a discussion on accessibility because I’d realized that anything that makes a spreadsheet easier for people that are color-blind or require assistive technologies also makes the spreadsheet easier for all users. Further, it’s not just spreadsheets that can feel inaccessible. You may sometimes feel that Excel itself is impenetrable. Over the course of the entire book, my goal is to demystify as many aspects of Excel as will fit in the pages I have available.

In this chapter, I’ll discuss design strategies that will improve accessibility for all users, and point out certain Excel features that can improve accessibility within workbooks, but also within the program itself.

This chapter will delve into the following areas:

  • How to make Excel more accessible regardless of your abilities
  • Implementing accessibility within spreadsheets
  • Using Excel’s Accessibility Checker feature
  • Accessing Excel’s Accessibility Reminder add-in
  • A brief overview of spreadsheets that are inaccessible because of design strategies
You have been reading a chapter from
Exploring Microsoft Excel's Hidden Treasures
Published in: Sep 2022
Publisher: Packt
ISBN-13: 9781803243948
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
Renews at $19.99/month. Cancel anytime
Banner background image