|
CompuEase ~ Microsoft & Adobe Software Training Ottawa Cancellation Policy
Description: Upon completion of the course, you will be familiar with the following: Advanced formulas, using range names in formulas, managing worksheets within workbooks, using advance formatting techniques, creating and printing charts as well as sorting data in alphanumeric order.
Course Outline
ABSOLUTE / RELATIVE RANGE
- Creating and using an Absolute Range
USING RANGE NAMES
- Creating a Range Name
- Jumping to a Named Range
- Using Range Names in Formulas
ADVANCED FORMULAS
- Using some of the Logical Formulas
- Using some of the Financial Functions
- Date Formulas
- Linking Formulas
MANAGING WORKSHEETS
- Copying / Moving Worksheets
- Moving Data between Worksheets
- Copying Data between Worksheets
- Renaming Worksheet Tabs
- Consolidation Worksheets
ADVANCED FORMATTING
- Using Styles
- Templates
- Conditional Formatting
- Autoformat
CHARTS
- Chart Concepts
- Creating Charts
- Editing Charts
- Printing Charts
DATA SORT
- Sorting Lists
- Sorting in Ascending/Descending Order
- Sorting using multiple fields
DATABASE
- Enabling AutoFilter
- Using AutoFilter to Filter a Custom List
Pre-Requisites: Knowledge of Excel Introduction and Windows experience
Certificates offered: Certificate of completion
Duration Details: 1 day
9:00am - 4:00pm
Facility Location: CompuEase Training Classroom
124 O'Connor, Suite 204
Ottawa
ON
Canada
K1P 5M9
| 
