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 |
|