Microsoft Excel 97 Intermediate Training Course in London and the UK
Our Excel Intermediate course will build on your current Excel skills. The course will focus more on Excel Functions, Worksheet Management, Working with Lists and Charting your data. Our Excel Intermediate course requires you to have a good understanding of the basic topics, as covered in our Introduction course. Existing users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel.
Excel 97 Intermediate Training Course Info
This course is designed for new or basic Excel users. The course will cover all aspects of creating new spreadsheets, including Excel calculations
Course Duration
This is a 1 day Excel 97 Intermediate Course. Course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This course can be run Onsite, at our Excel training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Excel 97 Intermediate Training Course Contents
Range Names
- Concept and Purpose
- Naming individual or range cellss
- 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
Excel 97 Courses
