Microsoft Excel and PowerPoint 15.0
Course Content
Welcome Onboard
-
Excel and PPT Shortcuts
-
How To Navigate LMS
02:12 -
How to Submit Assignment
Excel
-
Getting Started with EXCEL
01:02:54 -
Data Cleansing
50:19 -
RECAP; Intro to Excel & Data Cleansing
29:17 -
Data Cleansing Assignment
-
Text Functions & Data Separation
42:24 -
Text Function Assignment
-
Date Functions (Working with dates)
52:59 -
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
01:13:07 -
Cell Ref & Tables Assignment
-
Pivot tables and charts
02:13:10 -
Advanced Lookup Function
01:14:12 -
Logical Functions
41:13 -
Logical Function Assignment
-
List Management
19:56 -
Data Validation
34:53 -
Advanced Vlookup, Financial function & Whatif Analysis.
40:07 -
Advanced Vlookup Assignment
-
Statistics function
54:06 -
Stat Conditional Function Assignment
-
Conditional formatting
01:12:08 -
Questions and Answer
-
Excel New function 2021/2022
43:49 -
Excel Dashboard
01:37:29 -
Financial function & Whatif Analysis.
-
Power Query(GTA)
02:01:20 -
Excel dashboard continued
-
Artificial intelligence in Excel
-
Assignment
26:10 -
Macro and Excel New Functions
-
Group Presentations
PowerPoint
-
Intro to PowerPoint
01:12:20 -
Delivering Amazing Presentations
01:30:37 -
Designing Organogram with PowerPoint
01:39:09 -
Artificial intelligence in PowerPoint
-
Group Presentations
-
Assignments
Student Ratings & Reviews
No Review Yet