Upon completion, students will be familiar with: 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
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
- Using some of the Logical Formulas
- Using some of the Financial Functions
- Date Formulas
- Linking Formulas
- Copying / Moving Worksheets
- Moving Data between Worksheets
- Copying Data between Worksheets
- Renaming Worksheet Tabs
- Consolidation Worksheets
- Using Styles
- Conditional Formatting
- Chart Concepts
- Creating Charts
- Editing Charts
- Printing Charts
- Sorting Lists
- Sorting in Ascending/Descending Order
- Sorting using multiple fields
- Enabling AutoFilter
- Using AutoFilter to Filter a Custom List
- Prerequisites & Certificates
Knowledge of Excel Introduction and Windows experience
Certificate of completion
- Cancellation Policy
Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.
- Map & Reviews
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 613 times.