See your way to Excel spreadsheet stardom with this visual guide
If you're always hearing about the cool things Excel can do, here's your chance to see how to do them!Teach Yourself Visually Excel offers you a straightforward visual approach to working with the newest version of the world's leading spreadsheet program. Packed with visually rich tutorials and step-by-step instructions that will help you take your Excel skills to new heights, this friendly and approachable guide will have you creating, editing, and manipulating Excel spreadsheets in no time!
Excel can seem daunting, but with Teach Yourself Visually Excel, you'll quickly and painlessly learn how to perform dozens of tasks, including creating spreadsheets and charts, filtering and sorting data, working with PivotTables, and so much more. Covering the latest additions and changes to the newest version of Excel, a series of easy-to-follow, full-color tutorials helps you to excel at working with Excel!
* Tutorials and step-by-step screenshots make lessons easy to follow and understand
* Helps you grasp the basic functions of Excel--and beyond
* Walks you through Excel s new features
* Clearly demonstrates how to organize, present, analyze, and chart data with Excel
Whether you've never used Excel or just need to brush up on its new features, Teach Yourself Visually Excel will be the dog-eared resource you'll turn to again and again.
Autorentext
Paul McFedries (Toronto, Ontario) is the president of Logophilia Limited, a technical writing company. He has been programming since he was a teenager in the mid-1970s, has programmed everything from mainframes to desktops to bar code scanners, and has worked with many different languages, including Fortran, assembly language, C++, and, of course, JavaScript. Paul has written more than four dozen books that have sold more than two million copies worldwide. These books include Windows 8.1 Simplified, Teach Yourself VISUALLY Windows 8.1, Excel Data Analysis Visual Blueprint, and previous editions of Teach Yourself VISUALLY Excel. Paul encourages all readers to drop by his Web site, mcfedries.com.
Zusammenfassung
See your way to Excel spreadsheet stardom with this visual guide
If you're always hearing about the cool things Excel can do, here's your chance to see how to do them!Teach Yourself Visually Excel offers you a straightforward visual approach to working with the newest version of the world's leading spreadsheet program. Packed with visually rich tutorials and step-by-step instructions that will help you take your Excel skills to new heights, this friendly and approachable guide will have you creating, editing, and manipulating Excel spreadsheets in no time!
Excel can seem daunting, but with Teach Yourself Visually Excel, you'll quickly and painlessly learn how to perform dozens of tasks, including creating spreadsheets and charts, filtering and sorting data, working with PivotTables, and so much more. Covering the latest additions and changes to the newest version of Excel, a series of easy-to-follow, full-color tutorials helps you to excel at working with Excel!
- Tutorials and step-by-step screenshots make lessons easy to follow and understand
- Helps you grasp the basic functions of Exceland beyond
- Walks you through Excel s new features
- Clearly demonstrates how to organize, present, analyze, and chart data with Excel
Whether you've never used Excel or just need to brush up on its new features, Teach Yourself Visually Excel will be the dog-eared resource you'll turn to again and again.
Inhalt
Chapter 1 Working with Ranges
Select a Range 4
Fill a Range with the Same Data 6
Fill a Range with a Series of Values 8
Flash Fill a Range 10
Move or Copy a Range 12
Insert a Row or Column 14
Insert a Cell or Range 16
Delete Data from a Range 18
Delete a Range 20
Hide a Row or Column 22
Freeze Rows or Columns 24
Merge Two or More Cells 26
Transpose Rows and Columns 28
Select and Enter Data Using Touch Gestures 30
Chapter 2 Working with Range Names
Understanding the Benefits of Using Range Names 34
Define a Range Name 36
Using Worksheet Text to Define a Range Name 38
Navigate a Workbook Using Range Names 40
Change a Range Name 42
Delete a Range Name 44
Paste a List of Range Names 46
Chapter 3 Formatting Excel Ranges
Change the Font and Font Size 50
Apply Font Effects 52
Change the Font Color 54
Align Text Within a Cell 56
Center Text Across Multiple Columns 58
Rotate Text Within a Cell 60
Add a Background Color to a Range 62
Apply a Number Format 64
Change the Number of Decimal Places Displayed 66
Apply an AutoFormat to a Range 68
Apply a Conditional Format to a Range 70
Apply a Style to a Range 72
Change the Column Width 74
Change the Row Height 76
Wrap Text Within a Cell 78
Add Borders to a Range 80
Copy Formatting from One Cell to Another 82
Chapter 4 Building Formulas
Understanding Excel Formulas 86
Build a Formula 88
Understanding Excel Functions 90
Add a Function to a Formula 92
Add a Row or Column of Numbers 94
Build an AutoSum Formula 96
Add a Range Name to a Formula 98
Reference Another Worksheet Range in a Formula 100
Move or Copy a Formula 102
Switch to Absolute Cell References 104
Hide the Formula Bar or Ribbon 106
Troubleshoot Formula Errors 108
Chapter 5 Manipulating Worksheets
Navigate a Worksheet 112
Rename a Worksheet 113
Create a New Worksheet 114
Move a Worksheet 116
Copy a Worksheet 118
Delete a Worksheet 120
Change the Gridline Color 122
Toggle Worksheet Gridlines On and Off 124
Toggle Worksheet Headings On and Off 125
Set the Worksheet Tab Color 126
Set the Worksheet Background 128
Zoom In on or Out of a Worksheet 130
Split a Worksheet into Two Panes 132
Hide and Unhide a Worksheet 134
Chapter 6 Dealing with Workbooks
Create a New Blank Workbook 138
Create a New Workbook from a Template 140
Save a Workbook 142
Open a Workbook 143
Arrange Workbook Windows 144
Find Text in a Workbook 146
Replace Text in a Workbook 148
Check Spelling and Grammar 150
Chapter 7 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 8 Importing Data into Excel
Understanding External Data 168
Import Data from a Data Source 170
Import Data from an Access Table 172
Import Data from a Word Table 174
Import Data from a Text File 176
Import Data from a Web Page 180
Import Data from an XML File 182
Refresh Imported Data 184
Separate Cell Text into Columns 186
Chapter 9 Printing Workbooks
Adjust the Workbook Marg...