COURSE DESCRIPTION FOR
SAVE TIME WITH FUNCTIONS USING EXCEL
DESCRIPTION
Streamline your business and unleash the statistical powers
of Excel. You will discover how to track elapsed time, simply statistical
functions and apply error-handling and auditing techniques. The class is
instructor-led and is full of hands-on activities. You can also bring your
own files to experiment with. Learn to:
- Create formulas and perform calculations involving date
and time.
- Use Database functions and filters to extract information
from a worksheet.
- Do some data analysis using Excel's Statistical functions.
- Handle formulas that sometimes result in errors; use
Excel's auditing features.
LENGTH
One four hour session.
PREREQUISITES
Excel - Level 1 or equivalent
knowledge. You must also have a good understanding of basic Microsoft Windows,
file management and personal computers.
SPECIFIC CLASS CONTENT
Lab Activity 1: Track elapsed time
Experiment with cell formats and dates
Use the Now function to keep the current date in a worksheet
Create formulas to calculate elapsed time
Use the Workday function to calculate project due dates
Lab Activity 2: Get the information you need from your
Excel list
Use the Dsum function
Use the Dcount function
Use the Sumif function
Use the If function
Apply filters
Lab Activity 3: Simplify statistical analysis with functions
Use the Average, Median and Mode functions
Use the Stdev function
Find highs and lows with the Max and Min functions
Count items in a list
Apply filters to a list
Lab Activity 4: Apply error-handling and auditing techniques
Use the Iserror function
Nest the Iserror function within the If function
Use Excel's auditing features
NECESSARY SOFTWARE AND HARDWARE
- An IBM or IBM-compatible computer equipped with Excel
97 (or higher).
- Excel's Analysis ToolPak installed and enabled for Lab
Activity 1.
OTHER EXCEL CLASSES
- Excel - Charting and Organizing Data. Explore all of
Excel's impressive charting capabilities and list management functions.
- Excel - Advanced. Master advanced formulas and other
advanced features including macros and pivot tables.
- Mini Power Sessions:
--Create And Manage A Worksheet Database Using Excel
--Integrate Data And Graphs Into Your Word Document Using Excel And MS
Graph
--Make Sense Of Sales And Product Data With Pivot Tables Using Excel
--Showcase Your Data With Charts Using Excel
--Track And Analyze Business Data Using Excel
| 
