Beginning Microsoft Excel 2010 / (Record no. 22918)
[ view plain ]
000 -LEADER | |
---|---|
fixed length control field | 06265cam a2200241 a 4500 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
ISBN | 9781430229551 (pbk.) |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
ISBN | 1430229551 (pbk.) |
041 ## - LANGUAGE CODE | |
Language code of text/sound track or separate title | English |
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER | |
Classification number | 005.54 |
Item number | KAT |
100 1# - MAIN ENTRY--AUTHOR NAME | |
Author name | Katz, Abbott. |
245 10 - TITLE STATEMENT | |
Title | Beginning Microsoft Excel 2010 / |
Statement of responsibility, etc | Abbott Katz. |
246 30 - VARYING FORM OF TITLE | |
Title proper/short title | Microsoft Excel 2010 |
260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
Place of publication | [Berkeley, Calif.] : |
Name of publisher | Apress ; |
Place of publication | New York : |
Name of publisher | Distributed to the book trade worldwide by Springer Science+Business Media, |
Year of publication | c2010. |
300 ## - PHYSICAL DESCRIPTION | |
Number of Pages | xiv, 388 pages : |
Other physical details | illustrations ; |
Dimensions | 24 cm. |
500 ## - GENERAL NOTE | |
General note | Includes index. |
505 ## - FORMATTED CONTENTS NOTE | |
Formatted contents note | Contents at a glance<br/>Contents<br/>About the author<br/>About the technical reviewer<br/>Acknowledgments<br/>Introduction<br/>Chapter 1: Introduction To Excel<br/>Making the acquaintance<br/>Unlocking your inner worksheet<br/>Pep talk<br/>Interacting with the interface<br/>Tab talk<br/>Something new, something old<br/>Keeping tabs<br/>on a new one<br/>Cool QAT<br/>Understood in context<br/>Alt-ered consciousness<br/>Chapter 2: Getting Started And Getting Around The Worksheet<br/>More addresses than the phone book-cells, and how to get there<br/>Getting around<br/>Key points<br/>Ranges: a select tool<br/>Data entry: getting started<br/>Entering text: trespassing allowed<br/>Numbers are (a little) different<br/>Relocating the data: copying and moving<br/>Having your fill<br/>There'll be some changes made-editing cells<br/>Chapter 3: From Data Entry To Data Creation: Formula Basics And Beyond<br/>Cell references explained<br/>Ordering up your results<br/>Not just your average function<br/>Making range values COUNT<br/>MAX and MIN-recording highs and lows<br/>Absolute references: absolutely important<br/>More of the same<br/>You could look it up<br/>If: worth knowing-no ifs, ands, or buts<br/>In conclusion<br/>Chapter 4: Keeping Up Appearances-Formatting The Worksheet<br/>You've got designs on your worksheet<br/>Font button group: a closer look<br/>Borderline command<br/>Getting oriented<br/>Excel has got your number(s)<br/>Dates-the long and the short of it<br/>Time is on your side-yes it is<br/>New kind of copy-and paste<br/>Style setter<br/>Formatting-with conditions<br/>Just a bit more<br/>P S<br/>In conclusion<br/>Chapter 5: Stuff Of Legend-Charting In Excel<br/>Starting charting<br/>Making a chart of our own<br/>Changing the chart-it's your call<br/>Design tab-a closer look<br/>Change chart type<br/>Save as template<br/>Switch row/column<br/>Select data<br/>Chart layouts<br/>Chart styles<br/>Move chart<br/>Changing the chart default-and the 2-second chart<br/>Layout tab<br/>Working with chart labels<br/>Axes to grind<br/>Format tab-getting your objects in shape<br/>Sparklines: mini-charts with big impact<br/>You win some, you lose some<br/>In conclusion<br/>Chapter 6: Setting The Table: Database Features Of Excel 2010<br/>Sorting-sort of easy<br/>Using header rows<br/>Sorting by more than one field<br/>AutoFilter: picking and choosing your data<br/>Playing-or plying-the numbers<br/>Advanced filter-setting your data aside<br/>Table talk<br/>Creating a table<br/>Using table styles<br/>Adding a total row<br/>Examining the other table style options<br/>At the risk of repeating yourself: the remove duplicates option<br/>Data validation: improving your entree to data entry<br/>Using data validation<br/>Adding data entry rules<br/>Adding an input message<br/>Using the error alert option<br/>Adding a validation rule to existing data<br/>In conclusion<br/>Chapter 7: Working With Multiple Sheets<br/>Adding to sheets-inserting rows, columns and cells<br/>Inserting a column<br/>Inserting a row<br/>Deleting rows and columns<br/>Inserting and deleting cells<br/>Hiding rows and columns-and getting them back<br/>Multiple worksheet basics<br/>Inserting anew worksheet<br/>Busting a (sheet) move<br/>Hiding worksheets<br/>Grouping worksheets<br/>Far-flung formulas: working with multi-sheet cell references<br/>Doing a multi-sheet calculation<br/>Extending your reach: referring to cells in different workbooks<br/>Watch window-spying on your own data<br/>Protect your cells from unwanted intruders-even yourself<br/>Protecting a sheet<br/>Protecting a whole workbook<br/>Consolidating your data-getting it all together<br/>In conclusion<br/>Chapter 8: PivotTables And Pivot Charts<br/>Starting out with pivot-tables<br/>What's in a name?<br/>Constructing a pivot-table: let's go<br/>Inserting the table<br/>Setting up the pivot-table<br/>Updating the pivot-report<br/>Filters again-pivot-table style<br/>Your very own top 10 list<br/>Report filter-getting on top of the pivot-table<br/>Slicer-filter deluxe<br/>Grouping the data<br/>Formatting the pivot report-values and all<br/>Pivot charts<br/>In conclusion<br/>Chapter 9: Getting It On Paper-Printing In Excel 2010<br/>Hard copy? Pretty easy<br/>Print area option<br/>Margin-al utility<br/>Printing as you see fit<br/>Headers and footers-getting to the bottom (and the top) of your printout<br/>Title search<br/>There's more than one way to view a worksheet<br/>Gimme a (page) break-another view<br/>Customize your view, too<br/>In conclusion<br/>Chapter 10: Taking It To The Cloud: Sharing And Collaborating On The Internet<br/>Getting there<br/>Permission granted: sharing your workbooks<br/>Hey-you! Get onto my cloud!<br/>In conclusion<br/>Appendix A: Working with range names<br/>What's in a name? plenty, if it's a range<br/>Naming many ranges-at the same time<br/>Name manager-tracking your ranges<br/>In conclusion<br/>Appendix B: Keyboard shortcuts<br/>Control key combinations<br/>Other shortcut keys<br/>Appendix C: Error messages<br/>Nobody's perfect<br/>Index<br/> |
520 ## - SUMMARY, ETC. | |
Summary, etc | Beginning Microsoft Excel 2010 is a practical, step-by-step guide to getting started with the world's most widely used spreadsheet application. The book offers a hands-on approach to learning how to create and edit spreadsheets, use various calculation formulas, employ charts/graphs, and get work done efficiently. Microsoft is rolling out several new features with Excel 2010 - perhaps the most notable is the ability to use Excel 2010 online and this collaborate on a project in real time. Beginning Microsoft Office 2010 keeps you up-to-date with all of these new features and more. What you'll learn: What distinguishes 2010 from its immediate predecessor; What distinguishes 2010 from Excel 2003; Get started with data entry and formatting; How to get started with formula writing skills; Get started with database capabilities, including pivot tables; How to get started with charting |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
Subject | Business |
General subdivision | Computer programs. |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
Subject | Electronic spreadsheets. |
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
Subject | Business |
General subdivision | Computer software. |
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
Subject | Spreadsheet software. |
942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
Source of classification or shelving scheme | Dewey Decimal Classification |
Koha item type | Books |
Withdrawn status | Lost status | Source of classification or shelving scheme | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Source of acquisition | Cost, normal purchase price | Bill Date | Full call number | Accession Number | Price effective from | Koha item type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Dewey Decimal Classification | Institute of Public Enterprise, Library | Institute of Public Enterprise, Library | S Campus | 03/21/2024 | Atlantic Publishers | 2726.95 | 27-02-2024 | 005.54 KAT | 48396 | 03/21/2024 | Books |