Return to Search page:

Instructor-led Training Overview

Name: Excel Formulas & Functions

Overall Rating:

4.9 out of 5 (22 ratings)

Category: All Learners

Duration: 4.00 hour(s)

Individual Fee: $75.00

Reviewed - This development activity has been approved for value and appropriateness

Overview

Excel functions can greatly enhance your ability to perform tasks in day-to-day activities in Excel. There are hundreds of functions available in Excel. Learn how to find the functions you need. Learn a sample of functions from each of the categories to gain familiarity with their use.

Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, these Excel functions can be very important time savers and enhance your ability to create better performing spreadsheets!

Register for Learning

This Development Activity has not been scheduled.

Provider Information

College of Lake County
19351 West Washington Street
Building E, Suite E186
Grayslake, IL 60030
United States

Contact: Eric Pfligler
847-543-2990
CorporateTraining@clcillinois.edu
https://calendly.com/tadmeeting/tad-employer-demo

Objectives

Importance: Why this competency is important to our organization, mission, strategy, or goals.

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. Knowing how to calculate within Excel is an important skill set. Knowing how to find the function you need is just as critical.

Do and Show: Important tasks or skills you will be able to perform and demonstrate to others.

Understand the rules for entering formulas

Use Function AutoComplete and Autosum

Copying Formulas using Autofill by knowing the difference between Relative and Absolute Cell References

Create 3D Formulas for data consolidation

Assign names to cells for easy reference

Entering Additional Functions

Insert functions using the function dialog box or the Formula ribbon

Statistical Functions - MEDIAN and MODE

Financial Functions - PMT

Date and Time Functions - TODAY and NOW

Logical Functions - IF

Lookup and Reference Functions - VLOOKUP

Text Functions - PROPER, LEFT, RIGHT and TRIM

Separate data with Text to Columns

Course Outline

Topics

Rules for Entering Formulas

Cell Referencing

Order of Operations

Basic Functions

· Function AutoComplete

· Using AutoSum

Autocalculate

Copying Formulas

· Using Auto Fill

· Relative and Absolute Cell References

3d Formula

· Selecting Worksheets

Assigning Names to Cells

· Rules to Follow When Naming Cells

· Methods of Naming Cells

· The Name Box

· Create from Selection

· The Name Manager

Entering Additional Functions

· Using the Insert Function Dialog Box

· Using the Formula Ribbon

Statistical Functions

· MEDIAN Function

· MODE Function

Financial Functions

· PMT Function

· FV Function

Date and Time Functions

· Entering Dates

· Serial Value

· TODAY Function

· NOW Function

Logical Functions

· IF Function

Lookup and Reference Functions

· VLOOKUP Function

Text Functions

· PROPER Function

· LEFT Function

· RIGHT Function

Text to Columns

Impacted Skills

Skill	Prerequisite	Expected Outcome
Excel	3 - Skilled	4 - Advanced
Excel Advanced	3 - Skilled	4 - Advanced
Excel Formulas & Functions	1 - Beginner	3 - Skilled
Excel Intermediate	3 - Skilled	4 - Advanced

Subject Matter Experts

Cathy Horwitz

Costs

Class Costs
Class Value	No Charge
Individual Fee	$75.00
Private Class Fee	$0.00

Reviews

1 2 3 4 5	4.9 out of 5 (22 ratings)

1 2 3 4 5	Excel Formulas and Functions Wed, Dec 6, 2023
Cathy Horwitz did an excellent job of teaching the Excel Formulas and Functions seminar, which will be helpful with the work I currently do. Thank you, Cathy!

1 2 3 4 5	Excel Formulas & Functions Fri, Dec 1, 2023
Excellent training! Learned a lot and new functions that I was not aware of.

1 2 3 4 5	The class was very informative. I learned alot Thu, Nov 30, 2023
The teacher was very good. She would start talking about something and I would think "I know all about that" and then she would preceed to provide helpful tools to make my processing more efficient. I really enjoyed the class. I always want things to move faster but i understand the class is filled with different knowledge levels.

[See all User Reviews…]

Return to Search page: