IPE Libraray Catalogue Hyderabad

Includes index.

Contents 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

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