LEADER 00000cam 2200493 i 4500
001 ocn910538599
003 OCoLC
005 20230908034136.0
008 150831t20162016inua 001 0 eng d
010 2015950785
020 9780789755858
020 0789755858
035 (OCoLC)910538599
040 BTCTA|beng|erda|cDLC|dBTCTA|dBDX|dYDXCP|dCDX|dCCPLG|dVP@
|dMLY|dOCLCF|dCLE|dIBI|dBEDGE|dOCLCQ|dFIE|dOCLCQ|dOCLCO
|dDHA|dDAD|dOCLCQ|dOCL|dUKMGB|dOCLCO
042 lccopycat
049 CKEA
050 00 HF5548.4.M523|bJ44767 2016
082 04 005.5/4|223
100 1 Jelen, Bill.
245 10 Excel 2016 :|bVBA and macros /|cBill Jelen, Tracy Syrstad.
246 3 Excel 2016 Visual Basic for Applications and macros
246 30 VBA and macros
264 1 Indianapolis, Indiana :|bQue,|c[2016]
264 4 |c©2016
300 xviii, 588 pages :|billustrations ;|c23 cm.
336 text|btxt|2rdacontent
337 unmediated|bn|2rdamedia
338 volume|bnc|2rdacarrier
490 1 MrExcel library
500 Includes index.
505 0 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 ables -- Excel power -
- Sample user-defined functions -- Creating charts -- Data
visualizations and conditional formatting -- Dashboarding
with Sparklines in Excel 2016 -- REading from and writing
to the web -- Text file processing -- Automating Word --
Using Access as a back end to enhance a 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 2016 and what's changed.
630 00 Visual Basic for Applications (Computer program language)
650 0 Visual Basic for Applications (Computer program language)
650 0 Macroprogramming.
650 0 Macro instructions (Electronic computers)
650 7 Macro instructions (Electronic computers)|2fast
|0(OCoLC)fst01005191
650 7 Macroprogramming.|2fast|0(OCoLC)fst01005280
650 7 Visual Basic for Applications (Computer program language)
|2fast|0(OCoLC)fst01910316
700 1 Syrstad, Tracy.
830 0 MrExcel library.
914 FARM253087
994 C0|bCKE
Farmington, Main Library - Adult Department
|
005.369 JEL |
DUE 12-11-24 |
|