• Course
  • Vendor

This course provides a thorough exploration of the intermediate-to-advanced features in Excel that helps users perform more sophisticated data analysis, calculations, and formatting.

  • Course Start Date: 2024-03-21
  • 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 1 or equivalent experience

Lessons

This course provides a thorough exploration of the intermediate-to-advanced features in Excel that helps users perform more sophisticated data analysis, calculations, and formatting.

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

  • Managing multiple worksheets and workbooks
  • Working with intermediate/advanced formulas and functions
  • Using advanced formatting techniques
  • Using the auditing tools to determine data dependencies and errors
  • Using charts to graphically represent data

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 and Workbooks
  • More on Formulas and Functions
    • A Quick Review on Creating and Using Functions
    • Using The PMT Function
    • Using The IF Function
    • Using The AND and OR function
    • Creating Nested Functions
    • Auditing Worksheets
    • Identifying the Auditing Commands
    • The Watch Window
    • The Formula Evaluator
    • Tracing Precedents and Dependents
    • Correcting Worksheet Errors
  • Naming Cells and Ranges
    • Creating and Using Named Ranges
    • Automatically Naming Ranges
    • Navigating with Named Ranges
    • Using Range Names in Formulas
    • Pasting a List of Named Ranges
    • Deleting and Editing Range Names
    • Creating Named Constants
  • Advanced Formatting
    • Using Comments in a Worksheet
    • Reviewing, Showing, and Hiding Comments
    • Deleting a Comment
    • Using Format Painter
    • Creating Custom Number Formats
    • Applying Conditional Formatting Rules
  • Charting
    • Using Charts
    • Creating a Chart
    • Changing Chart Type, Style and Chart Sub-Type
    • Changing the Chart Source Data
    • Adding data to an existing chart
    • Changing the data in an existing chart
    • Removing 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

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-20
Virtual
ON TRACK COMPUTER TRAINING
2024-03-22
Virtual
ON TRACK COMPUTER TRAINING
2024-03-21
Virtual
ON TRACK COMPUTER TRAINING
2024-03-26
Virtual

More Courses in 'Microsoft Excel Training' Category

GLOBAL KNOWLEDGE
2024-05-06
Virtual
GLOBAL KNOWLEDGE
2024-03-22
Virtual
GLOBAL KNOWLEDGE
2024-08-08
Virtual
GLOBAL KNOWLEDGE
2024-09-05
Virtual