Excel Workbook For Dummies

Häftad, Engelska, 2022

309 kr

Beställningsvara. Skickas inom 5-8 vardagar. Fri frakt för medlemmar vid köp för minst 249 kr.

Get practical walkthroughs for the most useful Excel featuresLooking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you've been waiting for.This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you'll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program.Work through the book from start to finish or, if you'd prefer, jump right to the section that's giving you trouble, whether that's data visualization, macros, analysis, or anything else. You can also: Brush up on and practice time-saving keyboard shortcuts for popular commands and actionsGet a handle on multi-functional and practical pivot tables with intuitive practice exercisesLearn to secure your data with spreadsheet password protectionsPerfect for new users of Excel, Excel Workbook For Dummies is also the ideal resource for those who know their way around a spreadsheet but need a refresher on some of the more advanced features of this powerful program.

Produktinformation

Utgivningsdatum2022-03-21
Mått203 x 252 x 25 mm
Vikt590 g
FormatHäftad
SpråkEngelska
Antal sidor384
Upplaga2
FörlagJohn Wiley & Sons Inc
ISBN9781119832157

Tillhör följande kategorier

Affärsapplikationer inom Data och IT

Introduction 1Part 1: Building Worksheets 5Chapter 1: Getting Familiar with the Excel Interface 7Chapter 2: Entering the Worksheet Data 21Chapter 3: Formatting the Worksheet 37Chapter 4: Printing Worksheet Reports 59Chapter 5: Modifying the Worksheet 79Part 2: Using Formulas and Functions 101Chapter 6: Building Formulas 103Chapter 7: Copying and Correcting Formulas 123Chapter 8: Creating Date and Time Formulas 145Chapter 9: Financial Formulas and Functions 155Chapter 10: Using Math Functions 167Chapter 11: Using Common Statistical Functions 179Chapter 12: Using Lookup Functions 187Chapter 13: Using Logical Functions 197Chapter 14: Text Formulas and Functions 209Part 3: Working with Graphics 217Chapter 15: Charting Worksheet Data 219Chapter 16: Adding Graphics to Worksheets 231Part 4: Managing and Securing Data 249Chapter 17: Building and Maintaining Tables 251Chapter 18: Protecting Workbooks and Worksheet Data 271Part 5: Doing Data Analysis 283Chapter 19: Performing What-If Analysis 285Chapter 20: Generating PivotTables 299Part 6: Macros and Visual Basic for Applications 315Chapter 21: Using Macros 317Chapter 22: Using the Visual Basic Editor 327Part 7: The Part of Tens 341Chapter 23: Top Ten Features in Excel 343Chapter 24: Top Ten Tips for Using Excel Like a Pro 347Index 355