Book description
Excel 2013On Demand is built from the ground up for today's beginning-to-intermediate-level Exceluser. Like every book in the On Demand Series, it teaches visually, using an easy, friendly, full-color format designed to "show you how," instead of "telling you how." But that's not all. This book:
* Combines step-by-step training with quick-reference material users can rely on long after they've mastered the core skills they need
* Provides easy-to-follow task-based coverage of the techniques you'll use most often, presenting most tasks in just one or two pages
* Offers in-depth coverage of all new MOS (Microsoft Office Specialist) exam objectives, so you can use it as a study guide to enhance your job prospects or current career
* Provides additional end-of-chapter workshops, plus even more hands-on projects online
* Includes a complete practical troubleshooting guide
* Helps you upgrade by presenting New Feature icons, plus a detailed list of new features indexed to the pages where they're covered
Simply put, no other book offers beginning-to-intermediate-level Excelusers this much simplicity, usable content, flexibility, and value.
Table of contents
- Title Page
- Copyright Page
- Acknowledgments
- Contents
- Introduction
-
1. Getting Started with Excel
- Introduction
- Starting Excel
- Viewing the Excel Window
- Using the Ribbon
- Choosing Commands
- Working with the Ribbon and Toolbars
- Choosing Dialog Box Options
- Using the Status Bar
- Creating a Blank Workbook
- Creating a Workbook Using a Template
- Opening an Existing Workbook
- Converting an Existing Workbook
- Using Task and Window Panes
- Moving Around the Workbook
- Arranging Windows
- Getting Help While You Work
- Saving a Workbook
- Saving a Workbook with Different Formats
- Saving a Workbook to Online Services
- Working with Accounts
- Checking Compatibility
- Checking Accessibility
- Documenting Workbook Properties
- Switching Views
- Recovering a Workbook
- Closing a Workbook and Exiting Excel
-
2. Basic Workbook Skills
- Introduction
- Making Label Entries
- Selecting Cells
- Selecting Rows, Columns, and Special Ranges
- Entering Labels on a Worksheet
- Entering Values on a Worksheet
- Entering Values Quickly with AutoFill
- Inserting Content with Flash Fill
- Editing Cell Contents
- Clearing Cell Contents
- Understanding How Excel Pastes Data
- Storing Cell Contents
- Copying Cell Contents
- Moving Cell Contents
- Inserting and Deleting Cell Contents
- Finding and Replacing Cell Contents
- Correcting Cell Contents with AutoCorrect
- Inserting Information the Smart Way
- Checking Spelling
- Changing Proofing Options
- Using Custom Dictionaries
- Inserting Symbols
- Finding the Right Words
- Inserting Research Material
- Translating Text to Another Language
- Using Multiple Languages
- Working with Touch Screens
- Undoing and Redoing an Action
-
3. Working with Formulas and Functions
- Introduction
- Understanding Formulas
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Mixed Cell References
- Using 3-D Cell References
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Managing Names
- Simplifying a Formula with Ranges
- Displaying Calculations with the Status Bar
- Calculating Totals with AutoSum
- Calculating Totals with Quick Analysis
- Performing One Time Calculations
- Converting Formulas and Values
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Locating Circular References
- Performing Calculations Using Functions
- Creating Functions
- Creating Functions Using the Library
- Calculating Multiple Results
- Using Nested Functions
- Using Constants and Functions in Names
-
4. Modifying Worksheets and Workbooks
- Introduction
- Selecting and Naming a Worksheet
- Inserting and Deleting a Worksheet
- Moving and Copying a Worksheet
- Hiding and Unhiding Worksheets and Workbooks
- Selecting a Column or Row
- Hiding and Unhiding a Column or Row
- Inserting a Column or Row
- Deleting a Column or Row
- Adjusting Column Width and Row Height
- Freezing and Unfreezing a Column or Row
- Splitting a Worksheet into Panes
- Showing and Hiding Workbook Elements
- Zooming the View In and Out
- Creating Custom Views
- Setting Up for Personal Templates
- Creating a Personal Template
- Opening a Template
- Changing a Template
-
5. Formatting a Worksheet
- Introduction
- Formatting Numbers
- Formatting Text
- Applying Conditional Formatting
- Applying Specialized Conditional Formatting
- Creating Conditional Formatting
- Clearing Conditional Formatting
- Managing Conditional Formatting
- Finding Conditional Formatting
- Creating Sparkline Formatting
- Changing Data Alignment
- Controlling Text Flow
- Changing Data Color
- Adding Color and Patterns to Cells
- Adding Custom Colors
- Adding Borders to Cells
- Formatting Tabs and Background
- Copying Cell Formats
- Understanding Color Themes
- Viewing and Applying a Theme
- Creating Theme Colors
- Choosing Theme Fonts
- Choosing Theme Effects
- Creating a Custom Theme
- Choosing a Custom Theme
- Applying and Creating Cell Styles
- Modifying a Cell Style
- Finding and Replacing Cell Formatting
- 6. Viewing and Printing Worksheets and Workbooks
-
7. Inserting and Modifying Graphics
- Introduction
- Locating and Inserting Online Pictures
- Inserting Pictures from an Online Service
- Inserting a Picture from a SkyDrive or SharePoint
- Inserting a Picture from a File
- Inserting a Picture Screen Shot
- Adding an Artistic Style to a Picture
- Adding a Quick Style to a Picture
- Applying a Shape to a Picture
- Applying a Border to a Picture
- Applying Picture Effects
- Modifying Picture Size
- Compressing a Picture
- Correcting a Picture
- Recoloring a Picture
- Cropping and Rotating a Picture
- Removing a Picture Background
- Creating WordArt Text
- Formatting WordArt Text
- Applying WordArt Text Effects
- Modifying WordArt Text Position
- Creating SmartArt Graphics
- Using the Text Pane with SmartArt Graphics
- Modifying a SmartArt Graphic
- Resizing a SmartArt Graphic
- Formatting a SmartArt Graphic
- Formatting a Shape in a SmartArt Graphic
- Adding Pictures to a SmartArt Graphic
- Creating an Organization Chart
- Modifying an Organization Chart
-
8. Drawing and Modifying Shapes
- Introduction
- Drawing and Resizing Shapes
- Inserting Multiple Shapes
- Adding Text to a Shape
- Drawing Lines and Arrows
- Creating and Editing Freeforms
- Copying and Moving Objects
- Adding a Quick Style to a Shape
- Adding a Quick Style to Shape Text
- Applying Color Fills
- Applying Picture Fills
- Applying Texture Fills
- Applying Gradient Fills
- Applying Shape Effects
- Adding 3-D Effects to a Shape
- Adding 3-D Rotation Effects to a Shape
- Creating Shadows
- Aligning and Distributing Objects
- Connecting Shapes
- Selecting Objects Using the Selection Pane
- Changing Stacking Order
- Rotating and Flipping Objects
- Grouping and Ungrouping Shapes
-
9. Creating and Modifying Charts
- Introduction
- Understanding Chart Terminology
- Choosing the Right Type of Chart
- Creating a Chart
- Editing a Chart
- Moving and Resizing a Chart
- Selecting Chart Elements
- Changing Chart Elements
- Changing a Chart Type
- Changing a Chart Layout and Style
- Formatting Chart Elements
- Changing Chart Gridlines and Axes
- Changing Chart Titles
- Changing Chart Labels
- Pulling Out a Pie Slice
- Formatting Chart Data Series
- Formatting Chart Text
- Formatting Line and Bar Charts
- Changing the Chart Background
- Enhancing a Chart
- Editing Chart Data
- Adding and Deleting a Data Series
- Saving a Chart Template
- Managing Chart Templates
-
10. Analyzing Worksheet Data
- Introduction
- Understanding Tables
- Creating a Table
- Formatting a Table
- Creating or Modifying a Table Style
- Formatting Table Elements
- Creating Calculations in a Table
- Working with Tables
- Removing Table Rows and Columns
- Entering Data in a Table Using a Drop-Down List
- Sorting Data in a Table
- Displaying Parts of a Table with AutoFilter
- Creating Custom Searches
- Using Slicers to Filter a Table
- Exporting a Table to a SharePoint List
- Analyzing Data Using a PivotTable
- Analyzing Data Using a PivotChart
- Updating a PivotTable or PivotChart
- Modifying a PivotTable
- Formatting a PivotTable
- Working with PivotTable Data
- Using Slicers to Filter a PivotTable
- Display a Timeline to Filter a PivotTable
- Drilling into PivotTable Data
- Charting a PivotTable
- Presenting Data with Power View
- Working with PowerPivot
- Creating Groups and Outlines
- Converting Text to Columns
- Adding Data Validation to a Worksheet
- Creating a Drop-Down List
-
11. Building More Powerful Worksheets
- Introduction
- Using Data Analysis Tools
- Using the Euro Conversion
- Looking at Alternatives with Data Tables
- Asking “What If” with Goal Seek
- Creating Scenarios
- Using Solver
- Using Inquire Tools
- Using Lookup and Reference Functions
- Using Text Functions
- Summarizing Data Using Subtotals
- Summarizing Data Using Functions
- Using Date & Time Functions
- Using Logical Functions
- Using Financial Functions
- Using Math Functions
- Using Statistical Functions
- Using Information Functions
- Using Compatibility Functions
- Using Web Functions
-
12. Protecting and Securing a Workbook
- Introduction
- Inspecting Workbooks
- Protecting a Worksheet
- Locking or Unlocking Worksheet Cells
- Adding Security Encryption to a Workbook
- Adding Password Protection to a Workbook
- Adding a Digital Signature
- Adding a Signature Line
- Avoiding Harmful Attacks
- Using the Trust Center
- Selecting Trusted Publishers and Locations
- Setting Document Related Security Options
- Setting App Catalog Security Options
- Setting Add-in Security Options
- Setting ActiveX Security Options
- Setting Macro Security Options
- Changing Message Bar Security Options
- Setting Privacy Options
- Setting External Content Security Options
- Working with Office Safe Modes
- Marking a Workbook as Read-Only
-
13. Reviewing and Sharing Workbook Data
- Introduction
- Sharing Workbooks
- Creating and Reading a Cell Comment
- Editing and Deleting a Cell Comment
- Tracking Workbook Changes
- Sending a Workbook Using E-Mail
- Sending a Workbook by Internet Fax
- Sending a Workbook by Instant Message
- Presenting a Workbook Online
- Sharing Information Between Programs
- Linking Data
- Linking and Embedding Files
- Exporting and Importing Data
- Consolidating Data
- Getting External Data
- Getting Text Data
- Connecting to External Data
- Getting Query Data from a Database
- Getting Data from Microsoft Access
- Working with XML
- Creating an XML Data Map
- Saving or Exporting Data in XML
-
14. Publishing Workbook Data as Web Pages
- Introduction
- Opening a Workbook as a Web Page
- Previewing a Web Page
- Creating a Hyperlink
- Formatting a Hyperlink
- Changing Web Page Options
- Saving a Worksheet as a Web Page
- Publishing a Web Page
- Copying a Web Table to a Worksheet
- Creating Refreshable Web Queries
- Getting Data from Web Queries
- Getting Documents from the Web
-
15. Tools for Working More Efficiently
- Introduction
- Setting General Excel Options
- Setting New Workbook and Start Up Options
- Setting Editing Options
- Setting Image Options
- Setting Chart Options
- Setting Workbook and Worksheet Display Options
- Setting Display View Options
- Setting Advanced Options
- Setting Formula Options
- Changing Advanced Document Properties
- Customizing the Way You Create Objects
- Accessing Commands Not in the Ribbon
- Working with Office Tools
- Maintaining and Repairing Office
-
16. Expanding Excel Functionality
- Introduction
- Adding and Inserting Apps for Office
- Viewing and Managing Add-ins
- Loading and Unloading Add-ins
- Enhancing a Workbook with VBA
- Viewing the Visual Basic Editor
- Setting Developer Options
- Understanding How Macros Automate Your Work
- Recording a Macro
- Creating a Macro
- Running a Macro
- Controlling a Macro
- Adding a Digital Signature to a Macro Project
- Assigning a Macro to a Toolbar or Ribbon
- Saving a Workbook with Macros
- Opening a Workbook with Macros
- Inserting ActiveX Controls
- Using ActiveX Controls
- Setting ActiveX Control Properties
- Adding VBA Code to an ActiveX Control
-
17. Working Online with Office Documents
- Introduction
- Working Online with SharePoint and SkyDrive
- Signing in to SharePoint or SkyDrive
- Saving and Opening on SharePoint or SkyDrive
- Accessing Documents on SharePoint
- Syncing Documents on SharePoint
- Sharing Documents on SkyDrive
- Accessing Documents on SkyDrive
- Managing Documents on SkyDrive
- Downloading or Uploading Documents on SkyDrive
- Creating Office Documents on SkyDrive
- Sending Links to Documents on SkyDrive
- Comparing the Office Desktop App to the Web App
- Working with Office Web Apps
- Saving or Printing Documents in Office Web Apps
- Co-authoring Documents with Office Web Apps
- New! Features
- Microsoft Office Specialist
- Index
- Online Workshop
Product information
- Title: Excel® 2013 On Demand
- Author(s):
- Release date: February 2013
- Publisher(s): Que
- ISBN: 9780133353136
You might also like
book
Excel® 2013 In Depth
Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing …
book
Easy Office 2016
Easy Office 2016 See it done. do it yourself. It’s that Easy! Easy Office 2016 teaches …
book
Excel® 2013 Formulas and Functions
Master core Excel 2013 tools for building powerful, reliable spreadsheets! Excel expert Paul McFedries shows how …
book
Using Microsoft® Excel® 2010
Get comfortable with the latest versions of Microsoft Excel, Microsoft Excel Starter, and the Excel Web …