| |
| |
| |
Technology | |
| |
| |
Fundamentals | |
| |
| |
| |
Getting Started with Computer Concepts | |
| |
| |
| |
The Computer Is a System | |
| |
| |
| |
Common Operating Systems | |
| |
| |
| |
Input Devices | |
| |
| |
| |
Storage Devices | |
| |
| |
| |
Apps and Applications | |
| |
| |
| |
Networks | |
| |
| |
| |
Cloud Computing | |
| |
| |
| |
Share Files with Others | |
| |
| |
| |
Office 365 | |
| |
| |
| |
Buying a Computer | |
| |
| |
| |
Getting Started with Windows 8 | |
| |
| |
| |
Sign In to Windows 8 | |
| |
| |
| |
Work with Store Apps | |
| |
| |
| |
Create and Save Documents | |
| |
| |
| |
Search for Applications, Files, and Settings | |
| |
| |
| |
Download and Unzip Student Data Files | |
| |
| |
| |
View Files in File Explorer | |
| |
| |
| |
Search for and Copy Files | |
| |
| |
| |
Move, Rename, and Delete Files | |
| |
| |
| |
Personalize the Desktop and Create Snips | |
| |
| |
| |
Print, Restore Settings, and Sign Out | |
| |
| |
More Skills | |
| |
| |
| |
Customize the Start Screen | |
| |
| |
| |
Modify the Desktop | |
| |
| |
| |
Switch to a Microsoft Account | |
| |
| |
| |
Use the SkyDrive App | |
| |
| |
| |
Browse with Internet Explorer | |
| |
| |
| |
Browse from the Start Screen | |
| |
| |
| |
Browse from the Desktop and Add Favorites | |
| |
| |
| |
Navigate and Search Websites | |
| |
| |
| |
Use Accelerators and Search Providers | |
| |
| |
| |
Manage Browser Tabs | |
| |
| |
| |
Organize Favorites | |
| |
| |
| |
Print and Save Web Pages | |
| |
| |
| |
View and Delete Browsing History | |
| |
| |
| |
Protect Online Privacy | |
| |
| |
| |
Manage Pop-ups and Check Website Safety | |
| |
| |
More Skills | |
| |
| |
| |
Change Your Home Page | |
| |
| |
| |
Add Navigation Tiles to the Start Screen | |
| |
| |
| |
Add Tracking Protection | |
| |
| |
| |
Change Internet Security Settings | |
| |
| |
| |
Getting Started with Microsoft Office Applications | |
| |
| |
| |
Common Features of Office 2013 | |
| |
| |
| |
Start Office Applications | |
| |
| |
| |
Create Documents from Templates | |
| |
| |
| |
Type and Edit Text | |
| |
| |
| |
Save Files and Create Folders | |
| |
| |
| |
Apply Themes and Format Text | |
| |
| |
| |
Preview and Print Documents | |
| |
| |
| |
Open and Save Student Data Files | |
| |
| |
| |
Format Worksheets | |
| |
| |
| |
Copy and Paste Objects and Format Slides | |
| |
| |
| |
Format Access Reports | |
| |
| |
More Skills | |
| |
| |
| |
Store Office Files on SkyDrive | |
| |
| |
| |
Use Office Help | |
| |
| |
| |
Send Files as E-mail Attachments | |
| |
| |
| |
Optimize Office 2013 RT | |
| |
| |
| |
Microsoft Office | |
| |
| |
Microsoft Word | |
| |
| |
Introduction to Word | |
| |
| |
| |
Create Letters and Memos | |
| |
| |
| |
Type Letter Text | |
| |
| |
| |
Apply Styles and Set Grammar and Spelling Options | |
| |
| |
| |
Select and Insert Text | |
| |
| |
| |
Copy, Cut, and Paste Text | |
| |
| |
| |
Check Spelling and Grammar | |
| |
| |
| |
Check Writing Style and Insert Synonyms | |
| |
| |
| |
Use Format Painter | |
| |
| |
| |
Apply Advanced Font Settings | |
| |
| |
| |
Create Document Footers | |
| |
| |
| |
Save Documents as PDF Files | |
| |
| |
More Skills | |
| |
| |
| |
Prepare Documents for Distribution | |
| |
| |
| |
Insert Screen Shots into Documents | |
| |
| |
| |
Split and Arrange Windows | |
| |
| |
| |
Insert Symbols | |
| |
| |
| |
Create Business Reports | |
| |
| |
| |
Find and Replace Text | |
| |
| |
| |
Insert and Modify Footnotes | |
| |
| |
| |
Add Sources | |
| |
| |
| |
Insert Citations and Bibliographies | |
| |
| |
| |
Format Bulleted and Numbered Lists | |
| |
| |
| |
Set Paragraph Indents | |
| |
| |
| |
Modify Line and Paragraph Spacing | |
| |
| |
| |
Set Line and Page Break Options and Modify Styles | |
| |
| |
| |
View Multiple Pages and Set Margins | |
| |
| |
| |
Create Custom Headers and Footers | |
| |
| |
More Skills | |
| |
| |
| |
Record AutoCorrect Entries | |
| |
| |
| |
Use AutoFormat to Create Numbered Lists | |
| |
| |
| |
Format and Customize Lists | |
| |
| |
| |
Create Standard Outlines | |
| |
| |
| |
Create Flyers | |
| |
| |
| |
Insert Text and Pictures from Files | |
| |
| |
| |
Resize and Align Pictures | |
| |
| |
| |
Apply Picture Styles and Artistic Effects | |
| |
| |
| |
Set Tab Stops | |
| |
| |
| |
Type Tabbed Lists | |
| |
| |
| |
Apply Table Styles | |
| |
| |
| |
Create Tables | |
| |
| |
| |
Delete and Add Table Rows and Columns | |
| |
| |
| |
Format Text in Table Cells | |
| |
| |
| |
Format Tables | |
| |
| |
More Skills | |
| |
| |
| |
Insert Text Boxes | |
| |
| |
| |
Format with WordArt | |
| |
| |
| |
Convert Text into Tables | |
| |
| |
| |
Insert Drop Caps | |
| |
| |
| |
Create Newsletters and Mail Merge Documents | |
| |
| |
| |
Modify Themes and Create Columns | |
| |
| |
| |
Modify Margins and Columns | |
| |
| |
| |
Apply Text Effects | |
| |
| |
| |
Create Styles | |
| |
| |
| |
Add Borders and Shading to Paragraphs and Pages | |
| |
| |
| |
Insert and Adjust Online Pictures | |
| |
| |
| |
Insert SmartArt | |
| |
| |
| |
Format SmartArt | |
| |
| |
| |
Create Labels Using Mail Merge | |
| |
| |
| |
Preview and Print Mail Merge Documents | |
| |
| |
More Skills | |
| |
| |
| |
Optimize Documents for Read Mode | |
| |
| |
| |
Work in Outline View | |
| |
| |
| |
Manage Document Properties | |
| |
| |
| |
Save Documents as Web Pages | |
| |
| |
Word Capstone Project | |
| |
| |
| |
Format Academic Reports and Include Information from the Web | |
| |
| |
| |
Use Excel Data in Word Mail Merge | |
| |
| |
Word Web App Project: Create Flyers Using Word Web App | |
| |
| |
Microsoft Excel | |
| |
| |
Introduction to Excel | |
| |
| |
| |
Create Workbooks with Excel 2013 | |
| |
| |
| |
Create and Save Workbooks | |
| |
| |
| |
Enter Data and Merge and Center Titles | |
| |
| |
| |
Construct Addition and Subtraction Formulas | |
| |
| |
| |
Construct Multiplication and Division Formulas | |
| |
| |
| |
Adjust Column Widths and Apply Cell Styles | |
| |
| |
| |
Insert the SUM Function | |
| |
| |
| |
AutoFill Formulas and Data | |
| |
| |
| |
Format, Edit, and Check Spelling | |
| |
| |
| |
Insert Footers and Adjust Page Settings | |
| |
| |
| |
Display Formulas and Print Worksheets | |
| |
| |
More Skills | |
| |
| |
| |
Create Workbooks from Templates | |
| |
| |
| |
Insert Names into Formulas | |
| |
| |
| |
Create Templates | |
| |
| |
| |
Manage Document Properties | |
| |
| |
| |
Insert Summary Functions and Create Charts | |
| |
| |
| |
Align and Wrap Text | |
| |
| |
| |
Apply Absolute Cell References | |
| |
| |
| |
Format Numbers | |
| |
| |
| |
Insert the AVERAGE Function | |
| |
| |
| |
Insert the MIN and MAX Functions | |
| |
| |
| |
Create Column Charts | |
| |
| |
| |
Format Column Charts | |
| |
| |
| |
Create and Format Pie Charts | |
| |
| |
| |
Update Charts and Insert WordArt | |
| |
| |
| |
Preview and Print Multiple Worksheets | |
| |
| |
More Skills | |
| |
| |
| |
Insert, Edit, and Delete Comments | |
| |
| |
| |
Change Chart Types | |
| |
| |
| |
Copy Excel Data to Word Documents | |
| |
| |
| |
Fill Data with Flash Fill | |
| |
| |
| |
Manage Multiple Worksheets | |
| |
| |
| |
Organize Worksheet Tabs | |
| |
| |
| |
Enter and Format Dates | |
| |
| |
| |
Clear Cell Contents and Formats | |
| |
| |
| |
Move Cell Contents and Use Paste Options | |
| |
| |
| |
Enter Data in Grouped Worksheets | |
| |
| |
| |
Insert Multiple Math Operators in Formulas | |
| |
| |
| |
Format Grouped Worksheets | |
| |
| |
| |
Insert, Hide, Delete, and Move Worksheets | |
| |
| |
| |
Create Summary Worksheets | |
| |
| |
| |
Create Clustered Bar Charts | |
| |
| |
More Skills | |
| |
| |
| |
Create Organization Charts | |
| |
| |
| |
Create Line Charts | |
| |
| |
| |
Set and Clear Print Areas | |
| |
| |
| |
Create, Edit, and Delete Hyperlinks | |
| |
| |
| |
More Functions and Excel Tables | |
| |
| |
| |
Insert the TODAY, NOW, and COUNT Functions | |
| |
| |
| |
Insert the IF Function | |
| |
| |
| |
Move Functions, Add Borders, and Rotate Text | |
| |
| |
| |
Apply Conditional Formatting | |
| |
| |
| |
Insert Sparklines | |
| |
| |
| |
Use Find and Replace | |
| |
| |
| |
Freeze and Unfreeze Panes | |
| |
| |
| |
Create, Sort, and Filter Excel Tables | |
| |
| |
| |
Filter Data | |
| |
| |
| |
Convert Tables to Ranges, Hide Rows and Columns, and Format Large Worksheets | |
| |
| |
More Skills | |
| |
| |
| |
Apply Conditional Color Scales with Top and Bottom Rules and Clear Rules | |
| |
| |
| |
Insert the Payment (PMT) Function | |
| |
| |
| |
Create PivotTable Reports | |
| |
| |
| |
Use Goal Seek | |
| |
| |
Excel Capstone Project | |
| |
| |
| |
Copy Word Tables into Excel Worksheets | |
| |
| |
| |
Link Data from Excel | |
| |
| |
Microsoft Access | |
| |
| |
Introduction to Access | |
| |
| |
| |
Create Database Tables | |
| |
| |
| |
Create Databases | |
| |
| |
| |
Create Tables in Datasheet View | |
| |
| |
| |
Enter Data into Datasheets | |
| |
| |
| |
Create Tables in Design View | |
| |
| |
| |
Relate Tables | |
| |
| |
| |
Enter Data in Related Tables | |
| |
| |
| |
Import Data into Tables | |
| |
| |
| |
Filter and Sort Datasheets | |
| |
| |
| |
Format Datasheets | |
| |
| |
| |
Preview and Print Datasheets | |
| |
| |
More Skills | |
| |
| |
| |
Compact and Repair Databases | |
| |
| |
| |
Work with the Long Text Data Type | |
| |
| |
| |
Work with the Attachment Data Type | |
| |
| |
| |
Work with the Hyperlink and Yes/No Data Types | |
| |
| |
| |
Create Select Queries | |
| |
| |
| |
Create Queries with the Simple Query Wizard | |
| |
| |
| |
Add Text Criteria | |
| |
| |
| |
Add Calculated Fields to Tables | |
| |
| |
| |
Create Queries in Design View | |
| |
| |
| |
Add Comparison Operators | |
| |
| |
| |
Add Date and Time Criteria | |
| |
| |
| |
Group and Total Queries | |
| |
| |
| |
Add Calculated Fields to Queries | |
| |
| |
| |
Work with Logical Operators | |
| |
| |
| |
Add Wildcards to Query Criteria | |
| |
| |
More Skills | |
| |
| |
| |
Export Queries to Excel | |
| |
| |
| |
Export Queries as Web Pages | |
| |
| |
| |
Link to External Data Sources | |
| |
| |
| |
Create Crosstab Queries | |
| |
| |
| |
Create Forms | |
| |
| |
| |
Use the Form Wizard | |
| |
| |
| |
Use Forms to Modify Data | |
| |
| |
| |
Format Forms in Layout View | |
| |
| |
| |
Add Controls and Conditional Formatting | |
| |
| |
| |
Use the Form Tool | |
| |
| |
| |
Work with Tabular Layouts | |
| |
| |
| |
Add Input Masks | |
| |
| |
| |
Change Data in One-to-Many Forms | |
| |
| |
| |
Create Forms from Queries | |
| |
| |
| |
Create Navigation Forms | |
| |
| |
More Skills | |
| |
| |
| |
Validate Fields | |
| |
| |
| |
Create Databases from Templates | |
| |
| |
| |
Create Macros | |
| |
| |
| |
Create Access Apps | |
| |
| |
| |
Create Reports | |
| |
| |
| |
Build Queries for Reports | |
| |
| |
| |
Create Reports Using the Report Tool | |
| |
| |
| |
Format Reports | |
| |
| |
| |
Add Totals to Reports | |
| |
| |
| |
Preview and Print Reports | |
| |
| |
| |
Create Reports with the Blank Report Tool | |
| |
| |
| |
Group and Sort Reports | |
| |
| |
| |
Modify Report Layouts | |
| |
| |
| |
Filter Reports | |
| |
| |
| |
Create Label Reports | |
| |
| |
More Skills | |
| |
| |
| |
Import Objects from Other Databases | |
| |
| |
| |
Export Reports to Word | |
| |
| |
| |
Save Reports as PDF Documents | |
| |
| |
| |
Save Reports as Web Pages and Save Export Steps | |
| |
| |
Access Capstone Project | |
| |
| |
| |
Create Envelopes from Access Queries | |
| |
| |
| |
Refer to Cells in Other Workbooks | |
| |
| |
Excel Web App Project: Create Workbooks Using Excel Web App | |
| |
| |
| |
Export Access Data to Word Documents | |
| |
| |
Access Web App Project: Create OneNote Notebooks | |
| |
| |
Microsoft PowerPoint | |
| |
| |
Introduction to PowerPoint | |
| |
| |
| |
Getting Started with PowerPoint 2013 | |
| |
| |
| |
Open, View, and Save Presentations | |
| |
| |
| |
Edit and Replace Text | |
| |
| |
| |
Format Slide Text | |
| |
| |
| |
Check Spelling and Use the Thesaurus | |
| |
| |
| |
Insert Slides and Modify Slide Layouts | |
| |
| |
| |
Insert and Format Pictures | |
| |
| |
| |
Organize Slides in Slide Sorter View | |
| |
| |
| |
Apply Slide Transitions and View Slide Shows | |
| |
| |
| |
Insert Headers and Footers and Print Handouts | |
| |
| |
| |
Add Notes Pages and Use Presenter View | |
| |
| |
More Skills | |
| |
| |
| |
Add Online Pictures | |
| |
| |
| |
Print Presentations, Notes Pages, and Custom Ranges | |
| |
| |
| |
Move and Delete Slides in Normal View | |
| |
| |
| |
Change Slide Size and Orientation | |
| |
| |
| |
Format a Presentation | |
| |
| |
| |
Create New Presentations | |
| |
| |
| |
Change Themes and Variants | |
| |
| |
| |
Change Font Colors and Effects | |
| |
| |
| |
Format Slide Backgrounds with Fill | |
| |
| |
| |
Add Pictures and Textures to Slide Backgrounds | |
| |
| |
| |
Format Text with WordArt | |
| |
| |
| |
Change Character Spacing | |
| |
| |
| |
Modify Bulleted and Numbered Lists | |
| |
| |
| |
Move and Copy Text and Objects | |
| |
| |
| |
Use Format Painter and Clear All Formatting | |
| |
| |
More Skills | |
| |
| |
| |
Edit Slide Masters | |
| |
| |
| |
Save and Apply Presentation Templates | |
| |
| |
| |
Create Slides from Microsoft Word Outlines | |
| |
| |
| |
Design Presentations with Contrast | |
| |
| |
| |
Enhance Presentations with Graphics | |
| |
| |
| |
Insert Slides from Other Presentations | |
| |
| |
| |
Insert, Size, and Move Online Pictures | |
| |
| |
| |
Modify Picture Shapes, Borders, and Effects | |
| |
| |
| |
Insert, Size, and Move Shapes | |
| |
| |
| |
Add Text to Shapes and Insert Text Boxes | |
| |
| |
| |
Apply Gradient Fills and Group and Align Graphics | |
| |
| |
| |
Convert Text to SmartArt Graphics and Add Shapes | |
| |
| |
| |
Modify SmartArt Layouts, Colors, and Styles | |
| |
| |
| |
Insert Video Files | |
| |
| |
| |
Apply Video Styles and Adjust Videos | |
| |
| |
More Skills | |
| |
| |
| |
Compress Pictures | |
| |
| |
| |
Save Groups as Picture Files | |
| |
| |
| |
Change Object Order | |
| |
| |
| |
Insert a Screen Shot in a Presentation | |
| |
| |
| |
Present Data Using Tables, Charts, and Animation | |
| |
| |
| |
Insert Tables | |
| |
| |
| |
Modify Table Layouts | |
| |
| |
| |
Apply Table Styles | |
| |
| |
| |
Insert Column Charts | |
| |
| |
| |
Edit and Format Charts | |
| |
| |
| |
Insert Pie Charts | |
| |
| |
| |
Apply Animation Effects and Change Duration | |
| |
| |
| |
Modify Animation Timings and Use Animation Painter | |
| |
| |
| |
Delay or Remove Animation | |
| |
| |
| |
Navigate Slide Shows | |
| |
| |
More Skills | |
| |
| |
| |
Save Presentations to CDs | |
| |
| |
| |
Insert Hyperlinks in Presentations | |
| |
| |
| |
Create Photo Albums | |
| |
| |
| |
Add Images to Tables | |
| |
| |
PowerPoint Capstone Project | |
| |
| |
| |
Copy and Paste Between Office Programs | |
| |
| |
| |
Send PowerPoint Handouts to Word | |
| |
| |
PowerPoint Web App Project: Create Presentations Using the PowerPoint Web App | |
| |
| |
Glossary | |
| |
| |
Index | |