Last edition Elsevier Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them!
Previous Edition
ISBN 13: 9780735626942
Imprint: Pearson Education Limited
Language: English
Authors: Curtis Frye
Pub Date: 2010
Pages: 480
Illus: Illustrated
Weight: 786.00 grams
Size: h 189 x 229 mm
Product Type: Softcover
| List Price |
| grn 1239 |
| $ 42,00 |
| to order |
- • Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
- • Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
- Curtis D. Frye. Curtis D. Frye is the author of several books on Microsoft Access and Excel, including Microsoft Office Excel 2007 Step by Step and Microsoft Office Excel 2003 Step by Step, along with numerous online training courses.
- Acknowledgments vii
- Introducing Microsoft Excel 2010 ix
- Modifying the Display of the Ribbon xxv
- Features and Conventions of This Book xxxi
- Using the Practice Files xxxiii
- Your Companion eBook xxxvi
- Getting Help xxxvii
- 1 Setting Up a Workbook 1
- Creating Workbooks 2 Modifying Workbooks 7 Modifying Worksheets 11 Customizing the Excel 2010 Program Window 15 Zooming In on a Worksheet 16 Arranging Multiple Workbook Windows 7 Adding Buttons to the Quick Access Toolbar 18 Customizing the Ribbon 20 Maximizing Usable Space in the Program Window 23 Key Points 27
- 2 Working with Data and Excel Tables 29
- Entering and Revising Data 30 Moving Data Within a Workbook 34 Finding and Replacing Data 38 Correcting and Expanding Upon Worksheet Data 43 Defining Excel tables _48 Key Points 53
- 3 Performing Calculations on Data 55
- Naming Groups of Data 56 Creating Formulas to Calculate Values 60 Summarizing Data That Meets Specific Conditions 70 Finding and Correcting Errors in Calculations 74 Key Points 81
- 4 Changing Workbook Appearance 83
- Formatting Cells 84 Defining Styles 90 Applying Workbook Themes and Excel Table Styles 94 Making Numbers Easier to Read 101 Changing the Appearance of Data Based on Its Value 106 Adding Images to Worksheets 113 Key Points 119
- 5 Focusing on Specific Data by Using Filters 121
- Limiting Data That Appears on Your Screen 122 Manipulating Worksheet Data 128 Selecting List Rows at Random 128 Summarizing Worksheets with Hidden and Filtered Rows 129 Finding Unique Values Within a Data Set 132 Defining Valid Sets of Values for Ranges of Cells 135 Key Points 141
- 6 Reordering and Summarizing Data 143
- Soring Worksheet Data 144 Organizing Data into Level 153 Looking Up Information in a Worksheet 160 Key Points 165
- 7 Combining Data from Multiple Sources 167
- Using Workbooks as Templates for Other Workbooks 168 Linking to Data in Other Worksheets and Workbooks 175 Consolidating Multiple Sets of Data into a Single Workbook 180 Grouping Multiple Data 184 Key Points 187
- 8 Analyzing Alternative Data Sets 189
- Defining an Alternative Dara Set 190 Defining Multiple Alternative Data Sets 194 Varying Your Data to Get a Desired Result by Using Goal Seek 198 Finding Optimal Solutions by Using Solver 201 Analyzing Data by Using Descriptive Statistics 2O7 Key Points 209
- 9 Creating Dynamic Worksheets by Using PivotTables 211
- Analyzing Data Dynamically by Using Pivot Tables 212 Filtering, Showing, and Hiding PivotTable Data 222 Editing PivotTables 236 Formatting PivotTables 242 Creating PivotTables from External Data 250 Key Points 257
- 10 Creating Charts and Graphics 259
- Creating Charts 260 Customizing the Appearance of Charts 267 Finding Trends in Your Data 274 Summarizing Your Data by Using Sparklines 276 Creating Dynamic Charts by Using PivotCharts 281 Creating Diagrams by Using SmartArt 286 Creating Shapes and Mathematical Equations 293 Key Points 301
- 11 Printing 303
- Adding Headers and Footers to Printed Pages 304 Preparing Worksheets for Printing 309 Previewing Worksheets Before Printing 312 Changing Page Breaks in Worksheet 312 Changing the Page Printing Order for Worksheets 314 Printing Worksheets 318 Printing Parts of Worksheets 322 Printing Charts 326 Key Points 322
- 12 Automating Repetitive Tasks by Using Macros 329
- Enabling and Examining Macros 330 Macro Security in Excel 2010 330 Examining Macros 332 Creating and Modifying Macros 336 Running Macros When a Button Is Clicked 339 Running Macros When a Workbook Is Opened 344 Key Points 347
- 13 Working with Other Microsoft Office Programs 349
- Including Office Documents in Workbooks 350 Storing Workbooks as Parts of Other Office Documents 355 Creating Hyperlinks 358 Pasting Charts into Other Documents 364 Key Points 365
- 14 Collaborating with Colleagues 362
- Sharing Workbooks 368 Saving a Workbook for Secure Electronic Distribution 372 Managing Comments 372 Tracking and Managing Colleagues' Changes 375 Protecting Workbooks and Worksheets 379 Finalizing a Workbook 385 Authenticating Workbooks 386 Saving Workbooks for the Web 388 Key Points 392
- Glossary 393 Keyboard Shortcuts 397
- Index 404
- About the Author 436
- To order a book, you need to send a phone number for a callback. Then specify:
- 1. Correct spelling of the first name, last name, as indicated in the passport or other document proving the identity. (Data is required upon receipt of the order)
- 2. City of delivery
- 3. Nova Poshta office number or desired delivery address.
- The prices on the site do not include the cost of Nova Poshta services.
- When prepaying for the Master Card, the supplier pays the order forwarding.
- Delivery is carried out anywhere in Ukraine.
- Delivery time 1-2 days, if the book is available and 3-4 weeks, if it is necessary to order from the publisher.