Microsoft Excel and PowerPoint 18.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:07:35 -
Data Cleansing
51:03 -
Data Cleansing Continued.
21:05 -
Data Cleansing Assignment
-
Text Functions & Data Separation
38:22 -
Text Function Assignment
-
Date Functions (Working with dates)
01:01:59 -
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
01:10:21 -
Cell Ref & Tables Assignment
-
Logical Functions
35:28 -
Pivot tables and charts
02:05:56 -
Pivot tables continuation
01:09:04 -
Advanced Lookup Function
-
Logical Function Assignment
-
List Management
18:42 -
Data Validation
20:36 -
Advanced Vlookup, Financial function & Whatif Analysis.
01:08:50 -
Advanced Vlookup Assignment
-
Statistics function
01:06:07 -
Stat Conditional Function Assignment
-
Conditional formatting
44:41 -
Questions and Answer
-
Excel New function 2021/2022
19:35 -
Excel Dashboard
-
Financial function & Whatif Analysis.
01:02:18 -
Power Query(GTA)
29:09 -
Excel dashboard continued
-
Artificial intelligence in Excel
39:12 -
Assignment
27:12 -
Macro and Excel New Functions
00:00 -
Group Presentations
-
Assignment 2
21:39
PowerPoint
-
Intro to PowerPoint
51:25 -
Powerpoint interface
46:12 -
Delivering Amazing Presentations
55:26 -
Artificial intelligence in PowerPoint
01:03:07 -
Group Presentations
-
Designing Organogram with PowerPoint
14:58 -
Assignments
14:10 -
Powerpoint themes and layout
54:05 -
Assignment 2
16:05
Student Ratings & Reviews
No Review Yet