logo

Online Public Access Catalogue

Beginning Microsoft Excel 2010 / (Record no. 22918)

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
Koha item type Books
Holdings
Withdrawn status Lost status Source of classification or shelving scheme Damaged status Not for loan Permanent Location Current Location Shelving location Date acquired Source of acquisition Cost, normal purchase price Bill Date Full call number Accession Number Price effective from Koha item type
          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