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.
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
[Berkeley, Calif.] : New York :
Apress ; Distributed to the Book trade worldwide by Springer Science+Business Media,
©2010.
|
Colección: | Expert's voice in Office.
|
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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.