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