- 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
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.