Module : 1 |
|
Identify the Components of the Word Interface |
|
00:30:00 |
|
Create a Word Document |
|
00:30:00 |
|
Help |
|
00:30:00 |
|
Navigate and Select Text |
|
00:30:00 |
|
Modify Text |
|
00:30:00 |
|
Find and Replace Text |
|
00:30:00 |
|
Apply Character Formatting |
|
00:30:00 |
|
Align Text Using Tabs |
|
00:30:00 |
|
Display Text as List Items |
|
00:30:00 |
|
Control Paragraph Layout |
|
00:30:00 |
|
Apply Borders and Shading |
|
00:30:00 |
|
Apply Styles |
|
00:30:00 |
|
Manage Formatting |
|
00:30:00 |
|
Insert a Table |
|
00:30:00 |
|
Modify a Table |
|
00:30:00 |
|
Format a Table |
|
00:30:00 |
|
Convert Text to a Table |
|
00:30:00 |
|
Sort a List |
|
00:30:00 |
|
Renumber a List |
|
00:30:00 |
|
Customize a List |
|
00:30:00 |
|
Insert Symbols and Special Characters |
|
00:30:00 |
|
Add Images to a Document |
|
00:30:00 |
|
Apply a Page Border and Color |
|
00:30:00 |
|
Add a Watermark |
|
00:30:00 |
|
Add Headers and Footers |
|
00:30:00 |
|
Control Page Layout |
|
00:30:00 |
|
Check Spelling and Grammar |
|
00:30:00 |
|
Other Proofing Tools |
|
00:30:00 |
|
Check Accessibility |
|
00:30:00 |
|
Customize the Word Interface |
|
00:30:00 |
|
Additional Save Options |
|
00:30:00 |
|
Manage Additional File Types |
|
00:30:00 |
|
Activities – Microsoft Word 2016 for Beginners |
|
00:00:00 |
Module : 2 |
|
Identify the Elements of the Excel Interface |
|
00:30:00 |
|
Activity – Identify the Elements of the Excel Interface |
|
00:05:00 |
|
Create a Basic Worksheet |
|
01:00:00 |
|
Activity – Create a Basic Worksheet |
|
00:05:00 |
|
Use the Help System |
|
00:15:00 |
|
Activity – Use the Help System |
|
00:05:00 |
|
Create Formulas in a Worksheet |
|
01:00:00 |
|
Activity – Create Formulas in a Worksheet |
|
00:05:00 |
|
Insert Functions in a Worksheet |
|
00:30:00 |
|
Activity – Insert Functions in a Worksheet |
|
00:05:00 |
|
Reuse Formulas |
|
00:30:00 |
|
Activity – Reuse Formulas |
|
00:05:00 |
|
Manipulate Data |
|
00:30:00 |
|
Activity – Manipulate Data |
|
00:05:00 |
|
Insert, Manipulate, and Delete Cells, Columns, and Rows |
|
00:30:00 |
|
Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows |
|
00:05:00 |
|
Search For and Replace Data |
|
00:30:00 |
|
Activity – Search For and Replace Data |
|
00:05:00 |
|
Spell Check a Worksheet |
|
00:30:00 |
|
Activity – Spell Check a Worksheet |
|
00:05:00 |
|
Modify Fonts |
|
00:30:00 |
|
Activity – Modify Fonts |
|
00:05:00 |
|
Add Borders and Colors to Cells |
|
01:00:00 |
|
Activity – Add Borders and Colors to Cells |
|
00:05:00 |
|
Apply Number Formats |
|
00:30:00 |
|
Activity – Apply Number Formats |
|
00:05:00 |
|
Align Cell Contents |
|
00:30:00 |
|
Activity – Align Cell Contents |
|
00:05:00 |
|
Apply Cell Styles |
|
00:30:00 |
|
Activity – Apply Cell Styles |
|
00:05:00 |
|
Define the Basic Page Layout for a Workbook |
|
01:00:00 |
|
Activity – Define the Basic Page Layout for a Workbook |
|
00:05:00 |
|
Refine the Page Layout and Apply Print Options |
|
00:30:00 |
|
Activity – Refine the Page Layout and Apply Print Options |
|
00:05:00 |
|
Format Worksheet Tabs |
|
00:30:00 |
|
Activity – Format Worksheet Tabs |
|
00:05:00 |
|
Manage Worksheets |
|
00:30:00 |
|
Activity – Manage Worksheets |
|
00:05:00 |
|
Manage the View of Worksheets and Workbooks |
|
00:30:00 |
|
Activity – Manage the View of Worksheets and Workbooks |
|
00:05:00 |
|
Customize General and Language Options |
|
00:30:00 |
|
Activity – Customize General and Language Options |
|
00:05:00 |
|
Customize Formula Options |
|
00:30:00 |
|
Activity – Customize Formula Options |
|
00:05:00 |
|
Customize Proofing and Save Options |
|
01:00:00 |
|
Activity – Customize Proofing and Save Options |
|
00:05:00 |
|
Customize the Ribbon and Quick Access Toolbar |
|
00:30:00 |
|
Activity – Customize the Ribbon and Quick Access Toolbar |
|
00:05:00 |
|
Customize the Functionality of Excel by Enabling Add-Ins |
|
00:30:00 |
|
Activity – Customize the Functionality of Excel by Enabling Add-Ins |
|
00:05:00 |
|
Customize Advanced and Trust Center Options |
|
00:30:00 |
|
Activity – Customize Advanced and Trust Center Options |
|
00:05:00 |
|
Activities – Microsoft Excel 2016 for Beginners |
|
00:00:00 |
Module : 3 |
|
Navigate the PowerPoint Environment |
|
00:30:00 |
|
ACTIVITY – NAVIGATING THE POWERPOINT 2016 USER INTERFACE |
|
00:05:00 |
|
Create and Save a PowerPoint Presentation |
|
00:15:00 |
|
ACTIVITY – CREATING AND SAVING A POWERPOINT PRESENTATION |
|
00:05:00 |
|
Use PowerPoint Help |
|
00:15:00 |
|
ACTIVITY – USING POWERPOINT HELP |
|
00:05:00 |
|
Select a Presentation Type |
|
00:15:00 |
|
ACTIVITY – SELECTING A PRESENTATION TYPE |
|
00:05:00 |
|
Build a Presentation |
|
00:15:00 |
|
ACTIVITY – BUILDING A PRESENTATION |
|
00:05:00 |
|
Lay Out a Presentation |
|
00:15:00 |
|
ACTIVITY – LAYING OUT A PRESENTATION |
|
00:05:00 |
|
Edit Text |
|
00:15:00 |
|
ACTIVITY – EDITING TEXT |
|
00:05:00 |
|
View and Navigate a Presentation |
|
00:15:00 |
|
ACTIVITY – VIEWING A PRESENTATION |
|
00:05:00 |
|
Format Characters |
|
00:15:00 |
|
ACTIVITY – FORMATTING CHARACTERS |
|
00:05:00 |
|
Format Paragraphs |
|
00:30:00 |
|
ACTIVITY – FORMATTING PARAGRAPHS |
|
00:05:00 |
|
Format Text Boxes |
|
00:15:00 |
|
ACTIVITY – FORMATTING TEXT BOXES |
|
00:05:00 |
|
Insert Images |
|
00:30:00 |
|
ACTIVITY – INSERTING IMAGES |
|
00:05:00 |
|
Insert Shapes |
|
00:15:00 |
|
ACTIVITY – INSERTING SHAPES |
|
00:05:00 |
|
Insert WordArt |
|
00:15:00 |
|
ACTIVITY – INSERT WORDART |
|
00:05:00 |
|
Edit Objects |
|
00:30:00 |
|
ACTIVITY – EDITING OBJECTS |
|
00:05:00 |
|
Format Objects |
|
00:15:00 |
|
ACTIVITY – FORMATTING OBJECTS |
|
00:05:00 |
|
Group Objects |
|
00:15:00 |
|
ACTIVITY – GROUPING OBJECTS |
|
00:05:00 |
|
Arrange Objects |
|
00:15:00 |
|
ACTIVITY – ARRANGING OBJECTS |
|
00:05:00 |
|
Animate Objects |
|
00:15:00 |
|
ACTIVITY – ANIMATING OBJECTS |
|
00:05:00 |
|
Create a Table |
|
00:15:00 |
|
ACTIVITY – CREATING A TABLE |
|
00:05:00 |
|
Format a Table |
|
00:15:00 |
|
ACTIVITY – FORMATTING A TABLE |
|
00:05:00 |
|
Insert a Table from Other Microsoft Office Applications |
|
00:15:00 |
|
ACTIVITY – INSERTING A TABLE FROM MICROSOFT EXCEL |
|
00:05:00 |
|
Create a Chart |
|
00:15:00 |
|
ACTIVITY – CREATING A CHART |
|
00:05:00 |
|
Format a Chart |
|
00:15:00 |
|
ACTIVITY – FORMATTING A CHART |
|
00:05:00 |
|
Manipulate a Chart |
|
00:15:00 |
|
ACTIVITY – MANIPULATING A CHART |
|
00:05:00 |
|
Insert a Chart from Microsoft Excel |
|
00:15:00 |
|
ACTIVITY – INSERTING A CHART FROM MICROSOFT EXCEL |
|
00:05:00 |
|
Review Your Presentation |
|
00:30:00 |
|
ACTIVITY – REVIEWING YOUR PRESENTATION |
|
00:05:00 |
|
Apply Transitions |
|
00:15:00 |
|
ACTIVITY – APPLYING TRANSITIONS |
|
00:05:00 |
|
Print Your Presentation |
|
00:15:00 |
|
ACTIVITY – PRINTING YOUR PRESENTATION |
|
00:05:00 |
|
Deliver Your Presentation |
|
01:00:00 |
|
ACTIVITY – DELIVERING YOUR PRESENTATION |
|
00:05:00 |
|
Activities – Microsoft PowerPoint 2016 Beginners Level |
|
00:00:00 |
Module : 4 |
|
Navigate the Outlook Interface |
|
00:15:00 |
|
ACTIVITY – NAVIGATING THE OUTLOOK INTERFACE |
|
00:05:00 |
|
Perform Basic E-mail Functions |
|
00:30:00 |
|
ACTIVITY – PERFORMING BASIC E-MAIL FUNCTIONS |
|
00:05:00 |
|
Use Outlook Help |
|
00:15:00 |
|
ACTIVITY – GETTING HELP IN MICROSOFT OUTLOOK 2016 |
|
00:05:00 |
|
Create an E-mail Message |
|
00:15:00 |
|
ACTIVITY – CREATING AN E-MAIL MESSAGE |
|
00:05:00 |
|
Check Spelling and Grammar |
|
00:15:00 |
|
ACTIVITY – CHECK SPELLING AND GRAMMAR |
|
00:05:00 |
|
Format Message Content |
|
00:15:00 |
|
ACTIVITY – FORMAT MESSAGE CONTENT |
|
00:05:00 |
|
Attach Files and Items |
|
00:15:00 |
|
ACTIVITY – ATTACHING A FILE TO A MESSAGE |
|
00:05:00 |
|
Enhance an E-mail Message |
|
00:30:00 |
|
ACTIVITY – ENHANCING AN E-MAIL MESSAGE |
|
00:05:00 |
|
Manage Automatic Message Content |
|
00:15:00 |
|
ACTIVITY – MANAGING AUTOMATIC MESSAGE CONTENT |
|
00:05:00 |
|
Customize Reading Options |
|
00:15:00 |
|
ACTIVITY – CUSTOMIZING READING OPTIONS |
|
00:05:00 |
|
Work with Attachments |
|
00:15:00 |
|
ACTIVITY – WORKING WITH ATTACHMENTS |
|
00:05:00 |
|
Manage Your Message Responses |
|
00:15:00 |
|
ACTIVITY – MANAGING YOUR MESSAGE RESPONSES |
|
00:05:00 |
|
Manage Messages Using Tags, Flags, and Other Commands |
|
00:15:00 |
|
ACTIVITY – MANAGING MESSAGES USING TAGS, FLAGS AND OTHER COMMANDS |
|
00:05:00 |
|
Organize Messages Using Folders |
|
00:15:00 |
|
ACTIVITY – ORGANIZING MESSAGES USING FOLDERS |
|
00:04:00 |
|
View the Calendar |
|
00:15:00 |
|
ACTIVITY – CUSTOMIZING YOUR CALENDAR VIEW |
|
00:05:00 |
|
Manage Appointments |
|
00:15:00 |
|
ACTIVITY – MANAGING APPOINTMENTS |
|
00:05:00 |
|
Manage Meetings |
|
00:30:00 |
|
ACTIVITY – CREATING AND MANAGING MEETINGS |
|
00:05:00 |
|
Print Your Calendar |
|
00:15:00 |
|
ACTIVITY – PRINTING YOUR CALENDAR |
|
00:05:00 |
|
Create and Update Contacts |
|
00:15:00 |
|
ACTIVITY – CREATING AND UPDATING CONTACTS |
|
00:05:00 |
|
View and Organize Contacts |
|
00:15:00 |
|
ACTIVITY – VIEW AND ORGANIZE CONTACTS |
|
00:05:00 |
|
Create Tasks |
|
00:15:00 |
|
ACTIVITY – CREATING TASKS |
|
00:05:00 |
|
Manage Tasks |
|
00:15:00 |
|
ACTIVITY – MANAGING TASKS |
|
00:05:00 |
|
Manage Notes |
|
00:15:00 |
|
ACTIVITY – CREATING AND MANAGING NOTES |
|
00:05:00 |
|
Customize the Outlook Interface |
|
00:30:00 |
|
ACTIVITY – CUSTOMIZING THE OUTLOOK INTERFACE |
|
00:05:00 |
|
Create and Manage Quick Steps |
|
00:15:00 |
|
ACTIVITY – CREATING AND MANAGING QUICK STEPS |
|
00:05:00 |
|
Activities – Microsoft Outlook 2016 for Beginners |
|
00:00:00 |
Module : 5 |
|
Orientation to Microsoft Access |
|
01:00:00 |
|
Create a Simple Access Database |
|
01:00:00 |
|
Get Help in Microsoft Access |
|
00:30:00 |
|
Modify Table Data |
|
00:30:00 |
|
Working With Records |
|
00:15:00 |
|
Sort and Filter Records |
|
00:30:00 |
|
Create Lookups |
|
01:00:00 |
|
Join Data from Different Tables in a Query |
|
01:00:00 |
|
Sort and Filter Data in a Query |
|
01:00:00 |
|
Perform Calculations in a Query |
|
00:30:00 |
|
Create Parameter Queries |
|
00:30:00 |
|
Create Basic Queries |
|
00:30:00 |
|
Create Find Duplicate and Find Unmatched Queries |
|
00:30:00 |
|
Summarize Data |
|
00:30:00 |
|
Create a Report |
|
01:00:00 |
|
Add Controls to a Report |
|
00:30:00 |
|
Enhance the Appearance of a Report |
|
00:30:00 |
|
The Access Options Dialog Box |
|
01:00:00 |
|
Create a Table |
|
01:00:00 |
|
Modify a Table and Fields |
|
00:30:00 |
|
Create Table Relationships |
|
00:30:00 |
|
Create Query Joins |
|
00:30:00 |
|
Join Tables That Have No Common Fields |
|
00:30:00 |
|
Relate Data within a Table |
|
00:30:00 |
|
Work with Subdatasheets |
|
00:30:00 |
|
Create Subqueries |
|
00:30:00 |
|
Data Normalization |
|
01:00:00 |
|
Create a Junction Table |
|
00:30:00 |
|
Import Data into Access |
|
00:30:00 |
|
Export Data to Text File Formats |
|
00:30:00 |
|
Export Access Data to Excel |
|
00:30:00 |
|
Create a Mail Merge |
|
00:30:00 |
|
Organize Report Information |
|
00:30:00 |
|
Format Reports |
|
00:30:00 |
|
Include Charts in a Report |
|
00:30:00 |
|
Add a Calculated Field to a Report |
|
00:30:00 |
|
Add a Subreport to an Existing Report |
|
00:30:00 |
|
Create a Mailing Label Report |
|
00:30:00 |
|
Publish a Report as PDF |
|
00:30:00 |
|
Activities – Exercise Files for Microsoft Access 2016 Beginners Level |
|
00:00:00 |