Loading...

EXCL1: Microsoft Excel – Level 1/Intro (2010, 2013, 2016)

Home / EXCL1: Microsoft Excel – Level 1/Intro (2010, 2013, 2016)

This course teaches students the foundations of Microsoft Office Excel. Students will gain the knowledge and skills to easily create and work with electronic spreadsheets. Students will learn to create, format, and enhance simple spreadsheets, as well as the skills to perform calculations and analyze the data that is critical to the success of their organization.

Course Length: 1 day(s)

Course Price: $275 CAD

Available Course Formats:

  • In-class
  • Instructor Led Online

Enroll Now

Course: EXCL1: Microsoft Excel – Level 1/Intro (2010, 2013, 2016)

  • 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
    • Backstage View*
    • 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, 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
      *2010 version only

Audience

The course is designed for beginner students who wish to gain the foundations of Microsoft Office Excel.

Prerequisites

  • Knowledge of your business requirements
  • Experience using basic Windows functionality
  • Experience using a Web browser

 

Instructor Led In Classroom

Newcomp can directly deliver courses through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.