Excel 2010 made simple
Get the most out of Excel 2010 with Excel 2010 Made Simple—learn the key features, understand what’s new, and utilize dozens of time-saving tips and tricks to get your job done. Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York :
Apress
2011.
|
| Edición: | 1st ed. 2011. |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628031106719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Quick Start Guide; The Excel Worksheet: What You're Looking At; Key Tips: Accessing Buttons with the Keyboard; Contextual Tabs; A Visit Backstage; Customizing the Quick Access Toolbar; Where to Learn More; Excel Keyboard Equivalents; Chapter 1 Introducing Excel 2010; The Advantages of Learning More; Spreadsheets Defined; Excel Can Be Fun; Summary; Chapter 2 Getting Around the Worksheet and Data Entry; The Journey Starts Here; Looking Around
- Getting Around a WorksheetSelecting Multiple Cells; Selecting Cells Down and Across the Worksheet; Selecting Cells with the Keyboard; Selecting All the Cells; Still One More Selection Technique-The Name Box; Entering Text and Data; Aligning Your Data-Where It Appears in the Cell; Widening and Narrowing Columns; Altering a column manually; Using the Auto-fit Feature; Entering Numerical Data-How it's Different; Entering Data into a Selected Range; Using Auto Fill to Speed Up Data Entry; Copying a Value with Auto Fill; Auto Filling a Numeric Sequence; Using Auto Fill with Text
- Using the Auto Fill Option ButtonCustomizing Auto Fill Lists; Data Validation: Bringing Quality Control to the Worksheet; Making a List-Personalizing a Drop-Down Menu; Explaining Data Validation Errors with Error Alerts; Adding Data Entry Instructions with Input Messages; Summary; Chapter 3 Editing Data; Changing Your Data; Undoing an Edit; Undoing What You've Just Undone with the Redo Button; Deleting Cell Contents; Copying and Moving: Duplicating and Relocating Your Data; Copying Data; Moving Data; The Clipboard: The Storage Area for Copied and Cut Data; Summary
- Chapter 4 Number Crunching 101: Functions, Formulas, and RangesAutomatic Calculations with Functions; Adding a Column of Numbers; Selecting the Range You Need; Viewing and Editing Your Formula: Back to the Formula Bar; Calculating an Average; Displaying Values Based on a Certain Condition; Revisiting Function Structure; Locating Functions in the Function Library; Customizing the Worksheet with Formulas; Writing a Basic Formula; Working Out the Order of Operations in a Formula; Copying Formulas: More Than Just Duplication; The Classic Copy-and-Paste Method
- Moving Formulas: An Important DifferenceKeeping a Cell Reference Constant with Absolute Addressing; Absolute Addressing: When We Don't Want It to Work; Introducing an Absolute Cell Address; Copying a Formula's Result Only; Clarifying Cell References by Naming a Range; Naming a Range in the Name Box; Naming Ranges from the Data in Your Worksheet; Naming A Range Containing One Cell: Why Bother?; The Name Manager: Where They're All Ar-ranged; Summary; Chapter 5 For Appearance's Sake: Formatting Your Data; What Formatting Does (and Doesn't Do); Basic Formatting; Changing the Font
- Changing the Font Size
