Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


In this course, you will learn more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing your data with other people, analyzing data, & using Excel data in other applications.

  • Course Start Date: May. 29
  • Location: Vancouver (Map)
  • Time: 8:30 am - 4:30 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
    8:30 AM - 4:30 PM
  • 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

Objectives
  • Creating, Maintaining, Filtering and using Subtotals in a List
  • Recording, Assigning and Using Macros
  • Creating and Using User Defined Functions
  • Performing 'What If' Analyses
  • Working with Scenarios
  • Querying a Database
  • Importing and Exporting Files and Data
  • Protecting Data
  • Pivot Tables, Reports and Charts
  • Other Advanced Business Analysis Tools
Outline
  • Working with Lists
    • Creating a List
    • Maintaining a List
    • Editing Records Using the Data Form
    • Filtering a List
    • Using Subtotals in a List
  • Working with Macros and User Defined Functions
    • Recording and Using Macros
    • Assigning Macros
    • Using User Defined Functions
  • Using Basic Analysis Tools
    • Performing 'What If' Analyses
    • Working with Scenarios
  • Using Advanced Analysis Tools and External Data
    • Querying a Database
    • Importing and Exporting Files
    • Protecting Data
    • Using Data Validation
    • Using Worksheet Protection
    • Password Protecting a Workbook
  • Using Business Analysis Tools
    • Working with Pivot Tables and Pivot Charts
    • Identifying the Parts of a Basic Pivot Table
    • Pivot Table Reports
    • Create a PivotTable from worksheet data
    • Create a PivotTable from an external data source
    • Create a PivotChart report from an existing PivotTable report
    • Delete a PivotTable or PivotChart report
    • Slicers
    • Using slicers
    • Formatting slicers for a consistent look
    • Sharing slicers between PivotTables
    • Sparklines
    • Types of Sparklines
    • Create a sparkline
    • Customize sparklines
    • Control which value points are shown
    • Change the style of or format sparklines
    • Online Analytical Processing (OLAP)
    • Business intelligence
    • What is Online Analytical Processing (OLAP)?
    • OLAP features in Excel 2010/2013

Prerequisites & Certificates
Pre-Requisites

Microsoft Excel 2010/2013 Level 2 or equivalent experience

Certificates offered

Certificate of completion


Cancellation Policy
Should you postpone or cancel your course you must give 5 business days notice.
Map & Reviews
On Track Computer Training
[ View Provider's Profile ]

On Track Computer Training Center
885 West Georgia St.
4th Floor

Vancouver, British Columbia
Canada   V6C 3E8


Reviews
 
Krishna is a great instructor! He is very knowledgeable, patient with the students, and very encouraging. He helps make the daunting task of learning Excel approachable. Thanks Krishna!!!
Reviewed by 2015
29-May-2017 $215 Regular Price $269 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 30 times.