Skip to content

[Grad-Cap Icon] Training

Search

You may use any or all of the criteria below to search for available instructor-led training classes or for self-paced training materials.

You may optionally refine your search with one or more of the following categories:

[Back Icon] Back to results

Excel 2013 Introduction

David Brobst, Technology Services
Sanger Hall - B1-020

No registration available.
Date Time
Tue 03/31/2015 9:00am - 12:00pm

This course covers the basics of using Excel 2013 in the office and teaching environments. Excel is a spreadsheet program that is able to calculate and analyze numerical data. Collected data displays graphically with a chart/graph or in table format. Basic terms and how they apply to the Excel environment provide an understanding of how Excel works.

Learning Objectives:

  • Describe a spreadsheet and suggest several potential applications
  • Explore Excel "Options" known as Backstage View to change application defaults
  • Create, manage, save, and open a spreadsheet
  • Understand the "Ribbon"
  • Type, copy, manage text, and numeric values in columns and rows
  • Resize, add, move, and delete columns and rows
  • Enter a series of numbers, dates, and data across a range
  • Change page orientation, set print titles and print range
  • Format spreadsheet using Styles
  • Display date and dollar amounts using different formats
  • Use Spell Check
  • Distinguish between a constant, formula, and function
  • Discuss the order of operations
  • Enter a formula to calculate numeric values
  • Use the fill handle to copy formulas across columns and rows
  • Understand the difference between absolute, relative, and mixed cell addressing
  • Enter a function to average and sum numeric values
  • Print a worksheet two ways (displaying the computed values or the cell formulas)
  • Create charts/graphs using Insert>Charts
Important Notice (Microsoft Silverlight): The 2010 videos require Microsoft Silverlight. If your video does not show or play, click the Silverlight installation icon when displayed to install the application. Click here to learn more about Silverlight.

Online Course Options:

Other Resources:

Prerequisites: Computer basics such as using a mouse, navigating, and managing electronic files and folders.
Cost:
$0.00
Sponsor:
Technology Services
Audience:
VCU Students, Faculty and Staff Only
Category:
Computer Basics, Microsoft Office, Spreadsheets
Contact:
VCU helpIT Center
804-828-2227
helpIT@vcu.edu