Colorado Free University Course Listing and Online Registration

Excel Formulas & Functions: On-Demand eLearning

Course:3427Z24
Dates:December 31, 2024
Meets:On-Demand eLearning, (6) 15-minute lessons
Location:On-Demand eLearning
Cost: $99.00

There are still openings remaining at this time.

OR

Save $0.00 with a CFU Membership

The Excel Formulas & Functions course includes the details of creating calculations in Excel from the most basic arithmetic formulas to some of the most important (and newest!) of the 475 built-in functions. Create spreadsheets that surpass!

Course Benefits / Outcomes

    • Create and manage accurate/effective Excel formulas
    • Identify mathematical processes to achieve accurate results
    • Use AutoSum, Average, Min, Max, Count formulas using the shortest shortcuts
    • Create basic formulas (demonstrate understanding of Order of Operations)
    • Calculate across multiple worksheets and workbooks
    • Save time with tips for paste special, fill down, auto sum, and show formulas
    • Process multiple calculations with a single formula
    • Learn preference settings for formulas and troubleshooting tips
    • Select the best solution from the collection of vital formulas and functions, including the newest function that replaces VLOOKUP and HLOOKUP.
    • An overview of Excel’s newest functions is included!

Prerequisite: Intended for Brave Beginners, Intermediate and Advanced Users who need best practices, shortcuts, and an introduction to the newest built-in functions.

On-Demand eLearning courses allow you to learn at your own pace and whenever it's convenient for you. All eLearning courses come with instructional videos, downloadable e-notes workbook, practice file, and knowledge review questions to assess your understanding of the topic. The video courses are composed of six 15-minute segments, for a total of 90-minutes per topic session. Students will receive an email within 2 business days of registering for the course containing a link to the online eLearning videos and downloadable class files and course E-Notes. Videos are accessible for 120 days.

On-Demand courses were developed by Mitzi Katz, a longtime CFU instructor and professional trainer, in collaboration with Ann Marie Elacqua, instructional designer, to provide busy professionals the opportunity to upgrade skills in a way that is convenient and efficient.

**Please note: You may register for and start this course at anytime. The 12/31/2024 date indicated is for our internal systems only and is not the actual date of the course.

Notes:

This course is presented as On Demand eLearning. You may access your course at a time that is convenient to you. You will receive an email within 2 business days of registering for your course containing a link to the online eLearning portal and an access code to download class files and access our training video. Videos are accessible for 120 days.
Fee: $99.00

Save $0.00 with a CFU Membership

On-Demand eLearning

This course is presented as On-Demand eLearning. You may access your course at a time that is convenient to you. You will receive an email within 2 business days of registering for your course containing a link to the online eLearning videos and downloadable class files and course E-Notes. Videos are accessible for 120 days.