| |
| |
Office | |
| |
| |
| |
Introduction to Microsoft Office 2013 Features | |
| |
| |
| |
Note Form | |
| |
| |
| |
Use File Explorer to Download, Extract, and Locate Files and Folders | |
| |
| |
| |
Using File Explorer to Download, Extract, and Locate Files and Folders | |
| |
| |
| |
Use Start Search to Locate and Start a Microsoft Office 2013 Desktop App | |
| |
| |
| |
Using Start Search to Locate and Start a Microsoft Office 2013 Desktop App | |
| |
| |
| |
Enter, Edit, and Check the Spelling of Text in an Office 2013 Program | |
| |
| |
| |
Entering and Editing Text in an Office 2013 Program | |
| |
| |
| |
Checking Spelling | |
| |
| |
| |
Perform Commands from a Dialog Box | |
| |
| |
| |
Performing Commands from a Dialog Box | |
| |
| |
| |
Using Undo | |
| |
| |
| |
Create a Folder and Name and Save a File | |
| |
| |
| |
Creating a Folder and Naming and Saving a File | |
| |
| |
| |
Insert a Footer, Add Document Properties, Print a File, and Close a Desktop App | |
| |
| |
| |
Inserting a Footer, Inserting Document Info, and Adding Document Properties | |
| |
| |
| |
Printing a File and Closing a Desktop App | |
| |
| |
| |
Memo | |
| |
| |
| |
Open an Existing File and Save It with a New Name | |
| |
| |
| |
Opening an Existing File and Saving It with a New Name | |
| |
| |
More Knowledge Read-only | |
| |
| |
| |
Sign In to Office and Explore Options for a Microsoft Office Desktop App | |
| |
| |
| |
Signing In to Office and Viewing Application Options | |
| |
| |
| |
Perform Commands from the Ribbon and Quick Access Toolbar | |
| |
| |
| |
Performing Commands from and Customizing the Ribbon and the Quick Access Toolbar | |
| |
| |
More Knowledge Customizing the Ribbon | |
| |
| |
| |
Minimizing and Using the Keyboard to Control the Ribbon | |
| |
| |
| |
Apply Formatting in Office Programs | |
| |
| |
| |
Changing Page Orientation and Zoom Level | |
| |
| |
More Knowledge Zooming to Page Width | |
| |
| |
| |
Formatting Text by Using Fonts, Alignment, Font Colors, and Font Styles | |
| |
| |
| |
Using Format Painter | |
| |
| |
| |
Using Keyboard Shortcuts and Using the Clipboard to Copy, Cut, and Paste | |
| |
| |
| |
Compress Files and Use the Microsoft Office 2013 Help System | |
| |
| |
| |
Compressing Files | |
| |
| |
| |
Using the Microsoft Office 2013 Help System in Excel | |
| |
| |
| |
Install Apps for Office and Create a Microsoft Account | |
| |
| |
| |
Installing Apps for Office | |
| |
| |
| |
Creating a Microsoft Account | |
| |
| |
Summary, GO! Learn It Online | |
| |
| |
Guide to Chapter Assessments | |
| |
| |
Glossary | |
| |
| |
Excel Introduction to Microsoft Excel 2013 | |
| |
| |
| |
Creating a Worksheet and Charting Data | |
| |
| |
| |
Sales Report with Embedded Column Chart and Sparklines | |
| |
| |
| |
Create, Save, and Navigate an Excel Workbook | |
| |
| |
| |
Starting Excel, Navigating Excel, and Naming and Saving a Workbook | |
| |
| |
More Knowledge Creating a New Workbook by Using a Template | |
| |
| |
| |
Enter Data in a Worksheet | |
| |
| |
| |
Entering Text, Using AutoComplete, and Using the Name Box to Select a Cell | |
| |
| |
| |
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, Cell Styles, and Themes | |
| |
| |
| |
Using Merge & Center and Applying Cell Styles | |
| |
| |
| |
Formatting Financial Numbers | |
| |
| |
| |
Changing the Workbook Theme | |
| |
| |
More Knowledge Formatting a Cell's Font, Style, Size, or Color with Individual Commands | |
| |
| |
| |
Chart Data to Create a Column Chart and Insert Sparklines | |
| |
| |
| |
Charting Data and Using Recommended Charts to Select and Insert a Column Chart | |
| |
| |
| |
Using the Chart Tools to Apply Chart Styles | |
| |
| |
| |
Creating and Formatting Sparklines | |
| |
| |
| |
Print a Worksheet, Display Formulas, and Close Excel | |
| |
| |
| |
Creating a Footer and Centering a Worksheet | |
| |
| |
| |
Adding Document Properties and Printing a Workbook | |
| |
| |
| |
Printing a Section of the Worksheet | |
| |
| |
| |
Changing Page Orientation and Displaying, Printing, and Hiding Formulas | |
| |
| |
More Knowledge Inserting a Watermark | |
| |
| |
GO! with Office Web Apps | |
| |
| |
Objective Create a Sales Report with an Embedded Column Chart Using the Excel Web App | |
| |
| |
Activity Creating a Sales Report with Embedded Column Chart Using the Excel Web App | |
| |
| |
| |
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 Operator | |
| |
| |
| |
Using the Quick Analysis Tool | |
| |
| |
| |
Copying Formulas Containing Absolute Cell References | |
| |
| |
More Knowledge Calculate a Percentage if You Know the Total and the Amount | |
| |
| |
| |
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 | |
| |
| |
More Knowledge Hiding Rows and Columns | |
| |
| |
| |
Adjusting Column Widths and Wrapping Text | |
| |
| |
| |
Changing Theme Colors | |
| |
| |
GO! with Office Web Apps | |
| |
| |
Objective Calculate the Value of an Inventory in the Excel Web App | |
| |
| |
Activity Creating an Inventory Valuation Report in the Excel Web App | |
| |
| |
GO! with Microsoft Office 365 | |
| |
| |
Activity Using the Exchange Online Outlook Meeting Tool to Collaborate | |
| |
| |
Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
Guide to Chapter Assessments | |
| |
| |
Glossary | |
| |
| |
Skills Review | |
| |
| |
Mastering Excel | |
| |
| |
Rubric | |
| |
| |
GO! Think | |
| |
| |
| |
Using Functions, Creating Tables, and Managing Large Workbooks | |
| |
| |
| |
Inventory Status Report | |
| |
| |
| |
Use Flash Fill and the Sum, Average, Median, Min, and Max Functions | |
| |
| |
| |
Using Flash Fill | |
| |
| |
| |
Moving a Column | |
| |
| |
| |
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 COUNT and Countif Functions | |
| |
| |
| |
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 | |
| |
| |
More Knowledge NOW Function Recalculates Each Time a Workbook Opens | |
| |
| |
| |
Freezing and Unfreezing Panes | |
| |
| |
More Knowledge Freeze Columns or Freeze Both Rows and Columns | |
| |
| |
| |
Create, Sort, and Filter an Excel Table | |
| |
| |
| |
Creating an Excel Table and Applying a Table Style | |
| |
| |
| |
Sorting an Excel Table | |
| |
| |
| |
Filtering an Excel Table and Displaying a Total Row | |
| |
| |
More Knowledge Band Rows and Columns in a Table | |
| |
| |
| |
Clearing Filters and Converting a Table to a Range of Data | |
| |
| |
| |
View, Format, and Print a Large Worksheet | |
| |
| |
| |
Modifying and Shrinking the Worksheet View | |
| |
| |
| |
Splitting a Worksheet Window into Panes | |
| |
| |
| |
Printing Titles and Scaling to Fit | |
| |
| |
More Knowledge Scaling for Data That Is Slightly Larger Than the Printed Page | |
| |
| |
GO! with Office Web Apps | |
| |
| |
Objective Sort, Filter, and Use Functions in a Table in Excel Web App | |
| |
| |
Activity Sort, Filter, and Use Functions in a Table | |
| |
| |
| |
Weekly Sales Summary | |
| |
| |
| |
Navigate a Workbook and Rename Worksheets | |
| |
| |
| |
Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of Worksheets | |
| |
| |
More Knowledge Copying a Worksheet | |
| |
| |
| |
Enter Dates, Clear Contents, and Clear Formats | |
| |
| |
| |
Entering and Formatting Dates | |
| |
| |
| |
Clearing Cell Contents and Formats | |
| |
| |
More Knowledge Clearing an Entire Worksheet | |
| |
| |
| |
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 | |
| |
| |
More Knowledge Hide Worksheet | |
| |
| |
| |
Formatting and Constructing Formulas on Grouped Worksheets | |
| |
| |
| |
Determining Multiple Totals at the Same Time | |
| |
| |
| |
Formatting Grouped Worksheets | |
| |
| |
| |
Create a Summary Sheet with Column Sparklines | |
| |
| |
| |
Ungrouping Worksheets | |
| |
| |
| |
Inserting a Worksheet | |
| |
| |
| |
Constructing Formulas That Refer to Cells in Another Worksheet | |
| |
| |
| |
Changing Values in a Detail Worksheet to Update a Summary Worksheet | |
| |
| |
| |
Inserting Column Sparklines | |
| |
| |
| |
Format and Print Multiple Worksheets in a Workbook | |
| |
| |
| |
Moving a Worksheet, Repeating Footers, and Formatting Multiple Worksheets in a Workbook | |
| |
| |
| |
Printing All or Individual Worksheets in a Workbook | |
| |
| |
GO! with Office Web Apps | |
| |
| |
Objective Summarize the Data on Multiple Worksheets in Excel Web App | |
| |
| |
Activity Creating an Inventory Valuation Report in the Excel Web App | |
| |
| |
GO! with Microsoft Office 365 | |
| |
| |
Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
Guide to Chapter Assessments | |
| |
| |
Glossary | |
| |
| |
Skills Review | |
| |
| |
Mastering Excel | |
| |
| |
Rubric | |
| |
| |
GO! Think | |
| |
| |
| |
Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools | |
| |
| |
| |
Enterprise Fund Pie Chart | |
| |
| |
| |
Chart Data with a Pie Chart | |
| |
| |
| |
Calculating Values for a Pie Chart | |
| |
| |
| |
Creating a Pie Chart in a Chart Sheet | |
| |
| |
| |
Format a Pie Chart | |
| |
| |
| |
Formatting a Chart Title by Applying a WordArt Style and Changing Font Size | |
| |
| |
| |
Formatting Chart Elements by Removing a Legend and Adding and Formatting Data Labels | |
| |
| |
| |
Formatting a Data Series with 3-D Effects | |
| |
| |
| |
Formatting a Data Series with a Shadow Effect | |
| |
| |
| |
Rotating a Pie Chart by Changing the Angle of the First Slice | |
| |
| |
| |
Exploding and Coloring a Pie Slice | |
| |
| |
| |
Formatting the Chart Area | |
| |
| |
| |
Edit a Workbook and Update a Chart | |
| |
| |
| |
Editing a Workbook and Updating a Chart | |
| |
| |
| |
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 | |
| |
| |
GO! with Office Web Apps | |
| |
| |
Objective Create a Jpeg Photo of a Chart and Upload to a OneNote Web App Notebook | |
| |
| |
Activity Creating a Jpeg Photo of a Chart and Uploading It to a OneNote Web App Notebook | |
| |
| |
| |
Tourism Spending Projection with Line Chart | |
| |
| |
| |
Design a Worksheet for What-If Analysis | |
| |
| |
| |
Using Parentheses in a Formula to Calculate a Percentage Rate of Increase | |
| |
| |
More Knowledge Use of Parentheses in a Formula | |
| |
| |
| |
Using Format Painter | |
| |
| |
More Knowledge Percentage Calculations | |
| |
| |
| |
Calculating a Value After an Increase | |
| |
| |
More Knowledge Percent Increase or Decrease | |
| |
| |
| |
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 Area in a Line Chart | |
| |
| |
| |
Formatting the Plot Area Gridlines and Axis Fonts in a Line Chart | |
| |
| |
More Knowledge Resizing a Chart | |
| |
| |
GO! with Office Web Apps | |
| |
| |
Objective Convert an Excel Worksheet to a Google Docs Spreadsheet with a Chart | |
| |
| |
Activity Converting an Excel Worksheet to a Google Docs Spreadsheet with a Chart | |
| |
| |
GO! with Microsoft Office 365 | |
| |
| |
Activity Using a Team Site to Collaborate | |
| |
| |
Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
Guide to Chapter Assessments | |
| |
| |
Glossary | |
| |
| |
Skills Review | |
| |
| |
Mastering Excel | |
| |
| |
Rubric | |
| |
| |
GO! Think | |