Microsoft Excel 2019 : inside out / created by Bill Jelen.

By:

Jelen, Bill [author.]

Material type: Text

TextPublisher: Pearson Education, Inc., 2019Description: xxxi, 829 pages : illustrations ; 24 cmContent type:

text
still image

Media type:

unmediated

Carrier type:

volume

ISBN:

9781509307692
1509307699

Other title:

Microsoft Excel 2019

Subject(s):

LOC classification:

HF5548.4.M523 JEL

Contents:

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

Summary: 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

Reviews from LibraryThing.com:

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Call number	Copy number	Status	Date due	Barcode
Book	Main Library Open Shelf	HF5548.4.M523 JEL (Browse shelf(Opens below))	160112	Available		BK148001

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

There are no comments on this title.

to post a comment.

here