Synopsis
Your one-stop guide to all things Excel 2016
Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic―and beyond. In no time, your Excel skills will go from 'meh' to excellent.
Written by expert Greg Harvey, who has sold more than 4.5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel. From generating pivot tables and performing financial functions to performing error trapping and building and running macros―and everything in between―this hands-on, friendly guide makes working with Excel easier than ever before.
- Serves as the ideal reference for solving common questions and Excel pain points quickly and easily
- Helps to increase productivity and efficiency when working in Excel
- Fully updated for the new version of Excel
- Covers basic and more advanced Excel topics
If working in Excel occasionally makes you want to scream, this will be the dog-eared, dust-free reference you'll turn to again and again.
"synopsis" may belong to another edition of this title.
About the Author
Greg Harvey, PhD, is the president of Mind Over Media, LLC., and a bestselling author of books on Excel, including all editions of Excel For Dummies and Excel Workbook For Dummies. He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since.
From the Back Cover
8 BOOKS IN 1
- Excel Basics
- Worksheet Design
- Formulas and Functions
- Worksheet Collaboration and Review
- Charts and Graphics
- Data Management
- Data Analysis
- Macros and VBA
Get up to speed right away with the all-new, all-powerful Excel 2016
Excel, the #1 spreadsheet tool used by millions, has undergone a massive makeover. Each of the self-contained minibooks in this easy-to-follow guide covers one important area of Excel 2016. Find out how to make the most of your worksheets, create eye-popping charts, analyze data like a pro, and even customize Excel with VBA programming!
- Start here if you're new to Excel, Book I covers all the essentials
- Worksheet 101 learn to enter data and build, format, print, and manage worksheets in Book II
- Getting functional Book III shows you how to build formulas to calculate just about anything
- Let's team up see how to share spreadsheets safely with other people and programs in Book IV
- Charts and graphs in Book V, find out how to choose and create the ideal visual representation for your data
- What to do with it discover in Book VI how to maintain, filter, query, and manage volumes of data
- Analyze everything Book VII shows you amazing ways to analyze data and summarize it with pivot tables
- Macro mania learn to automate common tasks with macros and create custom user-defined functions in Book VIII
Open the book and find:
- Tips for using Excel on a touchscreen device
- How to customize the Ribbon and the Quick Access toolbar
- Advice on editing spreadsheets
- Ways to find and eliminate formula errors
- Secrets of sharing on OneDrive®
- Steps for querying your data
- All about Office and Excel Add-ins
From the Inside Flap
8 BOOKS IN 1
- Excel Basics
- Worksheet Design
- Formulas and Functions
- Worksheet Collaboration and Review
- Charts and Graphics
- Data Management
- Data Analysis
- Macros and VBA
Get up to speed right away with the all-new, all-powerful Excel 2016
Excel, the #1 spreadsheet tool used by millions, has undergone a massive makeover. Each of the self-contained minibooks in this easy-to-follow guide covers one important area of Excel 2016. Find out how to make the most of your worksheets, create eye-popping charts, analyze data like a pro, and even customize Excel with VBA programming!
- Start here — if you're new to Excel, Book I covers all the essentials
- Worksheet 101 — learn to enter data and build, format, print, and manage worksheets in Book II
- Getting functional — Book III shows you how to build formulas to calculate just about anything
- Let's team up — see how to share spreadsheets safely with other people and programs in Book IV
- Charts and graphs — in Book V, find out how to choose and create the ideal visual representation for your data
- What to do with it — discover in Book VI how to maintain, filter, query, and manage volumes of data
- Analyze everything — Book VII shows you amazing ways to analyze data and summarize it with pivot tables
- Macro mania — learn to automate common tasks with macros and create custom user-defined functions in Book VIII
Open the book and find:
- Tips for using Excel on a touchscreen device
- How to customize the Ribbon and the Quick Access toolbar
- Advice on editing spreadsheets
- Ways to find and eliminate formula errors
- Secrets of sharing on OneDrive®
- Steps for querying your data
- All about Office and Excel Add-ins
"About this title" may belong to another edition of this title.
Search results for Excel 2016 All-in-One For Dummies
Stock Image
Excel 2016 All-in-One For Dummies
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00103778936
Stock Image
Excel 2016 All-in-One For Dummies
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Acceptable. Item in acceptable condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00096713363
Stock Image
Excel 2016 All-in-One For Dummies
Seller: Gulf Coast Books, Cypress, TX, U.S.A.
Seller rating 5 out of 5 stars
paperback. Condition: Good. Seller Inventory # 111907715X-3-33960806
Stock Image
Excel 2016 All-in-One For Dummies (For Dummies (Computer/Tech))
Seller: Orion Tech, Kingwood, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. Seller Inventory # 111907715X-3-25028983
Stock Image
Excel 2016 All-in-One For Dummies
Seller: Your Online Bookstore, Houston, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. Seller Inventory # 111907715X-3-21115651
Seller Image
Excel 2016 All-in-One For Dummies
Seller: Greenworld Books, Arlington, TX, U.S.A.
Seller rating 5 out of 5 stars
Condition: good. Fast Free Shipping â" Good condition. It may show normal signs of use, such as light writing, highlighting, or library markings, but all pages are intact and the book is fully readable. A solid, complete copy that's ready to enjoy. Seller Inventory # GWV.111907715X.G
Seller Image
Excel 2016 All-in-One For Dummies
Seller: Greenworld Books, Arlington, TX, U.S.A.
Seller rating 5 out of 5 stars
Condition: acceptable. Fast Free Shipping â" A well-loved copy with text fully readable and cover pages intact. May display wear such as writing, highlighting, bends, folds or library marks. Still a complete and usable book. Seller Inventory # GWV.111907715X.A
Seller Image
Excel 2016 All-in-One For Dummies
Seller: MERS Goodwill-Kansas City, Blue Springs, MO, U.S.A.
Seller rating 5 out of 5 stars
Condition: good. The book has been read but is in good condition. It has very minimal damage to the cover, including scuff marks, but no holes or tears. The dust jacket for hard covers may not be included. The binding has minimal wear. The majority of pages are undamaged with minimal creasing or tearing, minimal pencil underlining of text, no highlighting of text, and no writing in the margins. There are no missing pages. See the seller's listing for full details and a description of any imperfections. Seller Inventory # WMEKV.111907715X.G
Seller Image
Excel 2016 All-in-One For Dummies
Seller: Greenworld Books, Arlington, TX, U.S.A.
Seller rating 5 out of 5 stars
Condition: very_good. Fast Free Shipping â" Very Good condition book with a firm cover and clean pages. Shows normal use and some light wear or limited notes markings. A solid, nice copy to enjoy. Seller Inventory # GWV.111907715X.VG
Stock Image
Excel 2016 All-In-One for Dummies
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G111907715XI4N00