Microsoft® Office Excel 2003 inside out.

Format:

Book

Author/Creator:

Stinson, Craig.

Contributor:

Dodge, Mark.

Series:

Inside out

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Business--Computer programs.

Electronic spreadsheets.

Local Subjects:

Business--Computer programs.

Electronic spreadsheets.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (0 p.)

Edition:

1st edition

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

Hey, you know your way around a spreadsheet-so now dig into Excel 2003 and really put your data to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format. It's all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Excel mastery! Build on what you already know about Excel and quickly dive into what's newLearn how the experts design more powerful spreadsheetsSharpen your core to advanced

Contents:

Microsoft® Office Excel 2003; We&d Like to Hear from You!; About the CD; Using the CD; System Requirements; Support Information; Conventions and Features Used in this Book; Design Conventions; About the Authors; 1. Examining the Excel Environment; Getting Software Updates; Comparing Worksheets Side by Side; Improved Statistical Functions; New Task Panes; Document Workspaces; Information Rights Management; Improved List Management; If You Missed the Last Upgrade ...; Onward ...; 2. Excel Fundamentals; Subscribing to Excel; Recovering from Crashes; Heroic Measures; Examining the Excel Workspace

Using the Workbook WindowGetting Around in the Workbook; Workbook Navigation Tips; Resizing the Window; Exploring Menus and Dialog Boxes; Accessing Menus and Commands with the Keyboard; Dialog Boxes and Tabs; The Joy of Shortcut Menus; Understanding the Formula Bar; About the Status Bar; Introducing Toolbars; File Management Fundamentals; Use Your Own Folders for Templates; Changing the Default Book and Sheet; Saving Files; File Formats; Specifying the Default File Format; Creating Automatic Backup Files; Protecting Files; Adding Summary Information to Files; Saving the Entire Workspace

Opening FilesOpening Files When You Start Excel; Recovering Corrupted Files; Searching for Files; Importing and Exporting Files; Importing and Exporting Text Files; Sharing Data with Excel for the Macintosh; Online Help Works-Really!; Managing the Assistant; Using the Assistant; Getting Answers to Unasked Questions; Browsing the Help System; Customer Feedback Options; Shared Workspace; What&s on the Help Menu; 3. Custom-Tailoring the Excel Workspace; Customizing Toolbars on the Fly; Rearranging Buttons and Commands; Controlling the Display of Button Faces; Giving Face to the Faceless

Rearranging Menus and SubmenusChanging the Face of Buttons; Copying Button Faces; Does Size Matter?; Managing Toolbars; Creating New Toolbars and Menus; Attaching Custom Toolbars to Workbooks; Creating New Menus; Preserving Toolbar and Menu Changes; Restoring Toolbars and Menus; Other Toolbar and Menu Options; Controlling Other Elements of the Excel Interface; Hiding Zeros; Changing the Color Palette; Enhancing Accessibility; 2. Building Worksheets; Will You Need to Print the Worksheet?; Who Is the Audience?; Would Your Worksheet Survive Without You?; Does the Worksheet Rely on Imported Data?

Do You Need More Than One Worksheet?Have You Allowed Room to Insert New Rows and Columns?; 5. How to Work a Worksheet; Navigating Regions with the Mouse; Navigating with Special Keys; Selecting Stuff; Selecting Columns, Rows, and Multiple Areas; Selecting Regions; Selecting with the Go To Command; Entering Stuff; Using Special Characters; Understanding the Difference Between Displayed Values and Underlying Values; Creating Long Text Values; Using Word Wrapping; Understanding Numeric Text Entries; Entering Symbols; Making Entries in Ranges; Editing and Undoing Entries; Managing Worksheets

Naming and Renaming Sheets

Notes:

Description based upon print version of record.

Description based on publisher supplied metadata and other sources.

ISBN:

9780735635210

0735635218

9780585487144

0585487146

OCLC:

609856961