Produktdetaljer
ISBN
9781119832157
Publisert
2022-03-21
Utgave
2. utgave
Utgiver
Vendor
For Dummies
Vekt
590 gr
Høyde
252 mm
Bredde
203 mm
Dybde
25 mm
Aldersnivå
P, 06
Språk
Product language
Engelsk
Format
Product format
Heftet
Antall sider
384
Biographical note
Paul McFedries has published over 100 books, with topics ranging from Windows 10 to Microsoft Office, Apple gadgets, and Amazon Alexa. He is the author of the recently released Excel Data Analysis For Dummies and Google’s G Suite For Dummies.
Greg Harvey, PhD was author of over 30 For Dummies titles covering Excel.
Get practical walkthroughs for the most useful Excel features Looking 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 protections Perfect 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.
Les mer
Introduction 1 Part 1: Building Worksheets 5 Chapter 1: Getting Familiar with the Excel Interface 7 Chapter 2: Entering the Worksheet Data 21 Chapter 3: Formatting the Worksheet 37 Chapter 4: Printing Worksheet Reports 59 Chapter 5: Modifying the Worksheet 79 Part 2: Using Formulas and Functions 101 Chapter 6: Building Formulas 103 Chapter 7: Copying and Correcting Formulas 123 Chapter 8: Creating Date and Time Formulas 145 Chapter 9: Financial Formulas and Functions 155 Chapter 10: Using Math Functions 167 Chapter 11: Using Common Statistical Functions 179 Chapter 12: Using Lookup Functions 187 Chapter 13: Using Logical Functions 197 Chapter 14: Text Formulas and Functions 209 Part 3: Working with Graphics 217 Chapter 15: Charting Worksheet Data 219 Chapter 16: Adding Graphics to Worksheets 231 Part 4: Managing and Securing Data 249 Chapter 17: Building and Maintaining Tables 251 Chapter 18: Protecting Workbooks and Worksheet Data 271 Part 5: Doing Data Analysis 283 Chapter 19: Performing What-If Analysis 285 Chapter 20: Generating PivotTables 299 Part 6: Macros and Visual Basic for Applications 315 Chapter 21: Using Macros 317 Chapter 22: Using the Visual Basic Editor 327 Part 7: The Part of Tens 341 Chapter 23: Top Ten Features in Excel 343 Chapter 24: Top Ten Tips for Using Excel Like a Pro 347 Index 355
Les mer
Elevate your spreadsheet wizardry! The best way to learn how to build Excel® spreadsheets is to dive headfirst into the software and let the formulas and functions fly. With the exercises in this book, you’ll get hands-on experience with entering and formatting data, using formulas and functions, creating charts and PivotTables, and writing macros. The ultimate learn-by-doing guide to Microsoft’s best-selling spreadsheet program, this book offers step-by-step lessons on basic and advanced topics to help you master one of the most widely used business apps today! Inside… Enter data and format your spreadsheetAdd formulas and functionsCreate and customize chartsBuild sophisticated PivotTablesWrite time-saving macrosSecure your files with passwordsShare your work with colleaguesAvoid common Excel pitfalls
Les mer
Produktdetaljer
ISBN
9781119832157
Publisert
2022-03-21
Utgave
2. utgave
Utgiver
Vendor
For Dummies
Vekt
590 gr
Høyde
252 mm
Bredde
203 mm
Dybde
25 mm
Aldersnivå
P, 06
Språk
Product language
Engelsk
Format
Product format
Heftet
Antall sider
384
Biographical note
Paul McFedries has published over 100 books, with topics ranging from Windows 10 to Microsoft Office, Apple gadgets, and Amazon Alexa. He is the author of the recently released Excel Data Analysis For Dummies and Google’s G Suite For Dummies.
Greg Harvey, PhD was author of over 30 For Dummies titles covering Excel.