Excel Formulas and Functions Quick Tips Preview

Excel Formulas and Functions Quick Tips

With Jess Stratton Liked by 1,576 users
Duration: 35m Skill level: General Released: 7/24/2023

Start my 1-month free trial

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

4.7 out of 5

3,049 ratings
  • 5 star
    Current value: 2,340 76%
  • 4 star
    Current value: 476 15%
  • 3 star
    Current value: 173 5%
  • 2 star
    Current value: 34 1%
  • 1 star
    Current value: 26 <1%

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

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.