Microsoft Excel and PowerPoint Training 22.0
By Abdiel Wilson
Uncategorized
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
53:21 -
Data Cleansing
56:20 -
Data Cleansing Continued.
-
Data Cleansing Assignment
-
Sorting and Filtering
-
Date Functions (Working with dates)
57:09 -
Text Functions & Data Separation
26:48 -
List Management
28:18 -
Text Function Assignment
-
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
55:50 -
Cell Ref & Tables Assignment
-
Logical Functions
00:00 -
Pivot tables and charts
02:01:29 -
Pivot Table Assignment
-
Data Validation
20:56 -
Advanced Lookup Function
01:01:57 -
Logical Function Assignment
-
Advanced Vlookup Assignment
-
Statistics Conditional function
01:07:30 -
Stat Conditional Function Assignment
-
Conditional formatting
26:39 -
Questions and Answer
-
Excel New function 2021/2022
-
Excel Dashboard
00:00 -
Financial function & Whatif Analysis.
00:00 -
Financial funtion & whatif Analysis cont’d
-
Power Query(GTA)
01:22:48 -
assignment cell refrencing
00:00 -
Assignment logical functions
00:00 -
Assignment Data Cleansing
00:00 -
assignement Text functions
00:00 -
Excel dashboard continued
-
Artificial intelligence in Excel
00:00 -
Assignment Review
00:00 -
Assignment 2
-
Macro and Excel New Functions
-
Presentation
-
Group Presentations
-
Assignment Presentation
PowerPoint
-
Intro to PowerPoint
01:47:52 -
Powerpoint interface
-
Delivering Amazing Presentations
00:00 -
Artificial intelligence in PowerPoint
00:00 -
Group Presentations
-
Assignment 2
-
Designing Organogram with PowerPoint
00:00 -
Assignments
-
Powerpoint themes and layout
-
Dashboard in powerpoint
00:00
Career Support Session
-
Career Support Session
Student Ratings & Reviews
No Review Yet