Course Description:Most people use Microsoft Excel inefficiently, limiting themselves to just a handful of formulas and functions. They know little or nothing about the many powerful Excel functions that provide extended analytical capabilities that can save time and make you far more productive "Power User" of Excel.Problem is, Excel has nearly 300 built-in functions, and it's no easy task to know which ones might be useful to you. That's what this Webinar is about - exploring the tools most likely to help you and showing you how they work. Our Excel expert will cover how to:Simplify searching for data in tables with the lookup functions VLOOKUP, INDEX, and MATCHCategorize data more effectively by using the master date and time functions Debug formulas that are giving you incorrect answersCreate short, simple formulas by using specialized rounding functions and basic statistical and financial functions Use "array functions" that will help you tackle difficult formulas that deal with massive amounts of data.Use frequently overlooked TEXT functions so you can extract data from within cells, combine data from different cells and give you cleanup tools for dealing with problems such as:Leading or trailing spacesUpper/lowercase changesTrailing minus signs, and Text//value conversionsGain programming-like capability by mastering the IF, AND, OR, and CHOOSE functionsUse the power functions SUMIF and COUNTIF to help you tabulate database totals with easeAnd more |
