- 1 Section
- 12 Lessons
- 8 Quizzes
- 0m Duration
Understanding Chat GPT with Excel
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:
- Set up and integrate ChatGPT with Excel
- Generate basic Excel formulas with ChatGPT
- Use ChatGPT to generate formulas to sort and filter data in Excel
- Use ChatGPT to generate advanced formulas such as VLOOKUP, XLOOKUP, and Index Match
- 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.
You must be logged in and enrolled to submit a review .
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
