David Berman Communications
David Berman will help you repeat your successes

Accessible Spreadsheets: from Excel (and Google Sheets)

Accessible Spreadsheets: from Excel (and Google Sheets)

For a fully keyboard-accessible alternative for this video, either view it in Chrome or any Android or iOS device, view in Firefox with the YouTube ALL HTML5 add-on installed, or disable Flash in current Internet Explorer.

Transcript | David Berman on The New Standard on Web Accessibility WCAG 2 events

Transcript of the video David Berman on The New Standard on Web Accessibility WCAG 2.0 events.

(The speaker, David Berman is sitting in an armchair by the fireplace. Throughout the entire video, he addresses the camera directly.)

I’m David Berman and I’m often asked why Web accessibility matters so much, and why people should care: why people should bother making sure their web presences are accessible.

The simple answer is legislation tells us we have to. I have the background of knowing how to make websites accessible and i’ve put together this one-day course which takes you through why it matters, what the major issues are,and how to make your web presence accessible. It’s really important for us that when people come out of this course that they have usable knowledge.

And so we focus on WCAG 2.0 Level AA. Why? Because that’s the standard that the United States has in Section 508. That’s the standard that the Canadian government has chosen, and the new Web standards and provinces and states like Ontario’s AODA call for that level AA compliance. If you learn this, you’ll learn the standard that everyone in the world is heading towards.

The most important point I want to share is that accessibility matters to everyone.

When we know how to make a site accessible for the extremes, and we do it well, we do it in a way that the site becomes more usable for everyone.

A more usable site is going to make it more likely that your audience is going to connect with your message. If you can get your audience to support themselves by going to the site, you can drive down your support costs, as well as having more satisfied customers.

Why wouldn’t you want that? [chuckles] I find this course is fascinating and educational for both people in management, as well as IT professionals.

I find when people come out of this course they’re excited, they’re motivated, they’re entertained.

Most importantly, they’re educated … and the information sticks. Over the past ten years, I’ve had the opportunity to work with hundreds of organizations on four continents: professionals who see the value to their business, to their communities,to their bottom line, in making their web sites more accessible.

If you’re a manager, if you’re an IT professional, if you’re a programmer, if you’re a designer, join us: for web accessibility matters.

(Text on screen:

Web Accessibility Matters.

www.davidberman.com )

(David Berman Communications wordmark)

 

 

Course Description

Are your spreadsheets inclusive by default? Learn how to create accessible spreadsheets in Excel and Google Sheets.

An accessible spreadsheet is one that allows people living with accessibility issues to receive the same information as everyone else. From accessible headings to keyboard navigation, spreadsheet accessibility includes topics as varied as the human senses.

This course teaches Excel and Google Sheet users to succeed in effectively creating accessible spreadsheets, taking them into account the laws and regulations relevant to you.

You can succeed in maintaining the accessibility that is already cooked into accessible spreadsheets or create your own so that everyone can participate in the editorial process. Meanwhile, you’ll be reducing the effort that will be required for your Web team to convert your spreadsheets to accessible HTML or PDF.

Not only will you comply with the regulation and standards (e.g., WCAG 2, Revised Section 508, ADA, ENG 301 549, AODA…): you’ll be broadening the audience for your content while enriching the experience of existing users.

“Fun and engaging… David is great!”

– James Welsh, Conference Board of Canada

David Berman will convince you of why accessibility is important for everybody, then provide in-depth familiarity with federal and international guidelines that will help your spreadsheet content be a more effective resource for your entire audience. You’ll also gain familiarity with assistive technologies that help people with specific disabilities and difficulties.

Our full-day course includes a thorough review of every pertinent standard that applies to accessible spreadsheets, including policies that call for WCAG 2 and EN 301 549 conformance (such as U.S. Section 508 and Ontario’s AODA). These new standards allow spreadsheet files (or the HTML or PDF that result from them) to be your primary format, but only if your spreadsheet files are truly accessible … and that is poorly understood. We’ll cover everything from tables to formulas and testing recommendations.

Not only will you leave with ideas you can use right away: you may also gain a whole new attitude towards how technology can improve lives. By the end of the course, you will not only be aware of why accessibility and standards affect everyone: you’ll be equipped with a thorough understanding of what needs to be done and how, including tools and testing techniques. Each participant leaves with a comprehensive 160+ page learning guide, detailing every relevant accessibility success criterion.

This course incorporates adult learning principles and activities appropriate to a variety of learning styles and qualifies for CEUs (certified by organizations such as PPAC).

“Excellent… knowledge I can use.”

– Sandra Clark, Ministry of Trade and
Industry, Oslo (Norway)

“Focused and easy to follow.”

-Jason Hollett, gordongroup

“Great. He kept me listening and understanding.”

– Matthew Brunetti, Lixar IT

“Inspiring!”

– Morten Budeng, King Design

“Excellent.”

– Sylvie Nyman, Indian and Northern
Affairs Canada

What’s Wrong

There’s a need for people to understand what constitutes sufficiently-accessible spreadsheets, whether fillable or static, and the steps to get there with the least expense and effort. Although most professional developers now create content with some awareness of browser incompatibilities and platform dependencies, they still experience difficulties with emerging accessibility standards. Many spreadsheets continue to be developed based on assumptions that don’t address the specific needs of people living with disabilities and difficulties and thus fail to deliver the promise of accessible spreadsheets.

“Entertaining.”

– Sjur Kristiansen, Telenor Telecommunications
Group

“Eye-opening. Love your method of teaching.”

– Jean Descrochers, National Research
Council

What Makes This Course Unique

Our course leader, David Berman, is a consultant on accessibility for large IT projects and has worked on Web accessibility projects for many large organizations including Statistics Canada, the National Research Council, and IBM.

He is a high-level advisor to the United Nations on how accessible IT can help fulfill the Millennium Development Goals more rapidly.

He has been the project manager of numerous accessible online projects, has developed strategy and design for CAST, CFIA, CRA, CMHC, Health Canada, Canadian Heritage, Industry Canada, and the International Space Station … as well as many private sector and non-profit organizations.

By addressing and understanding accessibility issues, publishers can more effectively deliver their message to their entire audience, regardless of physical or mental impediments, while complying with legal and moral responsibilities.

“Right on target.”

– Marius Monsen, Reaktor ID

“He knows what to do!” “This will guide us for the AA Standards”

– Bassil Wehbe, Agriculture Canada

What You Will Learn

You will learn how to make spreadsheet files that include everyone from Step 1, that comply with every global standard for accessible spreadsheets. Specifically, you will learn:

  • Introduction
    • introduction to WCAG 2 and how it applies to spreadsheets
    • introduction to accessible spreadsheet software
  • Creating accessible spreadsheets
    • working with cell structures (headings and data)
    • working with layout (spacing and alignment)
    • baking accessibility into spreadsheets
    • workflow for accessible fillable spreadsheet (including optional locking of unfillable regions)
  • Flagging and repairing issues
  • Exporting to PDF
    • setting the export options
    • exporting
    • touching up and testing

“Very good: made me think…”

– Bente Mollevik, Norwegian Savings
Bank Association

“Great: very comprehensive. Touching on all aspects of accessibility.”

– Marc Iafelice, CFIA

“David really knows his topics. Very well done: got the point across in a way that can be apply to everyone.”

– Sean Strasbourg, CFIA

Goals

Upon completion, participants will be able to successfully create an accessible spreadsheet file (WCAG 2 Level AA compliant) using Microsoft Excel and/or Google Sheets.

At the end of this event, you will:

  • know many techniques you can apply right away to make spreadsheet content more accessible
  • be able to make informed decisions as to when a spreadsheet is the right place to start
  • understand better the experience of those living with disabilities using spreadsheets
  • know you’re doing the “right thing” by ensuring that everyone can participate in the spreadsheet development process

“Excellent.”

– Steinar Sandum, Adax, Svelvik (Norway)

“Interesting content, really well delivered. Visual and engaging. Gives us a common language and approach.”

– Chris Cook, CFIA

“This will change the way we work.”

– Sharon Drolet, Canadian Food Inspection Agency

What You Get

When David Berman Communications hosts this course*, regular ticket holders receive:

  • a complimentary, comprehensive 160+ page learning guide, detailing every applicable accessibility standard (also
    available separately for $97, with optional 1-on-1 distance coaching)
  • a thirty-minute one-on-one personal coaching tele-session with David within a month
  • the option to attend this course again in the future, as a refresherat no additional cost
  • the option to attend the first half on one date and the second half at a future date
  • a money-back guarantee: if, after coaching and refresher, you don’t think you’ve got your money’s worth, we’ll refund your entire fee
(*If you are attending one of our courses hosted by another organization, confirm which of these items apply.)

Register (at https://davidberman.com/register ) or call 1-613-728-6777… or bring this event to your site: for a keynote, half-day, or full-day event, customized for your group.

 

Prerequisites:

  • Intermediate knowledge of Microsoft Excel and/or Google Sheets

“Clear and entertaining: will allow more strategic planning rather than just reactionary stumbling.”

– Steve Doody, Justice Canada

“This will make us better communicators.”

– Luc Bergeron, SSHRC

“Perfect.”

– Jean Leclair, Environment Canada

About the Expert Speaker

David Berman is the principal of David Berman Communications. He has over 25 years of experience in graphic design and strategic communications. He has worked extensively in adapting the printed word for electronic distribution, including software interface development.

David was appointed a high-level advisor to the United Nations on how design and accessible ICT can help fulfill the Millennium Development Goals more rapidly.

He has extensive experience as a senior consultant in applying accessibility and standards to government Web sites, as well as to private sector clients such as IBM, both as a strategist and compliance testing leader. He regularly teaches accessibility principles as part of his professional development workshops, and developed a custom two-day workshop for the National Research Council on common look and feel. His plain writing, design, and accessibility work include award-winning projects for the City of Ottawa, the Ontario government, and Canada’s federal government. Clients include IBM, Justice Canada, HRDC, Canada Revenue Agency, the Ontario Ministry of Agriculture and Food, the Region of Ottawa-Carleton and the Ontario Literacy Coalition.

David has been featured in the Financial Post, the Globe And Mail, the Ottawa Citizen, the Montreal Gazette, Marketing, Applied Arts, HOW, and Communication Arts magazines, as well as ABC and CBC.

In addition to operating as one of the leading design strategists in Canada’s capital, David ranks #1 on speakerwiki.org on this topic for a reason. His arc as an internationally-celebrated expert speaker has brought him to over 30 countries. David is a National Professional Member of the Canadian Association of Professional Speakers (CAPS) and the Global Speakers Federation (GSF).

David is currently Ethics Chair of the Society of Graphic Designers of Canada, was named a Fellow (the highest professional honour for graphic designers in Canada) in 1999, and has served as a director and sustainability chair of Icograda, the world body for graphic and communications design.

Who Should Attend

This course is targeted to all project managers, Webmasters, production coordinators, IT professionals, strategists, and controllers, involved in developing presentations and Web sites.

  • heads of communication
  • Web and document managers
  • people who need to get their spreadsheets compliant with current and future government accessibility standards
  • people who write, edit, plan, translate, proofread, or manage online spreadsheets
  • people who coordinate people who build spreadsheets

This course delivers knowledge required for EN 301 549, WCAG 2.0 and WCAG 2.1 Level A and Level AA awareness training as documented in the Government of Canada’s Accessibility Responsibility Breakdown as well as current Treasury Board policy and evolving Accessible  Standards Canada standards. This course incorporates adult learning principles and activities appropriate to a variety of learning styles, and qualifies for CEUs.

Language:

English (French available upon request)

Duration:

One-day course, half-day course, or keynote presentation (we also provide this course customized on-site for your organization).

 

“I love David’s approach.”

-Carole Dubuc, Canadian Armed Forces

“Clear, concise, and very useful.”

-Annette Kallevig

“Excellent, eye-opening, and not preachy!”

-Carrie Walker-Boyd, Canadian Food Inspection Agency

 

Subscribe to our e-news to be notified when we schedule new instances of this topic.

 

Adobe PDF logo

Adobe invented PDF … now it’s an ISO standard

Return to top

Reviewed November 18, 2023

Schedule

“Really enjoyed your session.”

– Jim Dixon

“I love David’s approach.”

– Carole Dubuc, Canadian Armed Forces

 

ACCESSIBILITY EVENTS LOCATION HOST/REGISTRATION FEE*
Day of your choice: Custom one-on-one or one-to-many Your place or our online classroom Let’s collaborate! Call us now TBA
November 16, 2023 Online David Berman Communications Starting from $199 CAD
November 17, 2022 Online David Berman Communications Starting from $199 CAD
November 18, 2021 Online David Berman Communications Starting from $199 CAD
November 12, 2020 Online David Berman Communications Starting from $249 CAD
November 26, 2019 Online David Berman Communications Starting from $249 CAD
June 13, 2019 Online David Berman Communications Starting from $249 CAD
December 5, 2018 Online David Berman Communications Starting from $249 CAD
June 13, 2018 Online David Berman Communications Starting from $249 CAD
November 15, 2017 Online David Berman Communications Starting from $249 CAD
June 14, 2017 Online David Berman Communications (sponsored by CPL, RGD, Editors Canada) TBA
May 19, 2017 Ottawa, ON David Berman Communications TBA
April 3 – 5, 2017 Australia W4A TBA
May 11, 2017 Online The Institute for Performance and Learning TBA
February 14, 2017 Ottawa, ON BioTalent Canada TBA
November 3 – 5, 2016 Wellington, New Zealand Clarity 2016
Sept 14, 2016 Online eXplorance Free
August 17, 2016 Ottawa, ON Spruce Creative TBA
June 29, 2016 Toronto, ON Attend online or in person at OCAD University IDRC, 49 McCaul, Toronto
in The Red Lab, room
$299-625
June 18, 2016 Reno, Nevada TypeWell, in conjunction with the TECHWell 2016 Conference $299-650
May 20, 2016 Ottawa, ON Carleton University $299-625
Tue May 10, 2016 National Press Club, Washington, DC Center for Plain Language $250 USD
Spring 2016, (date tba) Dublin Ireland TBA TBA
November 20, 2015
(postponed)
Vancouver (Downtown)
SFU Downtown Campus
West Hastings Street
NL Thompson Associates $299-597
November 19, 2015
(postponed)
Victoria (Downtown),
Harbour Towers Hotel and Suites
345 Quebec Street
NL Thompson Associates $299-597
October 15, 2015 Ottawa, ON Art Beyond Sight Conference
October 12, 2015 Dublin, Ireland National Disability Authority private
October 2, 2015 (postponed) TBA David Berman Communications $299-597
October 1, 2015 Ottawa, ON Webinar: 11½ Free Tools for Testing Website Accessibility Free & available online
August 8 Toronto Keynote at Accessibility Innovation Showcase, Parapan Am Games Free
July 9, 2015 (postponed) Ottawa, ON TBA $299-597
June 29, 2015 Toronto, ON OCAD University IDRC, 49 McCaul, Toronto
in The Red Lab, room number 4904
$299-625
June 17, 2015 Ottawa, ON Webinar: Demystifying WCAG 2.0 Free & available online
April 25, 2015 (Tentative) Brussels, Belgium Inspirit and David Berman TBA
January 15, 2015 Ottawa, ON Webinar: Spotlight on Digital Accessibility for Your Marketing Campaign Free
January 14, 2015 Ottawa, ON Webinar: Solving Web Accessibility: Leaving No One Behind Free
December 2, 2014 Toronto, ON 108 Ideaspace

 

$357-697
November 10, 2014 Brussels, Belgium TBA TBA
November 5 or 8, 2014 Toronto, ON TBA TBA
October 9, 2014 Toronto, ON David Berman Communications $299-597
Wed July 16, 2014 (postponed) Ottawa, ON Carleton University $299-597
July 12-15, 2014 Ottawa Convention Centre, Ottawa, ON International Summit on Accessibility 2014 TBA
May 26, 2014 Bergen, Norway Den Norske Dataforenings Servicekontor NOK 1000£ – 4450£
May 20, 2014 Queensway Carleton Hospital, Ottawa, Ontario David Berman Communications $299-$597
Fri December 13, 2013 Montreal, QC eXplorance Inc by invitation
November 2013 (tentative) Toronto, ON TBA TBA
Fri November 8, 2013 City Hall, Toronto, ON DesignThinkers 2013 $299-597
Fri November 1, 2013 Room 2228, River Building,
Carleton University,
Ottawa, ON
David Berman Communications $299-597
Wed August 28, 2013 Carleton University David Berman Communications Free
Thu July 25, 2013 Carleton University David Berman Communications Free
Fri June 21, 2013 Room 2228,
River Building,
Carleton University
Ottawa, ON
David Berman Communications $299-597
Fri May 31, 2013 Carleton University David Berman Communications Free
Mon April 22, 2013 Cornwall, ON St. Lawrence College $390
Monday Apr 8 – 9, 2013 Toronto, ON St. Lawrence College $390
Wed February 27, 2013 Hamilton, ON David Berman / T-Base Communications $549-649
Fri February 22, 2013 Ottawa, ON David Berman Communications $354-649
Mon January 21, 2013 St Lawrence College, Kingston, ON St. Lawrence College $390
Thu January 10, 2013 London, ON David Berman / T-Base Communications $549-649
Thu December 13, 2012 Ottawa, ON Transportation Safety Board of Canada private
Thu November 22, 2012 River Building,
Carleton University
Ottawa, ON
David Berman Communications $354-649
Fri November 16, 2012 (postponed) Ottawa, ON David Berman Communications $549-649
Wed November 14, 2012 Ottawa, ON Ministère du Patrimoine canadien private
Thu November 8, 2012 Markham, ON David Berman / T-Base Communications $549-649
Wed November 7, 2012 Mississauga, ON David Berman / T-Base Communications $549-649
Fri October 26, 2012 Ottawa, ON OCDSB / T-Base Communications private
Thur October 25, 2012 Ottawa, ON OCDSB / T-Base Communications private
Wed October 17, 2012 Ottawa, ON OCDSB / T-Base Communications private
Tue October 9, 2012 (all day) (postponed) San Francisco, CA David Berman / T-Base Communications $549-649
Wed September 12, 2012 (all day) (postponed) Boston, MA David Berman / T-Base Communications $549-649
Tue-Wed July 17-18, 2012 Niagara Falls, ON Web Accessibility Matters private
Mon May 14, 2012 (morning) Delta Hotel, Winnipeg, MB Manitoba Libraries Conference $65-$130
Wed May 9, 2012 Strathcona Hotel, Toronto, ON T-Base Communications $549-$649
Tue May 8, 2012 (all day) Strathcona Hotel, Toronto, ON David Berman / T-Base Communications $549-649
Thu May 3, 2012 (all day) Toronto, ON Accessible Media Inc. private
Tue April 23, 2012 (all day) Hotel Pennsylvania, New York City, NY David Berman / T-Base Communications $549-649
Fri March 23, 2012 Adobe Canada, Ottawa T-Base Communications $549-649
Fri March 23, 2012 (Accessible PDF by Design – related all day course) Adobe Canada, Ottawa David Berman / T-Base Communications $549-649
Wed March 21, 2012 (7:00pm speech) Capital Hill Hotel, Ottawa, ON Editors Association of Canada, National Capital Chapter Free: EAC members, $10: non-members
Thurs March 9, 2012 Ottawa, ON Public Health Agency/T-Base Communications private event
Fri February 10, 2012 (morning) Ottawa, ON Canada Revenue Agency private
Thu January 19, 2012 (all day) Ottawa Convention Centre, Ottawa, ON David Berman / T-Base Communications $495-595
Mon-Tue January 9-10, 2012 Toronto, ON BMO / T-Base Communications private
Tue November 29, 2011 (all day) Toronto Convention Centre, Toronto, ON David Berman / T-Base Communications SOLD OUT
Thu November 23, 2011 Ottawa, ON National Research Council private
Wed November 3, 2011 Ottawa, ON National Research Council private
Wed October 5, 2011 Lord Elgin Hotel, Ottawa, ON David Berman / T-Base Communications $319-595
Fri September 9, 2011 Indigo Hotel, Ottawa, ON Correctional Service Canada private
Thu August 18, 2011 Adobe headquarters, Ottawa, ON David Berman Communications /RGD Ontario $249-495
Fri June 17 2011 Adobe headquarters, Ottawa, ON David Berman Communications /RGD Ontario $249-495
Thu April 7, 2011 Ottawa Public Library, Ottawa, ON RGD Ontario $395-495
Tue March 29, 2011 Ottawa, ON CFIA HR by invitation
Thu February 17, 2011 Ottawa, ON CFIA Public Affairs by invitation
Wed April 14, 2010 Ottawa, ON David Berman Communications $495
March 2010 Montreal, PQ eXplorance Inc. by invitation
Wed October 28, 2009 Beijing, China Icograda World Congress 2009 see host site
Thu April 30, 2009 San Francisco, CA Voices That Matter Web Design Conference speaker breakfast
Thu April 2, 2009 Delhi, India World Summit Award Grand Jury by invitation
Thu November 13, 2008 Ottawa, ON David Berman Communications $495
Mon July 6, 2008 Daegu Exhibition Conference Centre, Daegu, Korea Icograda Design Week in Daegu 2008 see host site
Tue April 29, 2008 Ottawa, ON David Berman Communications $495
Thu March 13, 2008 Tunney’s Pasture, Ottawa, ON Statistics Canada private event
Tue February 19, 2008 Tunney’s Pasture, Ottawa, ON Health Canada private event
Wed November 7, 2007 Minto Business Centre, Ottawa, ON David Berman Communications $495
Thu November 9, 2006 Minto Business Centre, Ottawa, ON David Berman Communications $495
Thu February 16, 2006 Minto Business Centre, Ottawa, ON David Berman Communications SOLD OUT
Tue December 6, 2005 Oslo, Norway Norwegian Design Council SOLD OUT
Thu October 20, 2005 Minto Business Centre, Ottawa, ON David Berman Communications SOLD OUT
Thu June 9, 2005 Minto Business Centre, Ottawa, ON David Berman Communications $495
Tue December 22, 2004 Tunney’s Pasture, Ottawa, ON Health Canada private event

*Discount packages for non-profits, and travel subsidies available. Additional discounts available for groups over 3 people. Call (613) 728-6777 for details.

All prices, offerings, and dates subject to change without notice.

To register for a course given by our own organization, register online or call (613) 728-6777.

Event Schedule (all events)

*Discount packages for non-profits, and travel subsidies available. Additional discounts available for groups over 3 people. Call (613) 728-6777 for details.

All prices, offerings, and dates subject to change without notice.

To register for a course given by our own organization, register
online
or call (613) 728-6777.

Event Schedule (all events)

“Very understandable and fun.”

– Liz Breines, Ministry of Trade and
Industry, Oslo (Norway)

“Highly valuable.”

– Maureen Quirouet, Parliament of Canada

Resources

RESOURCES FOR ATTENDEES

For the convenience of course attendees, we provide this list of hypertext links and books cited in this course’s learning guide roughly in the order they appear in the course and learning guide:

Legislation, lawsuits, and standards

Canada
USA
Other countries
Global

Accessibility guidelines

Assistive technologies and techniques

Visual difficulties
Dexterity/mobility/motor difficulties

 

Hearing difficulties

iOS Accessibility

Android, Windows Phone Accessibility

WCAG 2.0 (including Success Criteria Level A and AA, in order)

Guideline 1.1: Text Alternatives
Guideline 1.2: Time-based Media
Guideline 1.3: Adaptable
Guideline 1.4: Distinguishable
Guideline 2.1: Keyboard Accessible
Guideline 2.2: Enough Time
Guideline 2.3: Seizures
Guideline 2.4: Navigable
Guideline 3.1: Readable
Guideline 3.2: Predictable
Guideline 3.3: Input Assistance
Guideline 4.1: Compatible, etc.

Testing tools for web and mobile

WCAG 2.1 (including the new Success Criteria Level A and AA, in order)

Document standards, techniques and testing

 

Instructional design software: Adobe Captivate

Instructional design software: Articulate Storyline

Instructional design software: other

Accessible virtual classroom platforms

Introduction to Online Learning and Accessibility

Accessible content management

White papers

Other accessibility links

 

Register

Choose the registration approach that’s easiest for you:

  • use our secure form below (for credit cards, PayPal, or purchase orders)
  • … or call 613-728-6777 to register over the phone
  • … or download our registration form PDF, and fax it back to 613-482-4777
  • …or register at Eventbrite

Course Registration Form:

Ce formulaire Web disponible aussi en français


Add Your Comment