Contents Introduction xiv How do I use this book? xiv Adopted conventions xv 1 Help, checks and Web tools 1 Office Assistant 2 Office Assistant options 2 Help 4 Context help 5 Help icons 5 Wizards and templates 6 Templates 6 Wizards 7 Creating a template 8 Spelling and grammar 9 Automatic spellchecking 9 Office XP # Automatic grammar check 11 Activating a language 12 AutoCorrect 13 Find and Replace 13 Finding synonyms 15 Office XP and the Web 16 Browsing the Web from Office 16 Opening documents in Internet Explorer 17 Web preview 17 On-line collaboration 18 E-mailing from an application 18 Creating hyperlinks 18 2 Shared commands 21 Starting and quitting applications 22 Launching an application 22 Quitting an application 22 Undoing and redoing actions 23 Interface elements 24 Menu bar 24 Toolbars 25 Office XP #Entering text 41 Non-breaking hyphens, non-breaking spaces and accented upper case 42 Moving within the text 43 Going to a specific page 44 Selecting text 45 Correcting text 45 Views 46 Display views 46 Zoom 46 Switching between several documents 47 Formatting text and paragraphs 48 Formatting procedures 48 Quick character formatting 49 Sophisticated character formatting 50 Quick paragraph formatting 51 Sophisticated paragraph formatting 52 Bulleted lists 55 Borders and shading 56 Formatting pages 57 Framing a page 57 Background 57 Inserting a header and a footer 58 Formatting 58 4 Advanced Word functions 61 Creating a table 62 Drawing a table 62 Inserting a table 62 Table dialog box 63 Moving within a table 64 Selecting within a table 66 Inserting and deleting cells and rows 66 Orientation and display of the title row 67 Formatting tables 68 Creating columns 68 Mailshots 69 Main document 70 Automatic format with styles 74 Choosing a style 74 Creating a style 75 5 Basic Excel functions 77 The first step 78 Screen 78 Workbooks and worksheets 78 Worksheet management 79 Moving between worksheets 79 Adding, deleting, copying and moving worksheets 80 Hiding and showing a worksheet 82 Naming, grouping and ungrouping worksheets 82 Data 83 Types of data 83 Entering data 84 Special data 85 Selecting 86 Cell range 87 Managing cells, rows and columns 88 Help with your entry 90 Fill 90 Fill handles 91 Formatting 92 AutoFormat 92 Conditional formatting 93 6 Advanced Excel functions 95 Formulas 96 Creating formulas 96 Copying and moving formulas 98 Functions 99 Wizard function 100 Automatic entry 101 Scenarios 102 Sorting and filtering data 103 Sorting data 104 Filtering data 104 Auditing 105 Creating a chart 107 Editing a chart 110 7 Basic PowerPoint functions 113 The first step 114 Converting a presentation 115 Applying a template 115 AutoContent Wizard 115 Display views 117 New presentations 119 Inserting, deleting and formatting slides 120 Moving between slides 121 Text 122 Selecting text 123 Bulleted lists 123 Harmonisation 125 Slide Master 125 Colour schemes 126 Formatting slides 127 Tips for formatting text 127 Background 127 Pictures 128 Picture toolbar 129 Charts 131 8 Advanced PowerPoint functions 133 Placing objects 134 Ruler and guides 134 Arranging objects 135 Drawing 136 Drawing toolbar 137 Creating tables 137 Style coherence 137 Sorting, structuring and adapting slides 139 Organising a slide show with the summary slide 140 Creating bookmarks 141 Narration 142 Adapting the slide show to the audience 145 Animation 146 Animating transitions between slides 146 Animating slides 147 Customising animation effects 148 Starting a slide show 149 Slide shows on paper, slides or other media 149 Speaker notes 150 Transferring a slide show 151 9 Basic Outlook functions 153 Discovering Outlook 154 The Outlook bar 155 Outlook Today 155 Customising Outlook Today 155 Calendar 157 Contacts 157 Tasks 158 Managing tasks 159 Journal 160 Creating journal entries 161 Notes 163 Inbox 164 Creating contacts 164 Making a telephone call from a business card 166 Sending e-mail messages 166 10 Advanced Outlook functions 169 Using Calendar 170 Views 171 Recording an appointment 172 Regular appointments 175 Planning a meeting 176 Recording an event 178 Sending and receiving e-mail messages 179 E-mail configuration 180 Sending messages 181 Receiving messages 183 Index 185