by Greg Harvey, PhD
8 BOOKS in ONE
Publisher’s Acknowledgments Associate Publisher: Katie Mohr
Project Editor: Kelly Ewing
Technical Editor: Russ Mullen
Editorial Assistant: Matthew Lowe Sr. Editorial Assistant: Cherie Case
Production Editor: Mohammed Zafar Ali
Cover Image: ©Jojje/Shutterstock
Purchase Now !
Just with Paypal
Just with Paypal
Book Details
Price
|
8.00 USD |
|---|---|
Pages
| 1027 p |
File Size
|
23,895 KB |
File Type
|
PDF format |
ISBN
| 978-1-119-51794-8 (pbk) 978-1-119-51815-0 (ebk) 978-1-119-51821-1 (ebk) |
Copyright
| 2019 by John Wiley & Sons, Inc |
Greg Harvey has authored tons of computer books, the most recent being
Excel 2019 For Dummies. He started out training business users on how to
use IBM personal computers and their attendant computer software in the
rough-and-tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of
the last century. After working for a number of independent training firms, he
went on to teach semester-long courses in spreadsheet and database
management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For
Dummies books are, of course, his all-time favorites to write because they
enable him to write to his favorite audience, the beginner. They also enable
him to use humor (a key element to success in the training room) and, most
delightful of all, to express an opinion or two about the subject matter at hand.
Introduction
Excel 2019 All-in-One For Dummies brings together plain and simple
information on using all aspects of the latest-and-greatest version of
Microsoft Excel. It’s designed to be of help no matter how much or how little
experience you have with the program. As the preeminent spreadsheet and
data analysis software for all sorts of computing devices running Windows 10
(desktops, laptops, tablet PCs and even smartphones), Excel 2019 offers its
users seemingly unlimited capabilities too often masked in technical jargon
and obscured by explanations only a software engineer could love. On top of
that, many of the publications that purport to give you the lowdown on using
Excel are quite clear on how to use particular features without giving you a
clue as to why you would want to go to all the trouble.
Warning: Excel 2019 marks the first version of Microsoft Excel that runs
exclusively under a home or business version of Windows 10. If your
computer runs an earlier version of Windows, such as Windows 7 or 8, you
must content yourself with using Excel 2016, which is part of an Office 365
subscription has all the power of Excel 2019 but in a slightly different format.
If such is the case, you need to put this book down now and instead pick up
the Excel 2016 All-In-One For Dummies by Greg Harvey.
The truth is that understanding how to use the abundance of features offered
by Excel 2019 is only half the battle, at best. The other half of the battle is to
understand how these features can benefit you in your work; in other words,
“what’s in it for you.” I have endeavored to cover both the “how to” and “so
what” aspects in all my discussions of Excel features, being as clear as
possible and using as little tech-speak as possible.
Fortunately, Excel 2019 is well worth the effort to get to know because it’s
definitely one of the best data-processing and analysis tools that has ever
come along. Its Quick Analysis tool, Office Add-ins, Flash Fill, and
Recommended Charts and PivotTables, along with the tried-and-true Live
Preview feature and tons of ready-made galleries, make this version of the
program the easiest to use ever. In short, Excel 2019 is a blast to use when
you know what you’re doing, and my great hope is that this “fun” aspect of
using the program comes through on every page (or, at least, every other page).
Table of Contents
Cover
Introduction
About This Book
Foolish Assumptions
How This Book Is Organized
Conventions Used in This Book
Icons Used in This Book
Beyond the Book
Where to Go from Here
Book 1: Excel Basics
Chapter 1: The Excel 2019 User Experience
Excel 2019’s Sleek Look and Feel
Excel’s Start Screen
Excel’s Ribbon User Interface
Getting Help
Launching and Quitting Excel
Chapter 2: Customizing Excel 2019
Tailoring the Quick Access Toolbar to Your Tastes
Exercising Your Options
Using Office Add-ins
Using Excel’s Own Add-ins
Book 2: Worksheet Design
Chapter 1: Building Worksheets
Designer Spreadsheets
It Takes All Kinds (Of Cell Entries)
Data Entry 101
Saving the Data
Document Recovery to the Rescue
Chapter 2: Formatting Worksheets
Making Cell Selections
Adjusting Columns and Rows
Formatting Tables from the Ribbon
Formatting Tables with the Quick Analysis Tool
Formatting Cells from the Ribbon
Formatting Cell Ranges with the Mini-Toolbar
Using the Format Cells Dialog Box
Hiring Out the Format Painter
Using Cell Styles
Conditional Formatting
Chapter 3: Editing and Proofing Worksheets
Opening a Workbook
Cell Editing 101
A Spreadsheet with a View
Copying and Moving Stuff Around
Find and Replace This Disgrace!
Spell Checking Heaven
Looking Up and Translating Stuff
Marking Invalid Data
Eliminating Errors with Text to Speech
Chapter 4: Managing Worksheets
Reorganizing the Worksheet
Reorganizing the Workbook
Working with Multiple Workbooks
Consolidating Worksheets
Chapter 5: Printing Worksheets
Printing from the Excel 2019 Backstage View
Quick Printing the Worksheet
Working with the Page Setup Options
Using the Print Options on the Sheet tab of the Page Setup dialog box
Headers and Footers
Solving Page Break Problems
Printing the Formulas in a Report
Book 3: Formulas and Functions
Chapter 1: Building Basic Formulas
Formulas 101
Copying Formulas
Adding Array Formulas
Range Names in Formulas
Adding Linking Formulas
Controlling Formula Recalculation
Circular References
Chapter 2: Logical Functions and Error Trapping
Understanding Error Values
Using Logical Functions
Error-Trapping Formulas
Whiting-Out Errors with Conditional Formatting
Formula Auditing
Removing Errors from the Printout
Chapter 3: Date and Time Formulas
Understanding Dates and Times
Using Date Functions
Using Time Functions
Chapter 4: Financial Formulas
Financial Functions 101
The PV, NPV, and FV Functions
The PMT Function
Depreciation Functions
Analysis ToolPak Financial Functions
Chapter 5: Math and Statistical Formulas
Math & Trig Functions
Statistical Functions
Chapter 6: Lookup, Information, and Text Formulas
Lookup and Reference
Information, Please …
Much Ado about Text
Book 4: Worksheet Collaboration and Review
Chapter 1: Protecting Workbooks and Worksheet Data
Password-Protecting the File
Protecting the Worksheet
Chapter 2: Using Hyperlinks
Hyperlinks 101
Using the HYPERLINK Function
Chapter 3: Preparing a Workbook for Distribution
Getting Your Workbook Ready for Review
Annotating Workbooks
Chapter 4: Sharing Workbooks and Worksheet Data
Sharing Your Workbooks Online
Excel 2019 Data Sharing Basics
Exporting Workbooks to Other Usable File Formats
Book 5: Charts and Graphics
Chapter 1: Charting Worksheet Data
Worksheet Charting 101
Adding Sparkline Graphics to a Worksheet
Adding Infographics to a Worksheet
Printing Charts
Chapter 2: Adding Graphic Objects
Graphic Objects 101
Inserting Different Types of Graphics
Drawing Graphics
Adding Screenshots of the Windows 10 Desktop
Using Themes
Book 6: Data Management
Chapter 1: Building and Maintaining Data Lists
Data List Basics
Sorting Data
Subtotaling Data
Chapter 2: Filtering and Querying a Data List
Data List Filtering 101
Filtering Data
Using the Database Functions
External Data Query
Book 7: Data Analysis
Chapter 1: Performing What-If Scenarios
Using Data Tables
Exploring Different Scenarios
Hide and Goal Seeking
Using the Solver
Chapter 2: Performing Large-Scale Data Analysis
Creating Pivot Tables
Formatting a Pivot Table
Sorting and Filtering the Pivot Table Data
Modifying the Pivot Table
Creating Pivot Charts
Using the Power Pivot Add-in
Using the 3D Map feature
Creating Forecast Worksheets
Book 8: Macros and VBA
Chapter 1: Recording and Running Macros
Macro Basics
Assigning Macros to the Ribbon and the Quick Access Toolbar
Macro Security
Chapter 2: VBA Programming
Using the Visual Basic Editor
Creating Custom Excel Functions
Index
About the Author
Connect with Dummies
End User License Agreement
Bookscreen
About This Book
As the name states, Excel 2019 All-in-One For Dummies is a reference
(whether you keep it on your desk or use it to prop up your desk is your
business). This means that although the chapters in each book are laid out in a
logical order, each stands on its own, ready for you to dig into the
information at any point.
As much as possible, I have endeavored to make the topics within each book
and chapter stand on their own. When there’s just no way around relying on
some information that’s discussed elsewhere, I include a cross-reference that
gives you the chapter and verse (actually the book and chapter) for where you
can find that related information if you’re of a mind to.
Use the full Table of Contents and Index to look up the topic of the hour and
find out exactly where it is in this compilation of Excel information. You’ll
find that although most topics are introduced in a conversational manner, I
don’t waste much time cutting to the chase by laying down the main
principles at work (usually in bulleted form) followed by the hard reality of
how you do the deed (as numbered steps).