Audience Profile This MS Excel course in
Cape Town was designed for customers 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 customers 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 International offers instructor led computer courses in Africa, and also provides internationally-acclaimed online IT training over the internet, which are aimed at International IT
Certification exams. 2KO Africa performs IT training across the African continent; plus delivers online computer courses worldwide (24x7 via internet), enabling 2KO customers the opportunity to study courses online world-wide, to ensure the best training possible.
*PLEASE NOTE THAT ALL
MICROSOFT OFFICE COURSES ARE SUBJECT TO A MINIMUM OF 3
DELEGATES ATTENDING THE COURSE
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, customers 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
Pre-requisites Excel 2007 basic skills
At Course Completion Upon successful completion of this course, customers
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