Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 5


This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.

  • Course Start Date: Dec. 13
  • 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

This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.

Day Objectives
  • Using multiple worksheets, workbooks and workspaces
  • Working with Financial functions
  • Use advanced formatting techniques
  • Using the Auditing Tools to track information
  • Using charts to display financial data
  • Using Macros to automate your work environment
  • Use Templates
Outline
  • Using Multiple Worksheets and Workbooks
    • Using Multiple Worksheets
    • Inserting New Worksheets
    • Renaming Worksheets
    • Deleting Worksheets
    • Creating Multiple Views
    • Freezing Panes
    • Viewing and Arranging Multiple Worksheet Windows
    • Navigating in Multiple Workbooks
    • Selecting and Viewing Multiple Workbooks
    • Managing Multiple Worksheets and Workbooks
    • Selecting Multiple Worksheets
    • Moving and Copying Data between Worksheets
    • Linking Data Between Worksheets
    • Creating a 3-D Formula
  • Charting
    • Using Charts
    • Creating a Chart
    • Changing Chart Type, Style and Chart Sub-Type
    • Changes to the Chart Source Data
    • Add data to an existing chart
    • Change the data in an existing chart
    • Remove data from a chart
    • Managing Chart Objects
    • Moving and Resizing Chart Objects
    • Deleting Chart Objects
    • Adding Data Series and Objects to a Chart
    • Changing the Chart Type
    • Formatting Chart Objects
    • Printing Charts
  • Advanced Functions
    • Creating and Using Functions
    • Using Built-in Functions
    • Working with Arguments: The PMT Function
    • Using Dates and Times
    • Using Dates in Calculations
    • Using Nested Functions
    • Auditing Worksheets
    • Identifying the Auditing Commands
    • The Watch Window
    • The Formula Evaluator
    • Tracing and Correcting Worksheet Errors
  • Advanced Formatting
    • Using Comments in a Worksheet
    • Reviewing, Showing, and Hiding Comments
    • Deleting a Comment
    • Working with Styles
    • Applying a Style
    • Modifying Existing Styles
    • Using Format Painter
    • Creating Custom Number Formats
    • Applying an AutoFormat (Table Format)
    • Conditional Formats
    • Clear conditional formats

Prerequisites & Certificates
Pre-Requisites

Microsoft Excel 2016 Level 1 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 New Location
609 Granville Street
6th Floor
suite 650

Vancouver, BC
Canada   V7Y 1G6


Reviews
 
I am being told by a fellow employee that a different trainer they had for another course did a much better job. So I am giving your company the benefit of doubt. The instructor in this course was bouncing around through different levels of Excel and did not stay on topic.
Reviewed by 2017
13-December-2017 $207 Regular Price $259 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

Not interested in this Course?

Tell us why:

This page has been viewed 55 times.