Microsoft Excel Beginner

by Rapid Computer Training Inc. Claim Listing

Microsoft Excel is a spreadsheet application used all over the world in commercial and industrial applications where numbers are involved. This includes analysis, payroll, inventory, finance, accounting, charting, data listing, and complex calculations of any kind.

$310

Contact the Institutes

Fill this form

Advertisement

Rapid Computer Training Inc. Logo

img Duration

1 Day

Course Details

Intensive, hands-on, Excel Beginner course delivered online by a live trainer and not recorded videos. Please read the prerequisites and other details in the description below. We have distinct course dates for Pacific and Eastern Time zones. You can explore both options below.

Microsoft Excel is a spreadsheet application used all over the world in commercial and industrial applications where numbers are involved. This includes analysis, payroll, inventory, finance, accounting, charting, data listing, and complex calculations of any kind.

Our Excel Beginner course is designed for office users or those planning to work in an office. It is a foundation course that prepares you to take an intermediate course. It is recommended for those who are self-taught, as it fills the holes and gaps in their learning. Please refer to the detailed course outline below to learn what is covered in the course.

 

Prerequisites: 

At least six months of work experience in a Windows environment Good mouse skills

 

Course Outline
Lesson 1: Mastering the Excel Interface

  • Spreadsheet Basics

  • Running Microsoft Excel

  • The Excel Screen

  • Changing the Workbook View

  • Working with the Quick Access Toolbar

  • Working with Help

 

Lesson 2: Data Entry, Navigation and Data Selection

  • Using the auto-fill

  • Entering Information

  • Working with Dates

  • Editing Data

  • Deleting Data

  • Navigating Within a Worksheet

  • Selecting Cells

  • Copying Cells

  • Dragging and Dropping

  • Working with the Office Clipboard

  • Aligning Cell Data

  • Formatting Numbers

 

Lesson 3: Working with Formulas and Functions

  • Entering a Formula

  • Using Cell Addresses

  • Correcting Formulas

  • Absolute Cell Addressing

  • Working with Function Arguments

  • The AutoSum Feature

  • Accessing other Functions

 

Lesson 4: Worksheet Formatting

  • Applying Formatting Attributes

  • Changing Fonts and Point Size

  • Cell Borders and Colors

  • Customizing Cell Formats

  • Using Cell Styles

  • Using the Format Painter

  • Hiding and Unhiding Columns

  • Inserting a Row or Column

  • Deleting a Row or Column

  • Adjusting Column Width and Row Height

  • Spell-Checking the Worksheet

  • Freezing Columnssss and Rows

  • Splitting the Screen

 

Lesson 5: Managing a Workbook

  • Working with Multiple Sheets

  • Naming Worksheets

  • Deleting a Worksheet

  • Grouping Sheets

  • Switching Between Workbooks

 

Lesson 6: Printing Excel Worksheets

  • Printing

  • Changing the Page Setup

  • Changing the Print Area

  • Defining Print Titles

  • Customizing Headers/Footers

 

Appendices:  Handy Keyboard Shortcuts

  • Appendix A: Function Keys

  • Appendix B: Cursor Movement Keys

  • Appendix C: Shortcut Keys

 

Hands-on Exercises

 

  • Vancouver Branch

    777 Hornby Street, Suite 600, Vancouver

Check out more MS Excel courses in Canada

New Horizons London Logo

Excel 2016 - Part 1

Through completing the introductory Excel 2016 training course, you’ll develop foundational data manipulation knowledge and skills that you can build upon through additional training and use.

by New Horizons London [Claim Listing ]
Training Ottawa Logo

Microsoft Excel

This one-day course teaches you the basics of work books and work sheets. You will learn how to enter and format data, text, and formulas; how to use pre-defined functions for basic calculations; and how to avoid errors.

by Training Ottawa [Claim Listing ]
University of Ottawa’s Professional Development Institute Logo

Influential PowerPoint Presentations

A well-thought-out and constructed PowerPoint presentation can be an extremely effective way of communicating complex information quickly and efficiently to a range of audiences including senior officials and decision makers.

by University of Ottawa’s Professional Development Institute [Claim Listing ]
Training Ottawa Logo

Microsoft Word Basic

In this course, you’ll learn the basics of creating, editing, and formatting documents in Word 2013. Discover how to leverage templates to build better documents, collaborate with other team members, create numbered and bulleted lists, and work with tables.

by Training Ottawa [Claim Listing ]
The Great Canadian Training & Consulting Company Logo

Excel Level 2

Designed for users comfortable with the Level 1 topics and most of the Home Ribbon, but inexperienced with its more powerful features. Your Results: Become comfortable with the most common features and functions to use Excel in many new and powerful ways.

by The Great Canadian Training & Consulting Company
  • Price
  • Start Date
  • Duration

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