Excel Formulas and Functions Quick Tips
With Jess Stratton
Liked by 26 users
Duration: 46m
Skill level: General
Released: 4/10/2025
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 of us, figuring out how to apply these formulas and functions to solve everyday problems can seem overwhelming. In this course, tech trainer and M365 expert 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 start mastering Excel formula and function basics, including creating formulas, referencing cells, and using key functions like SUM, AVERAGE, and IF. Along the way, discover essential tools for counting, manipulating text, and retrieving specific data with advanced lookup functions. Jess also covers helpful techniques to avoid errors, create dynamic reports using GROUPBY and PIVOTBY, and improve data accuracy with functions like TRIM and IFERROR. By the end of this course, you’ll be prepared to handle a wide range of data tasks efficiently and effectively in Excel.
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.
-
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
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.