MS Office 2013 Suite (Access, Excel, Outlook, PowerPoint, Word) (Mentored On-Demand)

$220.00


  • Description
  • Course Content
  • Reviews (0)

Product Description

Microsoft Office Access 2013

This course provides students with knowledge and skills such as database management, advanced form design, packaging a database, encrypting a database, and preparing a database for multi-user access.

Microsoft Office Excel 2013

This course provides students with the knowledge and skills to automate common tasks, audit workbooks to avoid errors, share your data with other people, analyze data, and use Excel data in other applications.

Microsoft Office Outlook 2013

This course provides students with the knowledge and skills to utilize the advanced features provided with the Microsoft Outlook 2013 interface, such as advanced message, calendar, and contacts management.

Microsoft Office PowerPoint 2013

This course provides students with the knowledge and skills to customize the PowerPoint 2013 application, and effectively create, collaborate on, secure, and distribute complex multimedia presentations for a variety of situations.

Microsoft Office Word 2013

This course provides students with the knowledge and skills to create and work with lengthy documents, collaborate with others on documents, and create forms in Microsoft Word.

 

Microsoft Office Access 2013: Part 1
Course Introduction
Lesson 01 - Getting Started with Access
Lesson 02 - Working with Table Data
Lesson 03 - Querying a Database
Lesson 04 - Creating Advanced Queries
Lesson 05 - Generating Reports
Lesson 06 - Customizing the Access Environment
Microsoft Office Access 2013: Part 2
Course Introduction
Lesson 01 - Designing a Relational Database
Lesson 02 - Joining Tables
Lesson 03 - Organizing a Database for Efficiency
Lesson 04 - Sharing Data Across Applications
Lesson 05 - Advanced Reporting
Microsoft Office Access 2013: Part 3
Course Introduction
Lesson 01 - Implementing Advanced Form Design
Lesson 02 - Using Data Validation
Lesson 03 - Using Macros to Improve User Interface Design
Lesson 04 - Using Advanced Database Management
Lesson 05 - Distributing and Securing a Database
Lesson 06 - Managing Switchboards
Microsoft Office Excel 2013: Part 1
Course Introduction
Lesson 01 - Getting Started with Microsoft Excel 2013
Lesson 02 - Performing Calculations
Lesson 03 - Modifying a Worksheet
Lesson 04 - Formatting a Worksheet
Lesson 05 - Printing Workbook Contents
Lesson 06 - Managing Large Workbooks
Lesson 07 - Customizing the Excel Environment
Microsoft Office Excel 2013: Part 2
Course Introduction
Lesson 01 - Creating Advanced Formulas
Lesson 02 - Analyzing Data with Logical  and Lookup Functions
Lesson 03 - Organizing Worksheet Data with Tables
Lesson 04 - Visualizing Data with Charts
Lesson 05 - Analyzing Data with PivotTables, Slicers, and PivotCharts
Lesson 06 - Inserting Graphics
Lesson 07 - Enhancing Workbooks
Microsoft Office Excel 2013: Part 3
Course Introduction
Lesson 01 - Automating Worksheet Functionality
Lesson 02 - Auditing Worksheets
Lesson 03 - Analyzing and Presenting Data
Lesson 04 - Working With Multiple Workbooks
Lesson 05 - Exporting Excel Data
Microsoft Office Outlook 2013: Part 1
Course Introduction
Lesson 01 - Getting Started With Outlook 2013
Lesson 02 - Composing Messages
Lesson 03 - Reading and Responding to Messages
Lesson 04 - Managing Your Messages
Lesson 05 - Managing Your Calendar
Lesson 06 - Managing Your Contacts
Lesson 07 - Working With Tasks and Notes
Lesson 08 - Customizing the Outlook Environment
Microsoft Office Outlook 2013: Part 2
Course Introduction
Lesson 01 - Configure Advanced Message Options
Lesson 02 - Advanced Message Management
Lesson 03 - Advanced Calendar Management
Lesson 04 - Advanced Contact Management
Lesson 05 - Managing Activities by Using Tasks and Journal Entries
Lesson 06 - Sharing Workspaces with Others
Lesson 07 - Managing Outlook Data Files
Microsoft Office PowerPoint 2013: Part 1
Course Introduction
Lesson 01 - Getting Started with PowerPoint
Topic A: Navigate the PowerPoint Environment
Topic B: Create and Save a PowerPoint Presentation
Topic C: Use Help
Lesson 02 - Developing a PowerPoint Presentation
Topic A: Select a Presentation Type
Topic B: View and Navigate a Presentation
Topic C: Edit Text
Topic D: Building a Presentation
Lesson 03 - Performing Advanced Text Editing
Topic A: Format Characters
Topic B: Format Paragraphs
Topic C: Format Text Boxes
Lesson 04 - Adding Graphical Elements to Your Presentation
Topic A: Insert Clip Art and Images
Topic B: Insert Shapes
Lesson 05 - Modifying Objects in Your Presentation
Topic A: Edit Objects
Topic B: Format Objects
Topic C: Group Objects
Topic D: Arrange Objects
Topic E: Animate Objects
Lesson 06 - Adding Tables to Your Presentation
Topic A: Create a Table
Topic B: Format a Table
Topic C: Insert a Table from Other Microsoft Office Applications
Lesson 07 - Adding Charts to Your Presentation
Topic A: Create a Chart
Topic B: Format a Chart
Topic C: Insert a Chart from Microsoft Excel
Lesson 08 - Preparing to Deliver Your Presentation
Topic A: Review Your Presentation
Topic B: Applying Transitions
Topic C: Print Your Presentation
Topic D: Deliver Your Presentation
Microsoft Office PowerPoint 2013: Part 2
Course Introduction
Lesson 01 - Modifying the PowerPoint Environment
Topic A: Customize the User Interface
Topic B: Set PowerPoint 2013 Options
Lesson 02 - Customizing Design Templates
Topic A: Modify Slide Masters and Slide Layouts
Topic B: Add Headers and Footers
Topic C: Modify the Notes Master and the Handout Master
Lesson 03 - Adding SmartArt to a Presentation
Topic A: Create SmartArt
Topic B: Modify SmartArt
Lesson 04 - Working with Media and Animations
Topic A: Add Audio to a Presentation
Topic B: Add Video to a Presentation
Topic C: Customize Animations and Transitions
Lesson 05 - Collaborating on a Presentation
Topic A: Review a Presentation
Topic B: Store and Share Presentations on the Web
Lesson 06 - Customizing a Slide Show
Topic A: Annotate a Presentation
Topic B: Set Up a Slide Show
Topic C: Create a Custom Slide Show
Topic D: Add Hyperlinks and Action Buttons
Topic E: Record a Presentation
Lesson 07 - Securing and Distributing a Presentation
Topic A: Secure a Presentation
Topic B: Broadcast a Slide Show
Topic C: Create a Video or a CD
Microsoft Office Word 2013: Part 1
Course Introduction
Lesson 01 - Getting Started with Word
Lesson 02 - Editing a Document
Lesson 03 - Formatting Text and Paragraphs
Lesson 04 - Adding Tables
Lesson 05 - Managing Lists
Lesson 06 - Inserting Graphic Objects
Lesson 07 - Controlling Page Appearance
Lesson 08 - Proofing a Document
Lesson 09 - Customizing the Word Environment
Microsoft Office Word 2013: Part 2
Course Introduction
Lesson 01 - Working with Tables and Charts
Lesson 02 - Customizing Formats Using Styles and Themes
Lesson 03 - Using Images in a Document
Lesson 04 - Creating Custom Graphic Elements
Lesson 05 - Inserting Content Using Quick Parts
Lesson 06 - Controlling Text Flow
Lesson 07 - Using Templates
Lesson 08 - Using Mail Merge
Lesson 09 - Using Macros
Microsoft Office Word 2013: Part 3
Course Introduction
Lesson 01 - Collaborating on Documents
Lesson 02 - Adding Reference Marks and Notes
Lesson 03 - Simplifying and Managing Long Documents
Lesson 04 - Securing a Document
Lesson 05 - Forms

 

 

Reviews

There are no reviews yet.


Be the first to review “MS Office 2013 Suite (Access, Excel, Outlook, PowerPoint, Word) (Mentored On-Demand)”

[25% OFF] 'For less than $200 get trained and get certified' Learn More