Calgary Public Library

Excel 2013 eLearning kit for dummies, Faithe Wempen

eng

illustrations

no index present

non fiction

Excel 2013 eLearning kit for dummies

dictionaries

860982961

Faithe Wempen

A complete package for learning Excel 2013! Excel is essential to business today, but it can be tricky to navigate. If you're eager to excel at Excel, then this dynamic multimedia learning solution is for you. This complete Excel 2013 package includes a full-color printed book and a For Dummies interactive eLearning course on CD. You'll discover the basics of the Excel interface, how to navigate it, and how to make the most of key features including charts, formulas, functions, macros, and more. Follow the material sequentially or jump in and out as you wish - it's set up

At a Glance; Table of Contents; Introduction; About This Kit; Foolish Assumptions; Icons Used in This Kit; Beyond the Book; Where to Go from Here; Lesson 1: Creating Basic Worksheets; Understanding the Excel Interface; Typing and Editing Cell Content; Changing the Worksheet Structure; Working with Worksheets; Summing Up; Lesson 2: Creating Formulas and Functions; Introducing Formulas; Moving and Copying Formulas; Introducing Functions; Working with Named Ranges; Using Quick Analysis; Summing Up; Lesson 3: Formatting and Printing Worksheets; Adjusting Rows and ColumnsFormatting an Entire WorksheetUsing Theme Formatting; Printing Worksheets; Summing Up; Lesson 4: Formatting Data; Formatting Cells; Formatting Cell Content; Formatting Numbers; Using Conditional Formatting; Summing Up; Lesson 5: Storing and Managing Tables and Lists; Understanding Databases; Working with Tables in Excel; Merging and Splitting Data; Summing Up; Lesson 6: Exploring Financial Functions and Scenarios; Exploring Financial Functions; Analyzing Data; Creating Scenarios; Working with Named Ranges; Summing Up; Lesson 7: Working with Math, Statistical, and Text FunctionsUsing Math FunctionsUsing Statistical Functions; Formatting Data with Text Functions; Summing Up; Lesson 8: Creating and Formatting Charts; Creating a Basic Chart; Changing a Chart; Adding and Positioning Chart Elements; Formatting a Chart; Summing Up; Lesson 9: Working with PivotTables and PivotCharts; Creating a PivotTable; Sorting and Filtering PivotTable Data; Modifying a PivotTable; Creating a PivotChart; Summing Up; Lesson 10: Correcting and Validating Data; Finding and Fixing Errors in Formulas; Validating Data; Summing Up; Lesson 11: Protecting and Sharing Data; Protecting RangesSecuring WorkbooksTracking Changes in a Shared Workbook; Summing Up; Appendix: About the CD; Contents of This CD; System Requirements; Accessing the Excel eCourse; Using the CD; Customer Care; About the Author