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.
In this course, students learn how to use both the e-mail program and the personal information manager components of Microsoft Outlook. The skills learned in this course will help students use Microsoft Outlook effectively both at work and in their personal lives.
A support Analyst is an IT professional who resolves issues related to computer applications, hardware, and peripherals. This interdisciplinary is meant to transition to a Support Analyst career from the ground up.
Students will use formulas and built-in functions to solve mathematical problems, perform calculations, and filter and format data. By course-end, students will have the skills to illustrate and present spreadsheet data in graphical form, and develop a custom Excel application.
This course provides hands-on learning with Microsoft Excel and its applications in today’s business environment. Learners develop skills to navigate, consolidate, and analyze data across multiple worksheets.
You will focus on the core tools that you use; completing any three of the five courses will earn you a Microsoft Office Specialist digital badge from the University of Calgary.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy