Microsoft Excel 2013 or 2016 - Level 1 - Beginner

Office Applications/Productivity
Schedules
  12/26/17 - 9-5pm PST Glendale - CA
Delivery Type (Must Select One)
  Instructor-Led
  Online Live Instructor-Led
Version (Must Select One)
  2013
  2016
Optional
  Certiport Test with Proctor Fee ($126.00)
  Certiport Test with 1 Retake / Proctor Fee ($145.00)
  LearnITAnytime Online Subscription (1 Year Subscription - $195.00)
  IT Online Library (1 Year Subscription - $1595.00)
  Private Mentoring 3 Hours ($125)
Quantity
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions

 

This hands-on beginner class is suitable for Excel 2010, 2013 and 2016 users.
You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts.
Live face-to-face instructor. No minimum class size - all classes guaranteed to run!
This course is ideal for people new to Excel who need to produce reports, budgets, lists and other spreadsheets.


Excel Essentials
  • Starting Excel
  • The Excel Interface
  • Opening a Workbook
  • Navigating around a Workbook
  • Finding Data
  • Entering Data
  • Saving and Closing a Workbook

Creating Worksheets
  • Types of Data
  • Entering Text
  • Adjusting Column Width
  • Entering Numbers
  • Types of Formulas
  • Entering Formulas
  • About Functions
  • Inserting Functions
  • Copying and Moving Data
  • Copying Formulas
  • Absolute and Relative References

Formatting
  • Text Formatting
  • Number Formatting
  • Alignment
  • Text Wrapping
  • Merging Cell Data
  • Borders and Highlighting
  • Styles and Themes

Manipulating Data
  • Data Entry Shortcuts
  • Fill and Auto Fill
  • Replacing Data
  • Paste Options
  • Inserting and Deleting Rows and Columns
  • Hiding Rows and Columns

Charts
  • About Charts
  • Creating Charts
  • Chart Types and Elements

Output
  • Managing Worksheet Windows
  • Freezing Panes
  • Printing Worksheets
  • Print Setup Options
  • Print Areas and Titles
  • Headers and Footers
  • Sharing Workbooks

Settings and Templates
  • Workbooks Options and Properties
  • Working with Templates


Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.


 

At course completion:

 

This course is ideal for people new to Excel who need to produce reports, budgets, lists and other spreadsheets.


 

Previous Windows experience recommended


 

You may cancel this class 10 or more business days prior to the start date of the class for a full refund. No shows or cancellations made within 10 days will forfeit all fees paid.