Hosszú leírás:

Tartalomjegyzék:

The Missing Credits;
About the Author;
About the Creative Team;
Acknowledgements;
The Missing Manual Series;
Introduction;
What You Can Do with Excel;
Excel's New Face;
Excel's New Features;
About This Book;
Part I: Worksheet Basics;
Chapter 1: Creating and Navigating Worksheets;
1.1 Creating a Basic Worksheet;
1.2 Editing Data;
1.3 Navigating in Excel;
1.4 Saving Files;
1.5 Opening Files;
Chapter 2: Adding Information to Worksheets;
2.1 Adding Different Types of Data;
2.2 Quick Ways to Add Data;
Chapter 3: Moving Data Around a Worksheet;
3.1 Selecting Cells;
3.2 Moving Cells Around;
3.3 Adding and Moving Columns or Rows;
Chapter 4: Managing Worksheets and Workbooks;
4.1 Worksheets and Workbooks;
4.2 Find and Replace;
4.3 Spell Check;
Chapter 5: Formatting Cells;
5.1 Formatting Cell Values;
5.2 Formatting Cell Appearance;
Chapter 6: Smart Formatting Tricks;
6.1 The Format Painter;
6.2 Styles and Themes;
6.3 Conditional Formatting;
Chapter 7: Viewing and Printing Worksheets;
7.1 Controlling Your View;
7.2 Printing;
7.3 Controlling Pagination;
Part II: Formulas and Functions;
Chapter 8: Building Basic Formulas;
8.1 Creating a Basic Formula;
8.2 Formula Shortcuts;
8.3 Copying Formulas;
Chapter 9: Math and Statistical Functions;
9.1 Rounding Numbers;
9.2 Groups of Numbers;
9.3 General Math Functions;
9.4 Trigonometry and Advanced Math;
9.5 Advanced Statistics;
Chapter 10: Financial Functions;
10.1 The World of Finance;
10.2 Financial Functions;
10.3 Depreciation;
10.4 Other Financial Functions;
Chapter 11: Manipulating Dates, Times, and Text;
11.1 Manipulating Text;
11.2 Manipulating Dates and Times;
11.3 Math with Dates and Times;
11.4 Date and Time Functions;
Chapter 12: Lookup, Reference, and Information Functions;
12.1 The Basic Lookup;
12.2 Advanced Lookups;
12.3 Information Functions;
12.4 Tutorial: Quickly Generating Invoices from a Product Catalog;
Chapter 13: Advanced Formula Writing and Troubleshooting;
13.1 Conditions in Formulas;
13.2 Descriptive Names for Cell References;
13.3 Variable Data Tables;
13.4 Controlling Recalculation;
13.5 Solving Formula Errors;
Part III: Organizing Worksheets;
Chapter 14: Tables: List Management Made Easy;
14.1 The Basics of Tables;
14.2 Sorting and Filtering a Table;
14.3 Dealing with Duplicate Rows;
14.4 Performing Table Calculations;
Chapter 15: Grouping and Outlining Data;
15.1 Basic Data Grouping;
15.2 Grouping Timesavers;
Chapter 16: Templates;
16.1 Understanding Templates;
16.2 Creating a New Workbook from a Template;
16.3 Creating Templates;
Part IV: Charts and Graphics;
Chapter 17: Creating Basic Charts;
17.1 Charting 101;
17.2 Basic Tasks with Charts;
17.3 Practical Charting;
17.4 Chart Types;
Chapter 18: Formatting and Perfecting Charts;
18.1 Chart Styles and Layouts;
18.2 Adding Chart Elements;
18.3 Selecting Chart Elements;
18.4 Formatting Chart Elements;
18.5 Improving Your Charts;
18.6 Advanced Charting;
Chapter 19: Inserting Graphics;
19.1 Adding Pictures to a Worksheet;
19.2 Excel's Clip Art Library;
19.3 Drawing Shapes;
Part V: Advanced Data Analysis;
Chapter 20: Scenarios and Goal Seeking;
20.1 Using Scenarios;
20.2 Using Goal Seek;
20.3 Solver;
Chapter 21: Pivot Tables;
21.1 Summary Tables Revisited;
21.2 Building Pivot Tables;
21.3 Multi
-Layered Pivot Tables;
21.4 Fine
-Tuning Pivot Table Calculations;
21.5 Filtering a Pivot Table;
21.6 Pivot Charts;
Part VI: Sharing Data with the Rest of the World;
Chapter 22: Protecting Your Workbooks;
22.1 Understanding Excel's Safeguards;
22.2 Data Validation;
22.3 Locked and Hidden Cells;
Chapter 23: Worksheet Collaboration;
23.1 Preparing Your Workbook;
23.2 Adding Comments;
23.3 Tracking Changes;
23.4 Sharing Your Workbook;
Chapter 24: Querying Databases and XML Files;
24.1 Excel and Databases;
24.2 Understanding XML;
24.3 Excel and XML;
Chapter 25: Exchanging Data with Other Programs;
25.1 Sharing Information in Windows;
25.2 Embedding and Linking Objects;
25.3 Transferring Data;
Chapter 26: Connecting Worksheets to the Web;
26.1 Putting Worksheets on the Web;
26.2 Performing Web Queries;
26.3 Using Hyperlinks;
Part VII: Programming Excel;
Chapter 27: Automating Tasks with Macros;
27.1 Macros 101;
27.2 The Macro Recorder;
27.3 Macro Security;
27.4 Creating Practical Macros;
Chapter 28: Programming Spreadsheets with VBA;
28.1 The Visual Basic Editor;
28.2 Understanding Macro Code;
28.3 Exploring the VBA Language;
Part VIII: Appendix;
Appendix A: Customizing the Quick Access Toolbar;
A.1 The Quick Access Toolbar;
Colophon;