Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


The target students for this course are those who desire to gain the skills necessary to create templates, sort and filter data, analyze data, create charts and Pivot tables.

  • Course Start Date: Oct. 11
  • Location: Calgary (Map)
  • Time: 9:00 am - 4:00 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    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.
  • Duration: 1 Day
  • Delivery Method(s):Instructor Led
  • Mentored training is a revolutionary training method
    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.
  • Discount Seats Available:2
  • Category:Microsoft Excel Training

 
Course Outline
The target students for this course are those who desire to gain the skills necessary to create templates, sort and filter data, analyze data, create charts and Pivot tables.

Participants will also continue to build on the skills learned in Level 1 regarding the creation of formulas.

Course Outline
Lesson 1: Calculating Data with Advanced Formulas
  • Topic 1A: Apply Cell and Range Names
  • Topic 1B: Calculate Data Across Worksheets
  • Topic 1C: Use Specialized Functions
  • Topic 1D: Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data
  • Topic 2A: Create and Modify Tables
  • Topic 2B: Format Tables
  • Topic 2C: Sort or Filter Data
  • Topic 2D: Use Functions to Calculate Data

Lesson 3: Presenting Data Using Charts
  • Topic 3A: Create a Chart
  • Topic 3B: Modify Charts
  • Topic 3C: Format Charts

Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
  • Topic 4A: Create a PivotTable Report
  • Topic 4B: Filter Data Using Slicers
  • Topic 4C: Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects
  • Topic 5A: Insert and Modify Pictures and ClipArt
  • Topic 5B: Draw and Modify Shapes
  • Topic 5C: Illustrate Workflow Using SmartArt Graphics
  • Topic 5D: Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing the Excel Environment
  • Topic 6A: Customize the Excel Environment
  • Topic 6B: Customize Workbooks
  • Topic 6C: Manage Themes
  • Topic 6D: Create and Use Templates

Prerequisites & Certificates
Pre-Requisites

Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application. Excel 2007 Level 1 or equivalent knowledge

Certificates offered

Certificate of Completion


Cancellation Policy
Students are required to give notice if they are unable to attend their class:

2 weeks (10 full business days) or longer prior to training date = full refund
1 to 2 weeks (5 - 9 full business days) prior to training date = 50% of course fee refund
Less than 1 week (4 full business days or fewer) prior to training date = 0% refund

NOTE: You may substitute classes or students at any time.

Map & Reviews
New Era Technology Training
[ View Provider's Profile ]

New Era Technology Centre
718 8th Avenue SW
Suite 300

Calgary, Alberta
Canada   T2P 1H2


Reviews
 
It would have been beneficial for the instructors screen to have the capability of zooming in on parts of the workbook.
Reviewed by 2016
Mr. Mike is very knowledgeable about Excel 2010, Level 2, and I learned a lot during the class which I will be able to use on a daily basis at work. The Course contents were exactly as indicated. Looking forward to Level 3 someday !
Reviewed by 2013
It was really hot in the room - I know this is a persistent problem with clients - some like it hot, some like it cold! We didn't get to all the topics - I guess I'd rather have this and really understand the topics we did cover; but I needed chart work which we didn't get to.
Reviewed by 2013
May be more practice should be included. Thanks!
Reviewed by 2013
Mike did an awesome job. He was entertaining yet very knowledgeable.
Reviewed by 2012
The class was very rushed. The last few topics we essentially whipped through them but it still provided learning on what I needed to know
Reviewed by 2012
11-October-2016 $196 Regular Price $245 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
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!
need-to-train-a-group-banner

This course is also scheduled on the following dates:

Not interested in this Course?

Tell us why:

This page has been viewed 25 times.