Home Page Icon
Home Page
Table of Contents for
My Excel® 2013
Close
My Excel® 2013
by Michael Alexander
My Excel® 2013
About This eBook
Title Page
Copyright Page
Contents at a Glance
Table of Contents
About the Author
Dedication
Acknowledgments
We Want to Hear from You!
Reader Services
Introduction
What’s in This Book
1. Working with Excel’s Ribbon Menus
Familiarizing Yourself with the Ribbon Tabs
Understanding Workbooks and Worksheets
Understanding Contextual Tabs
Customizing the Quick Access Toolbar
2. Managing Workbooks and Worksheets
Opening an Excel Workbook
Closing an Excel Workbook
Saving a Workbook
Switching Between Open Workbooks
Switching Between Worksheets
Viewing Multiple Workbooks
Inserting and Deleting Worksheets
Renaming Worksheets
Coloring Worksheet Tabs
Moving Worksheets Within a Workbook
Copying Worksheets Between Workbooks
Password Protect a Workbook
Protecting a Worksheet
3. Entering and Managing Data
Entering Data
Editing and Deleting Existing Data
Zooming into Your Data
Undoing and Redoing Changes
Copying and Pasting Data
Freezing Rows and Columns
Splitting a Worksheet
Inserting Cells
Deleting Cells
Inserting and Deleting Rows
Inserting and Deleting Columns
Moving Data
Finding Data
Replacing Data
Applying a Data Filter
Sorting Data
Adding and Managing Cell Comments
4. Formatting Worksheet Data
Changing the Font and Font Size
Changing Column Width
Changing the Color of the Cell Background and Cell Text
Formatting the Display of Numeric Data
Applying Bold, Italic, and Underline
Using Merge and Center on Cells
Changing Horizontal Data Alignment
Changing Row Height
Changing Vertical Data Alignment
Changing Cell Orientation
Wrapping Data in a Cell
Changing Borders
Indenting Entries in a Cell
Clearing Formatting
Hiding and Unhiding Rows
Hiding and Unhiding Columns
Hiding and Unhiding a Worksheet
Using Format as Table
Copying Formatting
Creating and Applying a Formatting Style
Using Conditional Formatting
5. Working with Formulas and Functions
Using AutoSum Calculations
Entering a Formula
Editing a Formula or Function
Copying a Formula
Assigning Names to a Cell or Range
Referencing Names in a Function
Using Functions Across Worksheets
Using Auto-Calculate
Finding and Using Excel Functions
Recognizing and Fixing Errors
Recognizing Circular References
Checking for Formula References (PRECEDENTS)
Checking for Cell References (DEPENDENTS)
6. Working with Charts
Creating a Chart
Changing the Chart Type
Altering the Source Data Range
Altering Chart Options
Formatting the Plot Area
Formatting the Chart Area
Formatting the Axis Scale
Altering the Original Data
Adding Data to Charts
Adding a Legend
7. Working with Graphics
Using Drawing Tools
Inserting Clip Art
Inserting a Picture from File
Using AutoShapes
Inserting WordArt
Using Smart Art in Excel
Inserting a Diagram
Inserting Objects
Working with Inserted Objects
8. Printing in Excel
Using Print Preview
Setting the Print Area
Adjusting Page Margins
Inserting Page Breaks
Working in Page Break Preview Mode
Printing a Worksheet on One Page
Printing in Portrait or Landscape Orientation
Centering a Worksheet on a Page
Printing Gridlines and Row/Column Headers
Printing Cell Comments
Printing Cell Error Indicators
Printing Repeating Row and Column Titles
Adding Headers and Footers
Printing Your Worksheets
9. Working with Pivot Tables
Creating a Pivot Table
Rearranging a Pivot Table
Adding a Report Filter
Refreshing Pivot Table Data
Adding Pivot Table Data
Customizing Field Names
Applying Numeric Formats to Data Fields
Changing Summary Calculations
Showing and Hiding Data Items
Sorting Your Pivot Table
10. Using SkyDrive to Store and Share Excel Files
Signing Up For SkyDrive
Signing into SkyDrive
Saving a Workbook to SkyDrive
Opening a SkyDrive Workbook
Downloading a Workbook from SkyDrive
Sharing Your SkyDrive Workbooks with Others
Managing SkyDrive Workbooks
A. Excel Shortcut Keys
Using the Excel Shortcut Key Reference Table
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
Index
Next
Next Chapter
My Excel® 2013
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