Increase your productivity and work efficiency with various features of Microsoft Excel 2010. Get in-depth understanding of Excel 2010 starting from basic tips, commands and shortcuts to advanced formulas, formatting techniques, macros and charts.
This all-inclusive package helps you to navigate seamlessly through your worksheets and manage your data effectively with simple techniques. Learn fast, efficient ways to sort data, apply filters and use valuable functions to analyze complex data. Make use of formatting techniques to optimize a worksheet’s appearance. Find out quick ways to add formatting features and present your data in a meaningful manner. You will learn how to make your worksheet visually appealing with conditional formatting, form controls, tables, sparklines and SmartArt tools. The package also helps you create a Pivot Table to organize large lists of data in a matter of minutes.
Become competent in advanced Excel formulas and functions. Find out extended uses of the IF and VLOOKUP functions. Learn how to overcome limitations of the VLOOKUP function with the frequently combined MATCH and INDEX functions. You will also become familiar with productivity tips, shortcuts and accelerator tools. Plus, you will learn how to create a macro to automate repetitive tasks and work more efficiently. The package also explains how to create charts to get significant results from your data.
Topics covered in the package:
Benefit from this exhaustive guide and learn new ways to manage your data with Microsoft Excel 2010.
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info