Introduction to excel

Authors:

Language: Anglais
Cover of the book Introduction to excel

Approximative price 42.81 €

In Print (Delivery period: 12 days).

Add to cartAdd to cart
Publication date:
360 p. · 20.3x25.4 cm · Paperback

Contents

1 MICROSOFT EXCEL BASICS 1

1.1 Introduction to Worksheets 1

1.2 How to Use This Book 2

1.3 Typographic Conventions Used in This Book 2

1.4 Understanding the Excel 2007 Screen 3

1.4.1 Title Bar 4

1.4.2 Ribbon 6

1.4.3 Formula Bar 7

1.4.4 Work Area 9

1.4.5 Sheet Tabs 9

1.4.6 Status Bar 10

1.5 Getting Help 10

1.5.1 Browsing the Help Topic List 11

1.5.2 Searching the Help System 11

1.6 Creating and Saving Worksheets and Workbooks 12

1.6.1 Creating a New Workbook 12

1.6.2 Opening an Existing Workbook 12

1.6.3 Creating a New Worksheet 15

1.6.4 Introduction to Templates 16

1.6.5 Opening Workbooks with Macros 18

1.6.6 Saving Documents 21

1.6.7 The AutoRecover Feature 22

1.6.8 Naming Documents 24

1.7 Moving Around a Worksheet 25

1.7.1 Movement by Using the Keyboard 26

1.7.2 Movement by Using the Mouse 27

1.7.3 Movement by Using the Go To Dialog Box 27

1.8 Selecting a Region 29

1.8.1 Selection by Using Cell References 29

1.8.2 Selection by Using the Mouse 29

1.8.3 Selection by Using the Keyboard 30

1.9 Cutting, Moving, Copying, and Pasting 31

1.9.1 Cutting a Region 31

1.9.2 Moving a Region (Copy and Paste) 32

1.9.3 Copying a Region 32

1.10 Inserting and Deleting Cells 33

1.10.1 Deleting Cells 33

1.10.2 Clearing Cells 34

1.10.3 Inserting Cells 34

1.11 Shortcut Keys 34

1.12 Finding and Correcting Mistakes 35

1.12.1 Undoing Mistakes 35

1.12.2 Checking Spelling 35

1.12.3 The AutoCorrect Feature 36

1.13 Printing 37

1.13.1 Setting the Print Area 37

1.13.2 Previewing a Worksheet 37

1.13.3 Printing a Worksheet 39

2 ENTERING AND FORMATTING DATA 45

2.1 Introduction to Entering and Formatting Data 45

2.2 Entering Data 46

2.2.1 Entering Numeric Data 46

2.2.2 Entering Text Data 52

2.2.3 Entering Date and Time Data 54

2.3 Using the Fill Handle 56

2.3.1 Using the Fill Handle with the Left Mouse Button to Copy Cells 56

2.3.2 Using the Fill Handle with the Left Mouse Button-More Copy

Options 57

2.3.3 Creating a Linear Series with a Nonunity Increment 58

2.3.4 Using the Fill Handle with the Right Mouse Button for Additional Options 58

2.4 Formatting for Appearance 61

2.4.1 Changing the Appearance of Cells 61

2.4.2 Changing the Appearance of Columns and Rows 76

2.5 Working with Worksheets 79

2.5.1 Insert New Worksheets into a Workbook 79

2.5.2 Renaming a Worksheet 79

2.5.3 Changing the Color of the Worksheet Tab 79

2.5.4 Hiding a Worksheet 80

2.5.5 Locking a Worksheet 80

2.6 Formatting a Data Set as an Excel Table 82

2.6.1 Creating an Excel Table 83

2.6.2 Sorting Data in Excel Tables 85

2.6.3 Filtering Data in Excel Tables 85

2.6.4 Using a Total Row with Excel Tables 87

2.7 Conditional Formatting 91

3 FORMULAS AND FUNCTIONS 105

3.1 Introduction 105

3.2 Referencing Cells and Cell Ranges 105

3.2.1 Cell References 106

3.2.2 Referencing a Range of Cells 107

3.2.3 Naming a Cell or Range of Cells 108

3.3 Creating and Using Formulas 109

3.3.1 Formula Syntax 109

3.3.2 Arithmetic Operators and Operator Precedence 110

3.4 Using Excel's Built-in Functions 112

3.4.1 Examples of Statistical Functions 116

3.4.2 Examples of Trigonometric Functions 119

3.4.3 Example of Matrix Oper