Master VISUALLY Excel 2007
1st Edition
Published on 14. March 2008
Book
Paperback/Softback
776 pages
978-0-470-18170-6 (ISBN)
Description
Master Visually Microsoft Office Excel 2007
"One picture is worth a thousand words." If youprefer instructions that show you how rather than tell you why, then this complete visual reference is for you. Hundreds of succinctly captioned, step-by-step screen shots reveal how to accomplish more than 375 Excel 2007 tasks, including:
*
Navigating worksheets and workbooks
*
Creating letters with Mail Merge
*
Assigning formats to cells
*
Editing multiple worksheets at once
*
Summarizing with PivotTables and PivotCharts
*
Working with common formulas
*
"Master It" sidebars answer questions and present shortcuts
*
High-resolution screen shots demonstrate each task
*
Succinct explanations walk you through step by step
*
Two-page lessons break big topics into bite-sized modules
"One picture is worth a thousand words." If youprefer instructions that show you how rather than tell you why, then this complete visual reference is for you. Hundreds of succinctly captioned, step-by-step screen shots reveal how to accomplish more than 375 Excel 2007 tasks, including:
*
Navigating worksheets and workbooks
*
Creating letters with Mail Merge
*
Assigning formats to cells
*
Editing multiple worksheets at once
*
Summarizing with PivotTables and PivotCharts
*
Working with common formulas
*
"Master It" sidebars answer questions and present shortcuts
*
High-resolution screen shots demonstrate each task
*
Succinct explanations walk you through step by step
*
Two-page lessons break big topics into bite-sized modules
More details
Series
Edition
1., Auflage
Language
English
Place of publication
Chichester
United Kingdom
Publishing group
John Wiley and Sons Ltd
Target group
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23.1 cm
Width: 18.7 cm
Thickness: 4.5 cm
Weight
1496 gr
ISBN-13
978-0-470-18170-6 (9780470181706)
Schweitzer Classification
Person
Elaine Marmel is President of Marmel Enterprises, LLC, an organization which specializes in technical writing and software training. Elaine spends most of her time writing; she has authored and co-authored over 50 books about Microsoft Project, Microsoft Excel, QuickBooks, Peachtree, Quicken for Windows, Quicken for DOS, Microsoft Word for Windows, Microsoft Word for the Mac, Windows 98, 1-2-3 for Windows, and Lotus Notes. From 1994 to 2006, she also was the contributing editor to monthly publications Peachtree Extra and QuickBooks Extra.
Elaine left her native Chicago for the warmer climes of Arizona (by way of Cincinnati, OH; Jerusalem, Israel; Ithaca, NY; Washington, D.C. and Tampa, FL), where she basks in the sun with her PC, her dog Josh, and her cats, Cato, Watson, and Buddy, and sings barbershop harmony with the 2006 International Championship Scottsdale Chorus.
Elaine left her native Chicago for the warmer climes of Arizona (by way of Cincinnati, OH; Jerusalem, Israel; Ithaca, NY; Washington, D.C. and Tampa, FL), where she basks in the sun with her PC, her dog Josh, and her cats, Cato, Watson, and Buddy, and sings barbershop harmony with the 2006 International Championship Scottsdale Chorus.
Content
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.
8) 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 Collaboration with Others.
31) Using Workbooks in a Multi-User Environment.
32) Sharing Excel Data with Other Programs.
A) Excel Functions.
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.
8) 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 Collaboration with Others.
31) Using Workbooks in a Multi-User Environment.
32) Sharing Excel Data with Other Programs.
A) Excel Functions.