5.00
(1 Rating)
Microsoft Excel and PowerPoint 14.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:11:59 -
Data Cleansing
52:14 -
RECAP; Intro to Excel & Data Cleansing
02:23:58 -
Data Cleansing Assignment
-
Text Functions & Data Separation
34:11 -
Text Function Assignment
-
Date Functions (Working with dates)
01:02:52 -
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
57:24 -
Cell Ref & Tables Assignment
-
Pivot tables and charts
01:26:34 -
List Management
39:54 -
Data Validation
25:18 -
Logical Functions
37:45 -
Logical Function Assignment
-
Advanced Vlookup, Financial function & Whatif Analysis.
01:05:13 -
Advanced Vlookup Assignment
-
Statistics/Conditional function
48:31 -
Stat Conditional Function Assignment
-
Conditional formatting
40:44 -
Questions and Answer
27:42 -
Financial function & Whatif Analysis.
22:22 -
Excel New function 2021/2022
01:04:04 -
Power Query(GTA)
44:50 -
Excel Dashboard
-
Excel dashboard continued
-
Artificial intelligence in Excel
-
Assignment
-
Macro and Excel New Functions
-
Group Presentations
01:38:31
PowerPoint
-
Intro to PowerPoint
01:53:51 -
Delivering Amazing Presentations
01:57:06 -
Artificial intelligence in PowerPoint
01:41:33 -
Group Presentations
-
Designing Organogram with PowerPoint
-
Assignments
Student Ratings & Reviews
5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
GREAT