Excel: Introduction to Formulas and Functions
With Curt Frye
Liked by 1,828 users
Duration: 1h 54m
Skill level: Intermediate
Released: 9/19/2023
Course details
To unlock the power of Excel, you need to use formulas and functions. These calculation tools help you bring information to the surface and make better decisions. Excel: Introduction to Formulas and Functions shows beginner-level users how to summarize and analyze data with these powerful data analysis features. Instructor Curt Frye shows how to create formulas with mathematical operations such as addition, subtraction, multiplication, and division, and how to use cell references in your formulas. He explains how to summarize data with functions like SUM and AVERAGE, and work with data in named ranges and Excel tables. Curt also covers procedures to ensure data integrity, such as data validation, and demonstrates auditing techniques to ensure formulas are correct.
Note: This course was recorded on Excel for Microsoft 365. Most of the course contents will also be useful to those working with the most recent standalone versions of Office, including Office 2021.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
LinkedIn Learning
Certificate of Completion
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
-
-
Delora Clemons
Delora Clemons
Administrative Assistant at University of the Pacific - School of Health Sciences
Contents
What’s included
- Practice while you learn 1 exercise file
- Test your knowledge 5 quizzes
- Learn on the go Access on tablet and phone