Master Visually Excel 2007~tqw~ darksiderg

*******************************************************************************
Master Visually: Excel 2007
*******************************************************************************
General InformationType.................: Ebook
Part Size............: 81,702,529 bytes



Post InformationPosted by............: ~tqw~
Release NotesMaster Visually Excel 2007 covers the basics of using the program, such as
navigating in worksheets and workbooks and understanding how to enter
information into a worksheet, as well as intermediate through advance features,
such as using formulas and functions and finding and controlling formulaic
errors. A two-color, step-by-step consumer guide it features screen shots with
specific, numbered instructions showing the actions users need to perform to
execute certain tasks. In-depth, complete coverage of Excel 2007 allows users to
grow at ones own pace and achieve anything from a basic understanding of this
dynamic data tool to higher level productivity using the advanced features found
in Excel.

Table Of Contents

Table of Contents

PART I: Excel Basics.
1) Getting Started with Excel.
2) Managing Workbooks.
3) Formatting Cells.
PART II: Designing Worksheets.
4) Editing Worksheets.
5) Proofreading a Worksheet.
6) Adjusting Worksheets.
7) Managing Workbook Structure.
Working with Views.
9) Printing Worksheet Information.
PART III: Calculating Data.
10) Performing Basic Math.
11) Working with Common Formulas.
12) Mastering Date and Time Formulas.
13) Working with Financial Formulas.
14) Working with Lookup Formulas.
15) Applying Reference, Information, and Text Formulas.
16) Working with Logical and Error Trapping Formulas.
17) Analyzing Tabular Information with Functions.
18) Analyzing Formulas and Worksheets.
PART IV: Mastering Excel Charts.
19) Discovering Chart Basics.
20) Changing Chart Layout Details.
21) Formatting Charts.
22) Working with Graphic Elements.
PART V: Analyzing Data.
23) Working with Tables.
24) Summarizing Data with PivotTables and PivotCharts.
25) Visually Analyzing Data.
26) Linking and Consolidating Worksheets.
27) Performing What-If Analysis.
28) Performing Advanced Statistical Analysis.
PART VI: Customizing the Excel Environment.
29) Working with Macros.
30) Changing Excel Behavior.
PART VII: Using Excel in Collaborationwith Others.
31) Using Workbooks in a Multi-User Environment.
32) Sharing Excel Data with Other Programs.
A) Excel Functions.

Product Details

* ISBN: 0470181702
* ISBN-13: 9780470181706
* Format: Paperback, 816pp
* Publisher: Wiley, John & Sons, Incorporated
* Pub. Date: March 2008
Install NotesPDF Reader