Excel 2010 formulas /

A reference collection of formulas for spreadsheet challenges covers operators, nesting, functions, error values, naming, cell formatting, protection options, array formulas, pivot tables, and auditing.

Saved in:
Bibliographic Details
Main Author: Walkenbach, John
Format: Government Document Electronic eBook
Language:English
Published: Hoboken, NJ : Wiley Pub., ©2010.
Series:Mr. Spreadsheet's bookshelf.
Subjects:
Online Access:CONNECT

MARC

LEADER 00000nam a2200000 a 4500
001 in00006108770
006 m o d
007 cr cnu---unuuu
008 101109s2010 njua o 001 0 eng d
005 20240125144722.2
020 |a 9781118257630 
020 |a 9780470625514  |q (electronic bk.) 
020 |a 0470625511  |q (electronic bk.) 
020 |a 9780470625538  |q (electronic bk.) 
020 |a 0470625538  |q (electronic bk.) 
020 |a 1118257634  |q (electronic bk.) 
020 |a 9781621984283  |q (electronic bk.) 
020 |a 1621984281  |q (electronic bk.) 
020 |z 9780470475362 
020 |z 0470475366 
024 7 |a 10.1002/9781118257630  |2 doi 
035 |a (NhCcYBP)e80fa363d91f485b9a695405a0a7a4bb9781118257630 
035 |a 1wileyeba9781118257630 
037 |a 98595199-1CBB-4B20-8AB7-F2DF77C9C0B5  |b OverDrive, Inc.  |n http://www.overdrive.com 
040 |a NhCcYBP  |b eng  |c NhCcYBP 
050 4 |a HF5548.4.M523  |b W34489 2010eb 
082 0 4 |a 005.54  |2 22 
086 0 |a ACC1023 
100 1 |a Walkenbach, John. 
245 1 0 |a Excel 2010 formulas /  |c by John Walkenbach. 
246 1 4 |a Microsoft Excel 2010 formulas 
260 |a Hoboken, NJ :  |b Wiley Pub.,  |c ©2010. 
300 |a 1 online resource (xxiii, 788 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a Mr. Spreadsheet's bookshelf 
500 |a Wiley EBA  |5 TMurS 
520 |a A reference collection of formulas for spreadsheet challenges covers operators, nesting, functions, error values, naming, cell formatting, protection options, array formulas, pivot tables, and auditing. 
505 0 |a Excel in a nutshell -- Basic facts about formulas -- Working with names -- Introducing worksheet function -- Manipulating text -- Working with dates and times -- Counting and summing techniques -- Using lookup functions -- Tables and worksheet databases -- Miscellaneous calculations -- Borrowing and investing formulas -- Discounting and depreciation formulas -- Financial schedules -- Introducing arrays -- Performing magic with array formulas -- Intentional circular references -- Charting techniques -- Pivot tables -- Conditional formatting and data validation -- Creating megaformulas -- Tools and methods for debugging formulas -- Introducing VBA -- Function procedure basics -- VBA programming concepts -- VBA custom function examples. 
588 0 |a Print version record. 
630 0 0 |a Microsoft Excel (Computer file) 
650 0 |a Business  |x Computer programs. 
650 0 |a Electronic spreadsheets. 
730 0 |a WILEYEBA 
776 0 8 |i Print version:  |a Walkenbach, John.  |t Excel 2010 formulas.  |d Hoboken, NJ : Wiley Pub., ©2010  |z 9780470475362 
830 0 |a Mr. Spreadsheet's bookshelf. 
856 4 0 |u https://ezproxy.mtsu.edu/login?url=https://onlinelibrary.wiley.com/book/10.1002/9781118257630  |z CONNECT  |3 Wiley  |t 0 
949 |a ho0 
975 |p Wiley UBCM Online Book All Titles thru 2023 
976 |a 6006612 
998 |a wi  |d z 
999 f f |s c00a446c-fdbf-42e2-b8b9-f90df5ba75d0  |i c00a446c-fdbf-42e2-b8b9-f90df5ba75d0  |t 0 
952 f f |a Middle Tennessee State University  |b Main  |c James E. Walker Library  |d Electronic Resources  |t 0  |e HF5548.4.M523 W34489 2010eb  |h Library of Congress classification