Microsoft Excel and PowerPoint 17.0
Course Content
Welcome Onboard
-
Excel and PPT Shortcuts
-
How To Navigate LMS
02:12 -
How to Submit Assignment
01:35
Excel
-
Getting Started with EXCEL
01:03:02 -
Data Cleansing
53:04 -
Data Cleansing Continued.
19:55 -
Data Cleansing Assignment
-
Text Functions & Data Separation
27:28 -
Text Function Assignment
-
Date Functions (Working with dates)
01:10:10 -
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
01:08:48 -
Cell Ref & Tables Assignment
-
Logic Function Assignment
13:19 -
Pivot tables and charts
02:03:41 -
Advanced Lookup Function
01:01:29 -
Logical Function Assignment
-
Logical Functions
29:22 -
List Management
17:27 -
Data Validation
27:36 -
Advanced Vlookup, Financial function & Whatif Analysis.
-
Advanced Vlookup Assignment
-
Statistics function
40:55 -
Stat Conditional Function Assignment
-
Conditional formatting
27:03 -
Questions and Answer
-
Excel New function 2021/2022
14:37 -
Excel Dashboard
01:28:47 -
Excel dashboard continued
-
Financial function & Whatif Analysis.
34:40 -
Power Query(GTA)
01:44:46 -
Artificial intelligence in Excel
01:22:58 -
Assignment
19:38 -
Group Presentations
PowerPoint
-
Intro to PowerPoint
01:30:12 -
Delivering Amazing Presentations
01:41:42 -
Artificial intelligence in PowerPoint
01:22:58 -
Group Presentations
-
Creatin A Business Intelligence Report
01:34:15 -
Designing Organogram with PowerPoint
19:57 -
Assignments
Student Ratings & Reviews
No Review Yet