Microsoft Office Tutorial Course
Microsoft Office Tutorial Includes: Video Lessons, Instruction Manuals, Exam & Certificate of Completion.
Course Description
Learn Microsoft Office with this comprehensive Microsoft Office tutorial from TeachUcomp, Inc. Mastering Microsoft Office Made Easy features 797 video lessons with over 39 hours of introductory through advanced instruction. You get our complete courses in Access, Excel, Outlook, PowerPoint, Publisher and Word. Watch, listen and learn as your expert instructors guide you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our six printable classroom instruction manuals, which contain additional images and practice exercises. This complete Microsoft Office tutorial covers the same curriculum as our classroom training and was designed to provide a solid foundation in Office.
Whether you are completely new to Microsoft Office or upgrading from an older version, this Microsoft Office tutorial will empower you with the knowledge and skills necessary to be a proficient user. Our Microsoft Office tutorial is based on years of classroom training experience and teaching techniques. This lets us develop a Microsoft Office tutorial that is easy to use. You can also customize it to meet your personal learning needs. Simply launch the Microsoft Office tutorial interface, click to start a video lesson or open one of the manuals, and you’re on your way to mastering Office.
Access Course Syllabus & Sample Lessons
Select any of the video lessons markedto view them in a new window.
To view a sample of the instruction manual in PDF, click here:
Sample Access Manual
CHAPTER 1- |
Microsoft Office Tutorial: Getting Acquainted with Access |
|
Lesson 1.1- | Creating a New Database | |
Lesson 1.2- | Overview of a Database | |
Lesson 1.3- | The Access Interface | |
Lesson 1.4- | Touch Mode | |
Lesson 1.5- | Viewing Database Objects in the Navigation Bar | |
Lesson 1.6- | Opening and Closing Databases | |
CHAPTER 2- |
Microsoft Office Tutorial: Creating Relational Database Tables |
|
Lesson 2.1- | The “Flat File” Method of Data Storage | |
Lesson 2.2- | The Relational Model of Data Storage | |
Lesson 2.3- | Tips for Creating a Relational Database | |
Lesson 2.4- | Creating Relational Database Tables | |
Lesson 2.5- | Assigning a Primary Key to a Table | |
CHAPTER 3- |
Microsoft Office Tutorial: Using Tables |
|
Lesson 3.1- | Using Datasheet View | |
Lesson 3.2- | Navigating in Datasheet View | |
Lesson 3.3- | Adding Records in Database View | |
Lesson 3.4- | Editing and Deleting Records in Datasheet View | |
Lesson 3.5- | Inserting New Fields | |
Lesson 3.6- | Renaming Fields | |
Lesson 3.7- | Deleting Fields | |
CHAPTER 4- |
Microsoft Office Tutorial: Field Properties |
|
Lesson 4.1- | Setting Field Properties | |
Lesson 4.2- | The ‘Field Size’ Property | |
Lesson 4.3- | The ‘Format’ Property for Date/Time Fields | |
Lesson 4.4- | The ‘Format’ Property for Logical Fields | |
Lesson 4.5- | Setting Default Values for Fields | |
Lesson 4.6- | Setting Input Masks | |
Lesson 4.7- | Setting Up Validation Rules and Responses | |
Lesson 4.8- | Requiring Field Input | |
Lesson 4.9- | Allowing Zero Length Entries | |
CHAPTER 5- |
Microsoft Office Tutorial: Joining Tables in a Database |
|
Lesson 5.1- | The Relationships Window | |
Lesson 5.2- | Enforcing Referential Integrity | |
Lesson 5.3- | Creating Lookup Fields | |
CHAPTER 6- |
Microsoft Office Tutorial: Indexing Tables |
|
Lesson 6.1- | Indexes | |
Lesson 6.2- | Creating Indexes | |
Lesson 6.3- | Deleting Indexes | |
CHAPTER 7- |
Microsoft Office Tutorial: Queries |
|
Lesson 7.1- | Using the Simple Query Wizard | |
Lesson 7.2- | Designing Queries | |
Lesson 7.3- | Joining Tables in a Query | |
Lesson 7.4- | Adding Criteria to the QBE Grid | |
Lesson 7.5- | Running A Query | |
Lesson 7.6- | SQL View | |
Lesson 7.7- | Sorting Query Results | |
Lesson 7.8- | Hiding Fields in a Query | |
Lesson 7.9- | Using Comparison Operators | |
Lesson 7.10- | Using ‘AND’ and ‘OR’ Conditions | |
CHAPTER 8- |
Microsoft Office Tutorial: Advanced Queries |
|
Lesson 8.1- | Using the ‘BETWEEN…AND’ Condition | |
Lesson 8.2- | Using Wildcard Characters in Criteria | |
Lesson 8.3- | Creating a Calculated Field | |
Lesson 8.4- | Creating ‘Top Value’ Queries | |
Lesson 8.5- | Function Queries | |
Lesson 8.6- | Parameter Queries | |
CHAPTER 9- |
Microsoft Office Tutorial: Advanced Query Types |
|
Lesson 9.1- | Make-Table Queries | |
Lesson 9.2- | Update Queries | |
Lesson 9.3- | Append Queries | |
Lesson 9.4- | Delete Queries | |
Lesson 9.5- | Crosstab Queries | |
Lesson 9.6- | The ‘Find Duplicates’ Query | |
Lesson 9.7- | Removing Duplicate Records from a Table | |
Lesson 9.8- | The ‘Find Unmatched’ Query | |
CHAPTER 10- |
Microsoft Office Tutorial: Creating Forms |
|
Lesson 10.1- | Forms Overview | |
Lesson 10.2- | The Form Wizard | |
Lesson 10.3- | Creating AutoForms | |
Lesson 10.4- | Using Forms | |
Lesson 10.5- | Form and Report Layout View | |
Lesson 10.6- | Form and Report Design View | |
Lesson 10.7- | Viewing the Ruler and Gridlines | |
Lesson 10.8- | The ‘Snap to Grid’ Feature | |
Lesson 10.9- | Creating a Form in Design View | |
Lesson 10.10- | Modifying Form Sections in Design View | |
CHAPTER 11- |
Microsoft Office Tutorial: Form & Report Controls |
|
Lesson 11.1- | Selecting Controls | |
Lesson 11.2- | Deleting Controls | |
Lesson 11.3- | Moving and Resizing Controls | |
Lesson 11.4- | Sizing Controls ‘To Fit’ | |
Lesson 11.5- | ‘Nudging’ Controls | |
Lesson 11.6- | Aligning, Spacing and Sizing Controls | |
Lesson 11.7- | Formatting Controls | |
Lesson 11.8- | Viewing Control Properties | |
CHAPTER 12- |
Microsoft Office Tutorial: Using Controls |
|
Lesson 12.1- | The Controls Group | |
Lesson 12.2- | Adding Label Controls | |
Lesson 12.3- | Adding Logos and Image Controls | |
Lesson 12.4- | Adding Line and Rectangle Controls | |
Lesson 12.5- | Adding Combo Box Controls | |
Lesson 12.6- | Adding List Box Controls | |
Lesson 12.7- | Setting Tab Order | |
CHAPTER 13- |
Microsoft Office Tutorial: Subforms |
|
Lesson 13.1- | Creating Subforms | |
Lesson 13.2- | Using the Subform or Subreport Control | |
CHAPTER 14- |
Microsoft Office Tutorial: Reports |
|
Lesson 14.1- | Using the Report Wizard | |
Lesson 14.2- | Using Basic Reports | |
Lesson 14.3- | Creating a Report in Design View | |
Lesson 14.4- | Sorting and Grouping Data in Reports | |
Lesson 14.5- | Creating Calculated Fields | |
CHAPTER 15- |
Microsoft Office Tutorial: Subreports |
|
Lesson 15.1- | Creating Subreports | |
CHAPTER 16- |
Microsoft Office Tutorial: Charting Data |
|
Lesson 16.1- | Using Charts | |
Lesson 16.2- | Insert a Modern Chart | |
CHAPTER 17- |
Microsoft Office Tutorial: Macros |
|
Lesson 17.1- | Creating a Standalone Macro | |
Lesson 17.2- | Assigning Macros to a Command Button | |
Lesson 17.3- | Assigning Macros to Events | |
Lesson 17.4- | Using Program Flow with Macros | |
Lesson 17.5- | Creating Autoexec Macros | |
Lesson 17.6- | Creating Data Macros | |
Lesson 17.7- | Editing Named Data Macros | |
Lesson 17.8- | Renaming and Deleting Named Data Macros | |
CHAPTER 18- |
Microsoft Office Tutorial: Switchboard and Navigation Forms |
|
Lesson 18.1- | Creating a Switchboard Form | |
Lesson 18.2- | Creating a Navigation Form | |
Lesson 18.3- | Controlling Startup Behavior | |
CHAPTER 19- |
Microsoft Office Tutorial: Advanced Features |
|
Lesson 19.1- | Getting External Data | |
Lesson 19.2- | Exporting Data | |
Lesson 19.3- | Setting a Database Password | |
CHAPTER 20- |
Microsoft Office Tutorial: Advanced Features |
|
Lesson 20.1- | Using Access Help | |
Lesson 20.2- | The Tell Me Bar |
Excel Course Syllabus & Sample Lessons
Select any of the video lessons markedto view them in a new window.
To view a sample of the instruction manual in PDF, click here:
Excel Sample Manual
CHAPTER 1- |
Microsoft Office Tutorial: Getting Acquainted with Excel |
|
Lesson 1.1- | About Excel | |
Lesson 1.2- | The Excel Environment | |
Lesson 1.3- | The Title Bar | |
Lesson 1.4- | The Ribbon | |
Lesson 1.5- | The “File” Tab and Backstage View | |
Lesson 1.6- | Scroll Bars | |
Lesson 1.7- | The Quick Access Toolbar | |
Lesson 1.8- | Touch Mode | |
Lesson 1.9- | The Formula Bar | |
Lesson 1.10- | The Workbook Window | |
Lesson 1.11- | The Status Bar | |
Lesson 1.12- | The Workbook View Buttons | |
Lesson 1.13- | The Zoom Slider | |
Lesson 1.14- | The Mini Toolbar | |
Lesson 1.15- | Keyboard Shortcuts | |
CHAPTER 2- |
Microsoft Office Tutorial: File Management |
|
Lesson 2.1- | Creating New Workbooks | |
Lesson 2.2- | Saving Workbooks | |
Lesson 2.3- | Closing Workbooks | |
Lesson 2.4- | Opening Workbooks | |
Lesson 2.5- | Recovering Unsaved Workbooks | |
Lesson 2.6- | Opening a Workbook in a New Window | |
Lesson 2.7- | Arranging Open Workbook Windows | |
Lesson 2.8- | Freeze Panes | |
Lesson 2.9- | Split Panes | |
Lesson 2.10- | Hiding and Unhiding Workbook Windows | |
Lesson 2.11- | Comparing Open Workbooks | |
Lesson 2.12- | Switching Open Workbooks | |
Lesson 2.13- | Switching to Full Screen View | |
Lesson 2.14- | Working With Excel File Formats | |
Lesson 2.14- | Working With Excel File Formats | |
CHAPTER 3- |
Microsoft Office Tutorial: Data Entry |
|
Lesson 3.1- | Selecting Cells | |
Lesson 3.2- | Entering Text into Cells | |
Lesson 3.3- | Entering Numbers into Cells | |
Lesson 3.4- | AutoComplete | |
Lesson 3.5- | Pick from Drop-Down List | |
Lesson 3.6- | Flash Fill | |
Lesson 3.7- | Selecting Ranges | |
Lesson 3.8- | Ranged Data Entry | |
Lesson 3.9- | Using AutoFill | |
CHAPTER 4- |
Microsoft Office Tutorial: Creating Formulas |
|
Lesson 4.1- | Ranged Formula Syntax | |
Lesson 4.2- | Simple Formula Syntax | |
Lesson 4.3- | Writing Formulas | |
Lesson 4.4- | Using AutoSum | |
Lesson 4.5- | Inserting Functions | |
Lesson 4.6- | Editing a Range | |
Lesson 4.7- | Formula AutoCorrect | |
Lesson 4.8- | AutoCalculate | |
Lesson 4.9- | Function Compatibility | |
CHAPTER 5- |
Microsoft Office Tutorial: Copying & Pasting Formulas |
|
Lesson 5.1- | Relative References and Absolute References | |
Lesson 5.2- | Cutting, Copying, and Pasting Data | |
Lesson 5.3- | AutoFilling Cells | |
Lesson 5.4- | The Undo Button | |
Lesson 5.5- | The Redo Button | |
CHAPTER 6- |
Microsoft Office Tutorial: Columns & Rows |
|
Lesson 6.1- | Selecting Columns & Rows | |
Lesson 6.2- | Adjusting Column Width and Row Height | |
Lesson 6.3- | Hiding and Unhiding Columns and Rows | |
Lesson 6.4- | Inserting and Deleting Columns and Rows | |
CHAPTER 7- |
Microsoft Office Tutorial: Formatting Worksheets |
|
Lesson 7.1- | Formatting Cells | |
Lesson 7.2- | The Format Cells Dialog Box | |
Lesson 7.3- | Clearing All Formatting from Cells | |
Lesson 7.4- | Copying All Formatting from Cells to Another Area | |
CHAPTER 8- |
Microsoft Office Tutorial: Worksheet Tools |
|
Lesson 8.1- | Inserting and Deleting Worksheets | |
Lesson 8.2- | Selecting Multiple Worksheets | |
Lesson 8.3- | Navigating Worksheets | |
Lesson 8.4- | Renaming Worksheets | |
Lesson 8.5- | Coloring Worksheet Tabs | |
Lesson 8.6- | Copying or Moving Worksheets | |
CHAPTER 9- |
Microsoft Office Tutorial: Setting Worksheet Layout |
|
Lesson 9.1- | Using Page Break Preview | |
Lesson 9.2- | Using The Page Layout View | |
Lesson 9.3- | Opening the Page Setup Dialog Box | |
Lesson 9.4- | Page Settings | |
Lesson 9.5- | Setting Margins | |
Lesson 9.6- | Creating Headers and Footers | |
Lesson 9.7- | Sheet Settings | |
CHAPTER 10- |
Microsoft Office Tutorial: Printing Worksheets |
|
Lesson 10.1- | Previewing and Printing Worksheets | |
CHAPTER 11- |
Microsoft Office Tutorial: Helping Yourself |
|
Lesson 11.1- | Using Excel Help | |
Lesson 11.2- | The Tell Me Bar- 2016 Only | |
Lesson 11.3- | Smart Lookup and Insights- 2016 Only | |
CHAPTER 12- |
Microsoft Office Tutorial: Creating 3D Formulas |
|
Lesson 12.1- | Creating 3D Formulas | |
Lesson 12.2- | 3D Formula Syntax | |
Lesson 12.3- | Creating 3D Range References | |
CHAPTER 13- |
Microsoft Office Tutorial: Named Ranges |
|
Lesson 13.1- | Naming Ranges | |
Lesson 13.2- | Creating Names from Headings | |
Lesson 13.3- | Moving to a Named Range | |
Lesson 13.4- | Using Named Ranges in Formulas | |
Lesson 13.5- | Naming 3D Ranges | |
Lesson 13.6- | Deleting Named Ranges | |
CHAPTER 14- |
Microsoft Office Tutorial: Conditional Formatting and Cell Styles |
|
Lesson 14.1- | Conditional Formatting | |
Lesson 14.2- | Finding Cells with Conditional Formatting | |
Lesson 14.3- | Clearing Conditional Formatting | |
Lesson 14.4- | Using Table and Cell Styles | |
CHAPTER 15- |
Microsoft Office Tutorial: Paste Special |
|
Lesson 15.1- | Using Paste Special | |
Lesson 15.2- | Pasting Linked Formulas | |
CHAPTER 16- |
Microsoft Office Tutorial: Sharing Workbooks |
|
Lesson 16.1- | About Sharing Workbooks | |
Lesson 16.2- | Simplified Workbook Sharing in Excel 2016 | |
Lesson 16.3- | Traditional Workbook Sharing | |
Lesson 16.4- | Highlighting Changes | |
Lesson 16.5- | Reviewing Changes | |
Lesson 16.6- | Using Comments | |
Lesson 16.7- | Compare and Merge Workbooks | |
CHAPTER 17- |
Microsoft Office Tutorial: Auditing Worksheets |
|
Lesson 17.1- | Auditing Worksheets | |
Lesson 17.2- | Tracing Precedent and Dependent Cells | |
Lesson 17.3- | Tracing Errors | |
Lesson 17.4- | Error Checking | |
Lesson 17.5- | Using the Watch Window | |
Lesson 17.6- | Cell Validation | |
CHAPTER 18- |
Microsoft Office Tutorial: Outlining Worksheets |
|
Lesson 18.1- | Using Outlines | |
Lesson 18.2- | Applying and Removing Outlines | |
CHAPTER 19- |
Microsoft Office Tutorial: Consolidating Worksheets |
|
Lesson 19.1- | Consolidating Data | |
CHAPTER 20- |
Microsoft Office Tutorial: Tables |
|
Lesson 20.1- | Creating a Table | |
Lesson 20.2- | Adding and Editing Records | |
Lesson 20.3- | Inserting Records and Fields | |
Lesson 20.4- | Deleting Records and Fields | |
CHAPTER 21- |
Microsoft Office Tutorial: Sorting Data |
|
Lesson 21.1- | Sorting Data | |
Lesson 21.2- | Custom Sort Orders | |
CHAPTER 22- |
Microsoft Office Tutorial: Filtering Data |
|
Lesson 22.1- | Using AutoFilters | |
Lesson 22.2- | Using the Top 10 AutoFilter | |
Lesson 22.3- | Applying a Custom AutoFilter | |
Lesson 22.4- | Creating Advanced Filters | |
Lesson 22.5- | Applying Multiple Criteria | |
Lesson 22.6- | Using Complex Criteria | |
Lesson 22.7- | Copying Filter Results to a New Location | |
Lesson 22.8- | Using Database Functions | |
CHAPTER 23- |
Microsoft Office Tutorial: What-If Analysis and Forecasts |
|
Lesson 23.1- | Using Data Tables | |
Lesson 23.2- | Using Scenario Manager | |
Lesson 23.3- | Using Goal Seek | |
Lesson 23.4- | Forecast Sheets- 2016 Only | |
CHAPTER 24- |
Microsoft Office Tutorial: Table-Related Functions |
|
Lesson 24.1- | The Hlookup and Vlookup Functions | |
Lesson 24.2- | Using the IF, AND, and OR Functions | |
CHAPTER 25- |
Microsoft Office Tutorial: Sparklines |
|
Lesson 25.1- | Inserting and Deleting Sparklines | |
Lesson 25.2- | Modifying Sparklines | |
CHAPTER 26- |
Microsoft Office Tutorial: Creating Charts In Excel |
|
Lesson 26.1- | Creating Charts | |
Lesson 26.2- | Selecting Charts and Chart Elements | |
Lesson 26.3- | Adding Chart Elements | |
Lesson 26.4- | Moving and Resizing Charts | |
Lesson 26.5- | Changing the Chart Type | |
Lesson 26.6- | Changing the Data Range | |
Lesson 26.7- | Switching Column and Row Data | |
Lesson 26.8- | Choosing a Chart Layout | |
Lesson 26.9 | Choosing a Chart Style | |
Lesson 26.10 | Changing Color Schemes | |
Lesson 26.11- | Printing Charts | |
Lesson 26.12- | Deleting Charts | |
CHAPTER 27- |
Microsoft Office Tutorial: Formatting Charts in Excel |
|
Lesson 27.1- | Formatting Chart Objects | |
Lesson 27.2- | Inserting Objects into a Chart | |
Lesson 27.3- | Formatting Axes | |
Lesson 27.4- | Formatting Axis Titles | |
Lesson 27.5- | Formatting a Chart Title | |
Lesson 27.6- | Formatting Data Labels | |
Lesson 27.7- | Formatting a Data Table | |
Lesson 27.8- | Formatting Error Bars | |
Lesson 27.9- | Formatting Gridlines | |
Lesson 27.10- | Formatting a Legend | |
Lesson 27.11- | Formatting Drop and High-Low Lines | |
Lesson 27.12- | Formatting Trendlines | |
Lesson 27.13- | Formatting Up/Down Bars | |
Lesson 27.14- | Formatting the Chart and Plot Areas | |
Lesson 27.15- | Naming Charts | |
Lesson 27.16- | Applying Shape Styles | |
Lesson 27.17- | Applying WordArt Styles | |
Lesson 27.18- | Saving Custom Chart Templates | |
CHAPTER 28- |
Microsoft Office Tutorial: Data Models |
|
Lesson 28.1- | Creating a Data Model from External Relational Data | |
Lesson 28.2- | Creating a Data Model from Excel Tables | |
Lesson 28.3- | Relating Tables in a Data Model | |
Lesson 28.4- | Managing a Data Model | |
CHAPTER 29- |
Microsoft Office Tutorial: PivotTables and PivotCharts |
|
Lesson 29.1- | Creating Recommended PivotTables | |
Lesson 29.2- | Manually Creating a PivotTable | |
Lesson 29.3- | Creating a PivotChart | |
Lesson 29.4- | Manipulating a PivotTable or PivotChart | |
Lesson 29.5- | Changing Calculated Value Fields | |
Lesson 29.6- | Formatting PivotTables | |
Lesson 29.7- | Formatting PivotCharts | |
Lesson 29.8- | Setting PivotTable Options | |
Lesson 29.9- | Sorting and Filtering Using Field Headers | |
CHAPTER 30- |
Microsoft Office Tutorial: Power Pivot |
|
Lesson 30.1- | Starting Power Pivot | |
Lesson 30.2- | Managing the Data Model | |
Lesson 30.3- | Calculated Columns | |
Lesson 30.4- | Measures | |
Lesson 30.5- | Creating KPIs | |
Lesson 30.6- | Creating and Managing Perspectives | |
Lesson 30.6- | Power Pivot PivotTables and PivotCharts | |
CHAPTER 31- |
Microsoft Office Tutorial: Power View |
|
Lesson 31.1- | Starting Power View | |
Lesson 31.2- | Adding Report Visualizations | |
Lesson 31.3- | Changing the Layout of Report Visualizations | |
Lesson 31.4- | Using Undo and Redo in Power View | |
Lesson 31.5- | Formatting the Power View Sheet | |
Lesson 31.6- | Creating Multiples in a Chart | |
Lesson 31.7- | Filtering Power View Using the Filter Area | |
Lesson 31.8- | Cross-Filtering Visualizations | |
CHAPTER 32- |
Microsoft Office Tutorial: Slicers and Timelines |
|
Lesson 32.1- | Inserting and Deleting Slicers | |
Lesson 32.2- | Modifying Slicers | |
Lesson 32.3- | Inserting and Deleting Timelines | |
Lesson 32.4- | Modifying Timelines | |
CHAPTER 33- |
Microsoft Office Tutorial: Security Features |
|
Lesson 33.1- | Unlocking Cells | |
Lesson 33.2- | Worksheet Protection | |
Lesson 33.3- | Workbook Protection | |
Lesson 33.4- | Password Protecting Excel Files | |
CHAPTER 34- |
Microsoft Office Tutorial: Making Macros |
|
Lesson 34.1- | Recording Macros | |
Lesson 34.2- | Running and Deleting Recorded Macros | |
Lesson 34.3- | The Personal Macro Workbook |
Outlook Course Syllabus & Sample Lessons
Select any of the video lessons markedto view them in a new window.
To view a sample of the instruction manual in PDF, click here:
Sample Outlook Manual
CHAPTER 1- |
Microsoft Office Tutorial: Getting Acquainted with Outlook |
|
Lesson 1.1- | The Outlook Environment | |
Lesson 1.2- | The Title Bar | |
Lesson 1.3- | The Ribbon | |
Lesson 1.4- | The Quick Access Toolbar | |
Lesson 1.5- | Touch Mode | |
Lesson 1.6- | The Navigation Bar, Folder Pane, Reading Pane, and To-Do Bar | |
CHAPTER 2- |
Microsoft Office Tutorial: Making Contacts |
|
Lesson 2.1- | The Contacts Folder | |
Lesson 2.2- | Customizing the Contacts Folder View | |
Lesson 2.3- | Creating Contacts | |
Lesson 2.4- | Basic Contact Management | |
Lesson 2.5- | Printing Contacts | |
Lesson 2.6- | Creating Contact Groups | |
Lesson 2.7- | Categorizing Contacts | |
Lesson 2.8- | Searching for Contacts | |
Lesson 2.9- | Calling Contacts | |
Lesson 2.10- | Mapping a Contact’s Address | |
CHAPTER 3- |
Microsoft Office Tutorial: E-Mail |
|
Lesson 3.1- | Using the Inbox | |
Lesson 3.2- | Changing the Inbox View | |
Lesson 3.3- | Message Flags | |
Lesson 3.4- | Searching for Messages | |
Lesson 3.5- | Creating, Addressing, and Sending Messages | |
Lesson 3.6- | Checking Message Spelling | |
Lesson 3.7- | Setting Message Options | |
Lesson 3.8- | Formatting Messages | |
Lesson 3.9- | Using Signatures | |
Lesson 3.10- | Replying to Messages | |
Lesson 3.11- | Forwarding Messages | |
Lesson 3.12- | Sending Attachments | |
Lesson 3.13- | Opening Attachments | |
Lesson 3.14- | Ignoring Conversations | |
CHAPTER 4- |
Microsoft Office Tutorial: The Sent Items Folder |
|
Lesson 4.1- | The Sent Items Folder | |
Lesson 4.2- | Resending Messages | |
Lesson 4.3- | Recalling Messages | |
CHAPTER 5- |
Microsoft Office Tutorial: The Outbox Folder |
|
Lesson 5.1- | Using the Outbox | |
Lesson 5.2- | Using the Drafts Folder | |
CHAPTER 6- |
Microsoft Office Tutorial: Using the Calendar |
|
Lesson 6.1- | The Calendar Window | |
Lesson 6.2- | Switching the Calendar View | |
Lesson 6.3- | Navigating the Calendar | |
Lesson 6.4- | Appointments, Meetings and Events | |
Lesson 6.5- | Manipulating Calendar Objects | |
Lesson 6.6- | Setting an Appointment | |
Lesson 6.7- | Scheduling a Meeting | |
Lesson 6.8- | Checking Meeting Attendance Status | |
Lesson 6.9- | Responding to Meeting Requests | |
Lesson 6.10- | Scheduling an Event | |
Lesson 6.11- | Setting Recurrence | |
Lesson 6.12- | Printing the Calendar | |
Lesson 6.13- | Teams Meetings in Outlook | |
Lesson 6.14- | Meeting Notes | |
CHAPTER 7- |
Microsoft Office Tutorial: Tasks |
|
Lesson 7.1- | Using Tasks | |
Lesson 7.2- | Printing Tasks | |
Lesson 7.3- | Creating a Task | |
Lesson 7.4- | Setting Task Recurrence | |
Lesson 7.5- | Creating a Task Request | |
Lesson 7.6- | Responding to Task Requests | |
Lesson 7.7- | Sending Status Reports | |
Lesson 7.8- | Deleting Tasks | |
CHAPTER 8- |
Microsoft Office Tutorial: Deleted Items |
|
Lesson 8.1- | The Deleted Items Folder | |
Lesson 8.2- | Permanently Deleting Items | |
Lesson 8.3- | Recovering Deleted Items | |
Lesson 8.4- | Recovering and Purging Permanently Deleted Items | |
CHAPTER 9- |
Microsoft Office Tutorial: Groups |
|
Lesson 9.1- | Accessing Groups | |
Lesson 9.2- | Creating a New Group | |
Lesson 9.3- | Adding Members to Groups and Inviting Others | |
Lesson 9.4- | Contributing to Groups | |
Lesson 9.5- | Managing Files in Groups | |
Lesson 9.6- | Accessing the Group Calendar and Notebook | |
Lesson 9.7- | Following and Stop Following Groups | |
Lesson 9.8- | Leaving Groups | |
Lesson 9.9- | Editing, Managing and Deleting Groups | |
CHAPTER 10- |
Microsoft Office Tutorial: The Journal Folder |
|
Lesson 10.1- | The Journal Folder | |
Lesson 10.2- | Switching the Journal View | |
Lesson 10.3- | Recording Journal Items | |
Lesson 10.4- | Opening Journal Entries and Documents | |
Lesson 10.5- | Deleting Journal Items | |
CHAPTER 11- |
Microsoft Office Tutorial: Public Folders |
|
Lesson 11.1- | Creating Public Folders | |
Lesson 11.2- | Setting Permissions | |
Lesson 11.3- | Folder Rules | |
Lesson 11.4- | Copying Public Folders | |
CHAPTER 12- |
Microsoft Office Tutorial: Personal & Private Folders |
|
Lesson 12.1- | Creating a Personal Folder | |
Lesson 12.2- | Setting AutoArchiving for Folders | |
Lesson 12.3- | Creating Private Folders | |
Lesson 12.4- | Creating Search Folders | |
Lesson 12.5- | One-Click Archiving | |
CHAPTER 13- |
Microsoft Office Tutorial:Notes |
|
Lesson 13.1- | Creating and Using Notes | |
CHAPTER 14- |
Microsoft Office Tutorial: Advanced Mailbox Options |
|
Lesson 14.1- | Creating Mailbox Rules | |
Lesson 14.2- | Creating Custom Mailbox Views | |
Lesson 14.3- | Handling Junk Mail | |
Lesson 14.4- | Color Categorizing | |
Lesson 14.5- | Advanced Find | |
Lesson 14.6- | Mailbox Cleanup | |
CHAPTER 15- |
Microsoft Office Tutorial: Outlook Options |
|
Lesson 15.1- | Using Shortcuts | |
Lesson 15.2- | Adding Additional Profiles | |
Lesson 15.3- | Adding Accounts | |
Lesson 15.4- | Outlook Options | |
Lesson 15.5- | Using Outlook Help | |
CHAPTER 16- |
Microsoft Office Tutorial: Delegates |
|
Lesson 16.1- | Creating a Delegate | |
Lesson 16.2- | Acting as a Delegate | |
Lesson 16.3- | Deleting a Delegate | |
CHAPTER 17- |
Microsoft Office Tutorial: Security |
|
Lesson 17.1- | Types of Email Encryption in Outlook | |
Lesson 17.2- | Sending Encrypted Email |
PowerPoint Course Syllabus & Sample Lessons
Select any of the video lessons markedto view them in a new window.
To view a sample of the instruction manual in PDF, click here:
Sample PowerPoint Manual
CHAPTER 1- |
Microsoft Office Tutorial: Getting Acquainted with PowerPoint |
|
Lesson 1.1- | The PowerPoint Environment | |
Lesson 1.2- | The Title Bar | |
Lesson 1.3- | The Ribbon | |
Lesson 1.4- | The “File” Tab and Backstage View | |
Lesson 1.5- | The Quick Access Toolbar | |
Lesson 1.6- | Touch/Mouse Mode | |
Lesson 1.7- | The Scroll Bars | |
Lesson 1.8- | The Presentation View Buttons | |
Lesson 1.9- | The Zoom Slider | |
Lesson 1.10- | The Status Bar | |
Lesson 1.11- | The Mini Toolbar | |
Lesson 1.12- | Keyboard Shortcuts | |
CHAPTER 2- |
Microsoft Office Tutorial: Creating Basic Presentations |
|
Lesson 2.1- | Opening Presentations | |
Lesson 2.2- | Closing Presentations | |
Lesson 2.3- | Creating New Presentations | |
Lesson 2.4- | Saving Presentations | |
Lesson 2.5- | Recovering Unsaved Presentations | |
Lesson 2.6- | Inserting New Slides | |
Lesson 2.7- | Applying Slide Layouts | |
Lesson 2.8- | Slide Selections | |
Lesson 2.9- | Working with PowerPoint File Formats | |
Lesson 2.10- | AutoSave Online Presentations | |
Lesson 2.11- | Reuse Slides in PowerPoint | |
CHAPTER 3- |
Microsoft Office Tutorial: Using Presentation Views |
|
Lesson 3.1- | Normal View | |
Lesson 3.2- | Outline View | |
Lesson 3.3- | Slide Sorter View | |
Lesson 3.4- | Notes Page View | |
Lesson 3.5- | Slide Show View | |
Lesson 3.6- | Reading View | |
CHAPTER 4- |
Microsoft Office Tutorial: Using Text |
|
Lesson 4.1- | Adding Text to Slides | |
Lesson 4.2- | Basic Object Manipulation | |
Lesson 4.3- | Font Formatting | |
Lesson 4.4- | Paragraph Formatting | |
Lesson 4.5- | Applying Custom Bullets and Numbering | |
Lesson 4.6- | Using Tabs | |
Lesson 4.7- | Setting Text Options | |
Lesson 4.8- | Checking Spelling | |
CHAPTER 5- |
Microsoft Office Tutorial: Using Pictures |
|
Lesson 5.1- | Inserting Pictures Saved Locally | |
Lesson 5.2- | Inserting Online Pictures | |
Lesson 5.3- | Basic Graphic Manipulation | |
Lesson 5.4- | Using Picture Tools | |
Lesson 5.5- | Using the Format Picture Task Pane | |
Lesson 5.6- | Fill and Line Settings | |
Lesson 5.7- | Effects Settings | |
Lesson 5.8- | Size and Properties Settings | |
Lesson 5.9- | Picture Settings | |
Lesson 5.10- | Alt Text | |
CHAPTER 6- |
Microsoft Office Tutorial: Drawing Objects |
|
Lesson 6.1- | Inserting Shapes | |
Lesson 6.2- | Formatting Shapes | |
Lesson 6.3- | The Format Shape Task Pane | |
Lesson 6.4- | Inserting WordArt | |
CHAPTER 7- |
Microsoft Office Tutorial: Using SmartArt |
|
Lesson 7.1- | Inserting and Manipulating SmartArt | |
Lesson 7.2- | Formatting SmartArt | |
CHAPTER 8- |
Microsoft Office Tutorial: Inserting Charts, Tables, and Objects |
|
Lesson 8.1- | Inserting Charts | |
Lesson 8.2- | Inserting Tables | |
Lesson 8.3- | Inserting Objects | |
CHAPTER 9- |
Microsoft Office Tutorial: Inserting Video and Audio |
|
Lesson 9.1- | Inserting Videos | |
Lesson 9.2- | Inserting Audio | |
Lesson 9.3- | Recording Audio | |
Lesson 9.4- | Screen Recording | |
CHAPTER 10- |
Microsoft Office Tutorial: Collaborating in PowerPoint |
|
Lesson 10.1- | Collaborating on a Presentation | |
Lesson 10.2- | Using Classic Comments in PowerPoint | |
Lesson 10.3- | Using Modern Comments in PowerPoint | |
Lesson 10.4- | Comparing Presentations | |
CHAPTER 11- |
Microsoft Office Tutorial: Using Themes |
|
Lesson 11.1- | Applying Themes | |
Lesson 11.2- | Customizing Theme Colors | |
Lesson 11.3- | Customizing Theme Fonts | |
Lesson 11.4- | Changing Theme Effects | |
Lesson 11.5- | Customizing Theme Background Styles | |
CHAPTER 12- |
Microsoft Office Tutorial: Applying Animation |
|
Lesson 12.1- | Adding Slide Transition Animation | |
Lesson 12.2- | Adding Object Animation | |
Lesson 12.3- | Animating Multimedia Playback | |
CHAPTER 13- |
Microsoft Office Tutorial: Slide Shows |
|
Lesson 13.1- | Start a Slide Show | |
Lesson 13.2- | Slide Show Pointer Options | |
Lesson 13.3- | Using Custom Shows | |
Lesson 13.4- | Set Up Show | |
Lesson 13.5- | Record a Slide Show | |
Lesson 13.6- | Rehearsing Timings | |
Lesson 13.7- | Subtitles in a Slide Show | |
Lesson 13.8- | Save a Slide Show as a Video | |
Lesson 13.9- | Save as Show | |
Lesson 13.10- | Publish to Stream | |
Lesson 13.11- | Hide a Slide in a Slide Show | |
Lesson 13.12- | Rehearse with Coach | |
CHAPTER 14- |
Microsoft Office Tutorial: Zooms, Links, and Actions |
|
Lesson 14.1- | Using Zooms | |
Lesson 14.2- | Using Links | |
Lesson 14.3- | Using Actions | |
CHAPTER 15- |
Microsoft Office Tutorial: Printing Your Presentation |
|
Lesson 15.1- | Changing Slide Size | |
Lesson 15.2- | Setting the Slide Header and Footer | |
Lesson 15.3- | Previewing and Printing Presentations | |
Lesson 15.4- | Check Accessibility | |
Lesson 15.5- | Creating a PDF Document | |
CHAPTER 16- |
Microsoft Office Tutorial: Using Presentation Masters |
|
Lesson 16.1- | Using Slide Masters and Slide Layouts | |
Lesson 16.2- | Using the Notes Master | |
Lesson 16.3- | Using the Handout Master | |
Lesson 16.4- | Saving a Presentation Template | |
CHAPTER 17- |
Microsoft Office Tutorial: Helping Yourself |
|
Lesson 17.1- | Using PowerPoint Help | |
Lesson 17.2- | The Tell Me Bar and Microsoft Search | |
CHAPTER 18- |
Microsoft Office Tutorial: PowerPoint Options and Export Options |
|
Lesson 18.1- | Setting PowerPoint Options | |
Lesson 18.2- | Creating an Animated GIF | |
Lesson 18.3- | Package a Presentation for CD | |
Lesson 18.4- | Exporting Handouts to Word |
Publisher Course Syllabus & Sample Lessons
Select any of the video lessons markedto view them in a new window.
To view a sample of the instruction manual in PDF, click here:
Sample Publisher Manual
CHAPTER 1- |
Microsoft Office Tutorial: Getting Acquainted with Publisher |
|
Lesson 1.1- | The Publisher Environment | |
Lesson 1.2- | The Title Bar | |
Lesson 1.3- | The Ribbon | |
Lesson 1.4- | The File Tab and Backstage View | |
Lesson 1.5- | The Quick Access Toolbar | |
Lesson 1.6- | Touch Mode | |
Lesson 1.7- | The Scroll Bars | |
Lesson 1.8- | The Page Layout View Buttons | |
Lesson 1.9- | The Zoom Slider and Zoom Button | |
Lesson 1.10- | The Status Bar | |
Lesson 1.11- | The Mini Toolbar | |
Lesson 1.12- | Keyboard Shortcuts | |
CHAPTER 2- |
Microsoft Office Tutorial: Creating Basic Publications |
|
Lesson 2.1- | Creating New Publications | |
Lesson 2.2- | Changing the Publication Template | |
Lesson 2.3- | Using Business Information | |
Lesson 2.4- | Saving Publications | |
Lesson 2.5- | Closing Publications | |
Lesson 2.6- | Opening Publications | |
Lesson 2.7- | Inserting New Pages | |
Lesson 2.8- | Deleting Pages | |
Lesson 2.9- | Moving Pages | |
CHAPTER 3- |
Microsoft Office Tutorial: Basic Skills |
|
Lesson 3.1- | Inserting Text Boxes | |
Lesson 3.2- | Inserting Shapes | |
Lesson 3.3- | Adding Text to Shapes | |
Lesson 3.4- | Inserting Pictures Saved Locally | |
Lesson 3.5- | Inserting Online Pictures | |
Lesson 3.6- | Inserting Picture Placeholders | |
Lesson 3.7- | Using the Scratch Area | |
Lesson 3.8- | Moving, Resizing, and Rotating Objects | |
Lesson 3.9- | Deleting Objects | |
Lesson 3.10- | Using Find and Replace | |
Lesson 3.11- | Using AutoCorrect | |
Lesson 3.12- | Inserting WordArt | |
CHAPTER 4- |
Microsoft Office Tutorial: Formatting Objects |
|
Lesson 4.1- | Formatting Text | |
Lesson 4.2- | Formatting Shapes | |
Lesson 4.3- | Formatting Clip Art and Pictures | |
CHAPTER 5- |
Microsoft Office Tutorial: Using Building Blocks |
|
Lesson 5.1- | Creating Basic Building Blocks | |
Lesson 5.2- | Using Building Blocks | |
CHAPTER 6- |
Microsoft Office Tutorial: Master Pages |
|
Lesson 6.1- | Using Master Pages | |
CHAPTER 7- |
Microsoft Office Tutorial: Customizing Schemes |
|
Lesson 7.1- | Creating a Custom Color Scheme | |
Lesson 7.2- | Creating a Custom Font Scheme | |
Lesson 7.3- | Customizing Page Backgrounds | |
CHAPTER 8- |
Microsoft Office Tutorial: Using Tables |
|
Lesson 8.1- | Creating and Deleting Tables | |
Lesson 8.2- | Selecting Table Elements | |
Lesson 8.3- | Inserting and Deleting Columns and Rows | |
Lesson 8.4- | Merging Text in Table Cells | |
Lesson 8.5- | Modifying Text in Table Cells | |
Lesson 8.6- | Formatting Tables | |
CHAPTER 9- |
Microsoft Office Tutorial: Page Setup and Layouts |
|
Lesson 9.1- | Using Page Setup | |
Lesson 9.2- | Using Layout Guides | |
Lesson 9.3- | Using the Rulers | |
CHAPTER 10- |
Microsoft Office Tutorial: Mailings |
|
Lesson 10.1- | Mail Merge | |
Lesson 10.2- | The Step by Step Mail Merge Wizard | |
Lesson 10.3- | Creating a Data Source | |
Lesson 10.4- | Selecting Recipients | |
Lesson 10.5- | Inserting and Deleting Merge Fields | |
Lesson 10.6- | Previewing a Merge | |
Lesson 10.7- | Detaching the Data Source | |
Lesson 10.8- | Finishing a Mail Merge | |
Lesson 10.9- | Merging a Catalog | |
CHAPTER 11- |
Microsoft Office Tutorial: Printing |
|
Lesson 11.1- | Previewing and Printing | |
Lesson 11.2- | Using the Pack and Go Feature | |
Lesson 11.3- | Sharing and Exporting Publications | |
CHAPTER 12- |
Microsoft Office Tutorial: Helping Yourself |
|
Lesson 12.1- | Using Publisher Help |
Word Course Syllabus & Sample Lessons
Select any of the video lessons markedto view them in a new window.
To view a sample of the instruction manual in PDF, click here:
Sample Word Manual
CHAPTER 1- |
Microsoft Office Tutorial: Getting Acquainted with Word |
|
Lesson 1.1- | About Word | |
Lesson 1.2- | The Word Environment | |
Lesson 1.3- | The Title Bar | |
Lesson 1.4- | The Ribbon | |
Lesson 1.5- | The “File” Tab and Backstage View | |
Lesson 1.6- | The Quick Access Toolbar | |
Lesson 1.7- | Touch Mode | |
Lesson 1.8- | The Ruler | |
Lesson 1.9- | The Scroll Bars | |
Lesson 1.10- | The Document View Buttons | |
Lesson 1.11- | The Zoom Slider | |
Lesson 1.12- | The Status Bar | |
Lesson 1.13- | The Mini Toolbar | |
Lesson 1.14- | Keyboard Shortcuts | |
CHAPTER 2- |
Microsoft Office Tutorial: Creating Basic Documents |
|
Lesson 2.1- | Opening Documents | |
Lesson 2.2- | Closing Documents | |
Lesson 2.3- | Creating New Documents | |
Lesson 2.4- | Saving Documents | |
Lesson 2.5- | Recovering Unsaved Documents | |
Lesson 2.6- | Entering Text | |
Lesson 2.7- | Moving through Text | |
Lesson 2.8- | Selecting Text | |
Lesson 2.9- | Non-Printing Characters | |
Lesson 2.10- | Working with Word File Formats | |
Lesson 2.11- | AutoSave Online Documents | |
CHAPTER 3- |
Microsoft Office Tutorial: Document Views |
|
Lesson 3.1- | Changing Document Views | |
Lesson 3.2- | Showing and Hiding the Ruler | |
Lesson 3.3- | Showing and Hiding Gridlines | |
Lesson 3.4- | Using the Navigation Pane | |
Lesson 3.5- | Zooming the Document | |
Lesson 3.6- | Opening a Copy of a Document in a New Window | |
Lesson 3.7- | Arranging Open Document Windows | |
Lesson 3.8- | Split Window | |
Lesson 3.9- | Comparing Open Documents | |
Lesson 3.10- | Switching Open Documents | |
Lesson 3.11- | Switching to Full Screen View | |
CHAPTER 4- |
Microsoft Office Tutorial: Basic Editing Skills |
|
Lesson 4.1- | Deleting Text | |
Lesson 4.2- | Cutting, Copying, and Pasting | |
Lesson 4.3- | Undoing and Redoing Actions | |
Lesson 4.4- | Finding and Replacing Text | |
Lesson 4.5- | Selecting Text and Objects | |
CHAPTER 5- |
Microsoft Office Tutorial: Basic Proofing Skills |
|
Lesson 5.1- | The Spelling and Grammar Tool | |
Lesson 5.2- | Setting Default Proofing Options | |
Lesson 5.3- | Using the Thesaurus | |
Lesson 5.4- | Finding the Word Count | |
Lesson 5.5- | Translating Documents | |
Lesson 5.6- | Read Aloud in Word | |
CHAPTER 6- |
Microsoft Office Tutorial: Font Formatting |
|
Lesson 6.1- | Formatting Fonts | |
Lesson 6.2- | The Font Dialog Box | |
Lesson 6.3- | The Format Painter | |
Lesson 6.4- | Applying Styles to Text | |
Lesson 6.5- | Removing Styles from Text | |
CHAPTER 7- |
Microsoft Office Tutorial: Formatting Paragraphs |
|
Lesson 7.1- | Aligning Paragraphs | |
Lesson 7.2- | Indenting Paragraphs | |
Lesson 7.3- | Line Spacing and Paragraph Spacing | |
CHAPTER 8- |
Microsoft Office Tutorial: Document Layout |
|
Lesson 8.1- | About Documents and Sections | |
Lesson 8.2- | Setting Page and Section Breaks | |
Lesson 8.3- | Creating Columns in a Document | |
Lesson 8.4- | Creating Column Breaks | |
Lesson 8.5- | Using Headers and Footers | |
Lesson 8.6- | The Page Setup Dialog Box | |
Lesson 8.7- | Setting Margins | |
Lesson 8.8- | Paper Settings | |
Lesson 8.9- | Layout Settings | |
Lesson 8.10- | Adding Line Numbers | |
Lesson 8.11- | Hyphenation Settings | |
CHAPTER 9- |
Microsoft Office Tutorial: Using Templates |
|
Lesson 9.1- | Using Templates | |
Lesson 9.2- | Creating Personal Templates | |
CHAPTER 10- |
Microsoft Office Tutorial: Printing Documents |
|
Lesson 10.1- | Previewing and Printing Documents | |
CHAPTER 11- |
Microsoft Office Tutorial: Helping Yourself |
|
Lesson 11.1- | The Tell Me Bar and Microsoft Search | |
Lesson 11.2- | Using Word Help | |
Lesson 11.3- | Smart Lookup | |
CHAPTER 12- |
Microsoft Office Tutorial: Working with Tabs |
|
Lesson 12.1- | Using Tab Stops | |
Lesson 12.2- | Using the Tabs Dialog Box | |
CHAPTER 13- |
Microsoft Office Tutorial: Pictures and Media |
|
Lesson 13.1- | Inserting Online Pictures | |
Lesson 13.2- | Inserting Your Own Pictures | |
Lesson 13.3- | Using Picture Tools | |
Lesson 13.4- | Using the Format Picture Task Pane | |
Lesson 13.5- | Fill & Line Settings | |
Lesson 13.6- | Effects Settings | |
Lesson 13.7- | Alt Text | |
Lesson 13.8- | Picture Settings | |
Lesson 13.9- | Inserting Screenshots | |
Lesson 13.10- | Inserting Screen Clippings | |
Lesson 13.11- | Inserting Online Video | |
Lesson 13.12- | Inserting Icons | |
Lesson 13.13- | Inserting 3D Models | |
Lesson 13.14- | Formatting 3D Models | |
CHAPTER 14- |
Microsoft Office Tutorial: Drawing Objects |
|
Lesson 14.1- | Inserting Shapes | |
Lesson 14.2- | Inserting WordArt | |
Lesson 14.3- | Inserting Text Boxes | |
Lesson 14.4- | Formatting Shapes | |
Lesson 14.5- | The Format Shape Task Pane | |
Lesson 14.6- | Inserting SmartArt | |
Lesson 14.7- | Design and Format SmartArt | |
Lesson 14.8- | Inserting Charts | |
CHAPTER 15- |
Microsoft Office Tutorial: Using Building Blocks |
|
Lesson 15.1- | Creating Building Blocks | |
Lesson 15.2- | Using Building Blocks | |
CHAPTER 16- |
Microsoft Office Tutorial: Styles |
|
Lesson 16.1- | About Styles | |
Lesson 16.2- | Applying Styles | |
Lesson 16.3- | Showing Headings in the Navigation Pane | |
Lesson 16.4- | The Styles Task Pane | |
Lesson 16.5- | Clearing Styles from Text | |
Lesson 16.6- | Creating a New Style | |
Lesson 16.7- | Modifying an Existing Style | |
Lesson 16.8- | Selecting All Instances of a Style in a Document | |
Lesson 16.9- | Renaming Styles | |
Lesson 16.10- | Deleting Custom Styles | |
Lesson 16.11- | Using the Style Inspector Pane | |
Lesson 16.12- | Using the Reveal Formatting Pane | |
CHAPTER 17- |
Microsoft Office Tutorial: Themes and Style Sets |
|
Lesson 17.1- | Applying a Theme | |
Lesson 17.2- | Applying a Style Set | |
Lesson 17.3- | Applying and Customizing Theme Colors | |
Lesson 17.4- | Applying and Customizing Theme Fonts | |
Lesson 17.5- | Selecting Theme Effects | |
CHAPTER 18- |
Microsoft Office Tutorial: Page Backgrounds |
|
Lesson 18.1- | Applying Watermarks | |
Lesson 18.2- | Creating Custom Watermarks | |
Lesson 18.3- | Removing Watermarks | |
Lesson 18.4- | Selecting a Page Background Color or Fill Effect | |
Lesson 18.5- | Applying Page Borders | |
CHAPTER 19- |
Microsoft Office Tutorial: Bullets and Numbering |
|
Lesson 19.1- | Applying Bullets and Numbering | |
Lesson 19.2- | Formatting Bullets and Number | |
Lesson 19.3- | Applying a Multilevel List | |
Lesson 19.4- | Modifying a Multilevel List | |
CHAPTER 20- |
Microsoft Office Tutorial: Tables |
|
Lesson 20.1- | Using Tables | |
Lesson 20.2- | Creating Tables | |
Lesson 20.3- | Selecting Table Objects | |
Lesson 20.4- | Inserting and Deleting Columns and Rows | |
Lesson 20.5- | Deleting Cells and Tables | |
Lesson 20.6- | Merging and Splitting Cells | |
Lesson 20.7- | Adjusting Cell Size | |
Lesson 20.8- | Aligning Text in Table Cells | |
Lesson 20.9- | Converting a Table into Text | |
Lesson 20.10- | Sorting Tables | |
Lesson 20.11- | Formatting Tables | |
Lesson 20.12- | Inserting Quick Tables | |
CHAPTER 21- |
Microsoft Office Tutorial: Table Formulas |
|
Lesson 21.1- | Inserting Table Formulas | |
Lesson 21.2- | Recalculating Word Formulas | |
Lesson 21.3- | Viewing Formulas vs. Formula Results | |
Lesson 21.4- | Inserting a Microsoft Excel Worksheet | |
CHAPTER 22- |
Microsoft Office Tutorial: Inserting Page Elements |
|
Lesson 22.1- | Inserting Drop Caps | |
Lesson 22.2- | Inserting Equations | |
Lesson 22.3- | Inserting Ink Equations | |
Lesson 22.4- | Inserting Symbols | |
Lesson 22.5- | Inserting Bookmarks | |
Lesson 22.6- | Inserting Hyperlinks | |
CHAPTER 23- |
Microsoft Office Tutorial: Outlines |
|
Lesson 23.1- | Using Outline View | |
Lesson 23.2- | Promoting and Demoting Outline Text | |
Lesson 23.3- | Moving Selected Outline Text | |
Lesson 23.4- | Collapsing and Expanding Outline Text | |
CHAPTER 24- |
Microsoft Office Tutorial: Mailings |
|
Lesson 24.1- | Mail Merge | |
Lesson 24.2- | The Step by Step Mail Merge Wizard | |
Lesson 24.3- | Creating a Data Source | |
Lesson 24.4- | Selecting Recipients | |
Lesson 24.5- | Inserting and Deleting Merge Fields | |
Lesson 24.6- | Error Checking | |
Lesson 24.7- | Detaching a Data Source | |
Lesson 24.8- | Finishing a Mail Merge | |
Lesson 24.9- | Mail Merge Rules | |
Lesson 24.10- | The Ask Mail Merge Rule | |
Lesson 24.11- | The Fill-in Mail Merge Rule | |
Lesson 24.12- | The If…Then…Else Mail Merge Rule | |
Lesson 24.13- | The Merge Record # Mail Merge Rule | |
Lesson 24.14- | The Merge Sequence # Mail Merge Rule | |
Lesson 24.15- | The Next Record Mail Merge Rule | |
Lesson 24.16- | The Next Record If Mail Merge Rule | |
Lesson 24.17- | The Set Bookmark Mail Merge Rule | |
Lesson 24.18- | The Skip Record If Mail Merge Rule | |
Lesson 24.19- | Deleting Mail Merge Rules in Word | |
CHAPTER 25- |
Microsoft Office Tutorial: Sharing Documents |
|
Lesson 25.1- | Sharing Documents in Word Using Co-authoring | |
Lesson 25.2- | Inserting Comments | |
Lesson 25.3- | Sharing by Email | |
Lesson 25.4- | Presenting Online | |
Lesson 25.5- | Posting to a Blog | |
Lesson 25.6- | Saving as a PDF or XPS File | |
Lesson 25.7- | Saving as a Different File Type | |
CHAPTER 26- |
Microsoft Office Tutorial: Creating a Table of Contents |
|
Lesson 26.1- | Creating a Table of Contents | |
Lesson 26.2- | Customizing a Table of Contents | |
Lesson 26.3- | Updating a Table of Contents | |
Lesson 26.4- | Deleting a Table of Contents | |
CHAPTER 27- |
Microsoft Office Tutorial: Creating an Index |
|
Lesson 27.1- | Creating an Index | |
Lesson 27.2- | Customizing an Index | |
Lesson 27.3- | Updating an Index | |
CHAPTER 28- |
Microsoft Office Tutorial: Citations and Bibliography |
|
Lesson 28.1- | Select a Citation Style | |
Lesson 28.2- | Insert a Citation | |
Lesson 28.3- | Insert a Citation Placeholder | |
Lesson 28.4- | Inserting Citations Using the Researcher Pane | |
Lesson 28.5- | Managing Sources | |
Lesson 28.6- | Editing Sources | |
Lesson 28.7- | Creating a Bibliography | |
CHAPTER 29- |
Microsoft Office Tutorial: Captions |
|
Lesson 29.1- | Inserting Captions | |
Lesson 29.2- | Inserting a Table of Figures | |
Lesson 29.3- | Inserting a Cross-Reference | |
Lesson 29.4- | Updating a Table of Figures | |
CHAPTER 30- |
Microsoft Office Tutorial: Creating Forms |
|
Lesson 30.1- | Displaying the Developer Tab | |
Lesson 30.2- | Creating a Form | |
Lesson 30.3- | Inserting Controls | |
Lesson 30.4- | Repeating Section Content Control | |
Lesson 30.5- | Adding Instructional Text | |
Lesson 30.6- | Protecting a Form | |
CHAPTER 31- |
Microsoft Office Tutorial: Making Macros |
|
Lesson 31.1- | Recording Macros | |
Lesson 31.2- | Running and Deleting Recorded Macros | |
Lesson 31.3- | Assigning Macros | |
CHAPTER 32- |
Microsoft Office Tutorial: Word Options |
|
Lesson 32.1- | Setting Word Options | |
Lesson 32.2- | Setting Document Properties | |
Lesson 32.3- | Checking Accessibility | |
CHAPTER 33- |
Microsoft Office Tutorial: Document Security |
|
Lesson 33.1- | Applying Password Protection to a Document | |
Lesson 33.2- | Removing Password Protection from a Document | |
Lesson 33.3- | Restrict Editing within a Document | |
Lesson 33.4- | Removing Editing Restrictions from a Document |
Microsoft Office Tutorial: Course Overview
Microsoft Office is a powerful suite of desktop applications used by individuals and businesses the world over. Mastering Microsoft Office Made Easy brings together 6 of our most popular application courses. Our Microsoft Office tutorial includes introductory through advanced material in Microsoft Access, Excel, Outlook, PowerPoint, Publisher, and Word. This Microsoft Office tutorial also offers over 39 hours of expert video training, 6 classroom instruction manuals in PDF, practice exercises and much more. This complete Microsoft Office tutorial covers the same curriculum as our classroom training and was designed to provide a solid foundation in Office.
Courses includes video lessons, printable instruction manuals, a practice exam with evaluative feedback (find out why your answers are right or wrong), your final exam submission, and a course certificate of completion- for each of the six courses.
At TeachUcomp, Inc., you choose how you want your Microsoft Office tutorial delivered.
Online subscriptions offer the most flexibility and value. With online training, you can access your courses anytime and anywhere you have an internet connection (including all new releases and updates). Your subscription grants you instant access to ALL of our courses for one low price. There are no contracts and you can cancel at any time. You may choose between a monthly or annual plan.
Courses are also available individually via digital download and online for a one-time charge.