Microsoft
Excel Level 2
Course Outline:
|
Introduction
to Microsoft Excel Level 2
In Microsoft® Office Excel: Level 1, you
created, edited, formatted, and printed
basic spreadsheets. You now have a need to
streamline repetitive tasks and display
spreadsheet data in more visually effective
ways. In this course, you will use
Microsoft® Excel to streamline and enhance
your spreadsheets with templates, charts,
graphics, and formulas.
Target Student: The target
students for this course are students who wish to gain
the skills necessary to create templates, sort and
filter data, import and export data, analyze 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
To create and edit Microsoft® Office Excel worksheets and
workbooks.
Course Objectives
By the end of this level you will be able to:
-
Use Conditional Formatting to manage data
-
Create and apply templates
-
Sort, Filter, Subtotal and use Pivot tables to analyse data
-
Manage complex formulas using Range Names
-
Calculate with advanced formulas including IF's and
VLOOKUP
-
Create and modify charts
-
Work with graphic objects
-
Use a range of useful shortcuts
Content
Conditional Formatting
techniques - Finding data - Highlighting data - Format
Painter tips - Invoice Tracker example
Sorting and Filtering Data - Sort Data Lists - Filter Data Lists
- Create and Apply Advanced Filters - Calculate with Database
Functions
Subtotals
and Pivot Tables - Subtotal data - Pivot table data -
Answer simple and complex questions easily
Calculating with Advanced Formulas - Range
Names to simplify the complex - Calculate Across
Worksheets - Calculate with Date and Time Functions - Calculate
with various IF Functions - Calculate with
VLOOKUP function options.
Creating and Applying Templates - Create a Workbook from a
Template - Create a Custom Template - Working with Comments -
Create a Hyperlink
Creating and Modifying Charts - Create a Chart - Format Chart
Items - Change the Chart Type - Create a Diagram
Working with Graphic Objects - Insert Graphics - Create
AutoShapes - Format Graphic Objects - Change the Order -
Graphic Objects - Group Graphic Objects - Move, Copy, and Resize
Graphic Objects
Importing and Exporting Excel data -
Export Excel Data - Import Excel data
|
|
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 |
