| |
| |
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 | |
| |
| |
More Knowledge Read-Only | |
| |
| |
| |
Sign In to Office and Explore Options for a Microsoft Office Desktop App | |
| |
| |
| |
Perform Commands from the Ribbon and Quick Access Toolbar | |
| |
| |
More Knowledge Customizing the Ribbon | |
| |
| |
| |
Apply Formatting in Office Programs | |
| |
| |
More Knowledge Zooming to Page Width | |
| |
| |
| |
Compress Files and Use the Microsoft Office 2013 Help System | |
| |
| |
| |
Install Apps for Office and Create a Microsoft Account | |
| |
| |
Summary, GO! Learn It Online | |
| |
| |
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 | |
| |
| |
More Knowledge Inserting a Watermark | |
| |
| |
| |
Printing a Section of the Worksheet | |
| |
| |
| |
Changing Page Orientation and Displaying, Printing, and Hiding Formulas | |
| |
| |
| |
Creating a Sales Report with Embedded Column Chart Using the Excel Web App | |
| |
| |
| |
Inventory Valuation | |
| |
| |
More Knowledge Calculate a Percentage if You Know the Total and the Amount | |
| |
| |
More Knowledge Hiding Rows and Columns | |
| |
| |
Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
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 | |
| |
| |
More Knowledge NOW Function Recalculates Each Time a Workbook Opens | |
| |
| |
| |
Use Date & Time Functions and Freeze Panes | |
| |
| |
| |
Using the NOW Function to Display a System Date | |
| |
| |
| |
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 | |
| |
| |
More Knowledge Band Rows and Columns in a Table | |
| |
| |
| |
Filtering an Excel Table and Displaying a Total Row | |
| |
| |
| |
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 | |
| |
| |
| |
Sort, Filter, and Use Functions in a Table | |
| |
| |
| |
Weekly Sales Summary | |
| |
| |
More Knowledge Copying a Worksheet | |
| |
| |
More Knowledge Clearing an Entire Worksheet | |
| |
| |
More Knowledge Hide Worksheets | |
| |
| |
Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
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 | |
| |
| |
| |
Creating a JPEG Photo of a Chart and Uploading It to a OneNote Web App Notebook | |
| |
| |
| |
Tourism Spending Projection with Line Chart | |
| |
| |
More Knowledge Use of Parentheses in a Formula | |
| |
| |
More Knowledge Percentage Calculations | |
| |
| |
More Knowledge Percent Increase or Decrease | |
| |
| |
More Knowledge Resizing a Chart | |
| |
| |
Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
Glossary | |
| |
| |
Skills Review | |
| |
| |
Mastering Excel | |
| |
| |
Rubric | |
| |
| |
GO! Think | |
| |
| |
| |
Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets | |
| |
| |
| |
Amortization Schedule and -Merchandise Costs | |
| |
| |
| |
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 | |
| |
| |
| |
Use Defined Names in a Formula | |
| |
| |
| |
Defining a Name | |
| |
| |
| |
Inserting New Data into a Named Range | |
| |
| |
| |
Creating a Defined Name by Using Row and Column Titles | |
| |
| |
| |
Using Defined Names in a Formula | |
| |
| |
| |
Lookup Form and Revenue Report | |
| |
| |
More Knowledge Creating Validation Messages | |
| |
| |
More Knowledge | |
| |
| |
Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
Glossary | |
| |
| |
Skills Review | |
| |
| |
Mastering Excel | |
| |
| |
Rubric | |
| |
| |
GO! Think | |
| |
| |
| |
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 | |
| |
| |
More Knowledge Converting a Tab Delimited Text File to a Word Table | |
| |
| |
| |
Sorted, Filtered, and Outlined Database | |
| |
| |
More Knowledge A Custom List Remains Available for All Workbooks in Excel | |
| |
| |
More Knowledge Using Wildcards | |
| |
| |
Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
Glossary | |
| |
| |
Skills Review | |
| |
| |
Mastering Excel | |
| |
| |
Rubric | |
| |
| |
GO! Think | |
| |
| |
| |
Creating Charts, Diagrams, and Templates | |
| |
| |
| |
Attendance Charts and Diagrams | |
| |
| |
| |
Create and Format Sparklines and a Column Chart | |
| |
| |
| |
Creating and Formatting Sparklines | |
| |
| |
| |
Creating a Column Chart | |
| |
| |
More Knowledge Sizing Handles and Selection Handles | |
| |
| |
| |
Changing the Display of Chart Data | |
| |
| |
More Knowledge Changing the Data in a Chart | |
| |
| |
| |
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 | |
| |
| |
| |
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 | |
| |
| |
| |
Adding Effects to a SmartArt Graphic | |
| |
| |
| |
Preparing Worksheets Containing Charts and Diagrams for Printing | |
| |
| |
| |
Order Form Template | |
| |
| |
More Knowledge Setting the Default Font for New Worksheets | |
| |
| |
More Knowledge Modifying a Template | |
| |
| |
Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
Glossary | |
| |
| |
Skills Review | |
| |
| |
Mastering Excel | |
| |
| |
Rubric | |
| |
| |
GO! Think | |