MARC details
| 000 -LEADER |
|---|
| fixed length control field |
03742cam a2200505 i 4500 |
| 001 - CONTROL NUMBER |
|---|
| control field |
20734004 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
OSt |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20241219100203.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
181106t20192019nyua 001 0 eng d |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER |
|---|
| LC control number |
2018963483 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9781509306114 |
| Qualifying information |
(paperback) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
1509306110 |
| Qualifying information |
(paperback) |
| 035 ## - SYSTEM CONTROL NUMBER |
|---|
| System control number |
(OCoLC)on1042882896 |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
YDX |
| Language of cataloging |
eng |
| Transcribing agency |
AMIU |
| Description conventions |
rda |
| Modifying agency |
OCLCQ |
| -- |
UOK |
| -- |
OCLCF |
| -- |
CLE |
| -- |
NYP |
| -- |
BKL |
| -- |
VP@ |
| -- |
IBI |
| -- |
BYV |
| -- |
IMT |
| -- |
DLC |
| 042 ## - AUTHENTICATION CODE |
|---|
| Authentication code |
lccopycat |
| 050 00 - LIBRARY OF CONGRESS CALL NUMBER |
|---|
| Classification number |
HF5548.4 |
| Item number |
.M52J45 2019 |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Jelen, Bill, |
| Relator term |
author. |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
Microsoft Excel 2019 VBA and macros / |
| Statement of responsibility, etc. |
Bill Jelen, Tracy Syrstad. |
| 246 30 - VARYING FORM OF TITLE |
|---|
| Title proper/short title |
VBA and macros |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
|---|
| Place of production, publication, distribution, manufacture |
[New York] : |
| Name of producer, publisher, distributor, manufacturer |
Published with the authorization of Microsoft Corporation by Pearson Education, Inc., |
| Date of production, publication, distribution, manufacture, or copyright notice |
[2019] |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
|---|
| Date of production, publication, distribution, manufacture, or copyright notice |
©2019 |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xxxvi, 585 pages : |
| Other physical details |
illustrations ; |
| Dimensions |
24 cm |
| 336 ## - CONTENT TYPE |
|---|
| Content type term |
text |
| Content type code |
txt |
| 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 |
| 500 ## - GENERAL NOTE |
|---|
| General note |
"Microsoft Press"--Back cover. |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Includes index. |
| 505 0# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
Unleashing the power of Excel with VBA -- This sounds like BASIC, so why doesn't it look familiar? -- Referring to ranges -- Looping and flow control -- R1C1-style formulas -- Creating and manipulating names in VBA -- Event programming -- Arrays -- Creating classes and collections -- Userforms : an introduction -- Data mining with Advanced Filter -- Using VBA to create pivot tables -- Excel power -- Sample user-defined functions -- Creating charts -- Data visualizations and conditional formatting -- Dashboarding with sparklines in Excel 2019 -- Reading from and writing to the web -- Text file processing -- Automating Word -- Using Access as a back end to enhance multiuser access to data -- Advanced userform techniques -- The Windows Application Programming Interface (API) -- Handling errors -- Customizing the ribbon to run macros -- Creating add-ins -- An introduction to creating Office add-ins -- What's new in Excel 2019 and what's changed. |
| 520 ## - SUMMARY, ETC. |
|---|
| Summary, etc. |
"Renowned Excel experts Bill Jelen (Mr Excel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions."--Amazon.com. |
| 583 ## - ACTION NOTE |
|---|
| Action |
Cataloging Notes: |
| Time/date of action |
20241219 |
| Action agent |
STAMIU-0199STAMIU-0199 |
| 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 or standard number |
(OCoLC)fst01366659 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Visual Basic for Applications (Computer program language) |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Business |
| General subdivision |
Computer programs. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Electronic spreadsheets. |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Business |
| General subdivision |
Computer programs. |
| Source of heading or term |
fast |
| Authority record control number or standard number |
(OCoLC)fst00842283 |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Electronic spreadsheets. |
| Source of heading or term |
fast |
| Authority record control number or standard number |
(OCoLC)fst00907463 |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Visual Basic for Applications (Computer program language) |
| Source of heading or term |
fast |
| Authority record control number or standard number |
(OCoLC)fst01910316 |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Computer software. |
| Source of heading or term |
sears |
| 700 1# - ADDED ENTRY--PERSONAL NAME |
|---|
| Personal name |
Syrstad, Tracy, |
| Relator term |
author. |
| 906 ## - LOCAL DATA ELEMENT F, LDF (RLIN) |
|---|
| a |
7 |
| b |
cbc |
| c |
copycat |
| d |
2 |
| e |
ncip |
| f |
20 |
| g |
y-gencatlg |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
Library of Congress Classification |
| Koha item type |
Book |
| Suppress in OPAC |
No |