Microsoft Excel (Introduction)

by Avantix Learning Claim Listing

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.

$275

Contact the Institutes

Fill this form

Advertisement

Avantix Learning Logo

img Duration

1 Day

Course Details

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

  • Toronto Branch

    18 King Street East, Suite 1400, Toronto

Check out more MS Excel courses in Canada

Academy of Learning Career College Logo

Microsoft Outlook

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.

by Academy of Learning Career College [Claim Listing ]
SysIntelligence Institute of Technology Logo

System Administrator / Support Analyst

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.

by SysIntelligence Institute of Technology [Claim Listing ]
Manitoba Institute of Trades and Technology Logo

Microsoft Excel For Business

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.

by Manitoba Institute of Trades and Technology [Claim Listing ]
Bow Valley College Logo

Microsoft Excel

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.

by Bow Valley College [Claim Listing ]
University Of Calgary Logo

Microsoft Office Specialist

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.

by University Of Calgary [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy