Microsoft Excel and PowerPoint Training 20.0
Course Content
Welcome Onboard
-
Excel and PPT Shortcuts
-
How To Navigate LMS
02:11 -
How to Submit Assignment
01:35
Excel
-
Getting Started with EXCEL
01:05:16 -
Data Cleansing
48:09 -
Data Cleansing Continued.
46:46 -
Data Cleansing Assignment
-
Text Functions & Data Separation
36:08 -
List Management
29:38 -
Text Function Assignment
-
Pivot tables and charts
02:09:20 -
Date Functions (Working with dates)
01:09:09 -
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
42:14 -
Cell Ref & Tables Assignment
-
Data Validation
18:23 -
Logical Function
28:22 -
Pivot Tables Assignment
-
Advanced Lookup Function
01:05:27 -
Advanced Lookup Function 2
23:15 -
Presentation
27:06 -
Logical Function Assignment
-
Advanced Vlookup Assignment
-
Statistics function
54:15 -
Stat Conditional Function Assignment
-
Conditional formatting
43:01 -
Questions and Answer
-
Excel New function
48:16 -
Excel Dashboard
01:24:39 -
Financial function & Whatif Analysis.
32:35 -
Power Query(GTA)
01:07:05 -
Excel dashboard continued
-
Artificial intelligence in Excel
-
Assignment
11:17 -
Assignment 2
27:40 -
Macro and Excel New Functions
-
Group Presentations
18:32 -
Assignment Presentation
20:16
PowerPoint
-
Intro to PowerPoint
01:31:12 -
Powerpoint interface
-
Delivering Amazing Presentations
01:45:01 -
Delivering Amazing Presentations 2
01:53:26 -
Artificial intelligence in PowerPoint
01:06:59 -
Group Presentations
-
Assignment 2
-
Designing Organogram with PowerPoint
41:54 -
Assignments
-
Powerpoint themes and layout
Student Ratings & Reviews
No Review Yet