Lien ebook : http://ezproxy.univ-catholille.fr/login?url=https://www.vleb...

eISBN : 9781118491720

Sommaire : Introduction

Part I: Getting Started with Excel
Chapter 1: Introducing Excel
Chapter 2: Entering and Editing Worksheet Data
Chapter 3: Essential Worksheet Operations
Chapter 4: Working with Cells and Ranges
Chapter 5: Introducing Tables
Chapter 6: Worksheet Formatting
Chapter 7: Understanding Excel Files
Chapter 8: Using and Creating Templates
Chapter 9: Printing Your Work

Part II: Working with Formulas and Functions
Chapter 10: Introducing Formulas and Functions
Chapter 11: Creating Formulas That Manipulate Text
Chapter 12: Working with Dates and Times
Chapter 13: Creating Formulas That Count and Sum
Chapter 14: Creating Formulas That Look Up Values
Chapter 15: Creating Formulas for Financial Applications
Chapter 16: Miscellaneous Calculations
Chapter 17: Introducing Array Formulas
Chapter 18: Performing Magic with Array Formulas

Part III: Creating Charts and Graphics
Chapter 19: Getting Started Making Charts
Chapter 20: Learning Advanced Charting
Chapter 21: Visualizing Data Using Conditional Formatting
Chapter 22: Creating Sparkline Graphics
Chapter 23: Enhancing Your Work with Pictures and Drawings

Part IV: Using Advanced Excel Features
Chapter 24: Customizing the Excel User Interface
Chapter 25: Using Custom Number Formats
Chapter 26: Using Data Validation
Chapter 27: Creating and Using Worksheet Outlines
Chapter 28: Linking and Consolidating Worksheets
Chapter 29: Excel and the Internet
Chapter 30: Protecting Your Work
Chapter 31: Making Your Worksheets Error Free

Part V: Analyzing Data with Excel
Chapter 32: Importing and Cleaning Data
Chapter 33: Introducing Pivot Tables
Chapter 34: Analyzing Data with Pivot Tables
Chapter 35: Performing Spreadsheet What-If Analysis
Chapter 36: Analyzing Data Using Goal Seeking and Solver
Chapter 37: Analyzing Data with the Analysis ToolPak

Part VI: Programming Excel with VBA
Chapter 38: Introducing Visual Basic for Applications
Chapter 39: Creating Custom Worksheet Functions
Chapter 40: Creating UserForms
Chapter 41: Using UserForm Controls in a Worksheet
Chapter 42: Working with Excel Events
Chapter 44: Creating Custom Excel Add-Ins

Part VII: Appendixes 941
Appendix A: Worksheet Function Reference
Appendix B: Excel Shortcut Keys
Index

Langue : Anglais

Lieu d'édition : TORONTO

Localisation : Bibliothèque Campus de Nice

Support : Numérique

Etat : Présent

Propriétaire : Bibliothèque