Microsoft Excel Intermediate
Course Duration: 1 Day
 Printer-friendly
version
Course Objective
By the end of the course, delegates
will be able to:
- Create a range of commonly used formulae
- Use the Function Wizard to
create a wider range of functions to perform many popular tasks
- Use
graphics and drawing tools to draw attention to important information
- Use
and manipulate sheets in the workbook
- Summarise data via 3D models
- Consolidate data from different workbooks
- Link to data from different
worksheets
- Create a database
- Sort, select and filter data
- Create automatic subtotals and manipulate
an outline view of a database
- Produce different types of charts and
format them
Delegate Profile
Existing users of Excel who have attended the Excel
Introduction course
or have equivalent knowledge.
Pre-Requisites
Attendees should have experience of using the
mouse, and a working knowledge of the Windows
operating
system, including
directory structures.
Structure
Each delegate has the exclusive use of a
PC and training includes extensive hands-on
activity.
Course Content
Recap on the introductory course
Quick demonstration
of all features covered in the introductory course
Creating commonly-used formulae
How to build up more advanced formulae
including:
- Cumulative totals
- Percentages
- Discounts
- Salary calculation
Why we need to use brackets in formulae
Paste function
Using the paste function facility
Graphics and drawing
Text boxes and arrows
Drawing and formatting
shapes
How to draw attention to important information
Workbooks
One workbook with many pages (sheets)
Using and naming the sheet tabs
Moving around the workbook
Inserting, deleting, copying and moving sheets
Grouping Sheets
Summaries and consolidation
Techniques for building
3D models
Drill-down formulae
Consolidating data to produce summary reports
Working with multiple files
Linking sheets via formulae
Creating a database
Creating a database and sorting
records
Using data forms and querying
Inserting automatic subtotals inside a sorted List
Using AutoFilter and the “top 10” function
U sing
data series
Creating and manipulating an outline to view different levels of
data on the worksheet
More on charts
Turning worksheet data into charts
Using the chart wizard and discovering how to format the individual
items on the chart
What’s Next
Trainer demonstration of a few advanced
features
 Back
to the top
|
