Beginning Microsoft Excel 2010
Presents a beginner's guide to the computer program, including instructions on creating spreadsheets, performing calculations, and charting tables, and reviews the new features in the 2010 version
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
[Berkeley, Calif.]
Apress
2010
|
| Series: | The expert's voice in Microsoft Office
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Cover
- Table of Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Chapter 1 Introduction to Excel
- Making the Acquaintance
- Unlocking Your Inner Worksheet
- The Pep Talk
- Interacting With the Interface
- Tab Talk
- Something New, Something Old
- Keeping Tabs8230;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 BookCells, 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
- ThereLl Be Some Changes MadeEditing 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 MinRecording Highs and Lows
- Absolute References: Absolutely Important
- More of the Same
- You Could Look It Up
- If: Worth KnowingNo Ifs, Ands, or Buts
- In Conclusion8230;
- Chapter 4 Keeping Up AppearancesFormatting the Worksheet
- The Font Button Group: A Closer Look
- Borderline Command
- Getting Oriented
- Excel Has Got Your Number(S)
- DatesThe Long and the Short of It
- Time Is On Your SideYes It Is
- A New Kind of Copyand Paste
- Style Setter
- FormattingWith Conditions
- Just a Bit More8230;
- P.S.
- In Conclusion8230;
- Chapter 5 The Stuff Of LegendCharting in Excel
- Starting Charting
- Making a Chart of Our Own
- Changing The ChartIts Your Call
- The Design TabA Closer Look
- Change Chart Type
- Save As Template
- Switch Row/Column
- Select Data
- Chart Layouts
- Chart Styles
- Move Chart
- Changing the Chart Defaultand the 2-Second Chart
- The Layout Tab
- Working With Chart Labels
- Axes to Grind
- The Format TabGetting Your Objects in Shape
- Sparklines: Mini-Charts With Big Impact
- You Win Some, You Lose Some
- In Conclusion8230;
- Chapter 6 Setting the Table: Database Features of Excel 2010
- SortingSort Of Easy
- Using Header Rows
- Sorting By More Than One Field
- The Autofilter: Picking and Choosing Your Data
- Playingor Plyingthe Numbers
- The Advanced FilterSetting 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 Entr233;e to Data Entry
- Using Data Validation
- Adding Data Entry Rules
- Adding An Input Message
- Using the Error Alert Option
- Adding a Validation