MS Excel 2007 Intermediate
Training
Inhouse
Description
-
Type
Training
-
Methodology
Inhouse
-
Duration
1 Day
The course will cover all aspects of creating new spreadsheets, including Excel calculations. Suitable for: New or basic Excel users.
Reviews
Subjects
- MS Excel
Course programme
Course Contents
Range Names
- Concept and Purpose
- Naming individual or range cells's
- Deleting and amending named ranges
- Using named cells/ranges in formulae
Conditional Functions & Formats and Date Calculations
- Benefits and purpose
- If Statements , Nested If
- And, Or, Not
- Combining If, And, Or, Not
- Sumif , Countif
- Conditional Formatting
- Entering Dates and Times
- Different date/time formats
- How dates are stored
- Calculating working days
- Using the DAY(),MONTH(),YEAR() functions
- Time calculations
Formulae Auditing
- Formula Auditing Tools
- Revealing Formulae
- Tracing Precedents/Dependents
- Goto Special
Worksheet Management & Linking
- Linking sheets in the same file
- Linking different Excel files
- Using Edit, Links
- Viewing different files at once
- Saving a workspace
- Viewing different sheets at once
- Window Split
- Data consolidation
Basic List Management
- Sorting Data
- Adding Subtotals
- AutoFilter
- Freeze Panes
- Group and Outline
- Data Form
Excel Charts / Graphs
- Using the Chart Wizard
- Editing and Formatting charts
- Saving custom chart types
- Setting a default chart type
**All the Excel 2007 intermediate course content above can be tailored by adding more basic or advanced functionality**
Time: The course starts at 09:30 and runs until 16:30.
The course is run on a date that suits you! We do not run public scheduled courses.
Additional information
Students per class: 8
MS Excel 2007 Intermediate