Core Office level

Word 2013 - Part 1 08 Hrs

Lesson 1: Getting Started with Word

•Identify the Components of the Word Interface
•Create a Word Document

Lesson 2: Editing a Document

•Navigate and Select Text
•Modify Text
•Find and Replace Text

Lesson 3: Formatting Text and Paragraphs

•Apply Character Formatting
•Align Text Using Tabs
•Display Text as List Items
•Control Paragraph Layout
•Apply Borders and Shading
•Apply Styles
•Manage Formatting

Lesson 4: Adding Tables

•Insert a Table
•Modify a Table
•Format a Table
•Convert Text to a Table

Lesson 5: Managing Lists

•Sort a List
•Renumber a List
•Customize a List

Lesson 6: Inserting Graphic Objects

•Insert Symbols and Special Characters
•Add Images to a Document

Lesson 7: Controlling Page Appearance

•Apply a Page Border and Color
•Add a Watermark
•Add Headers and Footers
•Control Page Layout

Lesson 8: Proofing a Document

•Check Spelling and Grammar
•Other Proofing Tools

Lesson 9: Customizing the Word Environment

•Customize the Word Interface
•Additional Save Options

Word 2013 - Part 2 08 Hrs

Lesson 1: Working with Tables and Charts

» Sort Table Data
» Control Cell Layout
» Perform Calculations in a Table
» Create a Chart

Lesson 2: Customizing Formats Using Styles and Themes

» Create and Modify Text Styles
» Create Custom List or Table Styles
» Apply Document Themes

Lesson 3: Using Images in a Document

» Resize an Image
» Adjust Image Appearance
» Integrate Pictures and Text
» Insert and Format Screenshots
» Insert Video

Lesson 4: Creating Custom Graphic Elements

» Create Text Boxes and Pull Quotes
» Draw Shapes
» Add WordArt and Other Text Effects
» Create Complex Illustrations with SmartArt

Lesson 5: Inserting Content Using Quick Parts

» Insert Building Blocks
» Create and Modify Building Blocks
» Insert Fields Using Quick Parts

Lesson 6: Controlling Text Flow

» Control Paragraph Flow
» Insert Section Breaks
» Insert Columns
» Link Text Boxes to Control Text Flow

Lesson 7: Using Templates

» Create a Document Using a Template
» Create a Template

Lesson 8: Using Mail Merge

» The Mail Merge Features
» Merge Envelopes and Labels
» Create a Data Source Using Word

Lesson 9: Using Macros

» Automate Tasks Using Macros
» Create a Macro

Excel 2013 - Part 1 08 Hrs

Lesson 1: Getting Started with Microsoft Office Excel 2013

» Navigate the Excel User Interface
» Use Excel Commands
» Create and Save a Basic Workbook
» Enter Cell Data
» Use Excel Help

Lesson 2: Performing Calculations

» Create Worksheet Formulas
» Insert Functions
» Reuse Formulas

Lesson 3: Modifying a Worksheet

» Insert, Delete, and Adjust Cells, Columns, and Rows
» Search for and Replace Data
» Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

» Modify Fonts
» Add Borders and Colors to Worksheets
» Apply Number Formats
» Align Cell Contents
» Apply Styles and Themes
» Apply Basic Conditional Formatting
» Create and Use Templates

Lesson 5: Printing Workbooks

» Preview and Print a Workbook
» Define the Page Layout

Lesson 6: Managing Workbooks

» Manage Worksheets
» Manage Workbook and Worksheet Views
» Manage Workbook Properties

Excel 2013 - Part 2 08 Hrs

Lesson 1: Customizing the Excel Environment

» Configure Excel Options
» Customize the Ribbon and the Quick Access Toolbar
» Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas

» Use Range Names in Formulas
» Use Specialized Functions
» Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting

» Analyze Data by Using Text and Logical Functions
» Apply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables

» Create and Modify Tables
» Sort Data
» Filter Data
» Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts

» Create Charts
» Modify and Format Charts

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

» Create a PivotTable
» Analyze PivotTable Data
» Present Data with PivotCharts
» Filter Data by Using Slicers

Access 2013 - Part 1 08 Hrs
  • Lesson 1: Getting Started with Access
    • Orientation to Microsoft Access
    • Create a Simple Access Database
    • Get Help in Microsoft Access
  • Lesson 2: Working with Table Data
    • Modify Table Data
    • Sort and Filter Records
    • Create Lookups
  • Lesson 3: Querying a Database
    • Join Data from Different Tables in a Query
    • Sort and Filter Data in a Query
    • Perform Calculations in a Query
  • Lesson 4: Creating Advanced Queries
    • Create Parameter Queries
    • Create Action Queries
    • Create Unmatched and Duplicate Queries
    • Summarize Data
  • Lesson 5: Generating Reports
    • Create a Report
    • Add Controls to a Report
    • Enhance the Appearance of a Report
    • Prepare a Report for Print
  • Lesson 6: Customizing the Access Environment
    • The Access Options Dialog Box
  • Lesson 7: Designing a Relational Database
    • Relational Database Design
    • Create a Table
    • Create Table Relationships
  • Lesson 8: Joining Tables
    • Create Query Joins
    • Join Tables That Have No Common Fields
    • Relate Data within a Table
    • Work with Subdatasheets
    • Create Subqueries
  • Lesson 9: Organizing a Database for Efficiency
    • Data Normalization
    • Create a Junction Table
    • Improve Table Structure
  • Lesson 10: Sharing Data Across Applications
    • Import Data into Access
    • Export Data to Text File Formats
    • Export Access Data to Excel
    • Create a Mail Merge
  • Lesson 11: Advanced Reporting
    • Organize Report Information
    • Format Reports
    • Include Control Formatting in a Report
    • Add a Calculated Field to a Report
    • Add a Subreport to an Existing Report
Access 2013 - Part 2 08 Hrs

Lesson 1: Implementing Advanced Form Design

» Add Controls to Forms
» Create Subforms
» Organize Information with Tab Pages
» Enhance Navigation of Forms
» Apply Conditional Formatting

Lesson 2: Using Data Validation

» Field and Record Validation
» Form Validation

Lesson 3: Using Macros to Improve User Interface Design

» Create a Macro
» Restrict Records Using a Condition
» Validate Data Using a Macro
» Automate Data Entry Using a Macro
» Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

» Link Tables to External Data Sources
» Manage a Database
» Determine Object Dependency
» Document a Database
» Analyze the Performance of a Database

Lesson 5: Distributing and Securing a Database

» Splitting a Database for Multiple User Access
» Implement Security
» Set Passwords
» Convert an Access Database to an ACCDE File
» Package a Database with a Digital Signature

Lesson 6: Managing Switchboards

» Create a Database Switchboard
» Modify a Database Switchboard
» Set Startup Options

Outlook 2013 - Part 1 08 Hrs

Lesson 1: Getting Started With Outlook 2013

•Navigate the Outlook Interface
•Perform Basic Email Functions
•Use Outlook Help

Lesson 2: Composing Messages

•Create an Email Message
•Check Spelling and Grammar
•Format Message Content
•Attach Files and Items
•Enhance an Email Message
•Manage Automatic Message Content

Lesson 3: Reading and Responding to Messages

•Customize Reading Options
•Work with Attachments
•Manage Your Message Responses

Lesson 4: Managing Your Messages

•Manage Messages Using Tags, Flags, and Commands
•Organize Messages Using Folders

Lesson 5: Managing Your Calendar

•View the Calendar
•Manage Appointments
•Manage Meetings
•Print Your Calendar

Lesson 6: Managing Your Contacts

•Create and Update Contacts
•View and Organize Contacts

Lesson 7: Working With Tasks and Notes

•Manage Tasks
•Manage Notes

Lesson 8: Customizing the Outlook Environment

•Customize the Outlook Interface
•Create and Manage Quick Steps

Outlook 2013 - Part 2 08 Hrs

Lesson 1: Configure Advanced Message Options

» Insert Advanced Characters and Objects
» Modify Message Settings, Properties, and Options
» Use Automatic Replies

Lesson 2: Advanced Message Management

» Sort Messages
» Filter Messages
» Organize Messages
» Search Messages
» Manage Junk Mail
» Manage Your Mailbox

Lesson 3: Advanced Calendar Management

» Manage Advanced Calendar Options
» Create Calendar Groups
» Manage Meeting Responses

Lesson 4: Advanced Contact Management

» Edit an Electronic Business Card
» Manage Advanced Contacts Options
» Forward Contacts
» Export Contacts

Lesson 5: Managing Activities by Using Tasks and Journal Entries

» Assign and Manage Tasks
» Record and Modify Journal Entries

Lesson 6: Sharing Workspaces with Others

» Delegate Access to Mail Folders
» Share Your Calendar
» Share Your Contacts

Lesson 7: Managing Outlook Data Files

» Back Up Outlook Items
» Change Data File Settings

لمشاهدة فيديو حول التراك إضغط هنا