Microsoft Excel and PowerPoint 16.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:10:44 -
Data Cleansing
51:31 -
Data Cleansing Assignment
-
Text Functions & Data Separation
56:21 -
Text Function Assignment
-
Date Functions (Working with dates)
56:29 -
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
01:03:33 -
Cell Ref & Tables Assignment
-
Logical Functions
50:12 -
Pivot tables and charts
02:21:16 -
Advanced Vlookup, Financial function & Whatif Analysis.
01:18:31 -
Logical Function Assignment
-
List Management
18:34 -
Data Validation
20:06 -
Advanced Vlookup, Financial function & Whatif Analysis.
-
Advanced Vlookup Assignment
-
Statistics function
42:27 -
Statistics Conditional Assignment
20:37 -
Stat Conditional Function Assignment
-
Conditional formatting
45:18 -
Questions and Answer
-
Excel New function 2021/2022
30:25 -
Financial function & Whatif Analysis.
45:25 -
Power Query(GTA)
37:54 -
Excel Dashboard
01:18:42 -
Artificial intelligence in Excel
17:52 -
Logic Functions Assignment
16:13 -
Macro and Excel New Functions
-
Group Presentations
-
Advanced lookup assignment
00:00
PowerPoint
-
Intro to PowerPoint
01:34:18 -
Delivering Amazing Presentations
01:39:45 -
Artificial intelligence in PowerPoint
01:11:06 -
Group Presentations
-
Designing Organogram with PowerPoint
17:53 -
Assignments
Student Ratings & Reviews
No Review Yet