MICROSOFT COURSES

Access

To register

Self-registration may be completed online by registering through Inspira at: inspira.un.org. For registration instructions please click here. For instructions on how to access inspira please look at the Inspira How-To guide.

For more information

Call extension 3-0770 or e-mail itlearning@un.org

Microsoft Office Access Level 1

One day

Target audience

Staff who wish to learn the basic and intermediate-level operations of the Microsoft Access and to understand the advantages of using a relational database programme. Completion of this course provides entry to the ICDL Full Certification programme.

Prerequisites

Windows XP Level 1 and Excel Level 1, or equivalent working knowledge

Topics covered

  • Introduction to Databases
  • Creating and Working with a Database
  • Creating a Table
  • Adding, Editing, and Deleting Records
  • Creating a Query
  • Finding, Filtering, and Formatting Data

    Microsoft Office Access Level 2

    One day

    Target audience

    Staff who need a more in-depth knowledge of querying and reporting in Microsoft Access.

    Prerequisites

    Microsoft Office Access Level 1 or equivalent working knowledge

    Topics covered

  • Working with Tables and Fields
  • Changing a Field's Data Type and Fomatting Fields
  • Creating Relational Databases
  • Working with Queries / Understanding the Different Types of Queries
  • Creating and Modifying a Form
  • Creating and Modifying a Report

    Microsoft Office Access Level 3

    One day

    Target audience

    Staff who are interested in learning introductory level administrator skillsets. For staff that may be working in a web-based environment and may need to adapt Access applications to the environment.

    Prerequisites

    Microsoft Office Access Level 2 or equivalent working knowledge

    Topics covered

  • Formatting Forms and Reports
  • Working with Controls
  • Working with Macros
  • Importing and Exporting Information
  • Analyzing Records with Microsoft Excel

    Excel

    To register

    Self-registration may be completed online by registering through Inspira at: inspira.un.org. For registration instructions please click here. For instructions on how to access inspira please look at the Inspira How-To guide.

    For more information

    Call extension 3-0770 or e-mail itlearning@un.org

    Microsoft Office Excel Level 1

    One day

    Target audience

    Staff who need to work with numerical or financial data and wish to gain hands on experience with using Microsoft Excel to manage, edit, and print data. Completion of this course provides entry to the ICDL Start Certification programme.

    Prerequisites

    Windows XP Level 1 or equivalent working knowledge

    Topics covered

  • Getting Started with Excel and Exploring the Layout
  • Understanding Workbooks vs. Worksheets
  • Understanding Cell Contents
  • Introduction to Formulas
  • Creating and Formatting Worksheets
  • Creating and Developing a Workbook
  • Printing

    Microsoft Office Excel Level 2

    One day

    Target audience

    Staff who wish to streamline and enhance their spreadsheets through the use of templates, charts, graphics and formulae. Completion of this course provides entry to the ICDL Start Certification programme.

    Prerequisites

    Microsoft Office Excel Level 1 or equivalent knowledge

    Topics covered

  • Understanding Templates
  • Creating and Working with Charts
  • Working with Formulas and Paste Function Feature
  • Manipulating (Sorting/Filtering) Data
  • Managing Workbooks

    Microsoft Office Excel Level 3

    One day

    Target audience

    Staff who wish to create macros, collaborate with others, audit and analyse worksheet data, create PivotTables and PivotCharts, import and export data in Microsoft Excel.

    Prerequisites

    Microsoft Office Excel Level 2 or equivalent working knowledge

    Topics covered

  • Advanced Formatting
  • Working with Multiple Workbooks and 3D Formulas
  • Auditing Worksheets and Formulas
  • Analyzing Data with PivotTables and Subtotals
  • Understanding Nested Functions
  • Exploring Collaborative Editing

    Powerpoint

    To register

    Self-registration may be completed online by registering through Inspira at: inspira.un.org. For registration instructions please click here. For instructions on how to access inspira please look at the Inspira How-To guide.

    For more information

    Call extension 3-0770 or e-mail itlearning@un.org

    Microsoft Office PowerPoint Level 1

    One day

    Target audience

    Staff who are new users of PowerPoint and who would like to design and produce slide show presentations. Completion of this course provides entry to the ICDL Full Certification programme.

    Prerequisites

    Windows XP Level 1 or equivalent working knowledge

    Topics covered

  • Creating a New Presentation
  • Understanding Objects (Next Slides, Tables, Charts, Graphics)
  • Formatting Text
  • Modifying Objects
  • Working with the Slide Master
  • Working with Images in Presentations

    Microsoft Office PowerPoint Level 2

    One day

    Target audience

    Staff who wish to gain the skills necessary to work with design templates, organizational charts, special effects, Web presentations, collaboration functionality, and advanced presentation delivery. Completion of this course provides entry to the ICDL Full Certification programme.

    Prerequisites

    Microsoft Office PowerPoint Level 1 or equivalent working knowledge

    Topics covered

  • Creating and Modifying Charts
  • Adding Objects (Organization Charts, Diagrams, Tables, Word Art)
  • Preparing Presentations for Delivery (Slide Shows, Slide Transitions, Custom Animations)
  • Printing (Entire Presentation, Notes Pages, Handouts)

    Project

    To register

    Self-registration may be completed online by registering through Inspira at: inspira.un.org. For registration instructions please click here. For instructions on how to access inspira please look at the Inspira How-To guide.

    For more information

    Call extension 3-0770 or e-mail itlearning@un.org

    Microsoft Office Project Level 1

    One day

    Target audience

    Staff familiar with project management concepts who create and modify project plans and need a tool to assist them in managing these project plans.

    Prerequisites

    Familiarity with project management concepts including completion of the Project Management workshop (see Human and Financial Resources Management section), and Windows XP Level 1 and equivalent working knowledge.

    Topics covered

  • Planning the project
  • Creating a New Project
  • Entering the Task List
  • Organizing Tasks into Phases
  • Entering and Assigning Resources
  • Viewing the Project

    Microsoft Office Project Level 2

    One day

    Target audience

    Staff who wish to learn more advanced features on Microsoft Project.

    Prerequisites

    Microsoft Office Project Level 1 or equivalent working knowledge

    Topics covered

  • Working with Tasks
  • Setting Task Deadlines
  • Working with Resources
  • Working with Costs
  • Balancing Overall located Resources
  • Updating Project Progress
  • Checking Project Status
  • Reporting the Project

    Visio

    To register

    Self-registration may be completed online by registering through Inspira at: inspira.un.org. For registration instructions please click here. For instructions on how to access inspira please look at the Inspira How-To guide.

    For more information

    Call extension 3-0770 or e-mail itlearning@un.org

    Microsoft Office Visio Level 1

    One day

    Target audience

    Staff who need to create diagrams, flow charts, and office floor plans.

    Prerequisites

    Windows XP Level 1 or equivalent working knowledge

    Topics covered

  • Overview of Visio
  • Creating a Diagram
  • Working with Shapes
  • Formatting a Diagram
  • Working with Flow Charts and Organizational Charts
  • Inserting and Deleting Pages
  • Using Visio with Other Programs

    Windows

    To register

    Self-registration may be completed online by registering through Inspira at: inspira.un.org. For registration instructions please click here. For instructions on how to access inspira please look at the Inspira How-To guide.

    For more information

    Call extension 3-0770 or e-mail itlearning@un.org

    Microsoft Windows XP Level 1

    One day

    Target audience

    Staff who need to learn the basic skills of understanding the PC desktop, files and folders, and an overview of the Internet and World Wide Web. Completion of this course provides entry to the ICDL Start Certification programme.

    Topics covered

  • Overview of using Personal Computers
  • Working with a Window
  • Using Windows Programs
  • Managing Folders and Files
  • Using Programs at the Same Time
  • Exploring the Internet
  • Understanding Viruses and Malware

    Word

    To register

    Self-registration may be completed online by registering through Inspira at: inspira.un.org. For registration instructions please click here. For instructions on how to access inspira please look at the Inspira How-To guide.

    For more information

    Call extension 3-0770 or e-mail itlearning@un.org

    Microsoft Office Word Level 1

    One day

    Target audience

    Staff who would like to gain basic hands-on word-processing knowledge and experience using Microsoft Word. Completion of this course provides entry to the ICDL Start Certification programme.

    Prerequisites

    Windows XP Level 1 or equivalent working knowledge

    Topics covered

  • Getting Started with Word and Exploring the Layout
  • Creating a Document
  • Editing a Document
  • Formatting Text and Paragraphs
  • Adding Tables
  • Inserting Graphics and Objects
  • Using Page Setup

    Microsoft Office Word Level 2

    One day

    Target audience

    Staff familiar with basic Microsoft Word capabilities, and who need to learn how to use Microsoft Word to create or modify complex business documents as well as customized Word efficiency tools. Completion of this course provides entry to the ICDL Start Certification programme.

    Prerequisites

    Microsoft Office Word Level 1 or equivalent working knowledge

    Topics covered

  • Working with Tables
  • Working with Templates and Styles
  • Customizing Formatting
  • Working with Graphics and Charts

    Microsoft Office Word Level 3

    One day

    Target audience

    Staff who need to learn the more advanced features of Microsoft Word to create, manage, revise, and distribute long documents, forms, and Web pages.

    Prerequisites

    Microsoft Office Word Level 2 or equivalent working knowledge

    Topics covered

  • Working with Forms and Fields
  • Understanding Mail Merge
  • Advanced Features (Macros, Auto Correct, Auto Text)