Excel with Chat GPT for visually impaired

Excel with Chat GPT for visually impaired

Intermediate
Excel with Chat GPT for visually impaired
Overview
Curriculum

This course is specifically designed for visually impaired students and students with low vision, who aim to excel in computer skills, with a special focus on leveraging AI to enhance efficiency, and productivity. Tailored to meet the evolving demands of AI knowledge in today's job market, this program equips learners with the tools they need to stay competitive.

 

*Note: To fully benefit from the course, it is recommended to use Office 2019 or later, with Office 365 being the preferred option for optimal results.

 

Course Title:

Excel Using ChatGPT:  For Visually Impaired Students

Learning Outcomes

After completing the course, the learners will be able to:

 

  1. Set up and integrate ChatGPT with Excel
  2. Generate basic Excel formulas with ChatGPT
  3. Use ChatGPT to generate formulas to sort and filter data in Excel
  4. Use ChatGPT to generate advanced formulas such as VLOOKUP, XLOOKUP, and Index Match
  5.  Use ChatGPT for guidance and directions in Excel

 

Course Category: MS Office

Language: English

Type: Free

Target Audience: Students, In Job, Job seeker

TOC

Session no

Session Name

Lesson no

Lesson name

1

Introduction and Setting Up

1

Understanding Excel and ChatGPT

2

Setting Up ChatGPT

2

Familiarising with Basic Operators

3

Getting Familiar with Basic Operators Part-1

4

Getting Familiar with Basic Operators Part-2

3

Counting Data in Excel

5

COUNTIF Function

4

Sort & Filter Data in Excel

6

Sort Data Part-1

7

Sort Data Part-2

8

Filter Data Part-1

9

Filter Data Part-2

5

Using LOOKUP in Excel

10

VLOOKUP

11

XLOOKUP

12

Index Match

       

Session Descriptions:

Session 1 - Introduction and Setting Up

This session introduces the learners to setting up ChatGPT and integrating Microsoft Excel with ChatGPT.

Session 2 -  Familiarising with Basic Operators

This session will familiarise the learners with the basic operators of Microsoft Excel with the aid of ChatGPT for performing basic calculations.

Session 3 - Counting Data in Excel

This session will teach the learners to use Microsoft Excel with the support of ChatGPT to count data.

Session 4 - Sort & Filter Data in Excel

This session will teach the learners to use ChatGPT to sort and filter data in Microsoft Excel.

Session 5 - Using LOOKUP in Excel

This session will teach the learners to use LOOKUP in Excel and generate LOOKUP formulas using ChatGPT.

 

This course includes

Introduction and Setting Up

Familiarising with Basic Operators

Counting Data in Excel

Sort & Filter Data in Excel

Using lookup and Index in Excel

×

Free Lesson Videos:

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Related Courses

Scroll to top