• Course
  • Vendor

This course completes the Excel series by teaching users how to perform what-if analysis on data, protect data, manage and manipulate lists, convert list data into Pivot Tables, and use Macros to automate repetitive tasks without knowledge of programming

  • Course Start Date: 2024-03-28
  • Time: 08:30:00 - 16:30:00
  • Duration: 1 Day(s)
  • Location: Virtual
  • Delivery Method(s): Virtual Instructor Led
$400.00
REGULAR PRICE $499.00 Save $99.00
2 discount seats left!
or make an offer

Course Outline

Pre-Requisites

Microsoft Excel 365 / 2019 / 2016 Level 2 or equivalent experience

Lessons

This course completes the Excel series by teaching users how to perform what-if analysis on data, protect data, manage and manipulate lists, convert list data into Pivot Tables, and use Macros to automate repetitive tasks (without knowledge of programming).

With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.

Objectives

  • Performing What-If Analyses using Goal Seek, Data Tables, and Scenario Manager
  • Protecting Data in the Worksheets and Workbook
  • Managing and Manipulating Data in a List
  • Creating and Managing Pivot Tables
  • Using Sparkline charts to add graphical representation to data
  • Using Other Advanced Analysis Techniques and Tools

Outline

  • Performing What-If Analysis

    • Using Goal Seek
    • Using Data Tables
    • Using Scenario Manager
  • Protecting Data

    • Using Data Validation
    • Using Worksheet Protection
    • Using Workbook Protection
    • Password Protecting a Workbook
    • Using "Read-Only"Mode
  • Working with Lists (aka Datasets, Recordsets)

    • Creating a List
    • Sorting a List
    • Filtering a List using AutoFilter
    • Filtering a List using Advanced Filter
    • Outlining data
    • Subtotaling data in a List
  • Creating and Managing Pivot Tables

    • Identifying the Structure of a Pivot Table
    • Creating a Pivot Table from worksheet data
    • Creating a Pivot Table from an external data source
    • Modifying, filtering, and formatting a Pivot Table
    • Using Slicers to filter a Pivot Table
    • Formatting Slicers for a consistent look
    • Sharing Slicers between Pivot Tables
  • Sparklines

    • Understanding the types of Sparklines
    • Creating a sparkline
    • Customizing sparklines
    • Controlling which value points are shown
    • Changing the style of or format sparklines
  • Working with Macros

    • Understanding what a Macro really is
    • Recording and Using Macros
    • Assigning Macros

Cancellation Policy

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

Training Location

Virtual
Your Address

Your City, Your Province
Your Country   

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 147 reviews.

No comment
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

Course Reviews

No Reviews Yet

More Courses from On Track Computer Training

ON TRACK COMPUTER TRAINING
2024-03-22
Virtual
ON TRACK COMPUTER TRAINING
2024-03-20
Virtual
ON TRACK COMPUTER TRAINING
2024-03-25
Virtual
ON TRACK COMPUTER TRAINING
2024-03-21
Virtual

More Courses in 'Microsoft Excel Training' Category

ON TRACK COMPUTER TRAINING
2024-03-21
Virtual
GLOBAL KNOWLEDGE
2024-09-04
Virtual
GLOBAL KNOWLEDGE
2024-05-28
Virtual
GLOBAL KNOWLEDGE
2024-04-17
Virtual