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:
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