Microsoft Excel and PowerPoint 12.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:09:51 -
Data Cleansing
53:29 -
Data Cleansing Contd
53:35 -
Data Cleansing Assignment
-
Text Functions & Data Separation
28:03 -
Text Function Assignment
-
Date Functions (Working with dates)
49:58 -
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
01:16:33 -
Cell Ref & Tables Assignment
-
Pivot tables and charts
02:10:19 -
List Management
25:12 -
Data Validation
28:24 -
Assignment Presentation
35:20 -
Logical Functions
35:01 -
Logical Function Assignment
-
Excel Dashboard
43:42 -
Advanced Vlookup, Financial function & Whatif Analysis.
01:07:40 -
Advanced Vlookup Assignment
-
Statistics/Conditional function
50:35 -
Stat Conditional Function Assignment
-
Conditional formatting
30:02 -
Conditional formating CONT”D
28:34 -
Artificial intelligence in excel
35:40 -
Group Presentations
26:43 -
Macro and Excel New Functions
27:54 -
Power Query(GTA)
01:07:38 -
Assignment and review
57:36 -
Financial function & Whatif Analysis.
-
Dash Board presentation
13:47
PowerPoint
-
Intro to PowerPoint
43:28 -
Delivering Amazing Presentations
01:53:26 -
Delivering Amazing Presentations Cont’d
01:35:31 -
Designing Organogram with PowerPoint
45:11 -
Artificial intelligence in PowerPoint
01:13:37 -
Group Presentations
24:46
Student Ratings & Reviews
No Review Yet