# Welcome to the Kids' Library!

Search for books, movies, music, magazines, and more.

Available items only
 Author Girvin, Mike.

# Title Slaying Excel dragons : a beginners guide to conquering Excel's frustrations and making Excel fun / Mike "excelisfun" Girvin.

 Imprint Uniontown, OH : Holy Macro! Books, c2011.

## Copies

Location Call No. OPAC Message Status
Axe 3rd Floor Stacks  005.54 M583g 2011    ---  Available
 Description xxvi, 550 p. : ill. ; 24 cm. Note Includes index. Summary Provides information on efficiently creating Excel reports, covering such topics as keyboard shortcuts, style formation, formulas and functions, data analysis, charts, and conditional formatting. Contents A Note from the author about stepped procedures -- A Note from the publisher about figures in the print edition -- 1 How Excel is set up -- 2 Keyboard shortcuts -- Control key shortcuts(and a few others) -- 3 Data in Excel -- Raw data versus information -- SUMIFS function -- Verifying formula results (and tracking down bad data) -- PivotTables -- Table format structure -- Sorting -- Excel table feature (Excel as a database) -- Number formatting as a facade -- Data alignment (types of data Excel recognizes) -- 4 Style formatting and page setup -- Applying style formatting -- Understanding page setup -- Built-in styles -- 5 Formulas and functions -- Formulas defined -- Order of operations -- Putting cell references in a formula -- Cell references -- Entering formulas into cells -- Efficient formulas that use ranges -- Built-in functions -- Average without zeros using the AVERAGEIF function -- PMT function for loan payment amount -- Defined names feature -- MAX for finding the largest value -- Defined names manager -- Create names from selection -- MIN for finding the smallest value -- COUNTA for counting the total number of words -- SUMIFS for adding with two criteria -- COUNTIFS for counting with two criteria -- COUNTIF function to create a small report -- AVERAGEIFS for averaging with two criteria -- Logical tests (and/or) -- SUMPRODUCT (to multiply and then add in succession) -- Multiple criteria counting and summing for Excel versions before 2007 -- IF function (for putting one of two items in a cell or formula) -- Lookup functions -- ROUND function -- Averaging with AVERAGE, MEDIAN, and MODE functions -- New Excel 2010 functions (RANK.EQ and RANK.AVE) -- Goal seek -- Array formulas -- Errors 6 Data analysis features -- Sort feature -- Subtotal feature -- PivotTable feature -- Filter feature -- Advanced filter feature -- Text to columns feature -- Importing data -- 7 Charts -- Categories and series -- Chart types -- Creating and formatting charts -- 8 Conditional formatting -- Built-in conditional formatting -- Logical formulas -- 9 Find and replace and go to features -- Appendix: Excel efficiency-robust rules -- Index. Subject Microsoft Excel (Computer file) -- Handbooks, manuals, etc. Microsoft Excel (Computer software) Business -- Computer software. Spreadsheet software. ISBN 9781615470006 (pbk.) 161547000X (pbk.) Standard No. AU@ 000047087356

Available items only