Course Title: Data Analysis and Visualization with Microsoft Excel
Course Description:
Data Analysis and Visualization with Microsoft Excel is a course designed for visually impaired individuals who want to harness the full power of Microsoft Excel for data-driven decision-making. This course focuses on advanced techniques for preparing, analyzing, and visualizing data, all taught with step-by-step guidance tailored for JAWS or NVDA screen reader users. Through hands-on exercises and real-world examples, learners will develop the skills to efficiently manage large datasets, apply complex formulas, create insightful PivotTables and charts, and implement accessibility best practices. By the end of the course, participants will be equipped to perform sophisticated data analysis and present findings with confidence and clarity.
Who should take this course?
- Individuals with visual impairment who want to develop practical skills in data analysis and visualization
- Anyone seeking to analyze, interpret, and present data effectively using accessible tools
- Students, professionals, and analysts aiming to strengthen their data analytics and reporting skills
What you will learn:
- Advanced data preparation, cleaning, and transformation techniques
- Using logical, lookup, reference, text, and date/time functions for data analysis
- Creating and customizing PivotTables and PivotCharts for meaningful data summarization
- Applying conditional formatting, sparklines, and advanced charts for data visualization
- Using statistical and analytical tools, including descriptive statistics and regression analysis
- Reporting and communicating insights derived from analyzed data
- Protecting sensitive data and collaborating effectively on Excel workbooks
- Implementing accessibility best practices for spreadsheets, tables, and charts
What you will gain:
- Confidence and proficiency in performing advanced data analysis and visualization using Excel with JAWS or NVDA
- Practical skills to manage, analyze, and visualize complex datasets
- Ability to create accessible, professional reports and dashboards
- Certificate of completion upon successful course completion
- Audio recordings of lessons for continuous review and practice
- Comprehensive course materials and reference guides
- Continuous lifetime support throughout your learning journey
- Opportunity to join our alumni page and connect with fellow graduates
Course Objectives:
By the end of the course, learners will be able to:
- Demonstrate a strong understanding of Excel features and tools used in data analysis and visualization.
- Apply analytical thinking and problem-solving skills using Excel as a primary data analysis platform.
- Efficiently manage, analyze, and interpret large datasets within Excel.
- Create dynamic, accessible reports and visualizations to support data-driven decision-making.
- Use advanced Excel functions to automate and streamline data analysis workflows.
- Apply best practices in organizing, cleaning, and presenting data for analytical purposes.
Course Duration:
6 Weeks (12 lessons: 2 lessons per week; 90 minutes per lesson)
Difficulty Level:
Advanced
Course Requirements
- Prior knowledge of Basic or intermediate Excel
- A computer running Windows 10 or 11
- Microsoft Office 2016 or later
- Stable internet connection
- NVDA or JAWS screen reader
Amount
Group Class: US$40.00 or GHS430.00 (for Ghanaians only)
Private Class: US$100.00 or GHS1070.00