Excel 2019 All-in-One For Dummies

Informationen zum Autor Greg Harvey, PhD, is a veteran computer educator dating back to the days of DOS and Lotus 1-2-3. He has taught spreadsheet and database management courses at Golden Gate University and written dozens of books, including many in the For Dummies series. Klappentext Make Excel work for youExcel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions--including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions.The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources. Get familiar with Worksheet design Find out how to work with charts and graphics Use Excel for data management, analysis, modeling, and visualization Make sense of macros and VBAIf you're a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you, this all-encompassing book makes it easy! Zusammenfassung Make Excel work for youExcel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions! such as creating and editing worksheets! to sharing and reviewing worksheets! to editing macros with Visual Basic! it provides you with a broad scope of the most common Excel applications and functions--including formatting worksheets! setting up formulas! protecting worksheets! importing data! charting data! and performing statistical functions.The book covers importing data! building and editing worksheets! creating formulas! generating pivot tables! and performing financial functions! what-if scenarios! database functions! and Web queries. More advanced topics include worksheet sharing and auditing! performing error trapping! building and running macros! charting data! and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze! model! and visualize vast quantities of data from a variety of local and online sources. Get familiar with Worksheet design Find out how to work with charts and graphics Use Excel for data management! analysis! modeling! and visualization Make sense of macros and VBAIf you're a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you! this all-encompassing book makes it easy! Inhaltsverzeichnis Introduction 1 About This Book 2 Foolish Assumptions 2 How This Book Is Organized 3 Conventions Used in This Book 7 Icons Used in This Book 9 Beyond the Book 9 Where to Go from Here 10 Book 1: Excel Basics 11 Chapter 1: The Excel 2019 User Experience 13 Excel 2019's Sleek Look and Feel 14 Excel's Start Screen 15 Excel's Ribbon User Interface 16 Getting Help 36 Launching and Quitting Excel 39 Chapter 2: Customizing Excel 2019 45 Tailoring the Quick Access Toolbar to Your Tastes 46 Exercising Your Options 49 Using O...

Auteur

Greg Harvey, PhD, is a veteran computer educator dating back to the days of DOS and Lotus 1-2-3. He has taught spreadsheet and database management courses at Golden Gate University and written dozens of books, including many in the For Dummies series.

Texte du rabat

Make Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions--including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources. Get familiar with Worksheet design Find out how to work with charts and graphics Use Excel for data management, analysis, modeling, and visualization Make sense of macros and VBA If you're a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you, this all-encompassing book makes it easy!

Contenu

Introduction 1

About This Book 2

Foolish Assumptions 2

How This Book Is Organized 3

Conventions Used in This Book 7

Icons Used in This Book 9

Beyond the Book 9

Where to Go from Here 10

Book 1: Excel Basics 11

Chapter 1: The Excel 2019 User Experience 13

Excel 2019's Sleek Look and Feel 14

Excel's Start Screen 15

Excel's Ribbon User Interface 16

Getting Help 36

Launching and Quitting Excel 39

Chapter 2: Customizing Excel 2019 45

Tailoring the Quick Access Toolbar to Your Tastes 46

Exercising Your Options 49

Using Office Add-ins 72

Using Excel's Own Add-ins 74

Book 2: Worksheet Design 79

Chapter 1: Building Worksheets 81

Designer Spreadsheets 82

It Takes All Kinds (Of Cell Entries) 92

Data Entry 101 99

Saving the Data 124

Document Recovery to the Rescue 130

Chapter 2: Formatting Worksheets 133

Making Cell Selections 134

Adjusting Columns and Rows 143

Formatting Tables from the Ribbon 148

Formatting Tables with the Quick Analysis Tool 152

Formatting Cells from the Ribbon 153

Formatting Cell Ranges with the Mini-Toolbar 156

Using the Format Cells Dialog Box 158

Hiring Out the Format Painter 177

Using Cell Styles 178

Conditional Formatting 183

Chapter 3: Editing and Proofing Worksheets 193

Opening a Workbook 194

Cell Editing 101 201

A Spreadsheet with a View 209

Copying and Moving Stuff Around 216

Find and Replace This Disgrace! 227

Spell Checking Heaven 232

Looking Up and Translating Stuff 236

Marking Invalid Data 237

Eliminating Errors with Text to Speech 238

Chapter 4: Managing Worksheets 241

Reorganizing the Worksheet 242

Reorganizing the Workbook 257

Working with Multiple Workbooks 267

Consolidating Worksheets 270

Chapter 5: Printing Worksheets 277

Printing from the Excel 2019 Backstage View 278

Quick Printing the Worksheet 284

Working with the Page Setup Options 285

Using the Print Options on the Sheet tab of the Page Setup dialog box 293

Headers and Footers 294

Solving Page Break Problems 301

Printing the Formulas in a Report 303

Book 3: Formulas and Functions 305

Chapter 1: Building Basic Formulas 307

Formulas 101 308

Copying Formulas 321

Adding Array Formulas 327

Range Names in Formulas 332

Adding Linking Formulas 341

Controlling Formula Rec…