Home Page Icon
Home Page
Table of Contents for
II. Calculating with Excel
Close
II. Calculating with Excel
by Bill Jelen
Microsoft Excel 2010 In Depth
Title Page
Copyright Page
Dedication
Contents At a Glance
Contents
About the Author
Acknowledgments
We Want to Hear From You!
Reader Services
Introduction
I. Changes in User Interface
1. The File Menu Becomes the Backstage View
2. The Ribbon Interface and Quick Access Toolbar
3. Using Other Excel Interface Improvements
4. Customizing the Ribbon
5. Keyboard Shortcuts
6. The Excel Options Dialog
7. The Big Grid and File Formats
II. Calculating with Excel
8. Understanding Formulas
9. Controlling Formulas
10. Understanding Functions
11. Using Everyday Functions: Math, Date and Time, and Text Functions
12. Using Powerful Functions: Logical, Lookup, and Database Functions
13. Using Financial Functions
14. Using Statistical Functions
15. Using Trig, Matrix, and Engineering Functions
16. Connecting Worksheets, Workbooks, and External Data
17. Using Super Formulas in Excel
18. Using Names in Excel
19. Fabulous Table Intelligence
III. Business Intelligence
20. Sorting Data
21. Removing Duplicates and Filtering
22. Using Automatic Subtotals
23. Using Pivot Tables to Analyze Data
24. Using Slicers and Filtering a Pivot Table
25. Mashing Up Data with PowerPivot
26. Using What-If, Scenario Manager, Goal Seek, and Solver
27. Automating Repetitive Functions Using VBA Macros
28. More Tips and Tricks for Excel 2010
29. Tour of the Best Add-Ins for Excel
IV. Visual Presentation of Data
30. Formatting Worksheets
31. Using Data Visualizations and Conditional Formatting
32. Using Excel Charts
33. Using Sparklines
34. Using SmartArt, Shapes, WordArt, and Text Boxes
35. Using Pictures and Clip Art
V. Sharing
36. Printing
37. Excel Web App and Other Ways to Share Workbooks
38. Saving Time Using the Easy-XL Program
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
7. The Big Grid and File Formats
Next
Next Chapter
8. Understanding Formulas
II. Calculating with Excel
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset