book

Show Me Microsoft® Office Excel 2003

Name: Show Me Microsoft® Office Excel 2003
Author: Steve Johnson - Perspection, Inc.
ISBN: 9780789730053

by Steve Johnson - Perspection, Inc.

September 2003

Beginner

384 pages

8h 45m

English

Que

Read now

Unlock full access

Copyright
Dedication
Acknowledgements
Perspection, Inc.AcknowledgementsAbout The AuthorWe Want To Hear From You!
Introduction
Find the Best Place to StartWhat's NewHow This Book WorksStep-by-Step InstructionsReal World ExamplesTroubleshooting GuideShow Me Live SoftwareMicrosoft Office Specialist
1. Getting Started with Excel
IntroductionStarting ExcelStart Excel from the Start MenuViewing the Excel Window and Task PanesStarting a New WorkbookStart a New Workbook from the Task PaneStart a New Workbook from the New ButtonCreate a File Using a Template or WizardGet Templates on the WebOpening an Existing WorkbookOpen a Workbook from the Excel WindowOpen a Recently Opened Workbook from the Start MenuMoving Around the WorkbookUse the Mouse to NavigateUse the Keyboard to NavigateGo To a Specific LocationWorking with Menus and ToolbarsChoose a Command Using a MenuChoose a Command Using a Toolbar ButtonChoose a Command Using a Shortcut KeyDisplay or Hide a ToolbarWorking with Dialog BoxesChoose Dialog Box OptionsUsing Task PanesOpen and Close Task PanesUse the Task PaneArranging WindowsResize and Move a WindowUse the Mouse to Move a WindowUse the Mouse to Resize a WindowArrange Multiple WindowsGetting HelpGet Help Without the Office AssistantGet Help While You WorkGet Help in a Dialog BoxGetting Help from the Office AssistantAsk the Office Assistant for HelpChoose an Office AssistantTurn Off the Office AssistantSaving a WorkbookSave a Workbook for the First TimeSave a File with Another NameSave a File in a New FolderSaving a File with Different FormatsSave a File as a Different TypeCreate a TemplateGetting Excel Updates on the WebGet Office Updates on the WebRecovering a WorkbookRecover a FileUsing AutoRecoverExiting ExcelClose a WorkbookQuit Excel
2. Basic Workbook Skills
IntroductionMaking Label EntriesSelecting CellsSelect a Contiguous RangeSelect a Non-contiguous RangeEntering Labels on a WorksheetEnter a Text LabelEnter a Number as a LabelEnter a Label Using AutoCompleteEntering Values on a WorksheetEnter a ValueEnter a Date or TimeChange Date or Time FormatEntering Values Quickly with AutoFillEnter Repeating Data Using AutoFillCreate a Complex Series Using AutoFillEditing Cell ContentsEdit Cell ContentsClearing Cell ContentsClear the Contents of a CellClear Cell Contents, Formatting, and CommentsUndoing and Redoing an ActionUndo an ActionRedo an ActionUnderstanding How Excel Pastes DataStoring Cell ContentsCopy Data to the Office ClipboardPaste Data from the Office ClipboardCopying Cell ContentsCopy Data Using the Windows ClipboardCopy Data Using Drag-and-DropPaste Data with Special ResultsMoving Cell ContentsMove Data Using the ClipboardMove Data Using Drag-and-DropPaste Cells from Rows to Columns or Columns to RowsInserting and Deleting Cell ContentsInsert a CellDelete a CellFinding and Replacing Cell ContentsFind Cell ContentsReplace Cell ContentsCorrecting Cell Contents with AutoCorrectAdd an AutoCorrect EntryEdit an AutoCorrect EntryChange AutoCorrect ExceptionsUsing Smart TagsChange Smart Tag OptionsGet a Stock Quote Using a Smart TagChecking Your SpellingCheck SpellingTurn On AutoCorrect
3. Working with Formulas and Functions
IntroductionCreating a Simple FormulaEnter a FormulaDisplay Formulas in CellsEditing a FormulaEdit a Formula Using the Formula BarCopy a Formula Using AutoFillCopy a Formula Using the Windows ClipboardUnderstanding Cell ReferencingCell References in FormulasRelative Cell ReferencesAbsolute Cell ReferencesUsing Absolute Cell ReferencesUse an Absolute ReferenceUsing Labels for Cell ReferencesDefine Label RangesRemove a Label RangeNaming Cells and RangesName a Cell or RangeSelect a Named Cell or RangeLet Excel Name a Cell or RangeApply a Name to a Cell or Range AddressSimplifying a Formula with RangesUse a Range in a FormulaUse a Range Name in a FormulaDisplaying Calculations with AutoCalculateCalculate a Range AutomaticallyCalculating Totals with AutoSumCalculate Totals with AutoSumCalculate with Extended AutoSumCalculate Subtotals and TotalsCorrecting Calculation ErrorsReview and Correct ErrorsCorrecting FormulasWatch Cells and FormulasCorrect ErrorsAuditing a WorksheetTrace Worksheet RelationshipsPerforming Calculations Using FunctionsEnter a FunctionCreating FunctionsEnter a Function Using Insert Function
4. Modifying Worksheets and Workbooks
IntroductionSelecting and Naming a WorksheetSelect a WorksheetName a WorksheetInserting and Deleting a WorksheetInsert a WorksheetDelete a WorksheetMoving and Copying a WorksheetMove a Worksheet Within a WorkbookCopy a WorksheetHiding and Unhiding Worksheets and WorkbooksHide or Unhide a WorksheetHide or Unhide a WorkbookSelecting a Column or RowSelect a Column or RowSelect Multiple Columns or RowsHiding and Unhiding a Column or RowHide a Column or RowUnhide a Column or RowInserting a Column or RowInsert a Column or RowInsert Multiple Columns or RowsDeleting a Column or RowDelete a Column or RowDelete Multiple Columns or RowsAdjusting Column Width and Row HeightAdjust Column Width or Row HeightAdjust Column Width or Row Height Using the MouseChange Column Width or Row Height Using AutoFitFreezing a Column or RowFreeze a Column or RowUnfreeze a Column or RowSplitting a Worksheet in PanesSplit a Worksheet in PanesCreating a TemplateCreate a TemplateOpening a TemplateOpen a TemplateChanging a TemplateChange an Excel Template
5. Formatting a Worksheet
IntroductionFormatting Text and NumbersFormat Text QuicklyFormat Numbers QuicklyFormat a Number Using the Format Cells Dialog BoxDesigning Conditional FormattingEstablish a Conditional FormatDelete a Conditional FormatCopying Cell FormatsCopy a Cell FormatChanging FontsChange Font, Font Style, and Font SizeChange Font and Font Size Using the Formatting ToolbarChanging Data AlignmentChange Alignment Using the Format Dialog BoxChange Alignment Using the Formatting ToolbarControlling Text FlowControl the Flow of Text in a CellChanging Data ColorChange Font Color Using the Formatting ToolbarAdding Color and Patterns to CellsApply Color and PatternsApply Color Using the Formatting ToolbarAdding Borders to CellsApply a BorderApply a Border Using the Formatting ToolbarFormatting Data with AutoFormatApply an AutoFormatModifying an AutoFormatModify an AutoFormatFormatting Tabs and BackgroundAdd Color to Worksheet TabsAdd or Remove a BackgroundCreating and Applying StylesCreate a New StyleApply a StyleModifying a StyleModify a StyleMerge StylesDelete a StyleFinding and Replacing FormattingFind or Replace Formatting
6. Printing Worksheets and Workbooks
IntroductionInserting Page BreaksInsert a Page BreakPreview and Move a Page BreakSetting Up the PageChange Page OrientationChange the Margin SettingsAdding Headers and FootersChange a Header or FooterCustomizing Worksheet PrintingPrint Part of a WorksheetPrint Row and Column Titles on Each PagePrint Gridlines, Column Letters, and Row NumbersFit Your Worksheet on a Specific Number of PagesSetting the Print AreaSet the Print AreaClear the Print AreaPreviewing a WorksheetPreview a WorksheetPrinting a Worksheet and WorkbookPrint All or Part of a Worksheet
7. Inserting Graphics and Related Material
IntroductionWorking with the ClipboardPaste Items from the Office ClipboardDelete Items from the Office ClipboardChange Clipboard OptionsInserting Research MaterialLocate and Insert Research MaterialUse the ThesaurusTranslate a WordChange Research OptionsInserting and Deleting PicturesInsert Clip Art from the Clip GalleryInsert a Picture from an Existing FileDelete a PictureInserting Media ClipsInsert a Clip Gallery Sound or Motion ClipInsert a Picture from a Scanner or CameraModifying PicturesChange ContrastChange BrightnessChoose a Color TypeRestore Original SettingsCropping PicturesCrop a PictureRedisplay a Cropped PictureStylizing Text with WordArtCreate WordArtEditing WordArt TextChange the Shape of WordArt TextRotate WordArt TextColor WordArt TextEdit or Format WordArt TextApplying WordArt Text EffectsMake All Letters the Same HeightAlign WordArtAdjust Character SpacingInserting an Organization ChartCreate an Organization ChartUse the Style GalleryType Text in a Chart BoxModifying an Organization ChartAdd a Chart BoxChange the Organization Chart LayoutRearrange a Chart BoxFormat a Chart BoxCreating a DiagramCreate a New DiagramModify a DiagramFormatting a DiagramFormat a Diagram

8. Drawing and Modifying Objects
IntroductionDrawing Lines and ArrowsDraw a Straight LineEdit a LineDraw and Edit an ArrowDrawing AutoShapesDraw an Oval or RectangleDraw an AutoShapeAdjust an AutoShapeResize an AutoShapeInserting AutoShapes from the Clip GalleryInsert an AutoShape from the Clip GalleryFind Similar AutoShapes in the Clip GalleryAdd Text to an AutoShapeMoving and Resizing an ObjectMove an ObjectNudge an ObjectResize a Drawing Object with the MouseResize an Object PreciselyRotating and Flipping an ObjectRotate an Object to Any AngleRotate or Flip a Object Using Preset IncrementsRotate a Drawing Object Around a Fixed PointRotate a Object PreciselyChoosing Object ColorsChange a Drawing Object's Fill ColorChange Colors and Lines in the Format AutoShape Dialog BoxCreate a Line PatternAdding Object ShadowsUse a Preset ShadowChange the Location of a ShadowChange the Color of a ShadowCreating a 3-D ObjectApply a Preset 3-D StyleSpin a 3-D ObjectSet Lighting for a 3-D ObjectSet Depth for a 3-D ObjectAligning and Distributing ObjectsAlign ObjectsDistribute ObjectsArranging and Grouping ObjectsChange the Order of ObjectsGroup Objects TogetherUngroup an ObjectRegroup an ObjectChanging Object View SettingsChange View Settings for Objects
9. Creating and Modifying Charts
IntroductionUnderstanding Chart TerminologyChoosing the Right Type of ChartCreating a ChartCreate a Chart Using the Chart WizardEditing a ChartSelecting and Editing a Chart ObjectSelect and Edit a Chart ObjectChanging a Chart TypeChange a Chart Type QuicklyMoving and Resizing a ChartMove an Embedded ChartResize an Embedded ChartPulling Out a Pie SliceExplode a Single Pie SliceExplode an Entire PieUndo a Pie ExplosionAdding and Deleting a Data SeriesAdd a Data Series QuicklyDelete a Data SeriesChange a Data SeriesChange Data Series OrderEnhancing a Data SeriesChange a Data Series Color or PatternAdd a Picture to a Data SeriesDelete a Picture from a Data SeriesEnhancing a ChartAdd a TitleAdd or Delete a LegendAdd a Text AnnotationDrawing on a ChartAdd a Drop Shadow to a Text AnnotationAdd a Drop Shadow to a Chart TitleDraw an Arrow on a ChartFormatting Chart ElementsFormat Chart TextFormat a Chart AxisAdding Chart GridlinesAdd Gridlines
10. Analyzing Worksheet Data
IntroductionUnderstanding ListsCreating a ListCreate a ListUnderstanding a Data FormAdding Records Using a Data FormAdd to a List Using a Data FormManaging Records Using a Data FormDisplay Selected RecordsEdit a RecordDelete a RecordSorting Data in a ListSort Data QuicklyDisplay Parts of a ListSort a List Using More Than One FieldDisplaying Parts of a List with AutoFilterDisplay Specific Records Using AutoFilterCreating Custom SearchesCreate a Custom Search Using AutoFilterEntering Data in a ListEnter Data in a List Using Pick From Drop-Down ListWorking with ListsInsert a Row in a ListConvert a List to a RangeAnalyzing Data Using a PivotTableCreate a PivotTable ReportUpdating a PivotTable and PivotChartUpdate a PivotTable ReportAdd or Remove a Field in a PivotTable or PivotChart ReportModifying a PivotTable and PivotChartAutoFormat a PivotTable ReportChange Field Settings in a PivotTable or PivotChart ReportCreate a PivotTable Report from an Existing PivotTable or PivotChartCharting a PivotTableCreate a PivotChart Report from a PivotTable ReportModify a PivotChart ReportCreate a PivotChart Report with a PivotTable ReportCreating Groups and OutlinesCreate an Outline or GroupWork an Outline or GroupUsing Database Functions in a ListUse the DSUM or DAVERAGE FunctionAdding Data Validation to a WorksheetCreate Validation Rules
11. Building More Powerful Worksheets
IntroductionLoading and Unloading Add-InsLoad or Unload Add-InsUsing Data Analysis ToolsUse Data Analysis ToolsLooking at Alternatives with Data TablesCreate a One-Input Data TableAsking “What If” with Goal SeekCreate a “What-If” Scenario with Goal SeekCreating ScenariosCreate and Show a ScenarioShow a ScenarioUsing SolverUse SolverUsing Lookup and Reference FunctionsUse the VLOOKUP FunctionUse the HLOOKUP FunctionUnderstanding How Macros Automate Your WorkRecording a MacroRecord a MacroRunning a MacroRun a Macro Using a Menu CommandUnderstanding Macro CodeDebugging a Macro Using Step ModeDebug a Macro Using Step ModeEditing a MacroEdit a MacroRestricting Workbook AccessSet Up Information Rights ManagementCreate a Workbook with Restricted PermissionProtecting Your DataApply a Password to a WorksheetApply a Password to Edit Parts of a WorksheetUsing Digital SignaturesSet Digital SignatureSet a Macro Security OptionApplying Security SettingsApply File Encryption
12. Sharing Workbook Data
IntroductionSharing WorkbooksEnable Workbook SharingChange Sharing OptionsCreating and Reading a Cell CommentAdd a CommentRead a CommentEditing and Deleting a Cell CommentEdit a CommentDelete a CommentTracking ChangesTurn On the Track Changes FeatureAccept or Reject Tracked ChangesComparing and Merging WorkbooksMerge Workbook DataSending a Workbook for ReviewSend a Workbook for Review Using E-MailSharing Information Between ProgramsImporting and ExportingEmbeddingLinkingHyperlinkingDeciding Which Method to UseExporting and Importing DataExport Excel Data Using Copy and PasteExport an Excel File to Another Program FormatImport a Text FileWorking with XMLAttach a SchemaCreate an XML Data MapImport XML DataExporting and Saving Data in XMLExport XML DataSave XML DataLinking and Embedding FilesCreate a Link to Another FileModify a LinkEmbed a New ObjectEmbed or Link to an Existing ObjectLinking DataCreate a Link Between Worksheets or WorkbooksBreak a LinkConsolidating DataConsolidate Data from Other Worksheets or WorkbooksGetting Data from a DatabaseDefine a New Data SourceCreate a Database QueryGetting Data from Another ProgramExport an Access Database Table into an Excel WorkbookCreate an Excel Workbook PivotTable from an Access Database
13. Publishing Data on the Web
IntroductionOpening a Workbook as a Web PageOpen a Workbook as a Web Page in ExcelPreviewing a Web PageView the Web PageCreating a HyperlinkCreate a HyperlinkJump to a HyperlinkRemove a HyperlinkSaving a Worksheet as a Web PageSave a Workbook or Worksheet as a Web PageSave a Workbook or Worksheet as a Single File Web PagePublishing a Web PageSave and Publish a Worksheet as an Interactive Web PageGetting Data from the WebGet Data from the Web Using the Web ToolbarCopying a Web Table to a WorksheetCopy a Web Table to a WorksheetCreating Refreshable Web QueriesCopy and Paste Refreshable Data from the WebGetting Data from Web QueriesGet Data from a New Web QuerySaving Web QueriesSave a Web QueryImport a QueryHolding an Online MeetingSchedule a MeetingHold a MeetingCollaborate in an Online MeetingParticipate in an Online MeetingSending Workbooks Using E-MailSend a Worksheet in an E-Mail MessageSend a Workbook as an E-Mail AttachmentRoute a Workbook in an E-Mail MessageGetting Documents from the WebAdd or Modify FTP LocationsAccess an FTP Site
14. Tools for Working More Efficiently
IntroductionModifying Workbook PropertiesDisplay Workbook PropertiesCustomize Workbook PropertiesLink to Workbook PropertiesFinding a File or Contents in a FileFind a File or Contents in a FileFind a Property in a FileChanging OptionsChange General OptionsChange Edit OptionsChanging Your Worksheet ViewChange View OptionsCreating a Custom ViewCreate a Custom ViewCreate a Custom ViewCreating a ToolbarCreate a ToolbarChange Toolbars and Menus OptionsCustomizing a ToolbarPersonalize a Toolbar QuicklyDelete a Button from a ToolbarAdd a Button to a ToolbarAdding Menus and Menu ItemsAdd a Menu ItemCreate a New MenuPlaying Back Worksheet DataSpeak the Value of CellsControlling Excel with Your VoiceWork with the Language BarTrain Your Computer to Your VoiceExecuting Voice CommandsExecute Voice CommandsDictating TextDictate TextRecognizing HandwritingInsert Handwritten Text into a DocumentInsert Handwritten Text on a Writing PadRepairing and Recovering Office ProgramsDetect and Repair ProblemsRecover an Office ProgramPerform Maintenance on Office ProgramsUsing Multiple LanguagesAdd a Language to Office Programs
15. Working Together on Office Documents
IntroductionViewing SharePoint Team ServicesAdministering SharePoint Team ServicesStoring Documents in the LibraryUpload a DocumentViewing Team MembersAdd New Members to the SiteSetting Up AlertsCreate Your E-Mail AlertAssigning Project TasksAdd a Task Item to Your SiteCreating an EventSetup New EventsLink to Events in OutlookCreating ContactsCreate a Contact ListLink to Contacts in OutlookHolding Web DiscussionsHold a Web DiscussionWorking with Shared WorkspaceUse Shared Workspace in an Office 2003 ProgramPublishing a ListPublish a Data ListWork with a Published Data List on the SharePoint ServerInstalling Windows 2003 and SharePoint Server 2003
Microsoft Office Specialist
About the Microsoft Office Specialist ProgramWhat Does This Logo Mean?Preparing for a Microsoft Office Specialist ExamTaking a Microsoft Office Specialist ExamThe Exam ExperienceTips for Taking an ExamExam ResultsGetting More Information
New! Features
Microsoft Office Excel 2003
Troubleshooting
CellsChartsClip art and objectsClipboardDataDatabase and listsEntering and selecting dataFormatting dataFormulas and functionsHelpImporting and exportingLanguages and voice optionsMenus, toolbars, and task panesMicrosoft Office SpecialistNavigationPrintingReviewing changesSavingSecuritySharePointSpellingTemplates and stylesWebWorksheets and workbooks

Overview

See it done, do it yourself! Spend less time reading and more time doing with this simple, step-by-step approach.

Excel 2003 provides powerful new tools with which to create, analyze, and share spreadsheet information.

Based on a proven, successful series format, this book uses a visual page design with easy-to-read text to teach beginning to intermediate level Excel tasks.

Troubleshooting guides, "see also" referencing, sample projects, and MOS objectives add even more for the ambitious learner.

Author Steve Johnson is a professional trainer and author of several best-selling books.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 0789730057Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills