Description |
1 online resource (xiv, 388 pages) : illustrations |
Series |
The expert's voice in Microsoft Office |
|
Expert's voice in Office.
|
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 |
Summary |
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 |
Notes |
User level: beginning |
|
English |
|
Copyright © Apress 2010 |
|
Print version record |
SUBJECT |
Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
|
|
Microsoft Excel (Computer file) blmlsh |
|
Microsoft Excel (Computer file) cct |
|
Microsoft Excel (Computer file) fast |
|
Microsoft Excel (Computer software) sears |
Subject |
Business -- Computer programs.
|
|
Electronic spreadsheets.
|
|
COMPUTERS -- Desktop Applications -- Spreadsheets.
|
|
Business -- Computer programs.
|
|
Electronic spreadsheets.
|
|
Informatique.
|
|
Business -- Computer programs
|
|
Electronic spreadsheets
|
|
Business -- Computer software.
|
|
Spreadsheet software.
|
Form |
Electronic book
|
ISBN |
9781430229568 |
|
143022956X |
|
1283075318 |
|
9781283075312 |
|
9786613075314 |
|
6613075310 |
|