Class Outline

 
UNC Charlotte

Information & Technology Services
Faculty and Staff Training

 

Using Excel Formulas & Functions

Microsoft Excel has available formulas and functions that manipulate numbers and dates. You will learn how to create formulas and use functions to perform arithmetic operations and date manipulation.

Length: 
2 hours		 Book:
Quick Reference Card
Optional Reference Book
Microsoft Excel 2002 Illustrated Complete
 0-6190-4505-1		 Prerequisite Class or Equivalent Knowledge:
Get to Know Your Computer
Understand the Windows (or Macintosh) Desktop Create Spreadsheets in Excel

Download Module

Course Content

Working with Formulas and Functions
  • Review Absolute and Relative References
  • Create formulas
  • Generate totals
  • Use dates
  • Build conditional statements
  • Use statistical functions
  • Display & print formula contents
  

 


 

 

Top of Page