Skills for Success with Excel 2013 Comprehensive

Common Features of Office 2013 Skill 1 Start Office Applications Skill 2 Create Documents from Templates Skill 3 Type and Edit Text Skill 4 Save Files in New Folders Skill 5 Apply Themes and Format Text Skill 6 Preview and Print Documents Skill 7 Open and Save Student Data Files Skill 8 Edit and Format Spreadsheets Skill 9 Copy and Paste and Format Slides Skill 10 Format Access Reports Skill 11 Store Documents on SkyDrive Skill 12 Use Office Help Skill 13 Send Files as E-mail Attachments Skill 14 Optimize Office for Tablets Web App Project: Share SkyDrive Files and Folders Chapter 1 Create Workbooks with Excel 2013 1.1 Create and Save Workbooks 1.2 Enter Data and Merge and Center Titles 1.3 Construct Addition and Subtraction Formulas 1.4 Construct Multiplication and Division Formulas 1.5 Adjust Column Widths and Apply Cell Styles 1.6 Insert the SUM Function 1.7 AutoFill Formulas and Data 1.8 Format, Edit, and Check Spelling 1.9 Insert Footers and Adjust Page Settings 1.10 Display Formulas and Print Worksheets More Skills 11 Create Workbooks from Templates More Skills 12 Insert Names into Formulas More Skills 13 Create Templates More Skills 14 Manage Document Properties Chapter 2 Insert Summary Functions and Create Charts Skill 1 Align and Wrap Text Skill 2 Apply Absolute Cell References Skill 3 Format Numbers Skill 4 Insert the AVERAGE Function Skill 5 Insert the MIN and MAX Functions Skill 6 Create Column Charts Skill 7 Format Column Charts Skill 8 Create and Format Pie Charts Skill 9 Update Charts and Insert WordArt Skill 10 Preview and Print Multiple Worksheets More Skills 11 Insert, Edit, and Delete Comments More Skills 12 Change Chart Types More Skills 13 Copy Excel Data to Word Documents More Skills 14 Fill Data with Flash Fill Chapter 3 Manage Multiple Worksheets Skill 1 Organize Worksheet Tabs Skill 2 Enter and Format Dates Skill 3 Clear Cell Contents and Formats Skill 4 Move Cell Contents and Use Paste Options Skill 5 Enter Data in Grouped Worksheets Skill 6 Insert Multiple Math Operators in Formulas Skill 7 Format Grouped Worksheets Skill 8 Insert, Hide, Delete, and Move Worksheets Skill 9 Create Summary Worksheets Skill 10 Create Clustered Bar Charts More Skills 11 Create Organization Charts More Skills 12 Create Line Charts More Skills 13 Set and Clear Print Areas More Skills 14 Create, Edit, and Delete Hyperlinks Chapter 4 More Functions and Excel Tables Skill 1 Use the TODAY, NOW, and COUNT Functions Skill 2 Use the IF Function Skill 3 Move Ranges with Functions, Add Borders, and Rotate Text Skill 4 Apply Conditional Formats with Custom Formats and Data Bars Skill 5 Insert Sparkines Skill 6 Use Find and Replace 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 11 Apply Conditional Color Scales with Top and Bottom Rules, and Clear Rules More Skills 12 Use the Payment (PMT) Function More Skills 13 Create PivotTable Reports More Skills 14 Use Goal Seek Web App Project: Create Excel Web App Workbooks Chapter 5 Format Cells and Worksheets 5.1 Insert Symbols and Create Custom Number Formats 5.2 Format Cells with the Format Painter 5.3 Apply Icon Sets as Conditional Formatting 5.4 Insert Formulas into Conditional Formatting Rules 5.5 Insert and Delete Rows, Columns, and Cells 5.6 Modify Cell Backgrounds and Borders 5.7 Create and Apply Custom Cell Styles 5.8 Customize, Save, and Apply Themes 5.9 Add Watermarks and Modify Background Colors 5.10 Hide Gridlines and Column and Row Headings 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 Screenshots Chapter 6 More Functions and Formulas 6.1 Modify Text Using Text Functions 6.2 Use Paste Options to Change Underlying Values 6.3 Look Up Data Using Lookup Functions 6.4 Edot Conditions in Logical Functions 6.5 Apply COUNTA and COUNTIF Functions 6.6 Perform What-If Analyses Using the Scenario Manager 6.7 Estimate Future Value 6.8 Insert Array Formulas 6.9 Calculate Conditional Sums 6.10 Calculate Conditional Averages More Skills 11 Use Web Functions More Skills 12 Use Solver More Skills 13 Delete Duplicate Records More Skills 14 Update Data with External Data Links Chapter 7 Work With Data and Audit Formulas 7.1 Import Data from Text Files 7.2 Apply Advanced AutoFilters 7.3 Sort Data Based on Using Conditional Formatting 7.4 Sort Data and Use the Subtotal Tool to Summarize Data 7.5 Trace and Evaluate Formulas 7.6 Audit Formulas Using Cell Watch 7.7 Create One-Variable Data Tables 7.8 Create Two-Variable Data Tables 7.9 Generate Custom Table Quick Styles 7.10 Convert Tables to Ranges 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 Manage and Present Data Visually 8.1 Import and TRIM data from Non-Native Files 8.2 Use LEFT, RIGHT, and MID Functions 8.3 Add Legends and Data Series to Charts 8.4 Enhance Charts with Trendlines and Text Boxes 8.5 Modify Excel Worksheet Templates 8.6 Consolidate Worksheet Data 8.7 Construct Dual Axis Charts 8.8 Create and Edit Custom Chart Templates 8.9 Edit and Save Excel File Type Versions 8.10 Send Workbook Files via E-mail and SkyDrive More Skills 11 Modify Charts and Graph Parameters More Skills 12 Insert and Edit SmartArt Charts More Skills 13 Embed Worksheet Data in a Web Page More Skills 14 Present a Workbook Online Chapter 9 Link and Analyze Data in PivotTables and PivotCharts 9.1 Use PowerPivot to Link Data with Access Databases 9.2 Create PivotTable Reports and Change PivotTable Report Views 9.3 Change Calculation Types and Format PivotTable Reports 9.4 Create PivotTable Report Calculated Fields 9.5 Use Cube Functions to Create Calculated Fields 9.6 Group and Filter PivotTable Reports 9.7 Use Slicers to Filter PivotTable Report 9.8 Create PivotChart Reports from External Data Sources 9.9 Use Power View to Create PivotChart Reports from PivotTable Reports 9.10 Change PivotChart Report Types and Print PivotChart Reports More Skills 11 Import and Export XML data More Skills 12 Create Web Queries and Clear Hyperlinks More Skills 13 Use Strict Converter More Skills 14 Use Inquire Add-in Chapter 10 Secure and Share Workbooks 10.1 Modify Excel Options and Word with Comments 10.2 Validate Data with Data Entry Rules 10.3 Track Changes 10.4 Accept and Reject Tracked Changes 10.5 Merge Changes 10.6 Use the Document Inspector to Remove Personal Information 10.7 Save Workbooks as Web Pages 10.8 Unlock Cells and Protect Worksheets 10.9 Record Macros 10.10 Write Macros Using VBA More Skills 11 Insert Form Controls More Skills 12 Set Form Properties More Skills 13 Assign a Macro to a Command Button More Skills 14 Add a Macro Button to the Quick Access Toolbar