Excelling with Microsoft Excel: Self-learning series 2 (Accessibility options)

By Opie (Simply a mom on a mission to inspire) in Excel tips on Nov 30, 2015Nov 28, 2015

This is the 2nd of my self-learning series, the first one was on Shortcuts and sparklines. If you are interested in taking the online e-learning independently, you can check out the link here >>>Microsoft Excel 2010 course, it is administered by Alison.

Key learning points for today

Accessibility options

The essence of this Excel functionality is to make your workbook or sheet user-friendly for all especially for the visually impaired. Just like me, am sure this does not often cross our mind. We always assume the final users would not encounter any challenges in navigating our completed spreadsheets.

Enough of the explanations, let me hit the nail on the head. I have painstakingly taken screenshots of the step by step procedure to guide anyone who would want to explore this Excel functionality.

a) Open your Excel worksheet, select File, then click on Info.

Select check for issues.

b) Three sub-options would be displayed namely: Inspect document, check accessibility and check compatibility. For this session, select check accessibility.

c) Issues will be displayed at the right hand corner of your worksheet. Example of how its shown is reflected in the screenshot below.

It would also include information oh how to fix these errors as illustrated below.

After you successfully clear all the issues, you would finally have your user-friendly workbook. Kudos!

Hope you found this useful and learnt something new as I did today.

Comment directly with your questions or send them to omtsdigest@gmail.com. I will be happy to research and provide answers.

You can join me on this educational journey on twitter @mophie227 or on my blog

Tweet
//

Tags: Alison, analytical tools, excel, improving competencies, keyboard shortcuts, Microsoft Excel, self-learner, sparklines

Published by Opie (Simply a mom on a mission to inspire)

Hi! I am Opie, an introverted mother of two who becomes a talkative whenever topics of mental health and navigating life comes up for discussion. I looovveee to inspire positive change through my blog posts mainly targeted at mothers and of course every other person. I am also not just a Chartered Accountant but a mentor, coach and a quiet but daring explorer of life and places. My content is targeted at inspiring a simple lifestyle of thought, hope and love. The OMT brand focuses on inspiration, entrepreneurship, youth and women empowerment and changing the African narrative a blog post at a time. Like OMT's Digest's tagline goes: I am simply a mom on a mission to inspire! View all posts by Opie (Simply a mom on a mission to inspire)