Discover Classes. Earn Rewards.

Excel 2013 Introduction

at ONLC Training Centers - Schaumburg

(5)
Course Details
Price:
$295 1 seat left
Start Date:

Fri, Sep 27, 9:00am - 3:45pm

Location:
Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor.
Purchase Options
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

In today's work environment, proficiency with spreadsheets is expected. In this course, you will work with Microsoft® Office Excel® 2013 create a new spreadsheet. You will learn to enter data in the most efficient way. You will create formulas to summarize and analyze data and learn the proper technique to copy and paste formulas. You will also learn to format for emphasis and readability and use print preview and page setup to print worksheets. 

This course is designed for students who are interested in learning the fundamentals needed to create and modify basic spreadsheets using Microsoft® Office Excel® 2013. This course is also intended for students interested in pursuing Microsoft Office Specialist certification in Microsoft® Office Excel® 2013.

Prerequisites

Knowledge of the appropriate Windows operating system. Must be familiar with the mouse, menus, dialog boxes, scroll bars, the Start menu and the taskbar. Proficiency with minimizing, maximizing and restoring Windows is required.


Getting Started

  • Starting Excel
  • Understanding the Display Screen
  • Working with the Ribbon
  • Working with the Quick Access Toolbar
  • Exploring the File Tab
  • Opening a Workbook
  • Managing Open Workbooks
  • Using Excel Help

Entering Data

  • Moving the Cell Pointer
  • Selecting a Range of Cells
  • Creating a New Workbook
  • Entering Constant Values
  • Saving a Workbook
  • Editing Cell Contents
  • Clearing Cell Contents
  • Working with Undo and Redo
  • Closing a Workbook
  • Exiting Excel

Using Formulas

  • Entering Formulas
  • Using the SUM Function
  • Summing Columns or Rows Automatically
  • Using Statistical Functions
  • Working with the Range Finder
  • Using Formula Error Checking

Working with Constant Values and Formulas

  • Copying and Pasting Constant Values and Formulas
  • Moving and Pasting Constant Values and Formulas
  • Using Collect and Paste
  • Using AutoFill

Formatting Worksheets

  • Formatting Numbers
  • Changing the Font Format
  • Aligning Cell Contents
  • Merging Cells
  • Adding Borders
  • Applying Cell Styles

Modifying Columns and Rows

  • Changing Column Width and Row Height
  • Using AutoFit
  • Inserting and Deleting Columns or Rows
  • Hiding Columns or Rows
  • Using Custom Worksheet Views

Editing Workbooks

  • Working with AutoCorrect
  • Checking Spelling
  • Using Find and Replace

Printing Worksheets

  • Using Print Preview
  • Using Page Setup Tools
  • Working in Page Layout View
  • Creating a Header and Footer
  • Using Page Break Preview
  • Printing a Worksheet

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (1)
Start Date Time Teacher # Sessions Price
9:00am - 3:45pm ONLC Remote Instructor 1 $295

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 2950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (2)

Similar Classes

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.
Loading...