Excel 2010 Level 2 (Intermediate)

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.

Learning Objectives:

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
- Create Charts With Visual Impact

Target Student:

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.

Course Outline:

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

Price: $265.00 +HST

Federal Government Standing Offer price: $225.25 +HST

Time: 9:00 am - 4:00 pm
Duration: 1 Day
Language: English


March 20, 2018

April 17, 2018

June 12, 2018

July 23, 2018

August 13, 2018

September 10, 2018

What You Get:

Training includes:

  • 1 course manual

  • Certificate of completion

  • Voucher for 30 days of After Training Support


Cancellation/Rescheduling Policy

Registrants who wish to reschedule their course may do so at least 10 working days before the commencement of their course providing the course fee is paid within 30 days following the originally scheduled date of the course. 


Notice of cancellation must be received 10 working days prior to the confirmed date for a no financial penalty to be incurred.


Assimil8 Learning

11 Rosemount Avenue, Ottawa, K1Y 4R8


© 2015 by Assimil8 Learning.