000			06265cam a2200241 a 4500
020			_a9781430229551 (pbk.)
020			_a1430229551 (pbk.)
041			_aENG
082	0	4	_a005.54 _bKAT
100	1		_aKatz, Abbott.
245	1	0	_aBeginning Microsoft Excel 2010 / _cAbbott Katz.
246	3	0	_aMicrosoft Excel 2010
260			_a[Berkeley, Calif.] : _bApress ; _aNew York : _bDistributed to the book trade worldwide by Springer Science+Business Media, _cc2010.
300			_a xiv, 388 pages : _billustrations ; _c24 cm.
500			_aIncludes index.
505			_aContents at a glance Contents About the author About the technical reviewer Acknowledgments Introduction Chapter 1: Introduction To Excel Making the acquaintance Unlocking your inner worksheet Pep talk Interacting with the interface Tab talk Something new, something old Keeping tabs on a new one Cool QAT Understood in context Alt-ered consciousness Chapter 2: Getting Started And Getting Around The Worksheet More addresses than the phone book-cells, and how to get there Getting around Key points Ranges: a select tool Data entry: getting started Entering text: trespassing allowed Numbers are (a little) different Relocating the data: copying and moving Having your fill There'll be some changes made-editing cells Chapter 3: From Data Entry To Data Creation: Formula Basics And Beyond Cell references explained Ordering up your results Not just your average function Making range values COUNT MAX and MIN-recording highs and lows Absolute references: absolutely important More of the same You could look it up If: worth knowing-no ifs, ands, or buts In conclusion Chapter 4: Keeping Up Appearances-Formatting The Worksheet You've got designs on your worksheet Font button group: a closer look Borderline command Getting oriented Excel has got your number(s) Dates-the long and the short of it Time is on your side-yes it is New kind of copy-and paste Style setter Formatting-with conditions Just a bit more P S In conclusion Chapter 5: Stuff Of Legend-Charting In Excel Starting charting Making a chart of our own Changing the chart-it's your call Design tab-a closer look Change chart type Save as template Switch row/column Select data Chart layouts Chart styles Move chart Changing the chart default-and the 2-second chart Layout tab Working with chart labels Axes to grind Format tab-getting your objects in shape Sparklines: mini-charts with big impact You win some, you lose some In conclusion Chapter 6: Setting The Table: Database Features Of Excel 2010 Sorting-sort of easy Using header rows Sorting by more than one field AutoFilter: picking and choosing your data Playing-or plying-the numbers Advanced filter-setting your data aside Table talk Creating a table Using table styles Adding a total row Examining the other table style options At the risk of repeating yourself: the remove duplicates option Data validation: improving your entree to data entry Using data validation Adding data entry rules Adding an input message Using the error alert option Adding a validation rule to existing data In conclusion Chapter 7: Working With Multiple Sheets Adding to sheets-inserting rows, columns and cells Inserting a column Inserting a row Deleting rows and columns Inserting and deleting cells Hiding rows and columns-and getting them back Multiple worksheet basics Inserting anew worksheet Busting a (sheet) move Hiding worksheets Grouping worksheets Far-flung formulas: working with multi-sheet cell references Doing a multi-sheet calculation Extending your reach: referring to cells in different workbooks Watch window-spying on your own data Protect your cells from unwanted intruders-even yourself Protecting a sheet Protecting a whole workbook Consolidating your data-getting it all together In conclusion Chapter 8: PivotTables And Pivot Charts Starting out with pivot-tables What's in a name? Constructing a pivot-table: let's go Inserting the table Setting up the pivot-table Updating the pivot-report Filters again-pivot-table style Your very own top 10 list Report filter-getting on top of the pivot-table Slicer-filter deluxe Grouping the data Formatting the pivot report-values and all Pivot charts In conclusion Chapter 9: Getting It On Paper-Printing In Excel 2010 Hard copy? Pretty easy Print area option Margin-al utility Printing as you see fit Headers and footers-getting to the bottom (and the top) of your printout Title search There's more than one way to view a worksheet Gimme a (page) break-another view Customize your view, too In conclusion Chapter 10: Taking It To The Cloud: Sharing And Collaborating On The Internet Getting there Permission granted: sharing your workbooks Hey-you! Get onto my cloud! In conclusion Appendix A: Working with range names What's in a name? plenty, if it's a range Naming many ranges-at the same time Name manager-tracking your ranges In conclusion Appendix B: Keyboard shortcuts Control key combinations Other shortcut keys Appendix C: Error messages Nobody's perfect Index
520			_aBeginning 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	_aBusiness _xComputer programs.
650		0	_aElectronic spreadsheets.
650		7	_aBusiness _xComputer software.
650		7	_aSpreadsheet software.
942			_2ddc _cBK
999			_c22918 _d22918