Excel Formulas and Functions Quick Tips
With Jess Stratton
Liked by 1,759 users
Duration: 37m
Skill level: General
Released: 7/24/2023
Course details
The myriad formulas and functions in Excel are a large part of what makes it such a uniquely powerful program. But for many users, figuring out how to apply these formulas and functions to solve everyday problems can seem overwhelming. In this course, staff instructor Jess Stratton demystifies these powerful features, sharing bite-sized tips designed to help you work faster and more efficiently in Excel. Jess begins by covering the fundamental concepts you need to get started with functions and formulas, such as how to programmatically reference cells located in other worksheets and combine cell data with other characters. She goes over identifying values, then digs into a variety of useful Excel functions. Jess highlights how to count cells that meet a specific set of criteria using COUNTIF, extract characters with LEFT and RIGHT, use INDEX and MATCH to retrieve a value, and much more.
Skills you’ll gain
Meet the instructor
Learner reviews
-
Steel Morss
Steel Morss
Mine Geologist
-
Michele Allen
Michele Allen
Operations Professional | Senior Analyst & Auditor at Verizon Wireless
-
Roniet Bhavsar
Roniet Bhavsar
Supply Planner (CMO) at Intas Pharmaceuticals Limited
Contents
What’s included
- Practice while you learn 1 exercise file
- Test your knowledge 6 quizzes
- Learn on the go Access on tablet and phone