Requirements
- National Identity Document, Passport, Work Permit or Asylum
- Have physical Address where you will receive a certificate
- Have a functioning cell phone number and the email address
Features
- Importing and exporting text files.
- Consolidating and linking data within spreadsheets.
- Applying filters and use forms in a spreadsheet.
- Creating and using macros.
- Combining and comparing large sets of data in a spreadsheet.
Target audiences
- All Ages Qualify
- Everyone Qualifies for our Courses
- All countries qualifies for our Courses
Online Course in Microsoft Office Excel Spreadsheets
- 258876 Work with spreadsheets – NQF Level 04
A person who is complete this course is capable of:
- Importing and exporting text files.
- Consolidating and linking data within spreadsheets.
- Applying filters and use forms in a spreadsheet.
- Creating and using macros.
- Combining and comparing large sets of data in a spreadsheet.
-
Student Guide
-
Text Book +Notes +Lesson
- 258876-2-1 SayPro Lesson Introduction
- 258876-2-2 SayPro Lesson Import and export text files
- 258876-2-3 SayPro Lesson CONVERTING DATA
- 258876-2-4 SayPro Lesson Converting text to dates
- 258876-2-5 SayPro Lesson Using DATEVALUE formula
- 258876-2-6 SayPro Lesson EXPORTING DATA TO A TEXT FILE
- 258876-2-7 SayPro Lesson : Export Excel data to text files with Kutools for Excel
- 258876-2-8 SayPro Lesson Consolidating and linking data within spreadsheets
- 258876-2-9 SayPro Lesson COPY SINGLE WORKSHEET ACROSS MULTIPLE WORKSHEETS
- 258876-2-10 SayPro Lesson Drag data between open workbook windows in Excel
- 258876-2-11 SayPro Lesson CONSOLIDATING AND LINKING DATA FROM MULTIPLE SPREADSHEETS
- 258876-2-12 SayPro Lesson USE A FORMULA TO CONSOLIDATE DATA
- 258876-2-13 SayPro Lesson Applying filters and using forms in spreadsheets
- 258876-2-14 SayPro Lesson ADVANCED FILTERING
- 258876-2-15 SayPro Lesson THE USE OF FORMS ON A SPREADSHEET
- 258876-2-16 SayPro Lesson EDITING AND DELETING RECORDS IN A FORM
- 258876-2-17 SayPro Lesson SORTING A FILTER LIST
- 258876-2-18 SayPro Lesson PRINTING A FILTER LIST
- 258876-2-19 SayPro Lesson Creating and using macros
- 258876-2-20 SayPro Lesson CREATING A MACRO
- 258876-2-21 SayPro Lesson RUNNING A MACRO
- 258876-2-22 SayPro Lesson ASSIGNING A MACRO TO AN OBJECT, GRAPHIC, OR CONTROL
- 258876-2-23 SayPro Lesson Combining and comparing large sets of data in spreadsheet
- 258876-2-24 SayPro Lesson CREATING A PIVOTTABLE
- 258876-2-25 SayPro Lesson REPORT FILTERS
- 258876-2-26 SayPro Lesson GROUP ITEMS IN A PIVOTTABLE REPORT
- 258876-2-27 SayPro Lesson UNGROUP GROUPED ITEMS
- 258876-2-28 SayPro Lesson CHANGING THE LAYOUT AND FORMAT OF A PIVOTTABLE REPORT
- 258876-2-29 SayPro Lesson Change a PivotTable report to compact, outline, or tabular form
- 258876-2-30 SayPro Lesson CHANGING OR REMOVING FORMATTING
- 258876-2-31 SayPro Lesson PivotCharts are like regular charts, except they display data from a PivotTable. As with a regular chart, you’ll be able to select a chart type, layout and style to best represent the data. In this example, we’ll use a PivotChart so we can visualize the trends in each sales region. To Create a PivotChart: 1. Select any cell in your PivotTable. The Options tab will appear in the Ribbon. 2. From the Options tab, click the PivotChart command.
- 258876-2-32 SayPro Lesson PRINTING A PIVOTTABLE REPORT
- 258876-2-33 SayPro Lesson DELETING A PIVOTTABLE REPORT
-
Home Activity and Tasks
-
Portfolio of Evidence Guide
- 258876-4-1 CONTACT DETAILS
- 258876-4-2 COMPETENCE
- 258876-4-3 ASSESSMENT STRATEGY
- 258876-4-4 ASSESSMENT PREPARATION
- 258876-4-5 AGREED ASSESSMENT PLAN
- 258876-4-6 Interview (RPL Purposes)
- 258876-4-7 LETTER OF COMMITMENT FROM THE LEARNER
- 258876-4-8 Declaration of Authenticity
- 258876-4-9 PORTFOLIO BUILDING
- 258876-4-10 RECORD OF LEARNING
- 258876-4-11 ASSESSMENT DECISION & EVIDENCE EVALUATION RECORD
- 258876-4-12 Assessor’s feedback report to the candidate
- 258876-4-13 Moderator’s Report
- 258876-4-14 ASSESSMENT REVIEW
- 258876-4-15 Candidate Appeal Form
- 258876-4-16 Assessor’s Contingency Plan
-
Formative Assessment-Pre-Assignment
-
Summative Assessment
- 258876-6-1 Summative Assessment Task 1 (SO 1, AC 2)
- 258876-6-2 Summative Assessment Task 2 (SO 1, AC 3)
- 258876-6-3 Summative Assessment Task 3 (SO 2, AC 2, AC 3)
- 258876-6-4 Summative Assessment Task 4 (SO 3, AC 1, 2, AC 3, AC 7, AC 8)
- 258876-6-5 Summative Assessment Task 5 (SO 3, AC 5, AC 6)
- 258876-6-6 Summative Assessment Task 6 (SO 4, AC 2, AC 3, AC 4, AC 5, AC 6)
- 258876-6-7 Summative Assessment Task 7 (SO 5, AC 1, AC 2, AC 3, AC 4, AC 5, AC 6, AC 7, AC 8, AC 9)
-
Suggestions and Improvements
- 258876-7-1 What did you like about this course. Accept and comment below
- 258876-7-2 What other courses do you think we can add. Accept and comment below
- 258876-7-3 What can you suggest more to Southern Africa Youth Academy. Accept and comment below
- 258876-7-4 What do you suggest we can do in future to improve our services. Accept and comment below
- 258876-7-5 How satisfied are you by the course you just completed.