Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4


This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export data.


 
Course Outline
This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources and import and export data.

CORE TOPICS Streamlining Workflow
Create a macro
Edit a macro
Customize Access to Excel commands
Apply conditional formatting
Add data validation criteria
Update a workbook’s properties
Modify Excel’s default settings

Collaborating with Others
Protect files
Share a workbook
Set revision tracking
Review tracked revisions
Merge workbooks
Adjust macro settings
Administer digital signatures

Auditing Worksheets
Trace cell precedents
Trace cell dependents
Locate errors in formulas
Locate invalid data and formulas
Watch and evaluate formulas
Group and outline data

Analyzing Data
Create a trendline
Create scenarios
Perform What-If analysis
Develop a PivotTable© report
Develop a PivotChart© report
Perform statistical analysis with the Analysis ToolPak
 
Working with Multiple Workbooks
Create a workspace
Consolidate data
Link cells in different workbooks
Edit links
 
Importing and Exporting Data
Export to Microsoft Word
Import a Word Table
Import text files
 
Structuring XML Workbooks
Develop XML Maps
Import, add and export XML data
Manage XML workbooks
Apply XML view options
Prerequisites & Certificates
Pre-Requisites

MS Excel 2003 Level 2

Certificates offered

Certificate of completion


Cancellation Policy
# A full 3 business days notice is required to change or cancel any course date. Once payment has been received, a credit will be held in your account if we have received sufficient notice of your cancellation or date change (we do not provide refunds). If insufficient notice is received, the entire fee for that course date will be charged.There is no charge for substitutions. If you cannot attend your course and cannot provide the 3 business days notice, you can send someone else in your place with no penalty.

Course Retake

If you cannot provide 3 business days notice of cancellation, you may take the course at a later date at no further charge with the following conditions.

1. You must take the course within 6 months of the original course date (no exceptions). After that time, the full course fee will be charged again.

2. Registration is on a stand-by basis only. If the course date you select becomes fully booked you will be asked to choose another date, which must be within 6 months of the original course date.

3. If you need to change or cancel your free re-take course, we must receive a full 3 business days notice of the change. If insufficient notice is received, this offer no longer applies and the full course fee will be charged again, should you choose to book another date.

4. This course is not transferable to another person. It must be taken by the same person who was scheduled for the original course.

5. This offer applies to the same course only (same software program, same course level and the same software version as was originally booked).
Map & Reviews
TCET
[ View Provider's Profile ]

Reviews
 
Great instructor
Reviewed by 2011
the instructor was very good. The one topic that I wanted to learn the most the computer was not set up properly so we could not go thru it which was very dissappointing. It is alot of info for one day but that is the way these courses are so it was not a shock.
Reviewed by 2011
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 1714 times.