Home Page Icon
Home Page
Table of Contents for
Close
by Guy Hart-Davis
Learn Excel 2011 for Mac
Title Page
Dedication
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Who Is This Book For?
What Does This Book Cover?
Conventions Used in This Book
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
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
Understanding the Components of a Function
Entering Functions in Your Worksheets
Nesting One Function Inside Another Function
Meeting Excel's Built-in Functions
Choosing the Right Calculation Preferences for Your Needs
Summary
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
Using Data Bars
Using Color Scales
Representing Data Graphically with Icon Sets
Showing Data Trends with Sparklines
Summary
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
Part III: Analyzing Data and Sharing and Automating Workbooks
Chapter 10: Creating Databases Using Tables
Creating Databases in Excel
Using Database Functions with Tables
Summary
Chapter 11: Solving Business Questions with What-If Analysis, Goal Seek, and Solver
Assessing the Impact of Variables Using Data Tables
Examining Different Scenarios in a Worksheet
Using Goal Seek
Solving Multiple-Variable Problems with Solver
Summary
Chapter 12: Analyzing Data with PivotTables
Understanding What PivotTables Are and What You Can Do with Them
Creating and Laying Out a PivotTable
Controlling the Design of a PivotTable
Formatting a PivotTable
Naming a PivotTable and Setting Options for It
Sorting and Filtering a PivotTable
Summary
Chapter 13: Collaborating and Sharing with Macs and Windows PCs
Making Your Worksheets Print Correctly
Sharing Your Worksheets as PDFs
Exporting Data to CSV Files
Documenting Your Workbooks
Sharing Your Workbooks with Your Colleagues
Merging Multiple Workbooks into a Single Workbook
Consolidating Multiple Worksheets into a Single Worksheet
Summary
Chapter 14: Automating Tasks with Macros and VBA
Understanding Your Options for Automating Tasks
Recording Macros
Recording an Example Macro
Running a Macro
Deleting a Macro
Editing Macros in the Visual Basic Editor
Summary
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
Next
Next Chapter
Title Page
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