Excel Formulas and Functions Quick Tips

Focused View

Jess Stratton

35:53

114 View

01 - Introduction

01 - Calculate data with ease in Excel.mp4

00:37

02 - 1. Formula and Function Basics

01 - Build a formula in a cell with =.mp4

01:16

02 - Create a named range.mp4

01:13

03 - Reference cells and worksheets.mp4

01:49

04 - Join text with an ampersand.mp4

00:57

03 - 2. Identifying Values

01 - Calculate a total with SUM.mp4

00:46

02 - Sum values that meet specific criteria with SUMIF.mp4

01:02

03 - Find the mean value with AVERAGE.mp4

00:54

04 - Test for valid data with IF.mp4

01:52

05 - Create complex tests with AND and OR.mp4

01:48

06 - Find record values with MAX, MIN, SMALL, and LARGE.mp4

01:04

07 - Perform date calculations with TODAY().mp4

01:02

04 - 3. Count Functions

01 - Count cells that contain numbers with COUNT.mp4

01:03

02 - Count nonblank cells with COUNTA.mp4

00:54

03 - Return a number of occurrences with COUNTIF.mp4

01:54

04 - Check-in with Jess.mp4

00:53

05 - 4. Text Functions

01 - Format numbers and dates with TEXT.mp4

01:38

02 - Extract characters with LEFT AND RIGHT.mp4

01:07

03 - Extract substrings with MID.mp4

00:56

04 - Count characters with LEN.mp4

01:01

05 - Identify where a character occurs with FIND.mp4

01:53

06 - Join strings with delimiters with TEXTJOIN.mp4

01:42

07 - Change text with SUBSTITUTE and REPLACE.mp4

01:51

06 - 5. Index, Match, and Lookups

01 - Retrieve a specific value with XLOOKUP.mp4

01:42

02 - Use INDEX and MATCH to retrieve a value.mp4

01:40

07 - 6. Avoiding Errors and Invalid Formulas

01 - Remove leading spaces with TRIM.mp4

01:37

02 - Include IFERROR to trap errors in formulas.mp4

01:09

08 - Conclusion

01 - Learn more complex features of Excel.mp4

00:33

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Formulas and Functions

Jess Stratton

Instructor's Courses

I am 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. My writings have been in computer textbooks, and I have several published articles in industry magazines and major websites including Lifehacker.org. I'm a frequent speaker at large industry conferences about productivity, web, and Lotus Notes/Domino. I used to own and operate a successful brick-and-mortar boutique style computer learning facility in downtown shopping district. I LOVE my job. I get to help people be the very best at their own jobs.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.