Microsoft Office 2010 is here! And this new release is aimed at making users more productive and efficient than ever.   Master the SKILLS of Excel 2010 with Kris Townsend's Skills for Success with Excel 2010 Comprehensive. Highly visual with bulleted, step-by-step instruction to give you the skills you need to succeed with all the features and components of Excel 2010.

Table of Contents:
Skills for Success with Excel Comprehensive Table of Contents Start! Common Features of Office 2010 Skill 1 Start Word and Navigate the Word Window Skill 2 Start Excel and PowerPoint and Work with Multiple Windows Skill 3 Save Files in New Folders Skill 4 Print and Save Documents Skill 5 Open Student Data Files and Save Copies Using Save As Skill 6 Type and Edit Text Skill 7 Cut, Copy, and Paste Text Skill 8 Format Text and Paragraphs Skill 9 Use the Ribbon Skill 10  Use Shortcut Menus and Dialog Boxes More Skills     More Skills 11 Capture Screens with the Snipping Tool       More Skills 12 Use Microsoft Office Help                    More Skills 13 Organize Files                    More Skills 14 Save Documents to Windows Live SkyDrive Chapter 1 Create Workbooks with Excel 2010 Skill 1  Create and Save New Workbooks Skill 2  Enter Worksheet Data and Merge and Center Titles Skill 3  Construct Addition and Subtraction Formulas Skill 4  Construct Multiplication and Division Formulas Skill 5  Adjust Column Widths and Apply Cell Styles Skill 6  Use the SUM Function Skill 7  Copy Formulas and Functions Using the Fill Handle Skill 8  Format, Edit, and Check the Spelling of Data Skill 9  Create Footers and Change Page Settings Skill 10  Display and Print Formulas and Scale Worksheets for Printing MORE SKILLS     More Skills 11 Create New Workbooks from Templates     More Skills 12 Use Range Names in Formulas     More Skills 13 Change Themes     More Skills 14 Manage Document Properties   Chapter 2 Create Charts Skill 1  Open Existing Workbooks and Align Text Skill 2  Construct and Copy Formulas Containing Absolute Cell References Skill 3  Format Numbers Skill 4  Create Column Charts Skill 5  Format Column Charts Skill 6  Create Pie Charts and Chart Sheets Skill 7  Apply 3-D Effects and Rotate Pie Chart Slices Skill 8  Explode and Color Pie Slices, and Insert Text Boxes Skill 9  Update Charts and Insert WordArt Skill 10  Prepare Chart Sheets for Printing MORE SKILLS     More Skills 11 Insert and Edit Comments     More Skills 12 Change Chart Types     More Skills 13 Copy Excel Data to Word Documents     More Skills 14 Fill Series Data into Worksheet Cells   Chapter 3 Manage Multiple Worksheets in a Workbook Skill 1  Work with Sheet Tabs Skill 2  Enter and Format Dates Skill 3  Clear Cell Contents and Formats Skill 4  Move, Copy, Paste and Paste Options Skill 5  Work with Grouped Worksheets Skill 6  Use Multiple Math Operators in a Formula Skill 7  Format Grouped Worksheets Skill 8  Insert and Move Worksheets Skill 9  Construct Formulas that Refer to Cells in Other Worksheets Skill 10  Create Clustered Bar Charts MORE SKILLS     More Skills 11 Create Organization Charts     More Skills 12 Create Line Charts     More Skills 13 Set and Clear Print Areas     More Skills 14 Insert Hyperlinks   Chapter 4 Using Excel Functions and Tables Skill 1  Use the SUM and AVERAGE Functions Skill 2  Use the MIN and MAX Functions Skill 3  Move Ranges with Functions, Add Borders, and Rotate Text Skill 4  Use the IF Function Skill 5  Apply Conditional Formatting with Custom Formats, Data Bars, and Sparklines Skill 6  Use Find and Replace and Insert the NOW Function Skill 7  Freeze and Unfreeze Panes Skill 8  Create and Sort Excel Tables Skill 9  Use the Search Filter in Excel Tables Skill 10  Convert Tables to Ranges, Hide Rows and Columns, and Format Large Worksheets MORE SKILLS     More Skills 11 Apply Conditional Color Scales with Top and Bottom Rules     More Skills 12 Use the Payment (PMT) Function     More Skills 13 Create PivotTable Reports     More Skills 14 Use Goal Seek   Chapter 5: Format Cells and Worksheets Skill 1 Insert Symbols and Create Custom Number Formats Skill 2 Format Cells With the Format Painter Skill 3 Apply Icon Sets as Conditional Formatting Skill 4 Use Formulas to Write Multiple Conditional Formatting Rules Skill 5 Insert and Delete Rows, Columns, and Cells Skill 6 Change Cell Backgrounds and Modify Borders Skill 7 Create and Apply Custom Cell Styles Skill 8 Customize, Save, and Apply Themes Skill 9 Add Watermarks and Modify Background Colors Skill 10 Hide Gridlines and Column and Row Headings MORE SKILLS     More Skills 11 Copy Styles Between Workbooks     More Skills 12 Draw Borders     More Skills 13 Convert Comma Separated Text into Columns     More Skills 14 Create Screen Clippings   Chapter 6: Work with Advanced Functions and Formulas Skill 1 Modify Text Using Text Functions Skill 2 Use Paste Options to Change Underlying Values Skill 3 Write Nested IF Functions Skill 4 Look Up Data using Lookup Functions Skill 5 Apply Logical Functions Skill 6 Use COUNTA and COUNTIF Functions Skill 7 Use the Scenario Manager to Perform What-If Analysis Skill 8 Calculate Future Value Skill 9 Use Goal Seek Skill 10 Calculate Conditional Sums MORE SKILLS     More Skills 11 Query Tables Using Criteria Ranges     More Skills 12 Use Solver     More Skills 13 Delete Duplicate Records     More Skills 14 Use External Links to Update Data   Chapter 7: Work with Data and Audit Formulas Skill 1 Import Data from Text Files Skill 2 Sort Data and Apply Advanced AutoFilters Skill 3 Sort Data Based on Conditional Formatting Skill 4 Use the Subtotal Tool to Summarize Data Skill 5 Trace and Evaluate Formulas Skill 6 Audit Formulas Using Cell Watch Skill 7 Create One-Variable Data Tables Skill 8 Create Two-Variable Data Tables Skill 9 Create Custom Table Quick Styles Skill 10 Convert Tables to Ranges MORE SKILLS     More Skills 11 Create Amortization Tables     More Skills 12 Use the ROUND Function     More Skills 13 Use Information Functions     More Skills 14 Sort Tables Based on Multiple Criteria   Chapter 8: Insert and Format Graphics and Shapes Skill 1 Insert Graphics into Headers Skill 2 Resize, Crop, and Compress Images Skill 3 Insert, Modify, and Remove Backgrounds from Clip Art Skill 4 Recolor Graphics and Apply Artistic Effects Skill 5 Create SmartArt Organization Charts Skill 6 Apply Quick Styles and Resize SmartArt Skill 7 Resize and Position SmartArt Shapes Skill 8 Format Individual SmartArt Shapes Skill 9 Insert and Format Shapes Skill 10 Group and Resize Shapes MORE SKILLS     More Skills 11 Add Alternate Text to Graphics     More Skills 12 Add Graphics to SmartArt Shapes     More Skills 13 Convert Graphics to SmartArt Shapes and Use the Selection and Visibility Pane     More Skills 14 Insert PowerPoint Slides Into Worksheets   Chapter 9: Import Data, Create PivotTable Reports and PivotChart Reports Skill 1 Import Data from Access Databases Skill 2 Create PivotTable Reports Skill 3 Change PivotTable Report Views Skill 4 Change Calculation Types and Format PivotTable Reports Skill 5 Create PivotTable Report Calculated Fields Skill 6 Group and Filter PivotTable Reports Skill 7 Slice PivotChart Report Views Skill 8 Create PivotChart Reports from External Data Sources Skill 9 Create PivotChart Reports from PivotTable Reports Skill 10 Format PivotChart Reports MORE SKILLS     More Skills 11 Import Word 2010 Tables     More Skills 12 Create Web Queries and Clear Hyperlinks     More Skills 13 Change PivotChart Report Types and Print PivotChart Reports     More Skills 14 Use Paste Special   Chapter 10: Share Workbooks and Create Macros Skill 1 Modify Excel Options and Work With Comments Skill 2 Validate Data with Data Entry Rules Skill 3 Track Changes Skill 4 Accept and Reject Tracked Changes Skill 5 Merge Changes Skill 6 Use the Document Inspector to Remove Personal Information Skill 7 Save Workbooks as Web Pages Skill 8 Unlock Cells and Protect Worksheets Skill 9 Record Macros Skill 10 Write Macros Using VBA MORE SKILLS     More Skills 11 Hide Cells     More Skills 12 Modify the Ribbon     More Skills 13 Save a Workbook as a PDF File     More Skills 14 Add a Macro Button to the Quick Access Toolbar