Microsoft Excel and PowerPoint 11.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:04:21 -
Data Cleansing
45:48 -
Data Cleansing Contd
48:55 -
Data Cleansing Cont’d
13:55 -
Data Cleansing Assignment
-
Text Functions & Data Separation
37:50 -
Text Function Assignment
-
Date Functions (Working with dates)
56:49 -
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
55:27 -
Cell Ref & Tables Assignment
-
Pivot tables and charts
01:47:48 -
QA session
24:39 -
List Management
35:26 -
Data Validation
17:54 -
Advanced Vlookup, Financial function & Whatif Analysis.
01:10:37 -
Advanced Vlookup Assignment
-
Logical Functions
29:31 -
Logical Function Assignment
-
Statistics/Conditional function
01:06:31 -
Stat Conditional Function Assignment
-
Conditional formatting
37:40 -
Group Final Project
-
Power Query(GTA)
37:16 -
Financial function & Whatif Analysis.
40:18 -
Excel Dashboard
01:16:48 -
Excel Dashboard CONT’D
45:20 -
Macro and Excel New Functions
46:24 -
Group Presentation
49:31 -
Excel Dashboard Submission
-
Group Project Submission
PowerPoint
-
Intro to PowerPoint
33:56 -
Delivering Amazing Presentations
01:24:00 -
Delivering Amazing Presentations
-
Project Presentation
44:05 -
Project Presentation 2
14:51 -
Story Telling
19:04 -
Group Presentations
09:46 -
Delivering Amazing Presentations cont’d
01:20:15 -
Artificial Intelligence
54:04 -
Designing Organogram with powerpoint
01:02:51
Student Ratings & Reviews
No Review Yet