$250

Microsoft Excel Training Courses | Intermediate Level Class- Toronto

Event Information

Share this event

Date and Time

Location

Location

PMVISION Training

1 Yonge St, Suite 1801

Toronto, Ontario M5E 1W7

Canada

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Event description

Description

MS. Excel Training Course – Excel 2019 Intermediate Level Classes

For more details and Registration, please visit the course page


This Intermediate Microsoft Excel 2019 training class is meant for students who want to advance their skill set by learning to work with Large Worksheets , Multiple Worksheets and Workbooks, Working with dates, Conditional formulas and formatting, and Using Templates.

Training Type: Classroom Training – Downtown Toronto ” Also available in Mississauga and Scarborough”

Other options : Online Training- On-site at your company office ” Anywhere”

Course Level: Intermediate

Number of students per session: Our class sizes are typically 6 students per session. Our classes are intentionally kept small in order to foster more interaction between the instructor and students. We limit classes to a maximum of six (6) students unless we are teaching a private group or organization. Each student is provided a laptop with hands-on access to Microsoft Excel 2019 (Windows)

Locations: Toronto ( 1 Yonge St), Also we offer the course in Mississauga & Scarborough.

Duration: 1 day ( 10 AM- 5 PM)

Special Offers: Sign up with a friend and save 5% each – Sign up with 2 friends and save 10%

Bring your laptop: Save $ 50 “$250 only” (Your laptop with Microsoft Excel 2016 or Excel 2019 installed). You can get Microsoft office including MS.Excel 2019 for less than $15/Month from Microsoft Office Official site. Select Office 365 Business

Corporate Training: Contact us for special offers

PREREQUISITES

A working knowledge of creating/formatting simple spreadsheets, basic formulas and functions . Or our Excel Introduction Level course.

TARGET AUDIENCE

This course is intended for students who have basic skills with Microsoft Excel 2019 and want to expand their knowledge. Improving formatting, organizing data, highlighting key information and creating formulas/links between sheets. Also for students who want to learn the topics covered in this course in the Excel 2019 interface.

COURSE OBJECTIVES

Upon successful completion of this course, you will have a good working knowledge of the following:

  • Quickly summarise multiple sheets of data into one
  • Turn long lists and reports into easy to read tables
  • Formulas to check whether cells pass or fail your rules
  • Create links between cells so that they all update automatically
  • Highlight targets, trends, duplicates and errors with Conditional Formatting
  • Formatting and layout consistency by saving as a Template

COURSE OUTLINE

Working with Large Worksheets

  • Viewing options
    – Adjusting zoom
    – Using Freeze Panes
    – Using Split Window
    Hiding and displaying data
    – Hiding rows and columns
    – Creating an outline
    Printing large worksheets
    – Page Break preview
    – Working with page breaks
    – Printing multiple sheets

Working with Multiple Worksheets and Workbooks

  • Using multiple worksheets
    – Navigating between sheets
    – Moving and copying sheets
    Linking worksheets
    – Creating 3-D formulas
    – Consolidating data
    Linking workbooks
    – Creating a formula to link workbooks
    – Using the Paste Link option
    – Maintaining links

Working with dates

  • Entering date functions
    – TODAY function
    – NOW function
    Date and time formats
    Using dates in formulas

Conditional formulas and formatting

  • The IF function Conditional formatting
    – Based on a cell value
    – Based on a formula
    – Identifying cells with conditional formatting
    – Copying conditional formats

List Management

  • Working with lists
    – Structure of a list
    Sorting and filtering lists
    – Simple sorting
    – Sorting by multiple columns
    – Using AutoFilter
    Advanced filtering
    – Using custom filter
    – Using Advanced Filter
    Adding subtotals to a list

Documenting and Auditing Comments

– Viewing, adding, editing and deleting comments
Auditing features
– Tracing formula errors
Protection
– Protecting a worksheet
– Protecting cell ranges


Using Templates

  • Built-in templates
    – Accessing and using Excel’s templates
    Creating and managing templates
    – Creating, using and modifying a custom template file


Included Course Materials

  • Course workbook “PDF” including step-by-step course exercises complete with many actual screen captures and advanced project tips, exercises and answers
  • Data files with all applicable Microsoft Excel files used in the course
  • Certificate of completion (PDF)

For more details about Microsoft Excel , please visit the product official page EXCEL 2016

Learn What’s New in Microsoft Excel 2019


Related Classes

Take Microsoft Excel 2019 Fundamentals Training Courses in Toronto, Mississauga, Scarborough , Montreal & Ottawa

Take Microsoft Excel 2019 Intermediate Level Training Classes in Toronto, Mississauga, Scarborough , Montreal & Ottawa

Take Microsoft Excel 2019 Advanced Level Classes in Toronto, Mississauga, Scarborough , Montreal & Ottawa

Microsoft Excel 2019 Tables, Pivot Tables and Conditional Formatting

Microsoft Excel 2019 | Using Formulas for Financial Analysis.

Microsoft Excel 2019 | Using Formulas For Statistical Analysis

Microsoft Excel 2019 | Data Analysis with Pivot Tables


Share with friends

Date and Time

Location

PMVISION Training

1 Yonge St, Suite 1801

Toronto, Ontario M5E 1W7

Canada

View Map

Refund Policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved