Microsoft
Excel Level 3
Course Outline:
|
Introduction
to Microsoft Excel Level 3
You have used Microsoft® Office
Excel to perform tasks such as
running calculations on data and
sorting and filtering numeric
data. You would now like to
automate some common tasks,
apply advanced analysis
techniques to more complex data
sets, collaborate on worksheets
with others, and share Excel
data with other applications. In
this course, you will do all of
these things.
Target Student: If you
want to create macros,
collaborate with others, audit
and analyze worksheet data,
create PivotTables and Pivot
Charts, incorporate multiple
data sources, and import and
export data.
Excel 2007 Courses
If you've moved to Excel 2007 and experience
difficulties using the new interface please ask us for
an Excel 2007 course.
|
|
Course Location
All these courses are regularly run at our
training centre at the Solent Business Park, Whiteley, Fareham,
Hampshire and Salisbury,
Wiltshire. If you have four or more
delegates for an Excel course we can run the course at
your offices, and offer you a very cost effective
solution.
Aims
You 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.
Course Objectives
By the end of this level you will be able to:
- Customize workbooks
- Collaborate with others using workbooks
- Audit worksheets
- Validate data of new or
existing workbooks
- Protect & hide data and cells
with single or multiple passwords
- Analyze data with what if
analysis
- Work with multiple workbooks
- Import and export data
Content
Manipulate data
- Manipulate data lists using a range of formulas
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
Forms -
Create and automated Form - Combo boxes - Check boxes - Spinners
- Tick boxes - Formulas
Perform What-If Analysis -
using Goal Seek - Solver - Create Scenarios - Develop a PivotTable©
Report - Develop a PivotChart© Report - Perform Statistical Analysis
with the Analysis Tool-Pack
Working with Multiple Workbooks - Create a Workspace -
Consolidate Data - Link Cells in Different Workbooks - Edit Links
Streamlining Workflow - Create a Macro - Edit a Macro - Apply
Conditional Formatting - Add Data Validation Criteria - Update a
Workbook's Properties
Importing and Exporting Data - Export to Microsoft Word - Import
a Word Table - Import Text Files
|
|
Scheduled Course Dates in Southampton and Salisbury
Towns within 1 hour of our Training Venues
Our
Southampton training centre is ideally located
within 1 hours driving of the following towns: Salisbury,
Winchester, Basingstoke, Andover, Farnborough, Portsmouth,
Fareham, Gosport, Chichester and Bournemouth.
Our Salisbury training centre is ideally
located within 1 hours driving of: Winchester, Basingstoke,
Farnborough, Andover, Fareham, Southampton, Bournemouth, Poole,
Bath, Swindon, Newbury, Ringwood and Tidworth.
|
 |
Microsoft Excel
Level 1
Introduction |
