Audience Profile This Excel course in Cape Town was designed for students
who have experience using Excel to create, edit, and
manage worksheets, and want to further their skills to
design macros, collaborate with others, audit and
analyze worksheet data, incorporate multiple data
sources, and import and export data. 2KO presents
Microsoft courses in Cape Town by means of full time
instructor-led training; as well as internet-accessible
online training, which are aimed at International IT
Certification exams. 2KO offers computer training in many African countries; and is also a leading supplier of internationally-recognised online IT courses, enabling 2KO students the opportunity to study courses online world-wide, to ensure the best training possible.
Course Accreditation: MS Excel Advanced
Unit Standard: 258876
This course is currently accredited by MICT SETA and is intended for people who need to have to work with spreadsheets in a variety of circumstances.
People credited with this unit standard are able to:
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.
In this course, students will automate sme common Excel
tasks, apply advanced analysis techniques to more
complex data sets, collaborate on worksheets with
others, and share Excel data with other applications.
Duration: 1 Day
Pre-requisites: Excel 2013 basic skills
At Course Completion: Upon successful completion of this course, students
will be able to:
Enhance productivity and efficiency by streamlining your
Collaborate with others using workbooks.
Work with multiple workbooks.
Import and export data.
Use Excel with the web.
Structure workbooks with XML.
Module Outline: Module 1: Streamlining
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Update a Workbook's Properties
Module 2: Collaborating with
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Administer Digital Signatures
Restrict Document Access
Module 3: Auditing Worksheets
Troubleshoot Errors in Formulas
Troubleshoot Invalid Data and Formulas
Watch and Evaluate Formulas
Create a Data List Outline
Module 4: Analyzing Data
Create a Trendline
Perform What-If Analysis
Perform Statistical Analysis with the Analysis ToolPak
Module 5: Working with Multiple
Create a Workspace
Link Cells in Different Workbooks
Module 6: Importing and Exporting
Export Excel Data
Import a Delimited Text File
Module 7: Using Excel with the Web
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query
Module 8: Structuring XML
Develop XML Maps
Import and Export XML Data