Excel Formulas and Functions Quick Tips

Offered byLinkedin Learning

Excel Formulas and Functions Quick Tips
at
Linkedin Learning
Overview

Learn how to count cells that meet a specific set of criteria using COUNTIF, extract characters with LEFT and RIGHT

Duration	1 hour
Total fee	₹1,150
Mode of learning	Online
Credential	Certificate

Excel Formulas and Functions Quick Tips
at
Linkedin Learning
Highlights

Earn a certificate of completion from LinkedIn Learning

Excel Formulas and Functions Quick Tips
at
Linkedin Learning
Course details

Skills you will learn

Excel Vlookup

More about this course

The myriad formulas and functions in Excel are, in large part, what makes it such a uniquely powerful program
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
Learn 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

Excel Formulas and Functions Quick Tips
at
Linkedin Learning
Curriculum

Introduction

Calculate data with ease in Excel

Formula and Function Basics

Build a formula in a cell with =

Create a named range

Reference cells and worksheets

Join text with an ampersand

Common Excel Functions

Count cells that contain numbers with COUNT

Count nonblank cells with COUNTA

Return a number of occurrences with COUNTIF

Calculate a total with SUM

Sum values that meet specific criteria with SUMIF

Find the mean value with AVERAGE

Test for valid data with IF

Create complex tests with AND and OR

Format numbers and dates with TEXT

Extract characters with LEFT and RIGHT

Extract substrings with MID

Count characters with LEN

Identify where a character occurs with FIND

Remove leading spaces with TRIM

Join strings with delimiters with TEXTJOIN

Change text with SUBSTITUTE and REPLACE

Find record values with MAX, MIN, SMALL, and LARGE

Perform date calculations with TODAY

Retrieve a specific value with XLOOKUP

Use INDEX and MATCH to retrieve a value

Include IFERROR to trap errors in formulas

Conclusion

Learn more complex features of Excel

Excel Formulas and Functions Quick Tips
at
Linkedin Learning
Faculty details

Jess Stratton

She is an instructor with LinkedIn Learning - With over 300 hours of instructional content on Lynda.com, my courses are specialized for businesses, home office, social media, and personal use focusing on Google Apps, Microsoft Office, home tech, and productivity/mobile apps.