Advance MS Office with AI and ChatGPT - NKC

Course Instructor: LeapUp Edutech

FREE

Course Overview

Schedule of Classes

Course Curriculum

4 Subjects

Module 1 - Excel Basics and Financial Function

2 Exercises • 37 Learning Materials

Cell Referencing

Video

00:17:39

Workbook - Cell and References

DOC

Notes - Cell and Referencing

PDF

Assignment - Cell Referencing

PDF

Formatting

Video

00:41:00

Assignment - Formatting

PDF

Workbook - Formatting

DOC

Notes - Formatting

PDF

Conditional Formatting

Video

00:17:41

Assignment - Conditional Formatting

PDF

Workbook - Conditional Formatting

DOC

Notes - Conditional Formatting

PDF

Data Types

Data Type

Video

00:04:58

Workbook - Data Type

DOC

Notes - Data Type

PDF

Assignment - Data Type

DOC

Future Value, Data Table

Future Value and Database table

Video

00:09:04

Workbook - Future Value and Data table

DOC

Notes - Future Value and Datatable

PDF

Assignment - Future Value and Data table

DOC

IRR, XIRR, MIRR

IRR XIRR MIRR.mp4

Video

00:09:11

Workbook - IRR XIRR MIRR

DOC

Notes - IRR XIRR MIRR

PDF

Assignment - IRR XIRR MIRR

DOC

NPV, XNPV

NPV XNPV

Video

00:05:34

Workbook - NPV

DOC

Workbook - XNPV

DOC

Notes - NPV XNPV

PDF

EMI Schedule

EMI Schedule SYD DD

Video

00:15:09

Workbook - EMI Schedule

DOC

Workbook - SYD DD

DOC

Notes - EMI Schedule SYD DD

PDF

Assignment - EMI Schedule SYD DD

DOC

Shortcuts

Function Shortcuts

PDF

Ctrl Shortcuts

PDF

Mac Shortcuts

PDF

Assignment

Assignment Instruction

PDF

Assignment Submission

Assignment

Module 2 - Advance Function and Data Analysis

2 Exercises • 68 Learning Materials

DSum, DCount and DAverage

DSUM DCOUNT DAVERAGE

Video

00:14:31

Workbook - Dsum

DOC

Workbook - Dcount

DOC

Notes - DSUM DCOUNT DAVERAGE

DOC

Workbook - Daverage

DOC

Assignment - DSUM, DCOUNT & DAverage

DOC

Look up Index and Match

Look up Match

Video

00:10:20

Index and Match Function

Video

00:13:39

Notes - Lookup

DOC

Notes - Index and Match

DOC

Workbook - Index and Match

DOC

Assignment - VLookup HLookup Match

DOC

Assignment - Index and Match

DOC

Data Table Goal Seek and Solver

Video

00:12:34

Notess - Datatable

DOC

Workbook - Datatable and Goal Seek and Solver

DOC

Assignment - Goal Seek and Excel Solver

DOC

Text Function

Video

00:14:45

Text Function Part 2

Video

00:17:17

Notes - Text Function

PDF

Workbook - Text Functions

DOC

Assignment - Text Functions

DOC

If and Nested If Function

If Function

Video

00:05:50

Advanced Nested If

Video

00:18:03

Nested If and Ifs

Video

00:09:10

Notes - IF Nested IFs

DOC

Workbook - Ifs and Nested Ifs

DOC

Assignment - If and Nested If

DOC

Date and Time Function

Date and Time Functions

Video

00:27:08

Notes - Date and Time

DOC

Workbook - Date and Time Functions

DOC

Assignment - Date and Time

DOC

Get Data

Get Data Part 1

Video

00:10:40

Get Data Part 2

Video

00:18:52

Get Data Part 3

Video

00:17:29

Notes - Get Data

DOC

Workbook - Get Data

DOC

Assignment - Get Data

DOC

Slicers and Filters

Pivot Slicers and Filters

Video

00:36:33

Workbook - Pivot Slicer and Filters

DOC

Notes - Pivot Table and Slicer

DOC

Assignment - Pivot Table and Slicer

DOC

Text to Column

Video

00:08:00

Notes - Text to Column

DOC

Workbook - Text to Column and Transponse

DOC

Assignment - Text to Column

DOC

Multi Level Sorting and Subtotal

Multi Level Sorting

Video

00:16:36

Notes - Multi Level Sorting

PDF

Assignment - Multi Level Sorting and Course Content

DOC

Workbook - Multi Level Sorting

DOC

Stock History

Video

00:05:40

Workbook - Stock History

DOC

Notes - Stock History

DOC

Assignment - Stock History

DOC

Basic Charts

Video

00:17:46

Workbook - Charts

DOC

Notes - Charts

DOC

Assignments - Charts

DOC

Advance Charts

Advanced Charts - Part 1

Video

00:18:15

Advanced Charts - Part 2

Video

00:17:37

Workbook - Charts

DOC

Notes - Charts

DOC

Assignment - Excel Chart

PDF

Flash Fill and Formatting as table

Formatting as Table and Flash Fill

Video

00:12:25

Workbook - Formatting as Table and FlashFill

DOC

Notes - Flash Fill and Formatting as Table

DOC

Assignment - Flash Fill and Formatting Table

DOC

MS Office Internal.

Assignment

Assignment Instruction

PDF

Assignment Submission

Assignment

Module 3 - ChatGPT and AI with MS Office

9 Learning Materials

Videos

3.1 Integrating AI adding in Excel.

Video

00:25:50

3.2 Chat GPT formulas in Excel.

Video

00:27:50

3.3 AI aided Excel Formulas

Video

00:09:14

3.4 GhostWriter in MS Word.

Video

00:16:34

Workbook and Assignment.

Workbook Chatgpt in Excel

DOC

Workbook AI aided formulas_

DOC

Workbook ChatGPT for Excel

DOC

Working File GhostWriter AI in Word

DOC

Working File Beautiful AI

PPT

Module 4 Analysis, Power Point and Story Board

24 Learning Materials

4.1 Addition Method, Remove Duplicate, Freeze Pane

4.1 Addition Method Remove Duplicate Freeze Pane

Video

00:30:39

Addition Method Remove Duplicate Freeze Pane.

DOC

4.2 Logical Operators Concatenate Functions.

Logical Operators Concatenate Functions.

Video

00:30:27

Logical Operators Concatenate Functions.

DOC

4.3 Excel ShortCut Keys Cell Reference

Excel ShortCut Keys Cell Reference

Video

00:31:01

Excel ShortCut Keys Cell Reference

DOC

4.4 Advance Filter and Custom View.

Advance Filter and Custom View.

Video

00:30:50

Advance Filter and Custom View.

DOC

4.5 Data Validation.

Data Validation.

Video

00:30:34

Data Validation.

DOC

4.6 Pivot Table and Basic Excel Functions.

Pivot Table and Basic Excel Functions

Pivot Table and Basic Excel Functions.

DOC

Pivot Table and Basic Excel Functions.

Video

00:30:38

4.7 Sparkline & Insert Tab.

Sparkline & Insert Tab.

Video

00:30:56

4.8 Financial function Statical Function

Financial function Statical Function

Video

00:33:22

4.9 AI Function & VBA Code.

AI Function & VBA Code.

Video

00:30:27

AI Function & VBA Code.

DOC

4.10 Google Gemini and ChatGPT

Google Gemini and ChatGPT

Video

00:31:43

4.11 Conditional Formatting with ChatGPT

Conditional Formatting with ChatGPT

Video

00:30:45

Conditional Formatting with ChatGPT

DOC

4.12 Dashboard in Excel.

Dashboard in Excel.

Video

00:31:19

Dashboard in Excel.

DOC

Workbook and Assignment.

Practice Assignment 1

DOC

Practice Assignment 2

DOC

Advance MS Office External Test.

Course Instructor

LeapUp Edutech

648 Courses • 49704 Students