Microsoft Excel Basic to Advanced Accelerator Program 25.0 Tier 2
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
45:58 -
Data Cleansing
01:05:51 -
Data Cleansing Continued.
00:00 -
Data Cleansing Assignment
-
Sorting and Filtering
-
Date Functions (Working with dates)
01:01:30 -
Text Functions & Data Separation
29:37 -
List Management
00:00 -
Text Function Assignment
-
Date and Time Function Assignment
-
Cells Ref Ranges and Tables
01:16:45 -
Cell Ref & Tables Assignment
-
Logical Functions
00:00 -
Pivot tables and charts
02:03:12 -
Pivot Table Assignment
-
Data Validation
00:00 -
Advanced Lookup Function
00:00 -
Logical Function Assignment
-
Advanced Vlookup Assignment
-
Statistics function
00:00 -
Stat Conditional Function Assignment
-
Conditional formatting
00:00 -
Questions and Answer
-
Excel New function 2021/2022
-
Excel Dashboard
00:00 -
Financial function & Whatif Analysis.
-
Financial funtion & whatif Analysis cont’d
00:00 -
Power Query(GTA)
00:00 -
Excel dashboard continued
-
Artificial intelligence in Excel
00:00 -
Assignment
00:00 -
Assignment 2
-
Macro and Excel New Functions
00:00 -
Presentation
-
Group Presentations
-
Assignment Presentation
PowerPoint
-
Intro to PowerPoint
00:00 -
Powerpoint interface
-
Delivering Amazing Presentations
-
Artificial intelligence in PowerPoint
-
Group Presentations
-
Assignment 2
-
Designing Organogram with PowerPoint
-
Assignments
-
Powerpoint themes and layout
Data Visualization with PowerBI
-
Introduction to Power BI Desktop
28:25 -
Lab 1: Getting Data into Power BI Desktop
-
Data preparation Steps in Power BI
-
Lab 2: Data Integration, Preparation & Cleansing using Power Query
-
Data Modelling
18:05 -
Lab 3 : Data Modeling in Power BI Desktop using Sales Data.
-
Data Visualization
22:32 -
Lab 4: Data Visualization. (DAX)
31:16 -
Power BI Series
-
Power BI Quiz
Career Support Session
-
Career Support Session
Student Ratings & Reviews
No Review Yet