1. All topics
  2. Business
  3. Business Software and Tools
  4. Spreadsheets
Excel Formulas and Functions Quick Tips (2023) Preview

Excel Formulas and Functions Quick Tips (2023)

With Jess Stratton Liked by 3,042 users
Duration: 37m Skill level: General Released: 7/24/2023

Start my 1-month free trial Buy for my team

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

6,562 ratings
  • 5 star
    Current value: 5,092 78%
  • 4 star
    Current value: 1,027 16%
  • 3 star
    Current value: 346 5%
  • 2 star
    Current value: 58 <1%
  • 1 star
    Current value: 39 <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.

Download on the App Store Get it on Google Play