000 -LEADER |
fixed length control field |
05007cam a2200517 i 4500 |
001 - CONTROL NUMBER |
control field |
20622704 |
003 - CONTROL NUMBER IDENTIFIER |
control field |
CITU |
005 - DATE AND TIME OF LATEST TRANSACTION |
control field |
20230211085908.0 |
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
fixed length control field |
180809t20192019inua 001 0 eng d |
010 ## - LIBRARY OF CONGRESS CONTROL NUMBER |
LC control number |
2018954472 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
International Standard Book Number |
9781119514787 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
International Standard Book Number |
9781119549376 |
035 ## - SYSTEM CONTROL NUMBER |
System control number |
(OCoLC)on1027189179 |
040 ## - CATALOGING SOURCE |
Original cataloging agency |
YDX |
Language of cataloging |
eng |
Transcribing agency |
YDX |
Description conventions |
rda |
Modifying agency |
BDX |
-- |
TOH |
-- |
SINLB |
-- |
JRZ |
-- |
CLE |
-- |
OCLCF |
-- |
VP@ |
-- |
JQM |
-- |
UAP |
-- |
ORK |
-- |
IGA |
-- |
JQW |
-- |
IBI |
-- |
DLC |
041 ## - LANGUAGE CODE |
Language code of text/sound track or separate title |
eng |
042 ## - AUTHENTICATION CODE |
Authentication code |
lccopycat |
050 00 - LIBRARY OF CONGRESS CALL NUMBER |
Classification number |
HF5548.4.M523 |
Item number |
A4646 2019 |
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER |
Classification number |
005.54 |
Edition number |
23 |
100 1# - MAIN ENTRY--PERSONAL NAME |
Preferred name for the person |
Alexander, Michael, |
Dates associated with a name |
1972- |
Relator term |
author. |
245 10 - TITLE STATEMENT |
Title |
Excel 2019 bible / |
Statement of responsibility, etc |
Michael Alexander, Dick Kusleika, previously by John Walkenbach. |
246 14 - VARYING FORM OF TITLE |
Title proper/short title |
Microsoft Excel 2019 bible |
264 #1 - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) |
Place of publication, distribution, etc |
Indianapolis, IN : |
Name of publisher, distributor, etc |
Wiley, |
Date of publication, distribution, etc |
[2019] |
264 #4 - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) |
Date of publication, distribution, etc |
©2019 |
300 ## - PHYSICAL DESCRIPTION |
Extent |
1 online resource (xlv, 1074 pages) : |
Other physical details |
illustrations |
336 ## - CONTENT TYPE |
Content type term |
text |
Content type code |
txt |
Source |
rdacontent |
336 ## - CONTENT TYPE |
Content type term |
still image |
Content type code |
sti |
Source |
rdacontent |
337 ## - MEDIA TYPE |
Media type term |
computer |
Media type code |
n |
Source |
rdamedia |
338 ## - CARRIER TYPE |
Carrier type term |
online resource |
Carrier type code |
nc |
Source |
rdacarrier |
500 ## - GENERAL NOTE |
General note |
"The comprehensive tutorial resource"--Cover. |
500 ## - GENERAL NOTE |
General note |
Includes index |
500 ## - GENERAL NOTE |
General note |
Michael Alexander is a Microsoft MVP and author of several books on advanced business analysis. He shares his wisdom from more than fifteen years consulting and developing reporting solutions for a variety of industries as the principle contributor at DataPigTechnologies.com, where he offers free video tutorials with the Microsoft Excel and Access communities. Dick Kusleika is a twelve-time Microsoft Excel MVP and principle contributor at the Daily Dose of Excel blog. John Walkenbach, principal of J-Walk and Associates, Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books including all previous editions of the Excel Bible. |
505 0# - CONTENTS |
Formatted contents note |
Getting started with Excel. Introducing Excel ; Entering an dediting worksheet data ; Performing basic worksheet operations ; Working with Excel ranges and tables ; Formatting worksheets ; Understanding Excel files and templates ; Printing your work ; Customizing the Excel user interface -- Working with formulas and functions. Introducing formulas and functions ; Using formulas for common mathematical operations ; Using formulas to manipulate text ; Using formulas with dates and times ; Using formulas for conditional analysis ; Using formulas for matching and lookups ; Using formulas for financial analysis ; Using formulas for statistical analysis ; Using formulas with tables and conditional formatting ; Understanding and using array formulas ; Making your formulas error-free -- Creating charts and other visualizations. Getting started with Excel charts ; Using advanced charting techniques ; Creating sparkline graphics ; Visualizing with custom number formats and shapes ; Implementing Excel dashboarding best practices -- Managing and analyzing data. Importing and cleaning data ; Using data validation ; Creating and using worksheet outlines ; Linking and consolidating worksheets ; Introducing PivotTables ; Analyzing data with PivotTables ; Performing spreadsheet what-if analysis -- Analyzing data using goal seeking and solver ; Analyzing data with the analysis toolpak ; Protecting your work -- Understanding power pivot and power query. Introducing power pivot ; Working directly with the internal data model ; Adding formulas to power pivot ; Introducing power query ; Transforming data with power query ; Making queries work together ; Enhancing power query productivity -- Automating Excel. Introducing visual basic for applications ; Creating custom worksheet functions ; Creating custom worksheet functions ; Creating userforms ; Using userform controls in a worksheet ; Working with Excel events ; Seeing some VBA examples ; Creating custom Excel add-ins. |
520 ## - SUMMARY, ETC. |
Summary, etc |
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. -- |
Assigning source |
Publisher's description. |
590 ## - LOCAL NOTE (RLIN) |
Local note |
Access is available to the CIT-U community. |
630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE |
Uniform title |
Microsoft Excel (Computer file) |
630 07 - SUBJECT ADDED ENTRY--UNIFORM TITLE |
Uniform title |
Microsoft Excel (Computer file) |
Source of heading or term |
fast |
Authority record control number |
(OCoLC)fst01366659 |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name as entry element |
Business |
General subdivision |
Computer programs. |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name as entry element |
Electronic spreadsheets. |
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name as entry element |
Business |
General subdivision |
Computer programs. |
Source of heading or term |
fast |
Authority record control number |
(OCoLC)fst00842283 |
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
Topical term or geographic name as entry element |
Electronic spreadsheets. |
Source of heading or term |
fast |
Authority record control number |
(OCoLC)fst00907463 |
655 ## - INDEX TERM--GENRE/FORM |
Genre/form data or focus term |
Electronic books |
700 1# - ADDED ENTRY--PERSONAL NAME |
Personal name |
Kusleika, Dick, |
Relator term |
author. |
700 1# - ADDED ENTRY--PERSONAL NAME |
Personal name |
Walkenbach, John, |
Relator term |
author. |
856 ## - ELECTRONIC LOCATION AND ACCESS |
Link text |
Full text available at Wiley Online Library Click here to view |
Uniform Resource Identifier |
https://onlinelibrary.wiley.com/doi/book/10.1002/9781119549376 |
942 ## - ADDED ENTRY ELEMENTS |
Source of classification or shelving scheme |
|
Item type |
EBOOK |