Computer Training Birmingham Alabama, Microsoft Office 2007, Microsoft Office 2003, IC3 Training, MOS, MCAS, Microsoft Office Excel 2003, Microsoft Office Excel 2007, Microsoft Office Project 2003, Soft Skills

Increasing the effectiveness of your workforce can be as simple as getting the right technology training!

News & Events

Technology Over Breakfast

Microsoft Office 2007

Soft Skills Training

Mastering Excel Formulas
Note: available for Microsoft Excel 2007 or 2003 versions

Are you ready to master Excel formulas?

Formulas are part of the power of Excel! Formulas can be used for many needs from calculating values to combining text columns together as one and much more!

There are many categories of functions within Excel each with powerful benefits. The outline below lists the topics that you will cover in this hands-on four-hour workshop. A computer and textbook will be in place for each person.

The course will start off with a brief review of formula rules, creating and editing formulas, afterwards on to more in-depth formula creation.

Topics Overview

Formula Review

Formula rules
Creating basic function formulas (SUM and AVERAGE)
Relative versus Absolute cell referencing
Editing formulas

Range Names

What are range names?
Creating range names
Using range names
Editing range names

Logical Functions

IF
VLOOKUP

Database Functions

DSUM

Statistical Functions

COUNTIF

Text Functions

CONCATENATE
PROPER
LOWER
UPPER

Prerequisite: A minimum knowledge in creating and modifying spreadsheets is required. Attendees must know how to insert rows, columns and cut, copy, and paste.