Microsoft Excel and PowerPoint 13.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:02:59 -
Data Cleansing
01:57:47 -
Data Cleansing Contd
24:08 -
Data Cleansing Assignment
-
Text Functions & Data Separation
01:29:49 -
Text Function Assignment
-
Date Functions (Working with dates)
58:31 -
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
53:54 -
Cell Ref & Tables Assignment
-
Pivot tables and charts
01:39:24 -
List Management
26:04 -
Data Validation
40:55 -
Logical Functions
34:28 -
Logical Function Assignment
-
Advanced Vlookup, Financial function & Whatif Analysis.
01:01:31 -
Advanced Vlookup Assignment
-
Statistics/Conditional function
54:36 -
Stat Conditional Function Assignment
-
Conditional formatting
01:03:13 -
Excel New function 2021/2022
34:05 -
Power Query(GTA)
33:46 -
Excel Dashboard
-
Excel dashboard continued
01:10:25 -
Artificial intelligence in Excel
01:23:31 -
Group Presentations
24:47 -
Financial function & Whatif Analysis.
24:48 -
Assignment
33:27 -
Macro and Excel New Functions
PowerPoint
-
Intro to PowerPoint
02:03:17 -
Delivering Amazing Presentations
01:54:22 -
Delivering Amazing Presentations 2
26:21 -
Group Presentations
36:57 -
Designing Organogram with PowerPoint
01:06:15 -
Artificial intelligence in PowerPoint
01:05:26 -
Assignments
51:59
Student Ratings & Reviews
No Review Yet