Microsoft Excel 2003 Level 2
Microsoft Office Excel contains powerful tools to help you analyze, manage, and share critical business data. Our latest version also lets you work more efficiently in teams, while helping to protect and control access to sensitive information.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
- Name and Reference Cells
- Protect Data
- Create Links
- Use Basic Excel Functions
- Create Charts
- Create Databases
- Work with Data Series
Prerequisites
- Microsoft Excel 2003 Level 1 or equivalent experience
Outline
- Section 1 - Cell Names And References
- Understanding Cell Naming
- Name a Cell
- Naming a Range of Cells
- Using Names In a Formula
- Understanding Relative Cell References
- Understanding Absolute Cell References
- Understanding Mixed Cell References
- Section 2 - Protecting Data
- Protection Basics
- Protecting Worksheets
- Protecting A Workbook
- Section 3 - Creating Links
- Linking Basics
- Linking Worksheets
- Linking Workbooks
- Section 4 - Functions
- Function Basics
- Creating Functions
- The PMT Function
- Section 5 - Charts
- Charting Basics
- Creating a Chart
- Editing A Chart
- Moving And Resizing An Embedded Chart
- Adding and Deleting a Data Series
- Section 6 - Lists
- List Basics
- Creating a List
- Using a Data Form
- Finding Information with the Data Form
- Creating a Record using the Data Form
- Sorting Data
- Filtering Data