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

Shirley Mitteldorfer, Technology Services
Technology Administration Building - 108

No registration available.
Date Time
Tue 09/02/2014 9am [TAB] - 12pm

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
  • Identify Excel "Options" known as Backstage View to change application defaults
  • Create, manage, save, and open a spreadsheet
  • Understand the "Ribbon"
  • Manipulate text and numeric values in columns and rows
  • Change a series of numbers, dates, and data across a range
  • Modify page orientation, set print titles and print range
  • Format a spreadsheet using Styles
  • Apply different formats to display date and dollar amounts
  • Perform a 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
  • Perform a function to average and sum numeric values
  • Understand how to 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