This MS Excel course in
Cape Town was designed for students wishing to gain the
skills needed to create macros, collaborate with others,
audit and analyze worksheet data, incorporate various
data sources, and import and export data. In addition,
the course is also for students desiring to prepare for
the Microsoft Certified Application Specialist exam in
Microsoft® Office Excel® 2007, and who already have
knowledge of the basics of Excel, including how to
create, edit, format, and print worksheets that include
charts and sorted and filtered 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 International runs computer courses across the African continent, and is a top provider of internationally certified online IT training, enabling 2KO students the opportunity to study courses online world-wide, to ensure the best training possible.
MS Excel Advanced Unit Standard:
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 some 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
Excel 2007 basic skills
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
Workbooks Develop XML Maps
Import and Export XML Data