Microsoft Office 2013 Training Tutorial

BY
Udemy

Obtain a detailed understanding of the core principles involved with Microsft Office software like Excel, Access, Word, Outlook, Powerpoint, and Publisher.

Mode

Online

Fees

₹ 799

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

TeachUcomp, Inc. developed the Microsoft Office 2013 Training Tutorial certification course, which is a high-quality software training course offered by Udemy and geared at participants who want to learn the principles and features of the Microsoft Office 2013 edition from the ground up. The Microsoft Office 2013 Training Tutorial online course by Udemy utilizes video-based learning material to explain the principles and functionalities of software such as Access, Excel, OneNote, Outlook, PowerPoint, Publisher, Word, and Windows.

Microsoft Office 2013 Training Tutorial online classes are designed for the participants who are total beginners who wish to develop in their careers by equipping them with the information and abilities needed to work on projects in the Microsoft Office 2013 edition. This is a self-paced course that covers a wide range of MS Office tools and concepts, including data bars, sparklines, macros, pivot tables, power pivot, data models, charts, graphs, forms, reports, file management, windows management, worksheet, workbook, animations, charting, graphing, conditional formatting, and much more.

The highlights

  • Certificate of completion
  • Self-paced course
  • 43.5 hours of pre-recorded video content

Program offerings

  • Online course
  • Learning resources. 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 799
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

After completing the Microsoft Office 2013 Training Tutorial online certification, participants will be able to develop a detailed knowledge of the principles and techniques associated with Microsoft Office including applications like Excel, Word, Outlook, OneNote, PowerPoint, Publisher, Access, and Windows. Participants will learn about tables, charts, sparklines, macros, data models, queries, forms, reports, spreadsheets, workbooks, animations, and presentations in the Microsoft Office environment. In addition, participants will learn data entry, graphing, charting, conditional formatting, window management, and file management procedures.

The syllabus

Getting Acquainted with Access

  • Creating a New Database- 2013
  • Creating a New Database- 2010:2007
  • Overview of a Database
  • The Access Interface
  • Touch Mode- 2013
  • Viewing Database Objects in the Navigation Pane
  • Opening and Closing Databases- 2013
  • Opening and Closing Databases- 2010:2007

Creating Relational Database Tables

  • The ‘Flat-File’ Method of Data Storage
  • The Relational Model of Data Storage
  • Tips for Creating a Relational Database
  • Creating Relational Database Tables
  • Assigning a Primary Key to a Table

Using Tables

  • Using Datasheet View
  • Navigating in Datasheet View
  • Adding Records in Datasheet View
  • Editing and Deleting Records in Datasheet View
  • Inserting New Fields
  • Renaming Fields
  • Deleting Fields
  • Creating and Deleting Tables
  • Selecting Table Elements
  • Inserting and Deleting Columns and Rows
  • Merging and Splitting Cells
  • Modifying Text in Table Cells
  • Formatting Tables

Field Properties

  • Setting Field Properties
  • The Field Size Property
  • The Format Property for Date/Time Fields
  • The Format Property for Logical Fields
  • Setting Default Values for Fields
  • Setting Input Masks
  • Setting Up Validation Rules and Responses
  • Requiring Field Input
  • Allowing Zero Length Entries

Joining Tables

  • The Relationships Window
  • Enforcing Referential Integrity
  • Creating Lookup Fields

Indexing Tables

  • Indexes
  • Creating Indexes
  • Deleting Indexes

Queries

  • Using the Simple Query Wizard
  • Designing Queries
  • Joining Tables in a Query
  • Adding Criteria to the QBE Grid
  • Running a Query
  • How is Using the QBE Grid Writing SQL Code?
  • Sorting Query Results
  • Hiding Fields in a Result Set
  • Using Comparison Operators
  • Using ‘AND’ and ‘OR’ Conditions

Advanced Queries

  • Using the ‘Between… And’ Condition
  • Using Wildcard Characters in Queries
  • Creating a Calculated Field
  • Creating ‘Top Value’ Queries
  • Function Queries
  • Parameter Queries

Advanced Query Types

  • Make Table Queries
  • Update Queries
  • Append Queries
  • Delete Queries
  • Crosstab Queries
  • The Find Duplicates Query
  • The Find Unmatched Query

Creating Forms

  • Forms Overview
  • The Form Wizard
  • Creating Forms
  • Using Forms
  • Form and Report Layout View
  • Form and Report Design View
  • Viewing the Ruler and Grid
  • The “Snap to Grid” Feature
  • Creating a Form in Design View
  • Inserting Your Own Pictures
  • Displaying the Developer Tab- 2013:2010
  • Using Picture Tools- 2013:2010
  • Displaying the Developer Tab- 2007 Only
  • Using Picture Tools- 2007 Only
  • Creating a Form
  • Using the Format Picture Task Pane- 2013 Only
  • Inserting Controls
  • Fill & Line Settings- 2013 Only
  • Repeating Section Content Control- 2013 Only
  • Effects Settings- 2013 Only
  • Adding Instructional Text
  • Layout & Properties Settings- 2013 Only
  • Protecting a Form
  • Picture Settings- 2013 Only

Form & Report Controls

  • Selecting Controls
  • Deleting Controls
  • Moving and Resizing Controls
  • Sizing Controls to Fit
  • Nudging Controls
  • Aligning, Spacing, and Sizing Controls
  • Formatting Controls
  • Viewing Control Properties

Using Controls

  • The Controls Group
  • Adding Label Controls
  • Adding Logo and Image Controls
  • Adding Line and Rectangle Controls
  • Adding Combo Box Controls
  • Adding List Box Controls
  • Setting Tab Order

Subforms

  • Creating Subforms
  • Using the Subform/Subreport Control

Reports

  • Using the Report Wizard
  • Using Basic Reports
  • Creating a Report in Design View
  • Sorting and Grouping Data in Reports
  • Creating Calculated Fields

Subreports

  • Creating Subreports

Charting Data

  • Using Charts

Macros in Access 2007

  • Creating and Using Macros
  • Macro Actions
  • Assigning Macros to a Command Button
  • Conditional Macros and Option Groups
  • Using Group Names in Macros
  • Creating Autoexec Macros

Macros in Access 2013:2010

  • Creating a Standalone Macro
  • Assigning Macros to a Command Button
  • Using Program Flow with Macros
  • Creating Autoexec Macros
  • Creating Data Macros

Switchboard and Navigation Forms

  • Creating a Switchboard Form
  • Creating a Navigation Form- 2013:2010 Only
  • Controlling Startup Behavior- 2007 Only
  • Controlling Startup Behavior- 2013:2010 Only

Advanced Features

  • Getting External Data
  • Exporting Data
  • Setting a Database Password- 2007 Only
  • Setting a Database Password- 2013:2010 Only
  • Using Help

Conclusion

  • Course Conclusion
  • Course Conclusion
  • Course Conclusion
  • Course Conclusion

Instruction Manuals

  • Introductory Access Manual
  • Intermediate Access Manual
  • Advanced Access Manual
  • Introductory Excel Manual
  • Intermediate Excel Manual
  • Advanced Excel Manual
  • Introductory Outlook Manual
  • Advanced Outlook Manual
  • Introductory PowerPoint Manual
  • Advanced PowerPoint Manual
  • Formatting Shapes- 2007 Only
  • Introductory Word Manual
  • The Format Shape Task Pane- 2013 Only
  • Intermediate Word Manual
  • The Format Shape Dialog Box- 2010 Only
  • Advanced Word Manual
  • The Format AutoShape Dialog Box- 2007 Only

Getting Acquainted with Excel

  • About Excel
  • The Excel Environment- 2013
  • The Excel Environment- 2010
  • The Excel Environment- 2007
  • The Title Bar
  • The Ribbon
  • The “File” Tab and Backstage View- 2013:2010
  • The Microsoft Office Button- 2007 Only
  • Scroll Bars
  • The Quick Access Toolbar
  • Touch Mode- 2013
  • The Formula Bar
  • The Workbook Window
  • The Status Bar
  • The Workbook View Buttons
  • The Zoom Slider
  • The Mini Toolbar
  • Keyboard Shortcuts

File Management

  • Creating New Workbooks- 2013 Only
  • Creating New Workbooks- 2010 Only
  • Creating New Workbooks- 2007 Only
  • Saving Workbooks- 2013 Only
  • Saving Workbooks- 2010 Only
  • Saving Workbooks- 2007 Only
  • Closing Workbooks- 2013 Only
  • Closing Workbooks- 2010:2007 Only
  • Opening Workbooks- 2013 Only
  • Opening Workbooks- 2010 Only
  • Opening Workbooks- 2007 Only
  • Recovering Unsaved Workbooks- 2013 Only
  • Using the “Window” Command Group
  • Switching to Full Screen View
  • Working with Excel File Formats

Data Entry

  • Selecting Cells
  • Entering Text into Cells
  • Entering Numbers into Cells
  • AutoComplete
  • Pick from Drop-Down List
  • Flash Fill- 2013 Only
  • Selecting Ranges
  • Ranged Data Entry
  • Using AutoFill

Creating Formulas

  • Ranged Formula Syntax
  • Simple Formula Syntax
  • Writing Formulas
  • Using AutoSum
  • Inserting Functions
  • Editing a Range
  • Formula AutoCorrect
  • AutoCalculate
  • Function Compatibility- 2013 Only

Copying & Pasting Formulas

  • Relative References and Absolute References
  • Cutting, Copying, and Pasting Data
  • AutoFilling Cells
  • The Undo Button
  • The Redo Button

Columns & Rows

  • Selecting Columns and Rows
  • Adjusting Column Width and Row Height
  • Hiding and Unhiding Columns and Rows
  • Inserting and Deleting Columns and Rows

Formatting Worksheets

  • Formatting Cells
  • The Format Cells Dialog Box
  • Clearing All Formatting from Cells
  • Copying All Formatting from Cells to Another Area

Worksheet Tools

  • Inserting and Deleting Worksheets
  • Selecting Multiple Worksheets
  • Navigating Worksheets- 2013 Only
  • Navigating Worksheets- 2010:2007
  • Renaming Worksheets
  • Coloring Worksheet Tabs
  • Copying or Moving Worksheets

Setting Worksheet Layout

  • Using Page Break Preview
  • Using the Page Layout View
  • The Page Setup Dialog Box

Printing Worksheets

  • Previewing and Printing Worksheets- 2013:2010
  • Using Print Preview- 2007 Only
  • Printing Worksheets- 2007 Only

Helping Yourself

  • Using Excel Help
  • Using OneNote Help
  • Using PowerPoint Help
  • Using Publisher Help
  • Customizing a Table of Contents
  • Using Word Help
  • Updating a Table of Contents

3D Formulas

  • Creating 3D Formulas
  • 3D Formula Syntax
  • Creating 3D Range References

Named Ranges

  • Naming Ranges
  • Creating Names from Headings
  • Moving to a Named Range
  • Using Named Ranges in Formulas
  • Naming 3D Ranges
  • Managing Named Ranges

Conditional Formatting and Cell Styles

  • Conditional Formatting
  • Finding Cells with Conditional Formatting
  • Clearing Conditional Formatting
  • Using Table and Cell Styles

Conditional FormattingPaste Special

  • Using Paste Special
  • Pasting Linked Formulas

Sharing Workbooks

  • Sharing Workbooks
  • Highlighting Changes
  • Reviewing Changes
  • Using Comments
  • Compare and Merge Workbooks

Auditing Worksheets

  • Auditing Worksheets
  • Tracing Precedent and Dependent Cells
  • Tracing Errors
  • Error Checking
  • Using the Watch Window
  • Cell Validation

Outlining Worksheets

  • Using Outlines
  • Applying and Removing Outlines

Consolidating Worksheets

  • Consolidating Data

Tables

  • Creating a Table
  • Adding an Editing Records
  • Inserting Records and Fields
  • Deleting Records and Fields
  • Creating a Table
  • Working with Columns and Rows
  • Formatting Tables and Table Data
  • Moving Tables and Table Data
  • Working with Word File Formats
  • Using Tables

Sorting Data

  • Sorting Data
  • Custom Sort Orders

Filtering Data

  • Using AutoFilters
  • Using the Top 10 AutoFilter
  • Using a Custom AutoFilter
  • Creating Advanced Filters
  • Applying Multiple Criteria
  • Using Complex Criteria
  • Copying Filter Results to a New Location
  • Using Database Functions

Using What-If Analysis

  • Using Data Tables
  • Using Scenario Manager
  • Using Goal Seek

Table-Related Functions

  • The Hlookup and Vlookup Functions
  • Using the IF, AND, and OR Functions

Sparklines

  • Inserting and Deleting Sparklines
  • Modifying Sparklines

Creating Charts In Excel 2013

  • Creating Charts
  • Selecting Charts and Chart Elements
  • Adding Chart Elements
  • Moving and Resizing Charts
  • Changing the Chart Type
  • Changing the Data Range
  • Switching Column and Row Data
  • Choosing a Chart Layout
  • Choosing a Chart Style
  • Changing Color Schemes
  • Printing Charts
  • Deleting Charts

Creating Charts in Excel 2010 & 2007

  • Creating Charts
  • Selecting Charts and Chart Elements
  • Moving and Resizing Charts
  • Changing the Chart Type
  • Changing the Data Range
  • Switching Column and Row Data
  • Choosing a Chart Layout
  • Choosing a Chart Style
  • Printing Charts
  • Deleting Charts

Formatting Charts in Excel 2013

  • Formatting Chart Objects
  • Inserting Objects into a Chart
  • Formatting Axes
  • Formatting Axis Titles
  • Formatting a Chart Title
  • Formatting Data Labels
  • Formatting a Data Table
  • Formatting Error Bars
  • Formatting Gridlines
  • Formatting a Legend
  • Formatting Drop and High-Low Lines
  • Formatting Trendlines
  • Formatting Up/Down Bars
  • Formatting the Chart and Plot Areas
  • Naming Charts
  • Applying Shape Styles
  • Applying WordArt Styles
  • Saving Custom Chart Templates

Formatting Charts in Excel 2010 & 2007

  • Formatting Chart Objects
  • Inserting Objects into a Chart
  • Changing Chart Labels
  • Changing Axes Display
  • Changing the Chart Background
  • Applying Chart Analysis Lines
  • Naming Charts
  • Applying Shape Styles to Chart Elements
  • Applying WordArt Styles to Chart Elements
  • Saving Custom Chart Templates

Data Models- 2013

  • Creating a Data Model from External Relational Data
  • Creating a Data Model from Excel Tables
  • Relating Tables in a Data Model
  • Managing a Data Model

PivotTables and PivotCharts- 2013

  • Creating Recommended PivotTables
  • Manually Creating a PivotTable
  • Creating a PivotChart
  • Manipulating a PivotTable or PivotChart
  • Changing Calculated Value Fields
  • Formatting PivotTables
  • Formatting PivotCharts
  • Setting PivotTable Options
  • Sorting and Filtering Using Field Headers

PivotTables and PivotCharts- 2010:2007

  • Creating PivotTables and PivotCharts
  • Manipulating a PivotTable
  • Changing Calculated Value Fields
  • Applying PivotTable Styles
  • Creating a PivotChart
  • Setting PivotTable Options
  • Sorting and Filtering PivotTable Data

PowerPivot

  • Starting PowerPivot
  • Managing the Data Model
  • Calculated Columns and Fields
  • Creating KPIs
  • Creating and Managing Perspectives
  • PowerPivot PivotTables and PivotCharts

Power View

  • Starting Power View
  • Adding Report Visualizations
  • Changing the Layout of Report Visualizations
  • Using Undo and Redo in Power View
  • Formatting the Power View Sheet
  • Creating Multiples in a Chart

Slicers and Timelines

  • Inserting and Deleting Slicers
  • Modifying Slicers
  • Inserting and Deleting Timelines
  • Modifying Timelines

Security Features

  • Unlocking Cells
  • Worksheet Protection
  • Workbook Protection
  • Password Protecting Excel Files- 2013
  • Password Protecting Excel Files- 2010:2007

Making Macros

  • Recording Macros
  • Running and Deleting Recorded Macros
  • The Personal Macro Workbook
  • The Format Picture Dialog Box- 2010 Only
  • The Format Picture Dialog Box- 2007 Only
  • Running and Deleting Recorded Macros

Getting Acquainted with OneNote

  • The OneNote Environment
  • The Title Bar
  • The Ribbon
  • The “File” Tab and Backstage View
  • The Quick Access Toolbar
  • The Scroll Bars
  • The Mini Toolbar
  • The Default “Personal” Notebook

Getting Started

  • Opening, Saving and Closing Notebooks
  • Creating New Notebooks
  • Creating, Moving and Deleting Sections and Pages
  • Creating, Moving and Deleting Subpages

Notes

  • Creating a Basic Note
  • Quick Notes (Unfiled Notes)
  • Copying and Pasting Content
  • Screen Clippings
  • Adding Pictures
  • Adding Audio & Video Files
  • Recording Audio & Video Files
  • Adding Other Types of Files
  • Embedding an Excel Spreadsheet or a Visio Diagram
  • Adding Mathematical Equations
  • Quick Filing – Sending Information to OneNote
  • Creating and Using Notes

Formatting Notes

  • Basic Text Formatting
  • Bullets and Numbering
  • Checking Spelling
  • Setting Default Proofing Options

Working with Microsoft Outlook

  • Inserting Outlook Meetings
  • Sending Notebook Pages via Microsoft Outlook
  • Working with Microsoft Outlook Tasks

Writing Tools

  • Pen Mode
  • Formatting Written Notes & Drawings
  • Converting Handwriting to Type

Viewing and Organizing Information

  • Organizing the OneNote Interface
  • Creating New Windows
  • Searching Content in a Notebook
  • Wiki Linking
  • Tagging Notes
  • Working with Sections
  • Section Groups

Stationery and Templates

  • Applying Templates and Stationery
  • Custom Templates
  • Choosing a Default Template

Formatting Pages

  • Defining Paper Size and Margins
  • Formatting Page Backgrounds
  • Adding a Background Graphic

Printing

  • Previewing and Printing
  • Previewing and Printing
  • Using the Pack and Go Feature
  • Sharing and Exporting Publications- 2013 Only
  • Save & Send- 2010 Only

Sharing Notebooks & Collaborating

  • Saving (Exporting) Notebooks to Share
  • Creating a Shared Notebook
  • Inviting Others to Share
  • Sharing Notes in an Outlook Meeting Invitation
  • Synching Notebooks
  • Sending Pages in Various Formats
  • Sharing Notebooks with SkyDrive
  • Author Indicators
  • Finding Newly Added Content with Highlighting
  • Page Versions

Researching with OneNote

  • Linked Notes
  • The Research Pane
  • Translating Text with the Mini Translator

Changing OneNote Options

  • Changing Display Options
  • Changing Other Options

Instruction Manual

  • Introductory OneNote Manual
  • Introductory Publisher Manual
  • Introductory Windows Manual

Getting Acquainted with Outlook

  • The Outlook Environment- 2013
  • The Outlook Environment- 2010
  • The Outlook Environment- 2007
  • The Title Bar
  • The Menu Bar- 2007
  • Using Toolbars- 2007
  • The Standard Toolbar- 2007
  • The Ribbon
  • The Microsoft Office Button- 2007
  • The Quick Access Toolbar
  • Touch Mode- 2013
  • The Navigation Bar, Reading Pane, and To-Do Bar

Making Contacts

  • The Contacts Folder
  • Customizing the Contacts Folder View
  • Creating Contacts
  • Basic Contact Management
  • Printing Contacts
  • Creating Contact Groups
  • Categorizing Contacts
  • Searching for Contacts
  • Calling Contacts
  • Mapping a Contact’s Address

E-mail

  • Using the Inbox
  • Changing the Inbox View
  • Message Flags
  • Searching for Messages
  • Creating, Addressing, and Sending Messages
  • Checking Message Spelling
  • Setting Message Options
  • Formatting Messages
  • Using Signatures
  • Replying to Messages
  • Forwarding Messages
  • Sending Attachments
  • Opening Attachments

The Sent Items Folder

  • The Sent Items Folder
  • Resending Messages
  • Recalling Messages

The Outbox Folder

  • Using the Outbox

Using the Calendar

  • The Calendar Window
  • Switching the Calendar View
  • Navigating the Calendar
  • Appointments, Meetings, and Events
  • Manipulating Calendar Objects
  • Setting an Appointment
  • Scheduling a Meeting- 2013:2010
  • Scheduling a Meeting- 2007
  • Checking Meeting Attendance Status
  • Responding to Meeting Requests
  • Scheduling an Event
  • Setting Recurrence
  • Printing the Calendar

Tasks

  • Using Tasks
  • Printing the Tasks
  • Creating a Task
  • Setting Task Recurrence
  • Creating a Task Request
  • Responding to Task Requests
  • Sending Status Reports
  • Deleting Tasks

Deleted Items

  • The Deleted Items Folder
  • Permanently Deleting Items
  • Recovering Deleted Items

The Journal Folder

  • The Journal Folder
  • Switching the Journal View
  • Recording Journal Items Automatically- 2010:2007
  • Recording Journal Items Manually
  • Opening Journal Entries and Documents
  • Deleting Journal Items

The Journal FolderPublic Folders

  • Creating Public Folders
  • Setting Permissions
  • Folder Rules
  • Copying Public Folders

Personal & Private Folders

  • Creating a Personal Folder
  • Setting AutoArchiving for Folders
  • Creating Private Folders
  • Creating Search Folders

Advanced Mailbox Options

  • Creating Mailbox Rules
  • Creating Custom Mailbox Views
  • Handling Junk Mail
  • Color Categorizing
  • Advanced Find

Outlook Options

  • Using Shortcuts
  • Adding Additional Profiles
  • Adding Additional Services
  • Outlook Options
  • Using Outlook Help

Delegates

  • Creating a Delegate
  • Acting as a Delegate
  • Deleting Delegates

Getting Acquainted with PowerPoint

  • The PowerPoint Environment- 2013
  • The PowerPoint Environment- 2010
  • The PowerPoint Environment- 2007
  • The Title Bar
  • The Ribbon
  • The “File” Tab and Backstage View- 2013:2010
  • The Microsoft Office Button- 2007 Only
  • The Quick Access Toolbar
  • Touch Mode- 2013
  • The Scroll Bars
  • The Presentation View Buttons
  • The Zoom Slider
  • The Status Bar
  • The Mini Toolbar
  • Keyboard Shortcuts

Creating Basic Presentations

  • Opening Presentations- 2013 Only
  • Opening Presentations- 2010 Only
  • Opening Presentations- 2007 Only
  • Closing Presentations
  • Creating New Presentations- 2013:2010
  • Creating New Presentations- 2007 Only
  • Saving Presentations- 2013 Only
  • Saving Presentations- 2010 Only
  • Saving Presentations- 2007 Only
  • Recovering Unsaved Presentations- 2013 Only
  • Inserting New Slides
  • Applying Slide Layouts
  • Sharing Presentations- 2013 Only
  • Using the “Save & Send” Features- 2010 Only
  • Working with PowerPoint File Formats

Using Presentation Views

  • Normal View
  • Slide Sorter View
  • Notes Page View
  • Slide Show View
  • Reading View- 2013:2010

Using Text

  • Adding Text to Slides
  • Basic Object Manipulation
  • Font Formatting
  • Paragraph Formatting
  • Applying Custom Bullets and Numbering
  • Using Tabs
  • Setting Text Options- 2013 Only
  • Setting Text Box Options- 2010:2007 Only
  • Checking Spelling

Using Pictures

  • Inserting Pictures- 2013 Only
  • Inserting Online Pictures- 2013 Only
  • Inserting Clip Art and Pictures- 2010:2007
  • Basic Graphic Manipulation
  • Using Picture Tools- 2013:2010
  • Using Picture Tools- 2007 Only
  • Using the Format Picture Task Pane- 2013 Only
  • Fill & Line Settings- 2013 Only
  • Effects Settings- 2013 Only
  • Size & Properties Settings- 2013 Only
  • Picture Settings- 2013 Only
  • The Format Picture Dialog Box- 2010 Only
  • The Format Picture Dialog Box- 2007 Only

Using SmartArt

  • Inserting and Manipulating SmartArt
  • Formatting SmartArt

Using Slide Show View

  • Running a Slide Show
  • Using Custom Shows

Printing Your Presentation

  • Changing Slide Size- 2013 Only
  • Using Page Setup- 2010:2007 Only
  • Setting the Slide Header and Footer
  • Using Print Preview- 2007 Only
  • Printing- 2007 Only
  • Previewing and Printing Presentations- 2013:2010

Applying Animation

  • Adding Slide Transition Animation- 2013:2010
  • Adding Object Animation- 2013:2010
  • Adding Slide Transition Animation- 2007 Only
  • Adding Custom Animation- 2007 Only

Drawing Objects

  • Inserting Shapes
  • Formatting Shapes- 2013:2010
  • Formatting Shapes- 2007 Only
  • Inserting WordArt- 2013:2010
  • Inserting WordArt- 2007 Only
  • Assigning Macros- 2013:2010
  • Inserting Shapes
  • Assigning Macros- 2007 Only
  • Inserting WordArt- 2013:2010

Inserting Video and Sound

  • Inserting Videos- 2013 Only
  • Inserting Videos- 2010:2007 Only
  • Inserting Audio- 2013 Only
  • Inserting Audio- 2010:2007 Only
  • Animating Multimedia Playback
  • Recording a Sound

Using Themes

  • Applying Themes
  • Creating Custom Color Schemes
  • Creating Custom Font Schemes
  • Customizing the Slide Background

Using Presentation Masters

  • Using Slide Masters and Slide Layouts
  • Using the Notes Master
  • Using the Handout Master
  • Saving a Presentation Template

Setting Up the Presentation

  • Setting Up the Slide Show
  • Recording Narration- 2013:2010
  • Recording Narration- 2007 Only
  • Rehearsing Timings

Applying Actions

  • Inserting Actions
  • Inserting Hyperlinks

Inserting Charts, Tables, and Objects

  • Inserting Charts
  • Inserting Tables
  • Inserting Objects

Setting PowerPoint Options

  • Setting PowerPoint Options

Getting Acquainted with Publisher

  • The Publisher Environment
  • The Title Bar
  • The Ribbon
  • The “File” Tab and Backstage View
  • The Quick Access Toolbar
  • Touch Mode- 2013
  • The Scroll Bars
  • The Page Layout View Buttons
  • The Zoom Slider and “Zoom” Button Group
  • The Status Bar
  • The Mini Toolbar
  • Keyboard Shortcuts

Creating Basic Publications

  • Creating New Publications
  • Changing the Publication Template- 2013 Only
  • Using Business Information
  • Saving Publications- 2013 Only
  • Saving Publications- 2010 Only
  • Closing Publications
  • Opening Publications- 2013 Only
  • Opening Publications- 2010 Only
  • Inserting New Pages
  • Deleting Pages
  • Moving Pages

Basic Skills

  • Inserting Text Boxes
  • Inserting Shapes
  • Adding Text to Shapes
  • Inserting Your Own Pictures- 2013 Only
  • Inserting Online Pictures- 2013 Only
  • Inserting Picture Placeholders- 2013 Only
  • Using the Scratch Area- 2013 Only
  • Inserting Clip Art and Pictures- 2010 Only
  • Moving, Resizing, and Rotating Objects
  • Deleting Objects
  • Using Find and Replace
  • Using AutoCorrect
  • Inserting WordArt

Formatting Objects

  • Formatting Text
  • Formatting Shapes
  • Formatting Clip Art and Pictures

Using Building Blocks

  • Creating Building Blocks
  • Using Building Blocks
  • Microsoft Office Course Conclusion

Master Pages

  • Using Master Pages

Customizing Schemes

  • Creating a Custom Color Scheme
  • Creating a Custom Font Scheme
  • Customizing Page Backgrounds- 2013 Only
  • Customizing Page Backgrounds- 2010 Only

Page Setup and Layouts

  • Using Page Setup
  • Using Layout Guides
  • Using the Rulers

Mailings

  • Mail Merge
  • The Step By Step Mail Merge Wizard
  • Creating a Data Source
  • Selecting Recipients
  • Inserting and Deleting Merge Fields
  • Previewing a Merge
  • Detaching the Data Source
  • Finishing a Mail Merge
  • Merging a Catalog
  • Setting Page and Section Breaks
  • Mail Merge
  • Using Headers and Footers
  • The Step by Step Mail Merge Wizard
  • Using Page Setup
  • Creating a Data Source

Introduction to Windows

  • About Windows
  • The Start Screen in Windows 8
  • Customizing the Start Screen in Windows 8
  • Using the Charm Bar in Windows 8
  • The Windows Desktop
  • The Mouse
  • Touch Gestures in Windows 8
  • App Snapping in Windows 8
  • Using a Microsoft User Account in Windows 8
  • Starting a Program in Windows 7 & Vista
  • Resizing a Desktop Window
  • Scrolling a Window
  • Shutting Down Windows

Windows Explorer

  • Windows Explorer in Windows 8
  • Navigating Folders
  • Changing Folder Views
  • Sorting Folder Contents
  • Selecting Files
  • Opening a File
  • Opening a Recently Accessed File or Folder
  • Creating a New Folder
  • Renaming Files and Folders
  • Cutting, Copying, and Pasting Files and Folders
  • Burning a CD or DVD
  • Deleting Files
  • Managing Libraries in Windows 8
  • Managing the Computer and Disks in Windows 8

Windows 8 Settings

  • Accessing Settings in Windows 8
  • Personalizing Windows 8
  • Managing Users in Windows 8
  • Notifications in Windows 8
  • Managing Search Settings in Windows 8
  • Managing Sharing Settings in Windows 8
  • General Settings in Windows 8
  • Privacy Settings in Windows 8
  • Managing Devices in Windows 8
  • Wireless Options in Windows 8
  • Ease of Access Settings in Windows 8
  • Sync Settings in Windows 8
  • HomeGroup Settings in Windows 8
  • Windows Update in Windows 8
  • File History in Windows 8

Control Panel Settings

  • The Control Panel
  • Personalizing the Desktop
  • Changing Screen Resolution
  • Backup and Restore in Windows 7
  • Backup and Restore in Windows Vista
  • System Restore
  • Creating Users in Windows 7 and Vista
  • Audio Adjustment
  • Adding Devices and Printers
  • Installing and Uninstalling New Software

Windows Management

  • Searching for a File or Folder in Windows 7 and Vista
  • The Recycle Bin
  • Creating Desktop Shortcuts
  • Pinning Items to the Taskbar or the Quick Launch Toolbar
  • Windows Help
  • Moving and Resizing the Windows Taskbar
  • Setting the Date and Time Display
  • Windows Updates
  • Customizing the Start Menu in Windows 7 and Vista

Using Apps in Windows 8

  • Downloading Apps from the Windows Store
  • Managing App Files
  • Using SkyDrive

Creating Documents

  • Starting WordPad
  • Editing Text
  • Formatting Text
  • Saving a Document
  • Opening a Document
  • Printing a Document
  • Closing a Document

Drawing Pictures

  • Starting Paint
  • Drawing Shapes and Lines
  • Adding Text
  • Erasing Parts of a Picture
  • Saving a Picture
  • Opening a Picture

Using the Internet

  • About the Internet
  • Using the Desktop Internet Explorer 10
  • Using the Internet Explorer 10 App
  • Connecting to the Internet
  • Windows Defender in Windows 8

Printing Information

  • Selecting a Printer
  • General Printing Options
  • Managing Print Jobs

Getting Acquainted with Word

  • About Word
  • The Word Environment- 2013:2010
  • The Word Environment- 2007
  • The Title Bar
  • The Ribbon
  • The “File” Tab and Backstage View- 2013:2010
  • The Microsoft Office Button- 2007 Only
  • The Quick Access Toolbar
  • Touch Mode- 2013
  • The Ruler
  • The Scroll Bars
  • The Document View Buttons
  • The Zoom Slider
  • The Status Bar
  • The Mini Toolbar
  • Keyboard Shortcuts

Creating Basic Documents

  • Opening Documents- 2013 Only
  • Opening Documents- 2010 Only
  • Opening Documents- 2007 Only
  • Closing Documents
  • Creating New Documents- 2013:2010
  • Creating New Documents- 2007 Only
  • Saving Documents- 2013 Only
  • Saving Documents- 2010 Only
  • Saving Documents- 2007 Only
  • Using Building Blocks
  • Recovering Unsaved Documents- 2013 Only

Bullets and Numbering

  • Entering Text
  • Applying Bullets and Numbering
  • Moving through Text
  • Formatting Bullets and Numbering
  • Selecting Text
  • Applying a Multilevel List
  • Non-Printing Characters
  • Modifying a Multilevel List Style
  • Managing Multiple Documents

Basic Editing Skills

  • Creating Tables
  • Deleting Text
  • Selecting Table Objects
  • Cutting, Copying, and Pasting
  • Inserting and Deleting Columns and Rows
  • Undoing and Redoing Actions
  • Deleting Cells and Tables
  • Finding and Replacing Text
  • Merging and Splitting Cells

Basic Proofing Tools

  • Adjusting Cell Size
  • The Spelling and Grammar Tool
  • Aligning Text in Table Cells
  • Setting Default Proofing Options
  • Converting a Table into Text

Font Formatting

  • Sorting Tables
  • Formatting Fonts
  • Formatting Tables
  • The Font Dialog Box
  • Inserting Quick Tables
  • The Format Painter

Formatting Paragraphs

  • Inserting Table Formulas
  • Aligning Paragraphs
  • Recalculating Word Formulas
  • Indenting Paragraphs
  • Viewing Formulas Vs. Formula Results
  • Line Spacing and Paragraph Spacing
  • Inserting a Microsoft Excel Worksheet

Using Templates

  • Selecting Recipients
  • Using Templates- 2013:2010
  • Inserting and Deleting Merge Fields
  • Using Templates- 2007 Only
  • Error Checking

Printing Documents

  • Detaching the Data Source
  • Previewing and Printing Documents- 2013:2010
  • Finishing a Mail Merge
  • Using Print Preview- 2007 Only

Creating a Table of Contents

  • Printing Documents- 2007 Only
  • Creating a Table of Contents

Working with Tabs

  • Deleting a Table of Contents
  • Using Tab Stops

Creating an Index

  • Using the Tabs Dialog Box
  • Creating an Index

Using Clip Art

  • Customizing an Index
  • Inserting Online Pictures- 2013
  • Updating an Index
  • Using Clip Art- 2010:2007

Word Options

  • Inserting WordArt- 2007 Only
  • Setting Word Options- 2013:2010
  • Inserting Text Boxes
  • Setting Word Options- 2007 Only
  • Formatting Shapes- 2013:2010

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books