Return to Search page:

Instructor-led Training Overview

Name: Excel: Understanding Excel's Basic Formulas

Overall Rating:

4.7 out of 5 (7 ratings)

Category: All Learners

Duration: 1.00 hour(s)

Individual Fee: Free

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

Overview

Learn the basic Excel skills in one hour.

Data entry
Opening, saving and closing files
Navigating within a worksheet
Learn the difference between relative and absolute cell references
Learn how to copy and paste formulas in Excel and apply autofill

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

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

Attendees will create and edit basic mathematical formulas. You will build formulas in Excel with function autocomplete or by typing them manually, while learning essential functions like SUM, MIN, MAX, AVERAGE and COUNT. You will also learn the difference between relative and absolute cell references as well as learning how to copy and paste formulas in Excel and apply autofill options.

Course Outline

Topics

Learn the Rules for Formulas
Rediscover the Order of Operation
Why Cell Referencing is Important
Discover Basic Calculations
Be Introduced to Functions and Autosum
Use SUM, AVERAGE, MAX, MIN, and COUNT
Use Autofill to Simplify Data Entry
Copy Formulas to Other Cells
Differentiate between Relative and Absolute References

Impacted Skills

Skill	Prerequisite	Expected Outcome
Excel	1 - Beginner	Not specified
Excel Formulas & Functions	1 - Beginner	Not specified

Subject Matter Experts

Cathy Horwitz

Years of Experience:44+ years

Area of Expertise: Microsoft Office

Costs

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

Reviews

1 2 3 4 5	4.7 out of 5 (7 ratings)

1 2 3 4 5	I Understand Basic Formulas! Tue, Feb 1, 2022
Great instructor!

1 2 3 4 5	Excel: Understanding Excel's Basic Formulas Mon, Jan 24, 2022
The course was very well. The instructor has deep knowledge of the subject and explains clearly and simply, very easy to understand. Thanks a lot.

1 2 3 4 5	Understanding Excel's Basic Formulas Thu, Jan 20, 2022
Kathy was very professional and patient. She explained each step and made sure the participants understood the step prior to moving on to the next one. I am interested in other Excel trainings she teaches. Thank you!

[See all User Reviews…]

Return to Search page: