Produktbild: Excel 2019 All-In-One for Dummies

Excel 2019 All-In-One for Dummies

37,99 €

inkl. gesetzl. MwSt., Versandkostenfrei


Beschreibung

Produktdetails

Einband

Taschenbuch

Erscheinungsdatum

13.11.2018

Verlag

John Wiley & Sons Inc

Seitenzahl

816

Maße (L/B/H)

23,3/18,9/4,5 cm

Gewicht

1108 g

Auflage

1. Auflage

Sprache

Englisch

ISBN

978-1-119-51794-8

Beschreibung

Produktdetails

Einband

Taschenbuch

Erscheinungsdatum

13.11.2018

Verlag

John Wiley & Sons Inc

Seitenzahl

816

Maße (L/B/H)

23,3/18,9/4,5 cm

Gewicht

1108 g

Auflage

1. Auflage

Sprache

Englisch

ISBN

978-1-119-51794-8

Herstelleradresse

Libri GmbH
Europaallee 1
36244 Bad Hersfeld
DE

Email: gpsr@libri.de

Ein neues Kapitel für Ihre Bücher

Ein neues Kapitel für Ihre Bücher

Schenken Sie Ihren alten Schätzen ein zweites Leben und erhalten dafür eine Thalia Geschenkkarte.

Jetzt verkaufen
Jetzt verkaufen

Noch keine Bewertungen vorhanden

Verfassen Sie die erste Bewertung zu diesem Artikel

Helfen Sie anderen Kundinnen und Kunden durch Ihre Meinung.

Kundinnen und Kunden meinen

Bewertungen (0)

Die Leseprobe wird geladen.
  • Produktbild: Excel 2019 All-In-One for Dummies
  • 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 Recalculation 343

    Circular References 345

    Chapter 2: Logical Functions and Error Trapping 347

    Understanding Error Values 348

    Using Logical Functions 349

    Error-Trapping Formulas 353

    Whiting-Out Errors with Conditional Formatting 356

    Formula Auditing 358

    Removing Errors from the Printout 370

    Chapter 3: Date and Time Formulas 371

    Understanding Dates and Times 371

    Using Date Functions 374

    Using Time Functions 383

    Chapter 4: Financial Formulas 387

    Financial Functions 101 387

    The PV, NPV, and FV Functions 388

    The PMT Function 392

    Depreciation Functions 395

    Analysis ToolPak Financial Functions 398

    Chapter 5: Math and Statistical Formulas 401

    Math & Trig Functions 402

    Statistical Functions 412

    Chapter 6: Lookup, Information, and Text Formulas 421

    Lookup and Reference 422

    Information, Please 433

    Much Ado about Text 438

    Book 4: Worksheet Collaboration and Review 445

    Chapter 1: Protecting Workb