Microsoft Excel 2019 inside out /

Dive into Microsoft Excel 2019-and really put your spreadsheet expertise to work. This supremely organised reference packs hundreds of timesaving solutions, tips, and workarounds-all you need to make the most of Excel's most powerful tools for analysing data and making better decisions. Renowne...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Jelen, Bill (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Place of publication not identified] : Pearson Education, [2018]
Temas:
Microsoft Excel (Computer file)
Electronic spreadsheets > Computer programs.
Tableurs > Logiciels.
Electronic spreadsheets > Computer programs
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Intro
  • Title Page
  • Copyright Page
  • Dedication Page
  • Contents at a Glance
  • Table of Contents
  • About the Author
  • Introduction
  • Who This Book Is For
  • How This Book Is Organized
  • About the Companion Content
  • Acknowledgments
  • Support and Feedback
  • Part I The Excel Interface
  • Chapter 1 What's New in Excel 2019
  • Office 365 Is the Future
  • Forward-Looking Features in Excel 2019
  • Power Query Is Still the Best New Feature in Excel 2019
  • Co-Authoring Allows Multiple People to Edit the Same Workbook at the Same Time
  • Improvements to PivotTables
  • New Calculation Functions in Excel 2019
  • Two New Charts in 2019
  • Inserting Icons and 3D Models
  • Using the Inking Tools in Excel 2019
  • Suggesting Ideas to the Excel Team
  • Accessibility Improvements Across Office
  • Changes to the Ribbon and Home Screen
  • Collecting Survey Data in Excel Using Office 365
  • Future Features Coming to Office 365
  • Dynamic Array Functions in Office 365
  • Chapter 2 Using the Excel Interface
  • Using the Ribbon
  • Using the Quick Access Toolbar
  • Using the Full-Screen File Menu
  • Using the New Sheet Icon to Add Worksheets
  • Navigating Through Many Worksheets Using the Controls in the Lower Left
  • Using the Mini Toolbar to Format Selected Text
  • Expanding the Formula Bar
  • Zooming In and Out on a Worksheet
  • Using the Status Bar to Add Numbers
  • Switching Between Normal View, Page Break Preview, and Page Layout View Modes
  • Chapter 3 Customizing Excel
  • Performing a Simple Ribbon Modification
  • Adding a New Ribbon Tab
  • Sharing Customizations with Others
  • Questions About Ribbon Customization
  • Using the Excel Options Dialog Box
  • Options to Consider
  • Five Excel Oddities
  • Chapter 4 Keyboard Shortcuts
  • Using Keyboard Accelerators
  • Using the Shortcut Keys
  • Using My Favorite Shortcut Keys
  • Using Excel 2003 Keyboard Accelerators
  • Part II Calculating with Excel
  • Chapter 5 Understanding Formulas
  • Getting the Most from This Chapter
  • Introduction to Formulas
  • Entering Your First Formula
  • Three Methods of Entering Formulas
  • Entering the Same Formula in Many Cells
  • Use the Table Tool to Copy a Formula
  • Chapter 6 Controlling Formulas
  • Formula Operators
  • Understanding Error Messages in Formulas
  • Using Formulas to Join Text
  • Copying Versus Cutting a Formula
  • Automatically Formatting Formula Cells
  • Using Date Math
  • Troubleshooting Formulas
  • Chapter 7 Understanding Functions
  • Working with Functions
  • Getting Help with Excel Functions
  • Using AutoSum
  • Chapter 8 Using Everyday Functions: Math, Date and Time, and Text Functions
  • Math Functions
  • Date and Time Functions
  • Text Functions
  • Examples of Math Functions
  • Examples of Date and Time Functions
  • Examples of Text Functions
  • Chapter 9 Using Powerful Functions: Logical, Lookup, and Database Functions
  • Examples of Logical Functions
  • Examples of Information Functions

Ejemplares similares