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