Excel 2016: Advanced Formulas and Functions

Focused View

Dennis Taylor

2:18:15

0 View

01 Introduction

001 Master the formulas and functions of Excel for Mac.mp4

01:06

02 Formula and Function Tools

001 Write formulas using a hierarchy of operators.mp4

04:19

002 Save time with AutoSum AutoCalc and extended features.mp4

04:18

003 Absolute Relative and Mixed references.mp4

05:57

03 IF and Related Functions

001 Use relational operators and IF logical tests.mp4

04:48

002 Create and expand nested IF functions.mp4

04:00

003 Create compound logical tests using AND and OR functions with IF.mp4

06:01

04 Lookup and Reference Functions

001 Look up information with VLOOKUP HLOOKUP and XLOOKUP (365).mp4

02:20

002 Find approximate matches with XLOOKUP and VLOOKUP (365).mp4

05:09

003 Find exact matches with XLOOKUP and VLOOKUP (365).mp4

03:49

004 Extended uses of XLOOKUP (365).mp4

04:50

005 Retrieve information by location with INDEX.mp4

02:30

006 Identify the presence of data with MATCH and XMATCH (365).mp4

05:38

05 Statistical Functions

001 Use MEDIAN for middle value MODE for most frequent.mp4

03:40

002 Tabulate blank cells with COUNTBLANK.mp4

02:46

003 Use COUNT COUNTA and the status bar.mp4

03:09

004 Tabulate with COUNTIF SUMIF and AVERAGEIF.mp4

04:57

005 Tabulate with COUNTIFS SUMIFS and AVERAGEIFS.mp4

04:05

06 Math Functions

001 Decimal rounding with ROUND ROUNDUP and ROUNDDOWN.mp4

05:51

002 Other rounding with MROUND CEILING and FLOOR.mp4

04:00

003 Generate random values with RAND RANDBETWEEN and RANDARRAY (365).mp4

05:50

004 Bypass errors and hidden data with AGGREGATE.mp4

05:05

07 Date and Time Functions

001 Use dates and times in Excel formulas.mp4

05:09

002 Use TODAY and NOW for dynamic date and time entry.mp4

03:51

003 Identify the day of the week with WEEKDAY.mp4

03:38

004 Working days with NETWORKDAYS and WORKDAY.mp4

04:39

005 Tabulate date differences with DATEDIF.mp4

04:18

08 Text Functions

001 Locate data with FIND and SEARCH.mp4

05:36

002 Extract specific data with LEFT RIGHT and MID.mp4

02:22

003 Remove extra spaces with TRIM.mp4

04:29

004 Use ampersand () CONCAT and TEXTJOIN to combine cell data.mp4

06:04

005 Adjust case within cells using the PROPER UPPER and LOWER.mp4

03:38

09 Conclusion

001 Continue your Excel journey.mp4

00:23

Description

Excel expert Dennis Taylor demystifies some of the most useful of the 450+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic functions (SUM, AVERAGE, and MAX), and a few critical keyboard shortcuts that will let you locate and display formula cells and accelerate working with Excel formulas—even on multiple sheets. He then covers how to find and retrieve data with the VLOOKUP and INDEX functions, calculate totals with counting and statistical functions, extract data with text functions, and work with date, time, array, math and information functions. The course focuses on practical examples that will help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Formulas and Functions

Dennis Taylor

Instructor's Courses

Leading Excel trainer with more than 200 hours (60+ courses) of online Excel training available on LinkedIn Learning. Presenter of in-person Excel classes and seminars in over 40 states and Canada. To learn more, visit www.excel-train.com.

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.