- Title Page
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Part I: Becoming Proficient with Excel:Mac
- Chapter 1: Learning the Secrets of the Excel:Mac Interface
- Getting Ready to Learn Excel's Secrets
- Four Ways to Control Excel
- Secrets of the Ribbon
- Secrets of the Toolbars
- Secrets of the Menu Bar
- Driving Excel with Keyboard Shortcuts
- Making the Toolbox Work Your Way
- Navigating Quickly Through Worksheets and Workbooks
- Tools for Entering Text and Formulas Quickly
- Viewing Your Workbooks
- Using Custom Views
- Summary
- Chapter 2: Configuring Excel:Mac to Suit the Way You Work
- Opening the Excel Preferences Dialog Box
- Controlling How the Excel Window Appears
- Choosing Editing Options
- Setting Preferences for Creating and Saving Your Workbooks
- Creating Custom Keyboard Shortcuts
- Customizing the Toolbars with the Commands You Need
- Customizing the Menus and the Menu Bar
- Turning Off or Customizing the Ribbon
- Opening One or More Workbooks Automatically with Excel
- Saving the Layout of Open Workbooks as a Workspace
- Summary
- Chapter 3: Creating Effective Workbooks and Templates
- Creating Workbooks from Scratch or from Templates
- Saving Your Workbooks for Use with Older Versions of Excel
- Organizing the Worksheets in a Workbook
- Four Easy Rules for Laying Out Your Worksheets
- Entering Data on Multiple Worksheets at Once
- Identifying Parts with Named Ranges
- Creating a Collapsible Worksheet by Outlining It
- Making the Most of Templates
- Summary
- Chapter 4: Formatting Your Worksheets Quickly and Efficiently
- Working with Rows and Columns
- Formatting Cells and Ranges
- Using Paste Special to Paste Formatting and Perform Actions
- Identifying Unusual Values with Conditional Formatting
- Checking Input with Data Validation
- Formatting Quickly with Table Formatting and Styles
- Adding Headers and Footers to Your Worksheets
- Summary
- Chapter 1: Learning the Secrets of the Excel:Mac Interface
- Part II: Performing Calculations and Presenting Data
- Chapter 5: Performing Custom Calculations with Formulas
- Understanding the Difference Between Formulas and Functions
- Referring to Cells and Ranges in Formulas and Functions
- Understanding the Components of Formulas
- Creating Straightforward Formulas
- Creating Complex Formulas
- Entering Formulas Quickly by Copying and Using AutoFill
- Choosing Preferences for Error Checking
- Troubleshooting Common Problems with Formulas
- Summary
- Chapter 6: Using Excel's Built-In Functions
- Chapter 7: Creating Clear and Persuasive Charts
- Learning the Essentials of Charts in Excel
- Choosing the Best Chart Type for Your Data
- Creating, Laying Out, and Formatting a Chart
- Copying a Chart's Formatting to Another Chart
- Reusing Your Own Designs by Creating Custom Chart Types
- Choosing Chart Preferences
- Using Your Charts in Word Documents and PowerPoint Presentations
- Summary
- Chapter 8: Using Data Bars, Color Scales, Icon Sets, and Sparklines
- Chapter 9: Illustrating Your Worksheets with Pictures, SmartArt, and More
- Inserting Clip Art
- Inserting Pictures in Your Workbooks
- Adding and Formatting a Shape
- Rotating a Graphical Object
- Positioning a Graphical Object
- Making a Picture Look the Way You Want It
- Inserting SmartArt Diagrams
- Adding Decorative Text with WordArt
- Positioning Graphical Objects Relative to Cells
- Arranging Graphical Objects to Control Which Is Visible
- Summary
- Chapter 5: Performing Custom Calculations with Formulas
- Part III: Analyzing Data and Sharing and Automating Workbooks
- Index
Summary
In this chapter, you've learned how to illustrate your worksheets by attaching data bars, color scales, and icon sets to conditional formatting. You've also learned how to show data trends with sparklines.
In the next chapter, I'll show you how to illustrate your worksheets further using pictures, clip art, SmartArt diagrams, and shapes.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.