Upon completion of the course, you will be familiar with the following: Advanced formulas, using range names in formulas, managing worksheets workbooks, using advance formatting techniques, creating and printing charts as well as sorting data i
- Course Start Date: Dec. 11
- Location: Ottawa
- Time: 9:00 am - 4:00 pm (Note on end times)
- Duration: 1 Day
on the number or students and pace of the class.
It is important to allow for the class to run a little bit longer,
or finish a little sooner, than expected.
- Delivery Method(s):Instructor Led
- Seats Available: YES
- Category:Microsoft Excel Training
that provides you with the quality training that
you have come to expect, and combines it with
flexible learning and a self paced environment.
For more information click here.
- Course Outline
Course Length: 6hrs (1 Day)
Managing numeric information and data is a key to success in every business. Microsoft Excel is the standard spreadsheet application used extensively for this purpose. Excel's powerful, yet easy to use formulas allow users to calculate data quickly, efficiently and accurately. Excel's database functions enable users to find, extract and analyze valuable data in order to make effective business decisions.
In this course, you will create advanced formulas, utilize and maintain database records, and add graphic elements to your worksheets for greater visual impact. You will:
- Create Advanced Formulas
- Use Range Names In Formulas
- Edit, Sort, Search And Extract Data
- Use Advance Formatting Techniques With Graphic Elements
This course is for individuals who are familiar with the basic elements of Microsoft Excel 2010 and wish to enhance their working knowledge of Excel.
Section 1: Advanced File Tasks
Lesson 1.1: Using Windows Explorer within Excel
Lesson 1.2: Saving Your Files
Lesson 1.3: Using File Management Tools, Part 1
Lesson 1.4: Using File Management Tools, Part 2
Section 2: Working with Functions and Formulas
Lesson 2.1: Using Formulas in Excel, Part 1
Lesson 2.2: Using Formulas in Excel, Part 2
Lesson 2.3: Exploring Excel Functions
Lesson 2.4: Using Functions in Excel
Lesson 2.5: Working with Names and Ranges
Lesson 2.6: Working with Array Formulas
Section 3: Managing Tables
Lesson 3.1: Working with Tables
Lesson 3.2: Working with Records and Fields
Lesson 3.3: Working with Tables and Filters
Lesson 3.4: Using Excel as a Database
Section 4: Adding the Finishing Touches
Lesson 4.1: Research Tools
Lesson 4.2: Using Themes
Lesson 4.3: Adding Text Boxes
Lesson 4.4: Inserting Pictures and ClipArt
Lesson 4.5: Editing Pictures
Section 5: Showing Data as a Graphic
Lesson 5.1: Inserting SmartArt
Lesson 5.2: Formatting SmartArt
Lesson 5.3: Adding Symbols, Equations, and Shapes
Lesson 5.4: Adding Sparklines
Lesson 5.5: Editing Sparklines
- Prerequisites & Certificates
Knowledge of Excel Introduction and Windows experience
Training includes 1 course manual, a Certificate of completion, and a voucher for 30 days of After Training Support
- 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 ]
CompuEase Training Classroom
130 Albert Street
Canada K1P 5G4
Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
This course is also scheduled on the following dates:
Not interested in this Course?
Tell us why:
This page has been viewed 33 times.