| 000 -LEADER |
|---|
| fixed length control field |
11573cam a2200361 a 4500 |
| 001 - CONTROL NUMBER |
|---|
| control field |
76073945 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
APU |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20160312051503.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
061102s2007 inua 001 0 eng |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER |
|---|
| LC control number |
2006036635 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
078973611X (pbk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9780789736116 (pbk.) |
| 035 ## - SYSTEM CONTROL NUMBER |
|---|
| System control number |
(OCoLC)76073945 |
| Canceled/invalid control number |
(OCoLC)72149914 |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
DLC |
| Transcribing agency |
APU |
| Modifying agency |
ANA |
| Language of cataloging |
eng |
| 050 00 - LIBRARY OF CONGRESS CALL NUMBER |
|---|
| Classification number |
HF5548.4.M523 |
| Item number |
J45 2007 |
| 082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER |
|---|
| Classification number |
005.54 |
| Item number |
JEL 2007 |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Jelen, Bill. |
| 9 (RLIN) |
739 |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
Special edition using Microsoft Excel 2007 / |
| Statement of responsibility, etc |
Bill Jelen. |
| 246 30 - VARYING FORM OF TITLE |
|---|
| Title proper/short title |
Using Microsoft Excel 2007. |
| 246 30 - VARYING FORM OF TITLE |
|---|
| Title proper/short title |
Microsoft Excel 2007. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) |
|---|
| Place of publication, distribution, etc |
Indianapolis, Ind. : |
| Name of publisher, distributor, etc |
Que Pub., |
| Date of publication, distribution, etc |
c2007. |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xxiii, 1048 p. : |
| Other physical details |
ill. ; |
| Dimensions |
24 cm. |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Includes index. |
| 505 2# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
Introduction -- Jaw-dropping new Excel features -- Where are my menus and toolbars? -- Introducing the ribbon -- Where is the classic mode? -- Conventions used in this book -- I. Mastering the new user interface -- 1. Introducing the ribbon user interface -- The Excel 2007 interface -- Using the Office icon menu -- Understanding the ribbon user interface -- Finding old menu items in the new interface -- 2. The Quick Access toolbar -- Changing the location of the Quick Access toolbar -- Adding your favorite commands to the Quick Access toolbar -- Customizing the Quick Access toolbar -- 3. The mini toolbar and other U.I. improvements -- Using the mini toolbar to format selected text -- Expanding the formula bar -- Zooming in and out on a worksheet -- Using the status bar to add numbers -- Switching between normal view, page break preview, and page layout view modes -- Using the new sheet icon to add worksheets -- 4. Keyboard shortcuts -- Using the new keyboard accelerators -- Using the shortcut keys -- Using Excel 2003 keyboard accelerators -- 5. Galleries, Live Preview, and themes -- Using galleries -- Using Live Preview -- Understanding themes -- 6. The Excel options dialog -- Introducing the Excel options dialog -- Toggling the new Excel 2007 features -- Controlling the look and feel of the worksheet window -- Guide to Excel options -- |
| 505 2# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
II. A tour of what's new -- 7. The big grid -- Excel 2007 grid limits -- Other limits in Excel 2007 -- Working with Excel 2003 named ranges in Excel 2007 -- Tips for navigating the big grid -- 8. Fabulous table intelligence -- Defining suitable data for Excel tables -- Keeping headers in view -- Adding a total row to a table -- Toggling totals -- Expanding a table -- Adding new formulas to tables -- Selecting only the data in the column -- Using table data for charts to ensure stickiness -- Replacing named ranges with table references -- Creating banded rows and columns with table styles -- Dealing with the AutoFilter drop-downs -- 9. Visualizing data in Excel -- Creating in-cell bar charts with data bars -- Creating heat maps with color scales -- Using stop if true to improve all conditional formatting -- Using the top/bottom rules -- Using the highlight cells rules -- Tweaking rules with advance formatting -- Combining rules -- Clearing conditional formats -- Extending the reach of conditional formats -- Special considerations for tables -- Special considerations for pivot tables -- 10. Using pivot tables to analyze data -- What is possible with pivot tables -- Preparing your data for pivot table analysis -- Creating our first pivot table -- Changing the default layout of a pivot table -- Adding new fields to a pivot table -- Eliminating blank cells from a pivot table -- Using pivot table legacy mode -- Pivot table limitations -- 11. Formatting pivot tables -- The new compact view -- Report layout options -- Special considerations when adding data fields to the value section -- Formatting a pivot table -- 12. Pivot table data crunching for Excel 2007 -- Grouping daily dates to months and years -- Sorting and filtering -- Exploring even more filtering options -- Adding new items along a dimension -- Showing percentages instead of values -- Exploring interesting uses for pivot tables -- Finding more information on pivot tables -- 13. Removing duplicates and filtering -- Using remove duplicates to find unique values -- Filtering records -- Using the advanced filter command -- 14. Sorting data -- Introducing the new sort dialog -- Using specialized sorting -- One-click sorting -- Sorting randomly -- 15. Using Excel charts -- Understanding the components of a chart -- Setting up your data for charting -- Inserting a chart by choosing a chart type -- Choosing a chart layout to further customize the chart type -- Customizing a chart by using a chart style or theme -- Charting tricks and techniques -- Using pivot charts -- 16. Using SmartArt, shapes, WordArt, and text boxes -- Using SmartArt -- Using shapes to display cell contents -- Using WordArt for interesting titles and headlines -- Using text boxes to flow long text passages -- 17. Using pictures and Clip Art -- Using pictures on worksheets -- Using Clip Art -- |
| 505 2# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
III. Working in a legacy environment -- 18. File format differences -- A brief history of file formats -- Using the new binary file format : BIFF12 -- Using the new XML file formats : XLSX and XLSM -- The future of file formats -- 19. Working with prior versions of Excel -- Opening Excel 2007 files in previous versions of Excel -- Creating Excel 2007 file formats in Excel 2003 -- Opening Excel 2003 files in Excel 2007 -- Preparing to save Excel 2007 files for Excel 97 through Excel 2003 -- The digital divide -- |
| 505 2# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
IV. Calculating with Excel -- 20. Understanding formulas -- Getting the most from this chapter -- Introduction to formulas -- Entering your first formula -- Three methods of entering formulas -- Entering the same formula in many cells -- Copying a formula by using the table tool -- 21. Controlling formulas -- Formula operators -- Understanding error messages in formulas -- Using formulas to join text -- Copying versus cutting a formula -- Automatically formatting formula cells -- Using date math -- Troubleshooting formulas -- 22. Understanding functions -- Working with functions -- Getting help with Excel functions -- Using AutoSum -- Using the new general-purpose functions in Excel 2007 -- Using the new CUBE functions in Excel 2007 -- Using the former ATP functions -- The function reference chapters -- 23. Using everyday functions : math, date and time, and text functions -- Examples of math functions -- Dates and times in Excel -- Examples of date and time functions -- Examples of text functions -- 24. Using powerful functions : logical, lookup, and database functions -- Examples of logical functions -- Examples of information functions -- Examples of lookup and reference functions -- Examples of database functions -- 25. Using financial functions -- Examples of common household loan and investment functions -- Examples of functions for financial professionals -- Examples of depreciation functions -- Functions for investment analysis -- Examples of functions for bond investors -- Examples of miscellaneous financial functions -- 26. Using statistical functions -- Examples of functions for descriptive statistics -- Examples of functions for regression and forecasting -- Examples of functions for inferential statistics -- Using the Analysis Toolpak to perform statistical analysis -- 27. Using Trig, matrix, and engineering functions -- A brief review of trigonometry basics -- Examples of logarithm functions -- Working with imaginary numbers -- Solving simultaneous linear equations with matrix functions -- Examples of engineering functions -- Using the Analysis Toolpack to perform fast Fourier Transforms (FFTs) -- 28. Connecting worksheets, workbooks, and external data -- Connecting two worksheets -- Connecting to a worksheet in another workbook -- Connecting to data on a Web page -- Setting up a connection to a text file -- Setting up a connection to an Access database -- Setting up SQL server, XML, OLE DB, and ODBC connections -- Managing connections -- 29. Using super formulas in Excel -- Using 3D formulas to spear through many worksheets -- Combining multiple formulas into one formula -- Calculating a cell reference in the formula by using the INDIRECT function -- Assigning a formula to a name -- Replacing multiple formulas with one array formula -- 30. Using names in Excel -- Defining a name for a cell by using the name box -- Naming a cell by using the new name dialog -- Using the name box for quick navigation -- Using scope to allow duplicate names in a workbook -- Using named ranges to simplify formulas -- Managing names -- Using a name to hold a value -- Assigning a formula to a name -- 31. Using What if , Scenario Manager, Goal Seek, and Solver -- Using What-if -- Using Scenario Manager -- Using Goal Seek -- Using Solver -- |
| 505 2# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
V. Formatting and sharing information -- 32. Formatting worksheets -- Why format worksheets? -- Using traditional formatting -- Formatting with styles -- Other formatting techniques -- Copying formats -- 33. Printing -- Using page layout view -- Using the improved headers and footers -- Using the page setup and sheet options -- Working with page breaks -- Printing -- 34. Sharing workbooks with others -- Sending a workbook via email -- Creating a PDF from a worksheet -- Publishing a worksheet to a Webpage -- Publishing to a server -- 35. More tips and tricks for Excel 2007-- Speeding up calculation by using multithreaded calculation -- Watching the results of a far-off cell -- Looking for hidden data in a workbook -- Marking a document as final to prevent changes -- Opening the same files everyday -- Downloading cool spreadsheets from Office online -- Adding visual interest by using a background picture -- Comparing documents side-by-side with synchronous scrolling -- Calculating a formula in slow motion -- Inserting a symbol in a cell -- Adding a digital signature line to a workbook -- Protecting a worksheet -- Sharing a workbook -- Separating text based on a delimiter -- Adding automatic subtotals -- Translating text -- |
| 505 2# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
VI. More power -- 36. Automating repetitive functions using VBA macros -- Checking security settings before using macros -- Recording a macro -- Case study : macro for formatting for a mail merge -- Everyday-use macro example : formatting an invoice register -- Understanding VBA code, an analogy -- Using simple variables and object variables -- Using R1C1-style formulas -- Customizing the everyday-use macro example : GetOpenFileName and GetSaveAsFileName -- From-scratch macro example : loops, flow control, and referring to ranges -- Combination macro example : creating a report for each customer -- Conclusion -- 37. Interacting with other Office applications -- Pasting Excel data to Microsoft OneNote -- Pasting Excel data to PowerPoint -- Creating tables in Excel and pasting to Word -- Pasting Word data to an Excel text box -- Using Excel data in a Word mail merge -- Building a pivot table from Access queries -- 38. A tour of the best add-ins for Excel -- Customizing the ribbon by using CustomizeRibbon -- Loading PDF data to Excel by using Able2Extract -- Doing Access with Excel by using DigDB -- Creating dashboards by using Speedometer Chart Creator -- Accessing more functions by using MoreFunc.dll -- Using add-ins from AddIns.com -- Index. |
| 630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE |
|---|
| Uniform title |
Microsoft Excel (Computer file) |
| 9 (RLIN) |
417 |
| 856 41 - ELECTRONIC LOCATION AND ACCESS |
|---|
| Public note |
Connect to the Table of contents only |
| Uniform Resource Identifier |
http://www.loc.gov/catdir/toc/ecip074/2006036635.html |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
|
| Koha item type |
Book |
| Koha issues (borrowed), all copies |
3 |
