Excel Workbook for Dummies - 2nd Edition by Paul McFedries & Greg Harvey (Paperback)

About the Book

Book Synopsis

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 actions
• Get a handle on multi-functional and practical pivot tables with intuitive practice exercises
• Learn 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.

From the Back Cover

Elevate your spreadsheet wizardry!

The best way to learn how to build Excel^(R) 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 spreadsheet
• Add formulas and functions
• Create and customize charts
• Build sophisticated PivotTables
• Write time-saving macros
• Secure your files with passwords
• Share your work with colleagues
• Avoid common Excel pitfalls

About the Author

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.