Microsoft Excel 2003 Intermediate Training Course
Our Excel 2003 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. Existing Excel 2003 users whom have not had any formal training will find this course extremely useful, as it will bridge the gap in your knowledge of Excel.
If you are not sure if our Excel 2003 Intermediate course is the correct level for you, please feel free to contact us. We offer a free TNA service which allows us to build a bespoke Excel 2003 Intermediate course that will be perfectly suited to your current knowledge.
Clients like QBE, TSO, Google, HSBC and many more choose us as their preferred Excel 2003 supplier. Let us show you what we can do!
Excel 2003 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 2003 Intermediate Course. Course starts at 09:30 and runs until 16:30
Excel 2003 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 2003 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 2003 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
**Remember that you can tailor the Excel 2003 Intermediate course contents as required**
Excel 2003 Courses
