Excel Intermediate 2003-2010
Short course
In Poole
Description
-
Type
Short course
-
Location
Poole
-
Duration
1 Day
To ensure that delegates have the right knowledge to make the most of Excel Workbooks.
Facilities
Location
Start date
Start date
About this course
Basic use of Excel is assumed plus familiarity with spreadsheets in general. Attendees should have created their own spreadsheets, including basic formulae, and be using this software regularly in their working environment.
Reviews
Course programme
Formulae
· Review of Cell Addressing within Formulae
· Copy Formulae
· Absolute Cell Referencing
Functions
· Use of the Average, Min, and Max functions
· Function Wizard
· Conditional Functions
· Date related functions
General
· Protecting sheets
Ranges
· Creating Named Ranges
· Using Range names in Formulae
Multiple Sheets
· Renaming Sheets
· Inserting and deleting sheets
· Copying sheets
· Group Edit Mode
Charts
· Editing Charts•
· Formatting Charts
· Adding Trend lines
· Using Secondary Axis•
· Using Drawing tools
Printing
· Print & Preview options - ranges/sheets
· Headers and Footers•
· Print Titles
Formatting
· Useful Text formats
· Clearing formats
· Formatting Dates
Excel Intermediate 2003-2010