Microsoft Excel: Introduction
Microsoft Excel Training Series | Level 1
Duration: 1 day
Microsoft® Excel® Versions: 2010 | 2013 | 2016 | 365 (Windows)
Delivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC) on request
Course Dates: December 10, 2018 | January 29, 2019 | View schedule
Course Fee: $295 CDN per person + HST or BYOD (bring your own device): $245 CDN person + HST*
Note: Public scheduled dates for this course are delivered as live instructor-led classroom training.
During this hands-on course, novice users will learn core skills to work effectively with Microsoft Excel worksheets. Students will learn to enter and edit different types of data and to enter formulas using operators and functions. Various strategies will be used to format and edit worksheets and workbooks. Different print settings will be applied and then previewed. At the end of the day, students will also learn to create simple charts quickly and easily. Throughout this course, the instructor will include numerous tips, tricks and shortcuts. Each student will also receive a full course manual.
Prerequisite: Basic keyboarding and computer skills
Location and timing: Public scheduled courses are held in downtown Toronto and run from 9:00 am to 4:00 pm (Eastern Standard Time).
Custom training: This course may be delivered at your site or ours as an instructor-led or virtual classroom solution. Contact us at firstname.lastname@example.org for more information including savings for custom group training.
Related training: View all Microsoft Excel courses >
INCLUDED IN THIS COURSE
- Comprehensive course manual
- Keyboard shortcuts quick reference
- Sample and exercise files
- Refreshments (for classes conducted in Avantix Learning classrooms)
- Certificate of completion
- Follow-up email support
Working in the Microsoft Excel Environment
- Overview of the Ribbon and the Quick Access Toolbar
- Navigating quickly in a worksheet
- Selecting cells and cell ranges using different strategies and shortcuts
- Entering different types of data
- Resizing columns and rows quickly and easily
Managing Workbooks and Worksheets
- Creating a new Excel workbook
- Saving a workbook
- Naming worksheets
- Moving or copying worksheets
- Inserting and deleting rows and columns
- Inserting and deleting worksheets in a workbook
- Using various strategies and shortcuts to cut, copy and paste data
Formatting Cells, Rows and Columns
- Applying number formatting
- Changing font and size
- Changing alignment
- Applying borders and shading
Creating Basic Formulas
- Creating simple formulas using basic operators
- Changing data and viewing updated results
- Showing and hiding formulas
- Entering formulas using the common Excel functions SUM, AVERAGE, MIN, MAX and COUNT
Understanding Errors and Error Checking
- Types of errors
- Choosing error checking options
- Ignoring errors
Previewing and Printing
- Setting a print area
- Changing margins
- Adding headers and/or footers
- Previewing your final result
Creating a Simple Chart
- Creating a basic bar or column chart from data
- Formatting the chart
- Changing the underlying data and view the updated results in the chart
Register Now for a public course at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.
Do you have any other questions? Contact us!
If you are looking for more information regarding versions, check out our Microsoft Excel versions overview.
Want to know more about our Excel courses? Check out our Frequently Asked Questions.
To request this page in an alternate format, contact our staff.
*Prices subject to change.
Copyright 2018 Avantix® Learning Inc.
You may like
As many Excel worksheets can become quite large, it can be useful to freeze row and column headings so that they are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one.
It’s a common issue for Microsoft Excel users to attempt to use AutoFill to fill data in a filtered list and it doesn’t work as expected. The fill data is entered into all cells, including the hidden or invisible cells. The solution is to enter data into visible cells only …
You can insert subtotals in Microsoft Excel data sets or lists using the Subtotal feature. Check out these 10 great tips which include showing and hiding subtotals, formatting subtotals, copying only subtotals and grand totals and more …
You may also like
You can easily change the measurement system units in Microsoft Word for all of your documents. If you’d prefer to work in inches rather than centimeters (or vice versa), simply change the measurement system in Word’s Options.
You can add notes or speaker notes in your PowerPoint files using the Notes pane in Normal view. Notes may be viewed by a presenter during a presentation and may be printed as well. When you create your PowerPoint slides, you can add, edit and format notes.
Check out these Word tips, tricks and shortcuts to select an entire table, a single cell, an entire row or column or even multiple rows or columns in tables.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | email@example.com