Close this window and go back to "Microsoft Office: The Best of the Rest One Step at a Time"

Microsoft Office: The Best of the Rest One Step at a Time

Table of Contents

Introduction 1
Chapter 1 - The Basics of Excel Spreadsheets
The Basics: Starting up Excel 2 Basics: Typing in Spreadsheets 5
The Basics: Spreadsheets 3 Basics: Editing Text in Cells 6
Basics: How Spreadsheets Work 4
Chapter 2 - Setting up an Excel Spreadsheet How You Want it
Setting Up: Selecting Groups of Cells 7 Setting Up: Automatic Corrections 10
Setting Up: Adding or Deleting Cells 8 Setting Up: Changing Cell Sizes 12
Setting Up: Copying & Pasting Cells 9
Chapter 3 - Excel Spreadsheet Design: Fonts, Borders, etc
Design: Fonts and Text Size 13 Design: Borders Round Cells 17
Design: Other Text Effects 14 Design: Colouring Cells and Text 19
Design: Text Alignment 15 Design: Copying a Cell's Formatting 20
Chapter 4 - Printing in Excel
Printing: Print Preview 21 Printing: Page Setup 24
Printing: Page Break Preview 22 Printing: Actually Printing 26
Printing: Changing Page Breaks 23
Chapter 5 - Excel Formulas, Charts, Numbers and Dates
Formulas: Setting up Tables 27 Charts: Charts using Excel 2007 33
Formulas: Calculations 28 Charts: Charts using Excel 2003 34
Formulas: Errors in Calculations 30 Numbers: Lists and Sequences 35
Formulas: Budgets 31 Dates: Sequences of Dates 36
Chapter 6 - Using Mail Merge
Mail Merge: Creating Address Lists 37 Mail Merge: Making Labels in Word 39
Chapter 7 - The Basics of Outlook
Outlook: Introduction 45 Outlook: Junk Email and Contacts 47
Outlook: Setting up 46 Outlook: Calendar and To Do Lists 48
Chapter 8 - The Basics of PowerPoint
PowerPoint: Introduction 49 PowerPoint: Pictures and Photos 54
PowerPoint: Finding Your Way Round 50 PowerPoint: Charts 55
PowerPoint: How It Works 51 PowerPoint: Viewing Slideshows 56
PowerPoint: Choosing a Slide Design 52 PowerPoint: Fancy Effects 57
PowerPoint: Entering Text 53
Chapter 9 - What on Earth is OneNote?
OneNote: In a Nutshell 58 OneNote: Top 3 Things to Do With It 59