Microsoft Excel 2003 Level 1
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
- Navigate worksheets, document windows, and the application window
- Manage and manipulate Excel files
- Edit data
- Work with ranges
- Create simple formulas
- Use built-in Excel functions
- Cut, copy, and paste data
- Format column width, row height, fonts, styles, borders and shading, data type and alignment
- Print worksheets
Prerequisites
- A thorough understanding of the Windows operating environment
- Strong mouse and keyboard ability
Outline
- Section 1 - Getting Started
- Loading Excel 2003
- Exiting Excel 2003
- Understanding Application and Document Windows
- The Standard Toolbar
- The Formatting Toolbar
- Manipulating Application and Document Windows
- Minimizing and Maximising Windows
- Moving and Sizing Windows
- Switching Between Application and Document Windows
- Accessing the Menu Using the Keyboard
- Section 2 - Spreadsheet Basics
- Understanding Spreadsheets
- Moving Around The Worksheet
- Freezing panes
- Entering Data into The Spreadsheet
- Editing Text In Cells
- Selecting a Range of Cells
- Clearing Cells
- Section 3 - File Management
- Managing Your Files
- Creating a New Document
- Saving Documents
- Opening Documents
- Closing Document Windows
- Arranging Document Subwindows
- Deleting Files
- Section 4 - Working With Formulas
- Understanding Formulas
- Practising your Skills
- Entering Simple Formulas
- Using Functions - The Sum Function
- Using Functions - The Paste Function Button
- Using The Fill Utility
- Practising Your Skills
- Section 5 - Formulating Your Spreadsheet
- Introduction to Formatting
- Text and Number Alignment
- Formatting Dates and Numbers
- Changing Row Height and Column Width
- Formatting Fonts
- Applying Borders and Shading
- Inserting Rows and Columns
- Using Cut, Copy, and Paste
- Section 6 - Printing Your Spreadsheet
- Understanding Page Setup, Print Preview And Printing
- Using Page Setup
- Setting the Page Setup Options
- Using Print Preview
- Printing the Spreadsheet