|
Description: 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.
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 & alignment
- Print worksheets
Outline
* Section 1 - Getting Started
o Loading Excel 2002
o Exiting Excel 2002
o Understanding Application and Document Windows
o The Standard Toolbar
o The Formatting Toolbar
o Manipulating Application and Document Windows
o Minimizing and Maximising Windows
o Moving and Sizing Windows
o Switching Between Application and Document Windows
o Accessing the Menu Using the Keyboard
* Section 2 - Spreadsheet Basics
o Understanding Spreadsheets
o Moving Around The Worksheet
o Freezing panes
o Entering Data into The Spreadsheet
o Editing Text In Cells
o Selecting a Range of Cells
o Clearing Cells
* Section 3 - File Management
o Managing Your Files
o Creating a New Document
o Saving Documents
o Opening Documents
o Closing Document Windows
o Arranging Document Subwindows
o Deleting Files
* Section 4 - Working With Formulas
o Understanding Formulas
o Practising your Skills
o Entering Simple Formulas
o Using Functions - The Sum Function
o Using Functions - The Paste Function Button
o Using The Fill Utility
o Practising Your Skills
* Section 5 - Formulating Your Spreadsheet
o Introduction to Formatting
o Text and Number Alignment
o Formatting Dates and Numbers
o Changing Row Height and Column Width
o Formatting Fonts
o Applying Borders and Shading
o Inserting Rows and Columns
o Using Cut, Copy, and Paste
* Section 6 - Printing Your Spreadsheet
o Understanding Page Setup, Print Preview And Printing
o Using Page Setup
o Setting the Page Setup Options
o Using Print Preview
o Printing the Spreadsheet
Pre-Requisites: A thorough understanding of the Windows operating environment
Strong mouse and keyboard ability
Certificates offered: Certificate of completion
Duration Details: 1 day
8:30am - 4:30pm
Facility Location: On Track Computer Training Center
1600 - 650 West Georgia Street
Vancouver
British Columbia
Canada
V6B 4N7
|
