• Course
  • Vendor

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: 2019-09-30
  • Time: 08:30:00 - 16:30:00
  • Duration: 1 Day(s)
  • Location: Vancouver
  • Delivery Methods(s): Instructor Led
$396.00
REGULAR PRICE $495.00 Save $99.00
2 discount seats left!
or make an offer

Course Outline

Pre-Requisites

Microsoft Excel 2016 Level 3 or equivalent experience

Lessons

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

Duration: 1 Day

Objectives

This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VB code and assign macros to screen items.

Outline

  • Introduction and the Macro Recorder
    • Introduction
    • Demonstration
    • Recording a macro
    • Recording a macro with absolute references
    • The personal macro workbook
    • Assigning shortcut keys
    • Deleting macros
    • Excel's New File Format
    • Recording a macro with relative references
  • Creating and Editing Macros With VBA Macro Functions
    • Macro storage concepts
    • The VBA program (the VB editor)
    • The program components
    • Storing and handling macros (modules)
    • Introduction to editing code
    • Copying and pasting procedures
    • Linking procedures together
    • Create and use a user-defined function
    • Auto-executable macros
  • Objects and Dialog Boxes
    • Introduction to objects
    • The object browser
    • Using the object browser and searching it
    • Built-in dialog boxes
    • User defined dialog boxes (message boxes and input boxes)
  • Introduction to Controls
    • Worksheet controls
    • User forms
    • Assign Macros to the Ribbon or Quick Access Toolbar
    • Accessing Macros in Excel

Cancellation Policy

Should you postpone or cancel your course you must give 5 business days notice.

Training Location

On Track New Location
609 Granville Street 6th Floor

Vancouver, BC
Canada   

About On Track Computer Training

x

For the best in Microsoft Excel Training in Vancouver, or any other Microsoft product training, including Access, Word, Outlook, PowerPoint or Project training come to On-Track Computer Training. In addition to Microsoft program we also offer: Dreamweaver MX training FrontPage training HTML training courses Flash MX & CS3 training Acrobat 7.0 Professional Illustrator CS2 & CS3 training InDesign CS2 & CS3 training Photoshop CS2 & CS3 training MS Publisher 2003 Visio 2002 training and much more in the Vancouver area. On-Track Computer Training Ltd. has been providing corporate computer training since 1989 and has established itself as a leader in innovative training, consulting and development. As a Microsoft GOLD Certified Partner On-Track continually strives to achieve the best in computer training and guarantees results and rates through our client satisfaction program. GUARANTEE'S Results: On-Track will retrain you at our cost if you are unable to understand objectives and provide complimentary refresher courses within 6 months Rates: On-Track will beat any written corporate computer training rate Support: On-Track provides free technical support through our email and phone system for those difficult situations Service: On-Track staff are all owners of the company and take pride in the service we offer

Training Provider Rating

This vendor has an overall average rating of 4.36 out of 5 based on 146 reviews.

I was expecting to see and learn more advanced materials like pivot point and vlookup in Level 2, but they are in level 3 so I ha ... Read more
x

I was expecting to see and learn more advanced materials like pivot point and vlookup in Level 2, but they are in level 3 so I have to come back for level 3.

She did a wonderful job with our group. It was fun and educational.
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
Great course, great teacher.
No comment
No comment
No comment
No comment
Course was more than I had expected and the trainer was very pleasant and enjoyable to learn from!
Learned what I needed and more. Good class size.
No comment
No comment

Course Reviews

No Reviews Yet

More Courses from On Track Computer Training

ON TRACK COMPUTER TRAINING
2019-10-22
Vancouver
ON TRACK COMPUTER TRAINING
2019-10-24
Vancouver
ON TRACK COMPUTER TRAINING
2019-09-25
Vancouver
ON TRACK COMPUTER TRAINING
2019-10-30
Vancouver

More Courses in 'Microsoft Excel Training' Category

GLOBAL KNOWLEDGE
2020-02-19
Vancouver
GLOBAL KNOWLEDGE
2019-10-01
Vancouver
GLOBAL KNOWLEDGE
2020-03-13
Vancouver
GLOBAL KNOWLEDGE
2020-03-16
Vancouver