Microsoft Excel Training Courses | Intermediate Level Class- Toronto

$250

 

Bring your laptop: $225 only   “Use coupon: excel25”

Next Classes:

Weekends: Sun, Feb 17

Weekdays:  Tuesday, Feb 19

Clear
SKU: N/A Categories: , ,

MS. Excel Training Course – Excel Intermediate Level Classes | Designed for Excel 365, 2019, 2016, 2013

 

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:  Excel Intermediate Level Course

Related Excel TrainingExcel Foundation Course  &  Excel Advanced Class

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 $ 25 “$225 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

 

Contact us

 

 

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

PMVISION  reserves the right to postpone/cancel an event, or change the location of an event because of insufficient enrollments, instructor illness or force-majeure events

 

Cancellation & Refund Policy

  • In case PMVISION  cancels an event, 100% refund will be paid to the delegate.
  • If the cancellation is done by the delegate within 48 hours of subscribing, 5% will be deducted as administration fee.
  • If a cancellation is done by a delegate 7 days or more, prior to the event, 20% of total paid fee will be deducted and the remaining amount will be refunded back to the delegate.
  • If a cancellation is done by a delegate 7 days or less, prior to the event, no refunds will be made
  • Bookings made at discounted prices ( Including Early Bird Booking) cannot be cancelled.

Delivery Methods:

  1.  Classroom Training: Downtown Toronto – Mississauga , Scarborough, Ottawa & Montreal.
  2.  Virtual Classroom
  3.  On-Site Training: At your location, anytime , anywhere
  4.  Corporate Training: Special rates for Corporate Training

Group Discount:

We provide special rate for groups :

  • 5% Discount for Group of 2
  • 10% Discount for Group of 3
  • 15% Discount for Group of 4

Certificate of Completion (PDF Format) is available upon attending the course.