Microsoft Excel Training Courses | Intermediate Level Class- Toronto
Event Information
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
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