Teach Yourself Visually Excel 365 - Paul McFedries

. .

Résumé :

Chapter 1 Getting Started with Excel

Getting to Know Excel 4

Start Excel on the Desktop 6

Navigate to Excel for the Web 7

Tour the Excel Window 8

Work with the Excel Ribbon 9

Chapter 2 Entering Data

Learning the Layout of a Worksheet 12

Understanding the Types of Data You Can Use 13

Enter Text into a Cell 14

Enter a Number into a Cell 16

Enter a Date or Time into a Cell 18

Edit Cell Data 20

Delete Data from a Cell 22

Chapter 3 Working with Ranges

Select a Range 26

Fill a Range with the Same Data 28

Fill a Range with a Series of Values 30

Flash Fill a Range 32

Move or Copy a Range 34

Insert a Row or Column 36

Insert a Cell or Range 38

Delete Data from a Range 40

Delete a Range 42

Hide a Row or Column 44

Freeze Rows or Columns 46

Merge Two or More Cells 48

Chapter 4 Working with Range Names

Understanding the Benefits of Using Range Names 52

Define a Range Name 54

Using Worksheet Text to Define a Range Name 56

Navigate a Workbook Using Range Names 58

Change a Range Name 60

Delete a Range Name 62

Chapter 5 Formatting Excel Ranges

Change the Font and Font Size 66

Apply Font Effects 68

Change the Font Color 70

Align Text Within a Cell 72

Center Text Across Multiple Columns 74

Rotate Text Within a Cell 76

Add a Background Color to a Range 78

Apply a Number Format 80

Change the Number of Decimal Places Displayed 82

Apply a Conditional Format to a Range 84

Apply a Style to a Range 86

Change the Column Width 88

Change the Row Height 90

Wrap Text Within a Cell 92

Add Borders to a Range 94

Copy Formatting from One Cell to Another 96

Chapter 6 Building Formulas

Understanding Excel Formulas 100

Build a Formula 102

Understanding Excel Functions 104

Add a Function to a Formula 106

Add a Range of Numbers 108

Build an AutoSum Formula 110

Add a Range Name to a Formula 112

Reference Another Worksheet Range in a Formula 114

Move or Copy a Formula 116

Switch to Absolute Cell References 118

Troubleshoot Formula Errors 120

Chapter 7 Manipulating Worksheets

Navigate a Worksheet 124

Rename a Worksheet 125

Create a New Worksheet 126

Move a Worksheet 128

Copy a Worksheet 130

Delete a Worksheet 132

Zoom In on or Out of a Worksheet 134

Split a Worksheet into Two Panes 136

Hide and Unhide a Worksheet 138

Chapter 8 Dealing with Workbooks

Create a New Blank Workbook 142

Create a New Workbook from a Template 144

Save a Workbook 146

Open a Workbook 147

Find Text in a Workbook 148

Replace Text in a Workbook 150

Chapter 9 Formatting Workbooks

Modify the Workbook Colors 154

Set the Workbook Fonts 156

Choose Workbook Effects 158

Apply a Workbook Theme 160

Add a Workbook Header 162

Add a Workbook Footer 164

Chapter 10 Importing Data into Excel

Understanding External Data 168

Import Data from an Access Table 170

Import Data from a Word Table 172

Import Data from a Text File 174

Import Data from a Web Page 176

Import Data from an XML File 178

Refresh Imported Data 180

Separate Cell Text into Columns 182

Chapter 11 Working with Tables

Understanding Tables 186

Get to Know Table Features 187

Convert a Range to a Tabl...

Biographie:
..

Sommaire:

Paul McFedries is a full-time technical writer. Paul has been authoring computer books since 1991, and he has more than 100 books to his credit. Paul's books have sold more than four million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Windows 11, Second Edition, Teach Yourself VISUALLY Microsoft 365, Second Edition, Google Workspace For Dummies, and HTML, CSS, and JavaScript for Dummies. Paul invites you to drop by his personal website at https://paulmcfedries.com and to follow him on X @paulmcf and on Facebook at https://facebook.com/PaulMcFedries....