Excel 2019 Bible. ([2018])

• Record Type: Book
• Other Titles: Microsoft Excel 2019 Bible
• Further Information: Note: Michael Alexander, Dick Kusleika ; previously by John Walkenbach.
• Authors: Alexander, Michael, 1972-; Kusleika, Dick
• Other Names: Walkenbach, John
• Contents: 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
• Publisher Details: Indianapolis, IN : Wiley
• Publication Date: 2018
• Extent: 1 online resource
• Subjects: 005.369; Business -- Computer programs; Electronic spreadsheets; COMPUTERS / Desktop Applications / Spreadsheets; Electronic books
• Languages: English
• ISBNs: 9781119514770; 1119514770; 9781119549376; 9781119514763; 1119514762
• Related ISBNs: 111954937X; 9781119514787; 1119514789
• Notes: Note: Online resource; title from PDF title page (EBSCO, viewed September 27, 2018).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.