Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Excel - Level 1 / Intro (2013)

New – Gain the knowledge, skills, and confidence to create, format, enhance, and print simple spreadsheets.

GK# 6705

Course Overview

TOP

Students will gain the knowledge, skills, and confidence to create, format, enhance, and print simple spreadsheets.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze data critical to the success of your organization. You will:

  • Get started with Microsoft Office Excel
  • Perform calculations
  • Modify a worksheet
  • Format a worksheet
  • Print workbooks
  • Manage workbooks

Outline

TOP
Viewing outline for:

Classroom Live Outline

Create, Open, and Save Workbooks

  • What is Excel?
  • Create a New Blank Workbook
  • Create a Workbook from a Template
  • Open Excel Files
  • Get Help
  • Save Workbooks
  • Navigate a Workbook

Explore the User Interface

  • Ribbon Overview
  • Mini Toolbar
  • Status Bar
  • Shortcut Key Tips
  • Contextual Tabs

Work with Data

  • Enter, Edit, and Delete Data
  • Data Selection Methods
  • Use Autofill and Autocomplete
  • Cut, Copy, Paste, and Paste Special
  • Resize Columns and Rows
  • Insert and Delete Columns, Rows, and Cells
  • Use Undo, Redo, and Repeat
  • Spellcheck and AutoCorrect
  • Use Find, Replace, and Go To
  • Use Basic Functions
  • Use SmartTags and Options Buttons
  • Add, Edit, and Remove Comments

Format a Workbook

  • Format Using the Home Ribbon
  • Format Using the Mini Toolbar
  • Format Using Dialog Boxes
  • Use and Modify Conditional Formatting
  • Use the Format Painter
  • Create and Modify Styles
  • Add, Name, Move, Delete, and Colour Sheets

Charts

  • Create and Format a Chart
  • Modify Chart Layout and Structure
  • Change Chart Types, Options, Location, and Data Source
  • Save a Chart as a Template

Printing and Viewing a Workbook

  • Use the View Ribbon
  • Split and Freeze
  • Manage Multiple Windows
  • Use Page Layout, Print Preview, and Basic Print Options
  • Add Headers and Footers

Customize

  • Customize the Quick Access Toolbar
  • Show/Hide the Ribbon

Prerequisites

TOP

The prerequisites for this course are an introductory course to Windows or a solid working knowledge of Windows.

Who Should Attend

TOP

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets.

Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Request this course in a different delivery format.
Enroll