Cargando…

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.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Katz, Abbott
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.