0 reviews

SayPro Course in Advanced Microsoft Office Excel Level 3 557842B

- Master advanced data analysis techniques, including pivot tables, power queries, and macros - Learn how to create dynamic dashboards and ... Show more

Instructor

Herbet Allet Shungube

Category

SayPro Technology and Computer Science Course Category

Description
Curriculum
Reviews

This advanced course is designed for experienced Excel users who want to take their skills to the next level. Participants will learn advanced techniques for data analysis, visualization, and manipulation, as well as how to automate tasks and create custom solutions.

Portfolio of Evidence Guide

1

116940-669874B-1-1 CONTACT DETAILS

Text lesson
2

116940-669874B-1-2 COMPETENCE

Text lesson
3

258876-557842B-1-3 ASSESSMENT PREPARATION

Text lesson
4

116940-669874B-1-5 AGREED ASSESSMENT PLAN

Text lesson
5

116940-669874B-1-6 Interview (RPL Purposes)

Text lesson
6

116940-669874B-1-7 LETTER OF COMMITMENT FROM THE LEARNER

Text lesson
7

116940-669874B-1-8 Declaration of Authenticity

Text lesson
8

116940-669874B-1-9 PORTFOLIO BUILDING

Text lesson
9

116940-669874B-1-10 RECORD OF LEARNING258876-557842B-1-9 Record of Learning

Text lesson
10

116940-669874B-1-12 Assessor’s feedback report to the candidate

Text lesson
11

116940-669874B-1-13 Moderator’s Report

Text lesson
12

482613B-1-13 ASSESSMENT REVIEW

Text lesson
13

258876-557842B-1-14 Candidate Appeal Form

Text lesson
14

258876-557842B-1-15 Assessor’s Contingency Plan

Text lesson

Learner Guide

15

258876-557842B-2-1 SayPro Lesson Import and export text files

Text lesson
16

258876-557842B-2-2 SayPro Lesson Converting Data

Text lesson
17

258876-557842B-2-3 SayPro Lesson Converting text to dates

Text lesson
18

258876-557842B-2-4 SayPro Lesson Using DATEVALUE formula

Text lesson
19

258876-557842B-2-5 SayPro Lesson EXPORTING DATA TO A TEXT FILE

Text lesson
20

258876-557842B-2-6 SayPro Lesson Consolidating and linking data within spreadsheets

Text lesson
21

258876-557842B-2-7 SayPro Lesson COPY SINGLE WORKSHEET ACROSS MULTIPLE WORKSHEETS

Text lesson
22

258876-557842B-2-8 SayPro Lesson Drag data between open workbook windows in Excel

Text lesson
23

258876-557842B-2-9 SayPro Lesson CONSOLIDATING AND LINKING DATA FROM MULTIPLE SPREADSHEETS

Text lesson
24

258876-557842B-2-10 SayPro Lesson USE A FORMULA TO CONSOLIDATE DATA

Text lesson
25

258876-557842B-2-11 SayPro Lesson Applying filters and using forms in spreadsheets

Text lesson
26

258876-557842B-2-12 Saypro Lesson ADVANCED FILTERING

Text lesson
27

258876-557842B-2-13 SayPro Lesson THE USE OF FORMS ON A SPREADSHEET

Text lesson
28

258876-557842B-2-14 SayPro Lesson EDITING AND DELETING RECORDS IN A FORM

Text lesson
29

258876-557842B-2-15 SayPro Lesson Creating and using macros

Text lesson
30

258876-557842B-2-16 SayPro Lesson CREATING A MACRO

Text lesson
31

258876-557842B-2-17 SayPro Lesson ASSIGNING A MACRO TO AN OBJECT, GRAPHIC, OR CONTROL

Text lesson
32

258876-557842B-2-18 SayPro Lesson Combining and comparing large sets of data in spreadsheet

Text lesson
33

258876-557842B-2-19 SayPro Lesson CREATING A PIVOTTABLE

Text lesson
34

258876-557842B-2-20 SayPro Lesson REPORT FILTERS

Text lesson
35

258876-557842B-2-21 SayPro Lesson CHANGING THE LAYOUT AND FORMAT OF A PIVOTTABLE REPORT

Text lesson
36

258876-557842B-2-22 SayPro Lesson CHANGING THE LAYOUT FORM OF A PIVOTTABLE REPORT

Text lesson
37

258876-557842B-2-23 SayPro Lesson Change a PivotTable report to compact, outline, or tabular form

Text lesson

Learner Documents

38

Learner ID

Text lesson
39

Learner CV

Text lesson
40

Learner Qualifications

Text lesson

Formative Assessment

41

258876-557842B-4-1 Formative Assessment Q1 (SO 1, AC 1, AC 2)

Assignment

Summative Assessment

42

258876-557842B-5-1 Summative Assessment Task (SO 5, AC 1, AC 2, AC 3, AC 4, AC 5, AC 6, AC 7, AC 8, AC 9)

Assignment

Course Evlauation

43

Course Evaluation Form

Text lesson

Please, login to leave a review

SayPro Course in Advanced Microsoft Office Excel Level 3 557842B

Popular SayPro Courses