Includes index.

Online resource; title from PDF title page (EBSCO, viewed September 27, 2018).

Cover; Title Page; Copyright; About the Authors; About the Technical Editors; Credits; Acknowledgments; Contents; Introduction; Is This Book for You?; Software Versions; Conventions Used in This Book; Excel commands; Typographical conventions; Mouse conventions; How This Book Is Organized; How to Use This Book; What's on the Website; Part I: Getting Started with Excel; Chapter 1: Introducing Excel; Understanding What Excel Is Used For; Looking at What's New in Excel 2019; Understanding Workbooks and Worksheets; Moving around a Worksheet; Navigating with your keyboard

Navigating with your mouseUsing the Ribbon; Ribbon tabs; Contextual tabs; Types of commands on the Ribbon; Accessing the Ribbon by using your keyboard; Using Shortcut Menus; Customizing Your Quick Access Toolbar; Working with Dialog Boxes; Navigating dialog boxes; Using tabbed dialog boxes; Using Task Panes; Creating Your First Excel Workbook; Getting started on your worksheet; Filling in the month names; Entering the sales data; Formatting the numbers; Making your worksheet look a bit fancier; Summing the values; Creating a chart; Printing your worksheet; Saving your workbook

Chapter 2: Entering and Editing Worksheet DataExploring Data Types; Numeric values; Text entries; Formulas; Entering Text and Values into Your Worksheets; Entering numbers; Entering text; Using Enter mode; Entering Dates and Times into Your Worksheets; Entering date values; Entering time values; Modifying Cell Contents; Deleting the contents of a cell; Replacing the contents of a cell; Editing the contents of a cell; Learning some handy data-entry techniques; Automatically moving the selection after entering data; Selecting a range of input cells before entering data

Using Ctrl+Enter to place information into multiple cells simultaneouslyChanging modes; Entering decimal points automatically; Using AutoFill to enter a series of values; Using AutoComplete to automate data entry; Forcing text to appear on a new line within a cell; Using AutoCorrect for shorthand data entry; Entering numbers with fractions; Using a form for data entry; Entering the current date or time into a cell; Applying Number Formatting; Using automatic number formatting; Formatting numbers by using the Ribbon; Using shortcut keys to format numbers

Formatting numbers by using the Format Cells dialog boxAdding your own custom number formats; Chapter 3: Performing Basic Worksheet Operations; Learning the Fundamentals of Excel Worksheets; Working with Excel windows; Moving and resizing windows; Switching among windows; Closing windows; Activating a worksheet; Adding a new worksheet to your workbook; Deleting a worksheet you no longer need; Changing the name of a worksheet; Changing a sheet tab color; Rearranging your worksheets; Hiding and unhiding a worksheet; Controlling the Worksheet View; Zooming in or out for a better view

The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible. -Create functional spreadsheets that work -Master formulas, formatting, pivot tables, and more -Get acquainted with Excel 2019's new features and tools Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.