| Title Page | 2 |
|---|
| Copyright Page | 3 |
|---|
| Contents at a Glance | 5 |
|---|
| Table of Contents | 6 |
|---|
| About the Author | 14 |
|---|
| About the Technical Reviewer | 15 |
|---|
| Acknowledgments | 16 |
|---|
| Introduction | 17 |
|---|
| Who Is This Book For? | 17 |
| What Does This Book Cover? | 17 |
| Conventions Used in This Book | 19 |
| Part I Becoming Proficient with Excel:Mac | 21 |
|---|
| Chapter 1 Learning the Secrets of the Excel:Mac Interface | 22 |
|---|
| Getting Ready to Learn Excel s Secrets | 22 |
| Four Ways to Control Excel | 23 |
| Secrets of the Ribbon | 24 |
| Understanding How the Ribbon s Tabs Work | 24 |
| Understanding How the Ribbon s Groups and Controls Work | 26 |
| Collapsing the Ribbon | 27 |
| Secrets of the Toolbars | 28 |
| Choosing Which Toolbars to Display | 28 |
| Switching the Standard Toolbar Between Icons and Textand Icons Only | 29 |
| Undocking and Docking the Formatting Toolbar | 29 |
| Secrets of the Menu Bar | 30 |
| Driving Excel with Keyboard Shortcuts | 31 |
| Making the Toolbox Work Your Way | 32 |
| Navigating Quickly Through Worksheets andWorkbooks | 34 |
| Elements of the Excel User Interface | 34 |
| Navigating Among Worksheets | 36 |
| Changing the Active Cell | 37 |
| Selecting and Manipulating Cells | 38 |
| Tools for Entering Text and Formulas Quickly | 40 |
| Importing Data | 40 |
| Importing Data from a Comma-Separated Values File or a Text File | 42 |
| Importing Data from a FileMaker Pro Database | 45 |
| Importing Data from an HTML File | 48 |
| Connecting a Worksheet to External Data Sources | 48 |
| Entering Text Using AutoCorrect | 48 |
| Opening the AutoCorrect Preferences Pane | 48 |
| Choosing Options to Make AutoCorrect Work Your Way | 49 |
| Creating AutoCorrect Exceptions | 50 |
| Creating Replace-As-You-Type Entries | 51 |
| Creating AutoCorrect Entries | 51 |
| Using Your AutoCorrect Entries | 52 |
| Entering Text with AutoFill and Custom Lists | 52 |
| Using AutoFill s Built-in Capabilities | 52 |
| Creating Your Own Custom AutoFill Lists | 55 |
| Entering Text Using Paste and Paste Options | 56 |
| Switching Data from Rows to Columns | 57 |
| Pasting in a Table from Word | 58 |
| Getting Comma-Separated Data into a Worksheet | 59 |
| Pasting in Multiple Items with the Scrapbook | 59 |
| Opening the Scrapbook | 59 |
| Adding an Item to the Scrapbook | 60 |
| Inserting an Item from the Scrapbook | 61 |
| Deleting an Item from the Scrapbook | 61 |
| Entering Text with Find and Replace | 61 |
| Inserting Symbols in a Document | 63 |
| Viewing Your Workbooks | 64 |
| Splitting the Window to View Separate Parts of aWorksheet | 65 |
| Opening Extra Windows to Show Other Parts of aWorkbook | 67 |
| Changing the Window and Arranging Open Windows | 67 |
| Zooming to Show the Data You Need to See | 68 |
| Freezing Rows and Columns So They Stay Onscreen | 69 |
| Using Custom Views | 70 |
| Summary | 71 |
| Chapter 2 Configuring Excel:Mac to Suit the Way You Work | 72 |
|---|
| Opening the Excel Preferences Dialog Box | 72 |
| Controlling How the Excel Window Appears | 74 |
| Choosing Options in the Settings Area of View Preferences | 76 |
| Choosing How to Display Comments | 76 |
| Choosing How to Display Objects | 76 |
| Choosing Window Options | 77 |
| Choosing Editing Options | 78 |
| Setting Preferences for Creating and Saving Your Workbooks | 81 |
| Creating Workbooks with the Number of Worksheets You Need | 81 |
| Choosing the Default Folder for Opening and Saving Workbooks | 81 |
| Choosing the Default Format for Saving Workbooks | 82 |
| Setting AutoRecover to Keep Backups of Your Workbooks for Safety | 83 |
| Making Excel Prompt You to Enter Workbook Properties | 84 |
| Creating Custom Keyboard Shortcuts | 85 |
| Customizing the Toolbars with the Commands You Need | 87 |
| Getting Ready to Customize the Toolbars | 87 |
| Creating a New Toolbar | 89 |
| Finding the Commands to Add to the Toolbars or Menus | 89 |
| Adding an Item to a Toolbar | 90 |
| Removing an Item from a Toolbar | 90 |
| Repositioning Items on a Toolbar | 90 |
| Changing How a Toolbar Button Appears | 90 |
| Adding a Built-in Menu to a Toolbar | 92 |
| Customizing the Menus and the Menu Bar | 92 |
| Customizing the Menus | 93 |
| Customizing the Menu Bar | 94 |
| Turning Off or Customizing the Ribbon | 96 |
| Turning the Ribbon Off So It Doesn t Appear | 96 |
| Customizing the Ribbon | 98 |
| Customizing the Ribbon the Quick Way | 98 |
| Customizing the Ribbon Using the Ribbon Preferences Pane | 98 |
| Opening One or More Workbooks Automatically with Excel | 99 |
| Saving the Layout of Open Workbooks as a Workspace | 100 |
| Summary | 100 |
| Chapter 3 Creating Effective Workbooks and Templates | 101 |
|---|
| Creating Workbooks from Scratch or fromTemplates | 101 |
| Creating a New Blank Workbook | 102 |
| Creating a New Workbook Based on a Template | 103 |
| Creating a New Workbook Based on an Existing Workbook | 103 |
| Saving a Workbook | 104 |
| Protecting a Workbook with Automatic Backups andPasswords | 105 |
| Entering Workbook Properties | 108 |
| Entering Standard Prope | 108 |
