Microsoft Excel and PowerPoint Training 21.0
Course Content
Welcome Onboard
-
Excel and PPT Shortcuts
-
How To Navigate LMS
02:12 -
How to Submit Assignment
01:35 -
Sorting and filtering
23:57
Excel
-
Getting Started with EXCEL
01:05:17 -
Data Cleansing
48:09 -
Data Cleansing Continued.
13:52 -
Data Cleansing Assignment
-
Sorting and Filtering
23:56 -
Date Functions (Working with dates)
45:13 -
Text Functions & Data Separation
24:43 -
List Management
-
Text Function Assignment
-
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
01:04:35 -
Cell Ref & Tables Assignment
-
Logical Functions
46:37 -
Pivot tables and charts
01:49:53 -
Pivot Table Assignment
-
Data Validation
11:19 -
Advanced Lookup Function
01:05:36 -
Logical Function Assignment
-
Advanced Vlookup Assignment
-
Statistics function
34:52 -
Stat Conditional Function Assignment
-
Conditional formatting
35:13 -
Questions and Answer
-
Excel New function 2021/2022
15:51 -
Excel Dashboard
01:49:02 -
Financial function & Whatif Analysis.
36:02 -
Power Query(GTA)
49:10 -
Excel dashboard continued
-
Artificial intelligence in Excel
52:05 -
Macro and Excel New Functions
-
Solution to Data Cleansing Assignment
13:33 -
Assignment Presentation
19:05 -
logical function assignment
11:33 -
look up assignmnet
17:42 -
Statistics function assignment
13:43
PowerPoint
-
Intro to PowerPoint
58:07 -
Presentations 2
-
Delivering Amazing Presentations
01:55:14 -
Powerpoint interface
-
Artificial intelligence in PowerPoint
51:44 -
Assignment 2
-
Designing Organogram with PowerPoint
00:00 -
Assignments
-
Powerpoint themes and layout
Career Support Session
-
Career Support Session
Student Ratings & Reviews
No Review Yet