Excel 2019 Bible. (Record no. 5300)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 11121nam a22005173i 4500 |
| 001 - CONTROL NUMBER | |
| control field | EBC5521163 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | MiAaPQ |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240724113353.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d | |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr cnu|||||||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 240724s2018 xx o ||||0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781119514770 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Canceled/invalid ISBN | 9781119514787 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (MiAaPQ)EBC5521163 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (Au-PeEL)EBL5521163 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)1054245932 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | MiAaPQ |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | MiAaPQ |
| Modifying agency | MiAaPQ |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | HF5548.4.M523 .A449 2019 |
| 082 0# - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.54 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Alexander, Michael. |
| 245 10 - TITLE STATEMENT | |
| Title | Excel 2019 Bible. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 1st ed. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Newark : |
| Name of producer, publisher, distributor, manufacturer | John Wiley & Sons, Incorporated, |
| Date of production, publication, distribution, manufacture, or copyright notice | 2018. |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Date of production, publication, distribution, manufacture, or copyright notice | ©2019. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource (1123 pages) |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Media type code | c |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Carrier type code | cr |
| Source | rdacarrier |
| 490 1# - SERIES STATEMENT | |
| Series statement | Bible Series |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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 mouse -- Using 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 Data -- Exploring 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. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Using Ctrl+Enter to place information into multiple cells simultaneously -- Changing 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 box -- Adding 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 -- Viewing a worksheet in multiple windows -- Comparing sheets side by side -- Splitting the worksheet window into panes -- Keeping the titles in view by freezing panes -- Monitoring cells with a Watch Window -- Working with Rows and Columns -- Inserting rows and columns -- Deleting rows and columns -- Changing column widths and row heights -- Changing column widths -- Changing row heights -- Hiding rows and columns -- Chapter 4: Working with Excel Ranges and Tables -- Understanding Cells and Ranges -- Selecting ranges -- Selecting complete rows and columns -- Selecting noncontiguous ranges -- Selecting multisheet ranges -- Selecting special types of cells. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Selecting cells by searching -- Copying or Moving Ranges -- Copying by using Ribbon commands -- Copying by using shortcut menu commands -- Copying by using shortcut keys -- Copying or moving by using drag-and-drop -- Copying to adjacent cells -- Copying a range to other sheets -- Using the Office Clipboard to paste -- Pasting in special ways -- Using the Paste Special dialog box -- Performing mathematical operations without formulas -- Skipping blanks when pasting -- Transposing a range -- Using Names to Work with Ranges -- Creating range names in your workbooks -- Using the Name box -- Using the New Name dialog box -- Using the Create Names from Selection dialog box -- Managing names -- Adding Comments to Cells -- Formatting comments -- Changing a comment's shape -- Reading comments -- Hiding and showing comments -- Editing comments -- Deleting comments -- Working with Tables -- Understanding a table's structure -- The header row -- The data body -- The total row -- The resizing handle -- Creating a table -- Adding data to a table -- Sorting and filtering table data -- Sorting a table -- Filtering a table -- Filtering a table with slicers -- Changing the table's appearance -- Chapter 5: Formatting Worksheets -- Getting to Know the Formatting Tools -- Using the formatting tools on the Home tab -- Using the Mini toolbar -- Using the Format Cells dialog box -- Formatting Your Worksheet -- Using fonts to format your worksheet -- Changing text alignment -- Choosing horizontal alignment options -- Choosing vertical alignment options -- Wrapping or shrinking text to fit the cell -- Merging worksheet cells to create additional text space -- Displaying text at an angle -- Using colors and shading -- Adding borders and lines -- Using Conditional Formatting -- Specifying conditional formatting -- Using graphical conditional formats -- Using data bars. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Using color scales -- Using icon sets -- Creating formula-based rules -- Understanding relative and absolute references -- Conditional formatting formula examples -- Identifying weekend days -- Highlighting a row based on a value -- Displaying alternate-row shading -- Creating checkerboard shading -- Shading groups of rows -- Working with conditional formats -- Managing rules -- Copying cells that contain conditional formatting -- Deleting conditional formatting -- Locating cells that contain conditional formatting -- Using Named Styles for Easier Formatting -- Applying styles -- Modifying an existing style -- Creating new styles -- Merging styles from other workbooks -- Controlling styles with templates -- Understanding Document Themes -- Applying a theme -- Customizing a theme -- Chapter 6: Understanding Excel Files and Templates -- Creating a New Workbook -- Opening an Existing Workbook -- Filtering filenames -- Choosing your file display preferences -- Saving a Workbook -- Using AutoRecover -- Recovering versions of the current workbook -- Recovering unsaved work -- Configuring AutoRecover -- Password-Protecting a Workbook -- Organizing Your Files -- Other Workbook Info Options -- Protect Workbook options -- Check for Issues options -- Manage Workbook options -- Browser View options -- Compatibility Mode section -- Closing Workbooks -- Safeguarding Your Work -- Working with Templates -- Exploring Excel templates -- Viewing templates -- Creating a workbook from a template -- Modifying a template -- Using default templates -- Using the workbook template to change workbook defaults -- Creating a worksheet template -- Editing your template -- Resetting the default workbook -- Using custom workbook templates -- Creating custom templates -- Saving your custom templates -- Using custom templates -- Chapter 7: Printing Your Work -- Doing Basic Printing. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Changing Your Page View -- Normal view -- Page Layout view -- Page Break Preview -- Adjusting Common Page Setup Settings -- Choosing your printer -- Specifying what you want to print -- Changing page orientation -- Specifying paper size -- Printing multiple copies of a report -- Adjusting the page margins -- Understanding page breaks -- Inserting a page break -- Removing manual page breaks -- Printing row and column titles -- Scaling printed output -- Printing cell gridlines -- Printing row and column headers -- Using a background image -- Adding a Header or a Footer to Your Reports -- Selecting a predefined header or footer -- Understanding header and footer element codes -- Exploring other header and footer options -- Exploring Other Print-Related Topics -- Copying Page Setup settings across sheets -- Preventing certain cells from being printed -- Preventing objects from being printed -- Creating custom views of your worksheet -- Creating PDF files -- Chapter 8: Customizing the Excel User Interface -- Customizing the Quick Access Toolbar -- About the Quick Access toolbar -- Adding new commands to the Quick Access toolbar -- Other Quick Access toolbar actions -- Customizing the Ribbon -- Why you may want to customize the Ribbon -- What can be customized -- How to customize the Ribbon -- Creating a new tab -- Creating a new group -- Adding commands to a new group -- Resetting the Ribbon -- Part II: Working with Formulas and Functions -- Chapter 9: Introducing Formulas and Functions -- Understanding Formula Basics -- Using operators in formulas -- Understanding operator precedence in formulas -- Using functions in your formulas -- Examples of formulas that use functions -- Function arguments -- More about functions -- Entering Formulas into Your Worksheets -- Entering formulas manually -- Entering formulas by pointing. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Pasting range names into formulas. |
| 588 ## - SOURCE OF DESCRIPTION NOTE | |
| Source of description note | Description based on publisher supplied metadata and other sources. |
| 590 ## - LOCAL NOTE (RLIN) | |
| Local note | Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Electronic spreadsheets. |
| 655 #4 - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books. |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Kusleika, Richard. |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Walkenbach, John. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Print version: |
| Main entry heading | Alexander, Michael |
| Title | Excel 2019 Bible |
| Place, publisher, and date of publication | Newark : John Wiley & Sons, Incorporated,c2018 |
| International Standard Book Number | 9781119514787 |
| 797 2# - LOCAL ADDED ENTRY--CORPORATE NAME (RLIN) | |
| Corporate name or jurisdiction name as entry element | ProQuest (Firm) |
| 830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE | |
| Uniform title | Bible Series |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=5521163">https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=5521163</a> |
| Public note | Click to View |
No items available.