Master VISUALLY Excel 2010
Published on 16. July 2010
Book
Paperback/Softback
736 pages
978-0-470-57769-1 (ISBN)
Description
The complete visual reference on Excel basics
Aimed at visual learners who are seeking an all-in-one reference that provides in-depth coveage of Excel from a visual viewpoint, this resource delves into all the newest features of Excel 2010. You'll explore Excel with helpful step-by-step instructions that show you, rather than tell you, how to navigate Excel, work with PivotTables and PivotCharts, use macros to streamline work, and collaborate with other users in one document.
* This two-color guide features screen shots with specific, numbered instructions so you can learn the actions you need to perform in order to execute a wide range of Excel 2010 tasks.
* Features beginning, intermediate andadvanced visual coverage of Excel 2010
* Shows you how to enter information into a worksheet, use formulas and functions, find and control formulaic errors, and much more
* Presents more than 1,000 screen shots that demonstrate step-by-step instructions of numerous Excel 2010 tasks
You're encouraged to move at your own pace as you acquire confidence and proficiency with the newest version of Excel.
Aimed at visual learners who are seeking an all-in-one reference that provides in-depth coveage of Excel from a visual viewpoint, this resource delves into all the newest features of Excel 2010. You'll explore Excel with helpful step-by-step instructions that show you, rather than tell you, how to navigate Excel, work with PivotTables and PivotCharts, use macros to streamline work, and collaborate with other users in one document.
* This two-color guide features screen shots with specific, numbered instructions so you can learn the actions you need to perform in order to execute a wide range of Excel 2010 tasks.
* Features beginning, intermediate andadvanced visual coverage of Excel 2010
* Shows you how to enter information into a worksheet, use formulas and functions, find and control formulaic errors, and much more
* Presents more than 1,000 screen shots that demonstrate step-by-step instructions of numerous Excel 2010 tasks
You're encouraged to move at your own pace as you acquire confidence and proficiency with the newest version of Excel.
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
ill
Dimensions
Height: 23.1 cm
Width: 18.7 cm
Thickness: 1.8 cm
Weight
1442 gr
ISBN-13
978-0-470-57769-1 (9780470577691)
Schweitzer Classification
Person
Content
PART I: Excel Basics.
1 Getting Started with Excel
2 Managing Workbooks.
3 Formatting Cells.
PART II: Designing Worksheets.
4 Editing and Proofreading Worksheets
5 Adjusting Worksheets.
6 Managing the Workbook Structure.
7 Working with Views.
8 Printing Worksheet Information.
PART III: Calculating Data.
9 Performing Basic Math.
10 Working with Common Formulas.
11 Mastering Date and Time Formulas.
12 Working with Financial Formulas.
13 Working with Commonly Used Lookup Formulas.
14 Applying Reference, Information, and Text Formulas.
15 Working with Logical and Error Trapping Formulas.
16 Analyzing Tabular Information with Functions.
17 Analyzing Formulas and Functions.
PART IV: Mastering Excel Charts.
18 Discovering Chart Basics.
19 Changing Chart Layout Details.
PART V: Analyzing Data.
20 Working with Graphic Elements.
21 Working with Tables.
22 Summarizing Data with PivotTables and PivotCharts.
23 Visually Analyzing Data.
24 Linking and Consolidating Worksheets.
25 Performing What-If Analysis.
26 Performing Advanced Statistical Analyses.
PART VI: Customizing the Excel Environment.
27 Working with Macros.
28 Customizing the Excel Environment.
PART VII: Using Excel in Collaboration with Others.
29 Using Workbooks in a Multiuser Environment.
30 Sharing Excel Data with Other Programs.
1 Getting Started with Excel
2 Managing Workbooks.
3 Formatting Cells.
PART II: Designing Worksheets.
4 Editing and Proofreading Worksheets
5 Adjusting Worksheets.
6 Managing the Workbook Structure.
7 Working with Views.
8 Printing Worksheet Information.
PART III: Calculating Data.
9 Performing Basic Math.
10 Working with Common Formulas.
11 Mastering Date and Time Formulas.
12 Working with Financial Formulas.
13 Working with Commonly Used Lookup Formulas.
14 Applying Reference, Information, and Text Formulas.
15 Working with Logical and Error Trapping Formulas.
16 Analyzing Tabular Information with Functions.
17 Analyzing Formulas and Functions.
PART IV: Mastering Excel Charts.
18 Discovering Chart Basics.
19 Changing Chart Layout Details.
PART V: Analyzing Data.
20 Working with Graphic Elements.
21 Working with Tables.
22 Summarizing Data with PivotTables and PivotCharts.
23 Visually Analyzing Data.
24 Linking and Consolidating Worksheets.
25 Performing What-If Analysis.
26 Performing Advanced Statistical Analyses.
PART VI: Customizing the Excel Environment.
27 Working with Macros.
28 Customizing the Excel Environment.
PART VII: Using Excel in Collaboration with Others.
29 Using Workbooks in a Multiuser Environment.
30 Sharing Excel Data with Other Programs.