Microsoft Excel 2003 Advanced Quick Source Guide

Download or read book Microsoft Excel 2003 Advanced Quick Source Guide written by Quick Source and published by . This book was released on 2006-04-01 with total page 6 pages. Available in PDF, EPUB and Kindle. Book excerpt: This 6 page, tri-fold, full-color, guide is an invaluable resource for anyone who uses Excel 2003! In a clear, user-friendly format, it provides step-by-step instructions, short cuts, and tips on how to execute more advanced commands of the software. Advanced topics include: Formatting Cells and Cell Borders, Assigning a Number Format to a Cell, Displaying Multiple Lines of Text in a Cell, Using the Format Painter, Using the AutoFormat Features, Adding Conditional Formatting, as well as Collapsing and Expanding a Dialog Box. This guide also covers Creating and Editing an Array Formula, Creating Lookup Formulas, Formula Errors, Correcting Formula Errors, and Using Row and Column Labels in Formulas. It also covers Naming a Cell, Row, Column, or Range of Cells and Creating a 3-D Reference. It covers Importing Data and Creating a Drop Down List from a Range. It will show you how to Sort and Filter Data as well as how to use Solver and Goal Seek and how to Create Scenarios. It covers Creating and Laying Out a PivotTable or PivotChart Report, Using the PivotTable Toolbar, Changing a PivotTable Report or PivotChart Format, Using the Chart Toolbar, and Formatting Chart Areas. It will also show you how to Preview a Worksheet, Print Cell Gridlines and Row and Column Headings, Set Up a Print Area, Print Worksheets and Selections, Send a Workbook as an E-mail Attachment, and Send a Worksheet as an E-mail Message. This guide also covers Sharing a Workbook, Merging Workbooks, and Tracking Changes in Shared Workbooks. It covers Protecting a Worksheet or Workbook and Applying Password Protection. It also shows how to Customize a Toolbar or Menu, Create a Custom Toolbar, Customize Excel Options, and much more! This is an excellent companion to the Excel 2003 Quick Reference Guide.