000 03010nam a2200361Ia 4500
005 20260803094119.0
008 251212s2010 xx 000 0 und d
245 1 _aExael 2010 bible /
_cJhon Walkenbach.
100 _aWalkenbach, Jhon
260 _aIndianapolis, India :
_bwiley Pub.,
_c2010.
300 _axliv. 1006.;:
300 _a24cm
300 _d1 CD ROM(4 3/4)
500 _aIncludes index
020 _a978-0-470-47487-7
650 _aBusiness
_xComputer programs
650 _aElectronic spreadsheets
650 _aMicrosoft Excel (Computer file)
050 _a005.54 W15e
943 _b0
_c0
_d0
_e1
_f0
_g2
_h0
_i0
_j0
944 _b1
_c1
_d0
953 _pHED1932
546 _aEnglish
953 _cColLIb
505 _a1: Getting started with Excel. Introducing Excel -- Entering and editing worksheet data -- Essential worksheet operations -- Working with cells and ranges -- Introducing tables -- Worksheet formating -- Understanding Excel files -- Using and creating templates -- Printing your work -- pt. 2: Working with formulas and functions. Introducing formulas and functions -- Creating formulas that manipulate text -- Working with dates and times -- Creating formulas that count and sum -- Creating formulas that look up values -- Creating formulas for financial applications -- Introducing array formulas -- Performing magic with array formulas -- pt. 3: Creating charts and graphics. Getting started making charts -- Learning advanced charting -- Visualizing data using conditional formatting -- Creating sparkline graphics -- Enhancing your work with pictures and drawings -- pt. 4: Using advanced Excel features. Customizing the Excel user interface -- Using custom number formats -- Using data validation -- Creating and using worksheet outlines -- Linking and consolidating worksheets -- Excel and the internet -- Sharing data with other office applications -- Using Excel in a workgroup -- Protecting your work -- Making your worksheets error-free -- pt. 5: Analyzing data with Excel. Getting data from external database files -- Introducing pivot tables -- Analyzing data with pivot tables -- Performing spreadsheet what-if analysis -- Analyzing data using goal seeking and solver -- Analyzing data with the analysis toolpak -- pt. 6: Programming Excel with VBA. Introducing Visual Basic for Applications -- Creating custom worksheet functions -- Creating userforms -- Using userform controls in a worksheet -- Working with Excel events -- VBA examples -- Creating custom Excel add-ins
520 _aSurveys the tools, features, and capabilities of Excel 2010, explaining the user interface and covering such topics as spreadsheet design, creating charts and diagrams, developing formulas, analyzing data, PivotTables, XML and data reporting, Internet applications, and VBA.
591 _a0
336 _aText
337 _aUnmediated
338 _aVolume
942 _2lcc
_cBK
_arizal
_b2015-04-07 23:18:29
_drizal
_e2015-04-07 23:18:29
998 _a5989
999 _c5968
_d5968