Product Description
Hey, you know your way around a spreadsheet—so now dig into Excel 2003 and really put your data to work! This supremely organized reference packs hundreds of time-saving solutions, troubleshooting tips, and handy workarounds in concise, fast answer format. Work smarter with core functions such as using worksheets and charts, analyzing data, and creating databases—and quickly advance your expertise by building PivotTable reports, creating macros, using custom functions, and automating Microsoft Excel with Microsoft Visual Basic® for Applications. Also learn how to link and embed Excel data in other Microsoft Office applications, and how to capture, reuse, and share data by exploiting XML features. On the companion CD you get an eBook of Microsoft Office Excel 2003 Inside Out, along with Insider Extras from the authors, a trial version of the Spreadsheet Assistant add-on, a collection of Microsoft resources for learning about Office, a catalog of 3rd-party Excel resources, and two additional e-books: the Microsoft Computer Dictionary, Fifth Edition, and the Insider’s Guide to Microsoft Office OneNote 2003. With INSIDE OUT, you’ll discover the best and fastest ways to perform everyday tasks—and challenge yourself to new levels of Excel mastery!

About the Author
Craig Stinson was a contributing author to Microsoft Windows® XP Inside Out and a coauthor of Microsoft Windows XP Inside Out, Deluxe Edition. Before coauthoring Microsoft Excel Version 2002 Inside Out, he cowrote several editions of the best-selling Running Microsoft Windows. He is also a contributing editor of PC Magazine and has written music reviews for such well-known publications as Billboard, the Boston Globe, and the Christian Science Monitor.

A former senior technical writer for the Microsoft Office User Assistance group, Mark Dodge cowrote Microsoft Excel Version 2002 Inside Out and was the coauthor of four editions of Running Microsoft Excel. He served as technical editor for more than a dozen books on Microsoft applications and has been honored with six awards from the Society for Technical Communication.




contenido

Part 1
Examining the Excel
Environment
Chapter 1
What’s New in Microsoft
Office Excel 2003
Chapter 2
Excel Fundamentals
Chapter 3
Custom-Tailoring the Excel
Workspace
Part 2
Building Worksheets
Chapter 4
Worksheet Design Tips
Chapter 5
How to Work a Worksheet
Chapter 6
How to Work a Workbook
Part 3
Formatting and Editing
Worksheets
Chapter 7
Worksheet Editing Techniques
Chapter 8
Worksheet Formatting
Techniques
Chapter 9
Advanced Formatting and
Editing Techniques
Part 4
Adding Graphics
and Printing
Chapter 10
Creating Spiffy Graphics
Chapter 11
Printing and Presenting
Part 5
Creating Formulas and
Performing Data
Analysis
Chapter 12
Building Formulas
Chapter 13
Using Functions
Chapter 14
Everyday Functions
Chapter 15
Formatting and Calculating
Date and Time
Chapter 16
Functions for Financial
Analysis
Chapter 17
Functions for Analyzing
Statistics
Chapter 18
Performing What-If Analysis
Part 6
Collaboration and
the Internet
Chapter 19
Collaborating with Excel
Chapter 20
Transferring Files to and
from Internet Sites
Part 7
Integrating Excel with
Other Applications
Chapter 21
Linking and Embedding
Chapter 22
Using Hyperlinks
Chapter 23
Using Excel Data in Word
and PowerPoint Documents
Part 8
Creating Charts
Chapter 24
Basic Charting Techniques
Chapter 25
Enhancing the Appearance
of Your Charts
Chapter 26
Working with Chart Data
Chapter 27
Advanced Charting Techniques
Part 9
Managing Databases
and Lists
Chapter 28
Managing Information in Lists
Chapter 29
Working with External Data
Chapter 30
Analyzing Data with PivotTable
Reports
Part 10
Automating Excel
Chapter 31
Recording Macros
Chapter 32
Creating Custom Functions
Chapter 33
Debugging Macros and
Custom Functions
Part 11
Appendixes
Appendix A
Installing Microsoft Excel
Appendix B
Using Speech and Handwriting
Recognition
Appendix C
Keyboard Shortcuts
Appendix D
Function Reference

nombre: Microsoft Office Excel 2003 Inside Out (Microsoft Office Excel Inside Out)

Autor: Craig Stinson

Idioma: ingles

formato: pdf

tamaño: 15066 KB

comprimido: winrar

sin pass

enlace:
[hide]
[Sólo los usuarios registrados pueden ver los enlacesInscríbase Aquí]
[/hide]
Comentar y agrade