Midlands State University Library

Microsoft Excel 2019 : (Record no. 162842)

MARC details
000 -LEADER
fixed length control field 04284nam a22003017a 4500
003 - CONTROL NUMBER IDENTIFIER
control field ZW-GwMSU
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20230724113747.0
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 230630b |||||||| |||| 00| 0 eng d
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9781509307692
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 1509307699
040 ## - CATALOGING SOURCE
Original cataloging agency rda
Language of cataloging English
Transcribing agency MSULIB
Description conventions rda
050 00 - LIBRARY OF CONGRESS CALL NUMBER
Classification number HF5548.4.M523 JEL
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Jelen, Bill,
Relator term author.
245 10 - TITLE STATEMENT
Title Microsoft Excel 2019 :
Remainder of title inside out /
Statement of responsibility, etc created by Bill Jelen.
246 30 - VARYING FORM OF TITLE
Title proper/short title Microsoft Excel 2019
264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE
Name of producer, publisher, distributor, manufacturer Pearson Education, Inc.,
Date of production, publication, distribution, manufacture, or copyright notice 2019.
300 ## - PHYSICAL DESCRIPTION
Extent xxxi, 829 pages :
Other physical details illustrations ;
Dimensions 24 cm
336 ## - CONTENT TYPE
content type term text
Source rdacontent
336 ## - CONTENT TYPE
content type term still image
Source rdacontent
337 ## - MEDIA TYPE
media type term unmediated
media type code n
source rdamedia
338 ## - CARRIER TYPE
carrier type term volume
carrier type code nc
source rdacarrier
504 ## - BIBLIOGRAPHY, ETC. NOTE
Bibliography, etc Includes index.
505 ## - FORMATTED CONTENTS NOTE
Formatted contents note Intro<br/>Title Page<br/>Copyright Page<br/>Dedication Page<br/>Contents at a Glance<br/>Table of Contents<br/>About the Author<br/>Introduction<br/>Who This Book Is For<br/>How This Book Is Organized<br/>About the Companion Content<br/>Acknowledgments<br/>Support and Feedback<br/>Part I The Excel Interface<br/>Chapter 1 What's New in Excel 2019<br/>Office 365 Is the Future<br/>Forward-Looking Features in Excel 2019<br/>Power Query Is Still the Best New Feature in Excel 2019<br/>Co-Authoring Allows Multiple People to Edit the Same Workbook at the Same Time<br/>Improvements to PivotTables New Calculation Functions in Excel 2019<br/>Two New Charts in 2019<br/>Inserting Icons and 3D Models<br/>Using the Inking Tools in Excel 2019<br/>Suggesting Ideas to the Excel Team<br/>Accessibility Improvements Across Office<br/>Changes to the Ribbon and Home Screen<br/>Collecting Survey Data in Excel Using Office 365<br/>Future Features Coming to Office 365<br/>Dynamic Array Functions in Office 365<br/>Chapter 2 Using the Excel Interface<br/>Using the Ribbon<br/>Using the Quick Access Toolbar<br/>Using the Full-Screen File Menu<br/>Using the New Sheet Icon to Add Worksheets Navigating Through Many Worksheets Using the Controls in the Lower Left<br/>Using the Mini Toolbar to Format Selected Text<br/>Expanding the Formula Bar<br/>Zooming In and Out on a Worksheet<br/>Using the Status Bar to Add Numbers<br/>Switching Between Normal View, Page Break Preview, and Page Layout View Modes<br/>Chapter 3 Customizing Excel<br/>Performing a Simple Ribbon Modification<br/>Adding a New Ribbon Tab<br/>Sharing Customizations with Others<br/>Questions About Ribbon Customization<br/>Using the Excel Options Dialog Box<br/>Options to Consider<br/>Five Excel Oddities<br/>Chapter 4 Keyboard Shortcuts Using Keyboard Accelerators<br/>Using the Shortcut Keys<br/>Using My Favorite Shortcut Keys<br/>Using Excel 2003 Keyboard Accelerators<br/>Part II Calculating with Excel<br/>Chapter 5 Understanding Formulas<br/>Getting the Most from This Chapter<br/>Introduction to Formulas<br/>Entering Your First Formula<br/>Three Methods of Entering Formulas<br/>Entering the Same Formula in Many Cells<br/>Use the Table Tool to Copy a Formula<br/>Chapter 6 Controlling Formulas<br/>Formula Operators<br/>Understanding Error Messages in Formulas<br/>Using Formulas to Join Text<br/>Copying Versus Cutting a Formula Automatically Formatting Formula Cells<br/>Using Date Math<br/>Troubleshooting Formulas<br/>Chapter 7 Understanding Functions<br/>Working with Functions<br/>Getting Help with Excel Functions<br/>Using AutoSum<br/>Chapter 8 Using Everyday Functions: Math, Date and Time, and Text Functions<br/>Math Functions<br/>Date and Time Functions<br/>Text Functions<br/>Examples of Math Functions<br/>Examples of Date and Time Functions<br/>Examples of Text Functions<br/>Chapter 9 Using Powerful Functions: Logical, Lookup, and Database Functions<br/>Examples of Logical Functions<br/>Examples of Information Functions<br/>
520 ## - SUMMARY, ETC.
Summary, etc 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
630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE
Uniform title Microsoft Excel (Computer file)
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element Electronic spreadsheets
General subdivision Computer programs.
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Source of classification or shelving scheme Library of Congress Classification
Koha item type Book
Holdings
Withdrawn status Lost status Source of classification or shelving scheme Damaged status Not for loan Home library Current library Shelving location Date acquired Source of acquisition Total Checkouts Full call number Barcode Date last seen Copy number Cost, replacement price Price effective from Koha item type
    Library of Congress Classification     Main Library Main Library Open Shelf 03/07/2023 Book Aid International   HF5548.4.M523 JEL BK148001 24/07/2023 160112 50.00 24/07/2023 Book