Microsoft Excel 2002 Intermediate Training Course in London and the UK
Our Excel 2002 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 2002 Intermediate Training Course Info
Audience: This Excel intermediate course will build on your basic Excel skills and show you more complex formulae, how to build formulae across worksheets, linking data and charting your data. We also cover protecting your sheets and workbooks.
Course Duration
This is a 1 day Excel 2002 Intermediate Course. Course starts at 09:30 and runs until 16:30
Excel 2002 Intermediate Course Objectives: After the course, you will be able to:
- Use Logical Functions, Financial and Statistical Functions
- Nest Functions
- Multiple Worksheet Management and Formulae
- Create Charts
- Protect Worksheets & Workbooks
Requirements: To get the most from this course, you must be able to perform basic Excel actions and create formulae and functions.
Course Duration
This is a 1 day Excel 2002 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 2002 Intermediate Training Course Contents
Range Names
- Concept and Purpose
- Naming individual or range cells
- 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 2002 Courses
