Advanced Spreadsheet with Microsoft Excel


Course Title: Advanced Spreadsheet with Microsoft Excel

Course Description

Advanced Spreadsheet with Microsoft Excel is a course specially designed for individuals with visual impairment, optimized for use with NVDA or JAWS screen readers. You’ll learn to confidently manage, analyze, and visualize complex data using keyboard shortcuts and accessible features, all while building proficiency with Excel’s most powerful tools.

Who should take this course?

  • Individuals with visual impairment who already have basic Excel skills and want to master advanced Excel functions with screen reader support
  • Anyone who uses JAWS or NVDA screen readers and wants to unlock the full potential of Microsoft Excel.
  • Professionals aiming to manage large datasets and perform sophisticated analysis accessibly
  • Students and analysts seeking an inclusive learning environment for Excel’s advanced capabilities

What you will learn

  • Manage large datasets across multiple worksheets using grouping, sorting, and filtering.
  • Create, format, and manage tables for effective data organization and analysis.
  • Build and troubleshoot complex formulas including advanced lookup, array, logical, text, and date functions.
  • Use data analysis tools like PivotTables, PivotCharts, subtotals, outlines, and conditional formatting.
  • Create, edit, and navigate charts with added alternative text for accessibility.
  • Collaborate by tracking changes, managing comments, and securely sharing workbooks.
  • Import data from external sources and export workbooks to accessible formats.
  • Apply accessibility best practices to design screen reader–friendly tables and check spreadsheet accessibility.

What you will gain

  • Certificate of proficiency after successfully finishing the course
  • Confidence in using advanced Excel features with a screen reader.
  • Practical skills to organize, analyze, and present data independently.
  • Knowledge of accessibility best practices to create spreadsheets that are easy to navigate and understand for all users.
  • Enhanced productivity and independence in academic, professional, or personal projects involving Excel.
  • Audio recordings of lessons for ongoing review and practice
  • Comprehensive course materials and reference guides
  • Continuous lifetime support for your learning journey
  • Opportunity to join our alumni page and connect with fellow graduates

Course Objectives

By the end of the lesson, learners will be able to:

  • Navigate and manage large Excel datasets using NVDA or JAWS keyboard shortcuts.
  • Apply advanced sorting, filtering, and data validation to organize data efficiently.
  • Create and format tables with structured references and accessible styles.
  • Utilize and troubleshoot complex formulas including lookup, logical, text, and date functions.
  • Design and manage PivotTables, PivotCharts, and apply conditional formatting.
  • Create and edit charts with descriptive alt text for accessible data interpretation.
  • Use Excel’s Accessibility Checker to identify and fix accessibility issues.

Course Duration

4 Weeks (8 lessons: 2 lessons a week; 90 minutes per lesson)

Difficulty Level: Advanced

Course Requirements

  1. Prior knowledge in Basic Excel
  2. Computer running Windows 10 or 11
  3. Microsoft Office 2016 or later versions
  4. Strong internet connection.
  5. NVDA or JAWS screen reader

Amount:

Group Class: US$30.00 or GHS321.00 (for Ghanaians only)

Private Class: US$75.00 or GHS803.00 (for Ghanaians only)

Select Learning Preference

Select Options to Enroll

Accessibility Toolbar