- Excel has two companion text functions:…one called Left, one called Right.…They allow us to copy information from the left side…of the cell or the right side of the cell.…And after showing you how these two functions work,…I'll also show you the relatively new feature…called Flash Fill, introduced in Excel 2013 that,…for many people, will negate the need for these functions.…If we want to pull of, for example,…the left-most information.…Say just the Last Name from this list,…we can't do it directly with the Left function.…But we can do it in combination with…another function called Find.…

If we know where the comma is, then we know…that we want everything to the left of that.…Let's start with this function called Find.…And you might have seen this in a previous movie.…We're looking for a comma here.…","…Whatever we're looking for is within commas.…And now a comma to indicate the…second part of the function, the second argument,…which is the location, A2.…Find the comma there for us.…It's in the sixth position, B-A-K-E-R comma.…

Resume Transcript Auto-Scroll

Author

Updated

3/1/2016

Released

1/28/2016

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.