Kids Library Home

Welcome to the Kids' Library!

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

Available items only
Print Material
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.


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