Date Time
Thu 10/08/2015 9:00am - 12:00pm

Microsoft Excel is a spreadsheet program included in the Microsoft Office Suite of applications. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.

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

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