Microsoft Excel 2019 : inside out /
Jelen, Bill,
Microsoft Excel 2019 : inside out / Microsoft Excel 2019 created by Bill Jelen. - xxxi, 829 pages : illustrations ; 24 cm
Includes index.
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
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. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customisations to advanced analysis, visualisations, and dashboards. Discover how experts tackle today's key tasks-and challenge yourself to new levels of mastery. Enter formulas more efficiency
9781509307692 1509307699
Microsoft Excel (Computer file)
Electronic spreadsheets--Computer programs.
HF5548.4.M523 JEL
Microsoft Excel 2019 : inside out / Microsoft Excel 2019 created by Bill Jelen. - xxxi, 829 pages : illustrations ; 24 cm
Includes index.
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
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. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customisations to advanced analysis, visualisations, and dashboards. Discover how experts tackle today's key tasks-and challenge yourself to new levels of mastery. Enter formulas more efficiency
9781509307692 1509307699
Microsoft Excel (Computer file)
Electronic spreadsheets--Computer programs.
HF5548.4.M523 JEL