Skip to main content
PROFICIENCY IN MICROSOFT EXCEL
0%
Previous
Course data
TRAINING OVERVIEW
Zoom Link Meeting
Course Outline:
Announcements
Trainer - Content Developer
MODULE 1: EXCEL HOME TAB AND RIBBON
SESSION 1: LECTURE VIDEO EXPLAINER
1.1 - Video Explainer - Home Tab and Ribbon in Depth
SESSION 2: LECTURE VIDEO EXPLAINER
2.1 - Video explainer - Conditional Activity Demonstration
SESSION 4: PRACTICE ACTIVITY WORKBOOK
3.1 - Activity Workbook Exercise (Conditional Formatting)
SESSION 5: QUIZ TEST
Quize Test 1
MODULE 2: EXCEL INSERT TAB AND RIBBON
SESSION 4: LECTURE VIDEO EXPLAINER
4.1 - Video explainer - Insert Tab and Ribbon
SESSION 5: LECTURE VIDEO EXPLAINER
5.1 - Pivot Tables Basics Demonstration
5.2 Pivot Table Workbook Task
SESSION 6: LECTURE VIDEO EXPLAINER
6.1 - Activity Workbook Exercise (Pivot Tables)
SESSION 7: LECTURE VIDEO EXPLAINER
7.1 Video Explainer - Slicers Instead of Filters.
SESSION 8: LECTURE VIDEO EXPLAINER
8.1 - Activity WorkBook Exercise (Slicers)
8.2 Virtual Team Activity exercise
8.3 Assignment activity
MODULE 3: EXCEL PAGE LAYOUT TAB AND RIBBON
3.1 Page Layout tab
MODULE 4: EXCEL FORMULAS TAB AND RIBBON
4.1 Video Explainer - Basic Formular and Functions
4.2 Assignment activity - Basic Formular and functions
4.3 Vloopup, Hlookup, Xlookup
4.4 Vlookup, Hlookup, Xlookup - Case study activity
MODULE 5: EXCEL DATA TAB AND RIBBON
4.1 Data Validation
4.2 Data entry Forms in Excel
MODULE 6: EXCEL REVIEW TAB AND RIBBON
5.1 Review Tab and Ribbon
PRACTICAL ACTIVITIES EXERCISES
PART 1. CONDITIONAL FORMATTING EXERCISE
1.1 - Video explainer - Conditional Formating Exercise 1
1.2 - Assignment 1 - Conditional formatting Workbook Exercise
PART 2: PIVOT TABLES DEVELOPMENT
2.1 - Video Explainer - Pivot Table 1
2.2 - Workbook Activity Exercise - Pivot Table Per 2.1
2.3 Pivot Table and other features Refresh
Next
Side panel
Categories
All categories
ACCA
COMPUTER AND ICT COURSES
EDUCATION AND TRAINING
CIMA
AAT
FINANCE AND BUSINESS COURSES
IFRS COURSES
Home
Login
English (en)
Afrikaans (af)
English (en)
Setswana (tn)
You are currently using guest access
Log in
Categories
Collapse
Expand
All categories
ACCA
COMPUTER AND ICT COURSES
EDUCATION AND TRAINING
CIMA
AAT
FINANCE AND BUSINESS COURSES
IFRS COURSES
Home
Login
Course info
PMEB PROFICIENCY IN MICROSOFT EXCEL
Skill Level
:
Beginner
Skill Level
:
Beginner
