Go! With Microsoft Excel 2010: Comprehensive With Cd-rom

Name: Go! With Microsoft Excel 2010: Comprehensive With Cd-rom
Availability: OutOfStock
ISBN: 9780132743792

ISBN-10: 0132743795

ISBN-13: 9780132743792

Edition: 2011

Authors: Shelley Gaskin, Alicia Vargas

List price: $122.00

30 day, 100% satisfaction guarantee!

Out of stock

We're sorry. This item is currently unavailable.

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

For introductory computer courses on Microsoft Excel 2010 or courses in computer concepts with a lab component on Excel. Teach the course YOU want in LESS TIME! The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clearly defined projects for students and a one-of-a-kind supplements package for instructors. 0132743795 / 9780132743792 GO WITH MICROSF EXCEL 2010 COMP& STDNT VIDSPackage consists of: 0135098211 / 9780135098219 GO! with Microsoft Excel 2010, Comprehensive0138007705 / 9780138007706 Student Videos for GO! with Microsoft Excel 2010, Comprehensive

Book details

List price: $122.00
Copyright year: 2011
Publisher: Pearson College Div
Binding: Paperback
Size: 10.00" wide x 11.00" long x 1.25" tall
Weight: 3.696
Language: English



Common Features



Using the Common Features of Microsoft Office 2010



PowerPoint File



Use Windows Explorer to Locate Files and Folders



Using Windows Explorer to Locate Files and Folders



Locate and Start a Microsoft Office 2010 Program



Locating and Starting a Microsoft Office 2010 Program



Enter and Edit Text in an Office 2010 Program



Entering and Editing Text in an Office 2010 Program



Perform Commands from a Dialog Box



Performing Commands from a Dialog Box



Create a Folder, Save a File, and Close a Program



Creating a Folder, Saving a File, and Closing a Program



Add Document Properties and Print a File



Adding Document Properties and Printing a File



Word File



Open an Existing File and Save it with a New Name



Opening an Existing File and Saving it with a New Name



Explore Options for an Application



Viewing Application Options



Perform Commands from the Ribbon



Performing Commands from the Ribbon



Minimizing and Using the Keyboard to Control the Ribbon



Apply Formatting in Office Programs



Formatting and Viewing Pages



Formatting Text



Using the Office Clipboard to Cut, Copy, and Paste



Viewing Print Preview and Printing a Word Document



Use the Microsoft Office 2010 Help System



Using the Microsoft Office 2010 Help System in Excel



Compress Files



Compressing Files


Excel



Creating a Worksheet and Charting Data



Sales Report with Embedded Column Chart and Sparklines



Create, Save, and Navigate an Excel Workbook



Starting Excel and Naming and Saving a Workbook



Navigating a Worksheet and a Workbook



Enter Data in a Worksheet



Entering Text and Using AutoComplete



Using Auto Fill and Keyboard Shortcuts



Aligning Text and Adjusting the Size of Columns



Entering Numbers



Construct and Copy Formulas and Use the SUM Function



Constructing a Formula and Using the SUM Function



Copying a Formula by Using the Fill Handle



Format Cells with Merge & Center and Cell Styles



Using Merge & Center and Applying Cell Styles



Formatting Financial Numbers



Chart Data to Create a Column Chart and Insert Sparklines



Charting Data in a Column Chart



Creating and Formatting Sparklines



Print, Display Formulas, and Close Excel



Changing Views, Creating a Footer, and Using Print Preview



Deleting Unused Sheets in a Workbook



Printing a Worksheet



Displaying, Printing, and Hiding Formulas



Inventory Valuation



Check Spelling in a Worksheet



Checking Spelling in a Worksheet



Enter Data by Range



Entering Data by Range



Construct Formulas for Mathematical Operations



Using Arithmetic Operators



Copying Formulas Containing Absolute Cell References



Edit Values in a Worksheet



Editing Values in a Worksheet



Formatting Cells with the Percent Style



Format a Worksheet



Inserting and Deleting Rows and Columns



Adjusting Column Widths and Wrapping Text



Using Functions, Creating Tables, and Managing Large Workbooks



Inventory Status Report



Use the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions



Using the SUM and AVERAGE Functions



Using the MEDIAN Function



Using the MIN and MAX Functions



Move Data, Resolve Error Messages, and Rotate Text



Moving Data and Resolving a # # # # # Error Message



Rotating Text



Use COUNTIF and IF Functions and Apply Conditional Formatting



Using the COUNTIF Function



Using the IF Function



Applying Conditional Formatting by Using Highlight


Cells Rules and Data Bars



Using Find and Replace



Use Date & Time Functions and Freeze Panes



Using the NOW Function to Display a System Date



Freezing and Unfreezing Panes



Create, Sort, and Filter an Excel Table



Creating an Excel Table



Sorting and Filtering an Excel Table



Converting a Table to a Range of Data



Format and Print a Large Worksheet



Printing Titles and Scaling to Fit



Weekly Sales Summary



Navigate a Workbook and Rename Worksheets



Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of Worksheets



Enter Dates, Clear Contents, and Clear Formats



Entering and Formatting Dates



Clearing Cell Contents and Formats



Copy and Paste by Using the Paste Options Gallery



Copying and Pasting by Using the Paste Options Gallery



Edit and Format Multiple Worksheets at the Same Time



Grouping Worksheets for Editing



Formatting and Constructing Formulas on Grouped Worksheets



Create a Summary Sheet with Column Sparklines



Constructing Formulas that Refer to Cells in Another Worksheet



Changing Values in a Detail Worksheet to Update a Summary Worksheet



Inserting Sparklines



Format and Print Multiple Worksheets in a Workbook



Moving and Formatting Worksheets in a Workbook



Printing All the Worksheets in a Workbook



Analyzing Data with Pie Charts, Line Charts, and What-If


Analysis Tools



Budget Pie Chart



Chart Data with a Pie Chart



Creating a Pie Chart and a Chart Sheet



Format a Pie Chart



Applying Percentages to Labels in a Pie Chart



Formatting a Pie Chart with 3-D



Rotating a Pie Chart



Exploding and Coloring a Pie Slice



Formatting the Chart Area



Inserting a Text Box in a Chart



Edit a Workbook and Update a Chart



Editing a Workbook and Updating a Chart



Inserting WordArt in a Worksheet



Use Goal Seek to Perform What-If Analysis



Using Goal Seek to Perform What-If Analysis



Preparing and Printing a Workbook with a Chart Sheet



Growth Projection with Line Chart



Design a Worksheet for What-If Analysis



Using Parentheses in a Formula to Calculate a Percentage Rate of Increase



Using Format Painter and Formatting as You Type



Calculating a Value After an Increase



Answer What-If Questions by Changing Values in a Worksheet



Answering What-If Questions and Using Paste Special



Chart Data with a Line Chart



Inserting Multiple Rows and Creating a Line Chart



Formatting Axes in a Line Chart



Formatting the Chart and Plot Areas



Preparing and Printing Your Worksheet



Excel Chapters 1-3



Use Financial and Lookup Functions, Define Names, and Validate Data



Amortization Schedule



Use Financial Functions



Inserting the PMT Financial Function



Use Goal Seek



Using Goal Seek to Produce a Desired Result



Using Goal Seek to Find an Increased Period



Create a Data Table



Designing a Two-Variable Data Table



Using a Data Table to Calculate Options



Quarterly Cost Report and Lookup Form



Define Names



Defining a Name



Inserting New Data into a Named Range



Changing A Defined Name



Creating a Defined Name by Using Row and Column Titles



Use Defined Names in a Formula



Using Defined Names in a Formula



Use Lookup Functions



Defining a Range of Cells for a Lookup Function



Inserting the VLOOKUP Function



Validate Data



Creating a Validation List



Managing Large Workbooks and Using Advanced Sorting and Filtering



Large Worksheet for a Class Schedule



Navigate and Manage Large Worksheets



Using the Go To Special Command



Hiding Columns



Using the Go To Command



Arranging Multiple Workbooks and Splitting Worksheets



Enhance Worksheets with Themes and Styles



Changing and Customizing a Workbook Theme



Creating and Applying a Custom Table Style



Format a Worksheet to Share with Others



Previewing and Modifying Page Breaks



Repeating Column or Row Titles



Inserting a Hyperlink in a Worksheet



Modifying a Hyperlink



Save Excel Data in Other File Formats



Viewing and Saving a Workbook as a Web Page



Saving Excel Data in CSV File Format



Saving Excel Data as a PDF or XPS File



Sorted, Filtered, and Outlined Database



Use Advanced Sort Techniques



Sorting on Multiple Columns



Sorting by Using a Custom List



Use Custom and Advanced Filters



Filtering by Format and Value Using AutoFilter



Filtering by Custom Criteria Using AutoFilter



Inserting the Sheet Name and Page Numbers in a Footer



Filtering by Using Advanced Criteria



Extracting Filtered Rows



Subtotal, Outline, and Group a List of Data



Subtotaling, Outlining, and Grouping a List of Data



Creating Charts, Diagrams, and Templates



Attendance Charts and Diagrams



Create and Format Sparklines and a 3-D Column Chart



Creating and Formatting Sparklines



Creating a 3-D Column Chart



Changing the Display of Chart Data



Editing and Formatting the Chart Title



Adding, Formatting, and Aligning Axis Titles



Editing Source Data



Formatting the Chart Floor and Chart Walls



Create and Format a Line Chart



Creating a Line Chart



Deleting a Legend and Changing a Chart Title



Changing the Values on the Value Axis



Formatting the Plot Area and the Data Series



Inserting a Trendline



Create and Modify a SmartArt Graphic



Creating a Process SmartArt Graphic



Modifying the Diagram Style



Create and Modify an Organization Chart



Creating and Modifying a SmartArt Organization Chart 3



Adding Effects to a SmartArt Graphic



Preparing Worksheets Containing Charts and Diagrams for Printing



Order Form Template



Create an Excel Template



Entering Template Text



Formatting a Template



Entering Template Formulas



Inserting and Modifying an Image



Inserting and Modifying a WordArt Image



Saving a File as a Template



Protect a Worksheet



Protecting a Worksheet



Create a Worksheet Based on a Template



Creating a Worksheet Based on a Template



Excel Chapters 4-6



Creating PivotTable and PivotChart Reports and Auditing Worksheets



PivotTable and PivotChart



Create a PivotTable Report



Creating a PivotTable Report



Adding Fields to a PivotTable Report



Use Slicers and Search Filters



Using a Slicer to Filter a PivotTable



Clearing Filters and Filtering by Using the Search Box



Modify a PivotTable Report



Rearranging a PivotTable Report



Displaying PivotTable Report Details in a New Worksheet



Displaying PivotTable Data on Separate Pages



Changing Calculations in a PivotTable Report



Formatting a PivotTable Report



Updating PivotTable Report Data



Create a PivotChart Report



Creating a PivotChart Report from a PivotTable Report



Modifying a PivotChart Report



Revenue Report for Formula Auditing



Trace Precedents and Dependents to Audit Worksheet Formulas



Using the Trace Precedents Command



Using the Trace Dependents Command



Using the Trace Dependents Command



Using the Trace Error Command



Use Error Checking to Audit Worksheet Formulas



Using Error Checking



Circling Invalid Data



Use the Watch Window to Monitor Cell Values



Using the Watch Window to Monitor Changes



Using the Data Analysis, Solver, and Scenario Features



Sales Analysis



Calculate a Moving Average



Creating a Custom Number Format



Calculating a Moving Average



Modifying the Moving Average Chart



Calculating Growth Based on a Moving Average



Project Income and Expenses



Projecting Income and Expenses



Determine a Break-Even Point



Charting the Break-Even Point With a Line Chart



Staffing Analysis



Use Solver



Installing Solver



Understanding a Solver Worksheet



Using Solver



Evaluate Complex Formulas



Evaluating Complex Formulas



Create Scenarios



Creating a Scenario Using the Scenario Manager



Creating a Scenario Using Solver



Creating a Scenario Summary



Using Macros and Visual Basic for Applications



Travel Expenses



Record a Macro



Adding the Developer Tab to the Ribbon



Changing the Macro Security Settings in Excel



Unprotecting a Workbook



Recording a Macro



Assign a Macro to a Button on the Quick Access Toolbar



Adding a Button to the Quick Access Toolbar



Testing the Macro Button



Modify a Macro



Changing the Visual Basic Code



VBA Procedure



Write a VBA Procedure to Use an ActiveX Control



Inserting ActiveX Controls



Changing the Properties of an ActiveX Control



Writing a VBA Procedure for a Command Button



Modifying a VBA Procedure



Testing the VBA Procedure and the ActiveX Control



Restore Initial Settings



Removing the Quick Access Toolbar Button and the Macro



Excel Chapters 7-9



External Data, Database Functions, and Side-by-Side


Tables



Medical Center Information



Get External Data into Excel



Importing Information into Excel from an Access Database



Importing Information into Excel from a Web Page



Importing Information into Excel from a Text File



Importing Information into Excel from an XML File



Create a Query and Use the Query Wizard to Sort and Filter



Creating a Query and Filtering and Sorting Data by Using the Query Wizard



Converting a Range and Formatting Imported Data



Use DAVERAGE and DSUM Database Functions



Using the DAVERAGE Database Function



Using the DSUM Database Function



Use DCOUNT and DGET Database Functions



Using DCOUNT



Using DGET



Office Equipment Inventory



Insert a Second Table into a Worksheet



Inserting a Second Table into a Worksheet



Sorting Side-by-Side Tables



Apply Conditional Formatting to Side-by-Side Tables



Applying Icon Sets to Side-by-Side Tables



Insert a Screenshot



Inserting a Screen Shot



Create Custom Headers and Footers



Creating Custom Headers and Footers



Collaborating with Others and Preparing a Workbook for Distribution



Summer Schedule



Create a Shared Workbook



Locating and Modifying Workbook Properties



Activating Track Changes to Create a Shared Workbook



Track Changes Made to a Workbook



Making a Copy of a Shared Workbook



Making Changes to a Shared Workbook



Making Changes to a Copy of the Shared Workbook



Merge Workbooks and Accept Changes



Merging Revisions



Accepting or Rejecting Tracked Changes



Removing the Shared Designation, Resetting the User Name, and Removing a Command from the Quick Access Toolbar



Adding a Signature Line



Distributed Workbook



Prepare a Final Workbook for Distribution



Ensuring Backward-Compatibility in a Workbook



Inspecting a Document



Encrypting a Workbook



Marking a Workbook as Final



Upload a Workbook to SkyDrive



Uploading a Workbook to SkyDrive



Excel Chapters 10-11


Glossary


Index