This instructor-led Excel course, designed for beginners, is the best course to learn core skills to work effectively with this popular spreadsheet program. Students will learn to enter and edit different types of data and to enter formulas using operators and functions.
This instructor-led Excel course, designed for beginners, is the best course to learn core skills to work effectively with this popular spreadsheet program. 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 edit, format, and manage worksheets and workbooks. Students will learn best practices to print worksheets and workbooks, set up and filter data, and create simple charts quickly and easily.
During this popular hands-on course, students will practice their skills and have the opportunity to ask questions and interact with the instructor. Each student will also receive a full course manual with tips, tricks, and shortcuts, as well as sample and exercise files.
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
Course Topics
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—text, numbers and dates
Resizing columns and rows quickly and easily
Managing Workbooks and Worksheets
Creating a new Excel 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
Saving a workbook
Formatting Cells, Rows and Columns
Applying number formatting
Applying date formatting
Changing font and size
Changing alignment
Applying borders and shading
Creating Basic Formulas
Creating simple formulas using basic operators to add, subtract, multiply, divide and combine cells
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
Getting Started with Filtering
Setting up lists or data sets
Understanding field names and records
Turning Filtering (auto-filtering) on
Filtering text, number and date fields
Removing filtering
Avantix Learning is a Canadian-owned Toronto-based training organization offering professional training, services, and solutions. We offer courses for Microsoft Office products, the Adobe suite, and FileMaker Pro, as well as training on accessible documents and presentations.
This Microsoft® Word 2013 Level 2 teaches the information worker how to apply some intermediate skills alongwith basic skill sets to work with business documents such as letters, forms, and newsletters.
The Microsoft Office Specialist (MOS) 2016 certification exam has been designed to test a candidate's ability to use an Office application realistically.
We offer Microsoft Office Training Courses across Saskatchewan. Contact us to make a booking for the following MS Office suites.
Access is Microsoft’s powerful database tool. Using Access you will learn to store, retrieve, and report on information. You will be able to sort, make queries, create reports, and understand all the functions of a relational database.
This workshop will teach you how to plan and create superior presentations, with tips on effective design, information flow, and timing. In this course you will learn that, having prepared well, you can actually have fun delivering your presentations.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy