Excel 2010-Basics

About the Class:

This workshop lasts 3 hours.

It is part of the following certificates series: Office 2010 Productivity  Excel 2010 End-User.

Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with common formulas and functions, and creating a simple chart. Formatting a worksheet and importing a text file are also covered. Although this workshop is intended for the spreadsheet novice, participants with some previous spreadsheet experience may gain a better understanding and learn some new tricks to increase their efficiency in using Excel.

What You’ll Learn:

  • Become familiar with spreadsheet terminology
  • Enter various types of data into a worksheet
  • Work with formulas and functions
  • Create a simple chart
  • Import tab-delimited data into excel
  • Format cells and ranges
  • Create named ranges and use them in formulas
  • Customize printouts

What You Need to Know:

  • Use a mouse
  • Open and close windows
  • Open and save files
  • Switch between applications

If you don’t have those skills, consider first taking the workshop:

Windows: Basic Computing Skills

 

Resources

Excel 2010(PC) Excel 2011(Mac)
Basic Tasks in Excel Microsoft Excel Tutorials