Microsoft Excel and PowerPoint 10.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 (July 2024)
55:21 -
Getting Started with EXCEL (Aug 3rd, 2024)
01:38:49 -
Data Cleansing (July 2024)
58:52 -
Data Cleansing Contd (July 2024)
46:16 -
Data Cleansing (Aug 4th, 2024)
01:30:45 -
Data Cleansing RECAP (Aug 10th, 2024)
40:45 -
Data Cleansing Assignment
-
Text Functions & Data Separation
42:57 -
Text Function Assignment
-
Date functions (Working with dates)
38:03 -
Date and Time Function Assignment
-
List Management
31:34 -
Data Validation
23:39 -
Cells Ref Ranges and Tables
01:06:55 -
Cell Ref & Tables Assignment
-
Pivot tables and charts
02:15:05 -
Advanced Vlookup, Financial function & Whatif Analysis.
01:34:54 -
Advanced Vlookup Assignment
-
Logical Functions
28:32 -
Logical Function Assignment
-
Statistics/Conditional function
01:06:54 -
Stat Conditional Function Assignment
-
Conditional formatting
58:19 -
Group Final Project
-
Project Submissions
-
Macro and Excel New Functions
29:10 -
Power Query(GTA)
51:00 -
Financial function & Whatif Analysis.
33:53 -
Group Presentation
38:33 -
Group Presentation 2
01:13:38 -
logical function Assignment
27:48 -
Group Presentation
01:17:12 -
Excel Dashboard
PowerPoint
-
Intro to PowerPoint
53:24 -
Delivering Amazing Presentations
01:25:32 -
Delivering Amazing Presentations
-
Designing Organogram with PowerPoint
02:06:14
Student Ratings & Reviews
No Review Yet