OFFICE PRODUCTIVITY

Office Productivity

This program will equip you with the basic knowledge and skills in using the computer and the latest versions of Microsoft Office applications such as Word and Excel. This will also teach you how to use Internet for your personal use and/or professional growth.

•   Computer Basics
•   Introduction to Internet
•   Microsoft Office 2007 / 2010

Overview:

This course is a comprehensive training course designed to give you the necessary computer skills to general workplace environments.  The course covers basic knowledge and skills in the following areas:

•          Computer concepts
•          Navigating through Windows 7 Operating system
•          File and Folder Management

What are the Prerequisites? None

Who should attend this course?

•          Individuals who want to gain basic knowledge and skills about computers and  the Internet

What will you learn?

•          Introduction to Computers
•          Hardware and Software
•          Getting started with Windows
•          Environment of Windows
•          Windows Control Panel
•          Windows Explorer
•          Computer Virus

Overview:

This instructor-led course will provide you with an overview of the new features and functions of Microsoft Office Word 2010.  This course can serve as a preparatory training for the certification exam in Word Microsoft Office Specialist (MOS) Core Level.

What are the Prerequisites?  Basic Computer Concepts and Windows

Who should attend this course?

This course is intended for novice information workers who want to learn beginning-level Word 2010 skills.

What will you learn?

• Sharing and Maintaining Documents
• Formatting Content
• Applying Page Layout and Reusable Content
• Including Illustrations and Graphics in a Document
• Proofreading documents
• Applying References and Hyperlinks
• Performing Mail Merge Operations

Overview:

Microsoft Excel 2010 Core will teach you how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations.  Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set.

What are the Prerequisites? Basic Computer Concepts and Windows

Who should attend this course?

• This course is intended for novice information workers who want to learn beginning-level Excel 2010 skills.

What will you learn?

• Creating a Basic Worksheet
• Managing the worksheet environment
• Creating cell data
• Formatting cells and worksheets
• Managing Worksheets and Workbook
• Formulas and functions
• Presenting Data Visually
• Sharing Worksheet Data with Other Users
• Analyzing and Organizing Data

 Internet Browsing

Overview:

In this course, you will learn how to access the internet and appreciate its features related to office productivity and personal use such online chat, sending messages through e-mail, and social networking.

What are the Prerequisites? Basic Computer Concepts and Windows

Who should attend this course?

• The target students for this course are those who desire to gain computer skills related to internet and World Wide Web.

What will you learn?

• Introduction to Internet
• Major Software Concepts of the Internet
• The internet tools
• World Wide Web (WWW)
• Working with the Browser
• Internet services
• URL (Uniform Resource Locator)
• Domain Names
• Creating E-mail account
• Logging-in and out
• Address Book
• Creating folder
• Composing a message
• Sending
• Opening & deleting received messages
• Attachments
• Instant Messaging
• Social Networks

Overview:

Microsoft PowerPoint is a comprehensive training course designed to give you the needed skills in using electronic presentation software.  The course covers topics like working with electronic slides, using graphic objects, and effects to enhance a presentation.

What are the Prerequisites? Basic Word processing using Microsoft Office Word 2007

Who should attend this course?

• This course is intended for information workers who want to learn how to create professional-looking presentations using PowerPoint 2007.

What will you learn?

• Tips in Making Effective Presentation
• Getting started with PowerPoint 2007
• Microsoft PowerPoint views
• Managing Files
• Working with Slides and Text
• Inserting Drawing objects
• Printing the presentations

Basic MICROSOFT EXCEL 2007 or 2010

General Outline

OBJECTIVE: Upon completion of this course, the student will learn the Basic features of MS EXCEL 2007 or 2010.

AUDIENCE:  For those who want to learn the basic features of MS EXCEL 2007

PREREQUISITE: Basic Computer Concepts and MS Windows Desktop operations

TOPICS COVERED:

• Microsoft Excel 2007 or 2010 Interface. What’s New?
• What is a Spreadsheet?
• Moving around the worksheet
• Working with Multiple Worksheets (Linking)
• Entering Data (Date/Time, Values, Labels)
• Entering and Selecting Range of Data
• Understanding Fill Series and AutoFill
• Entering Formula
• Understanding Formula standards (Relative, Absolute & Mixed References)
• Using AutoSUM
• Sorting Data
• Creating and Formatting Charts
• Formatting Cells (Borders and Shading)

• Migrating from 2003 to 2007 or 2010
• Advantages of using Excel 2007 or 2010
• Basic Excel Functions
• Keyboard Shortcuts

• Formulas beyond Addition & Subractions

• Deleting and Hiding Rows and Columns
• Using Subtotals
• Hiding and Unhiding Rows, Columns
• Printing
• Using Print Preview & Page Setup
• Using Page Break
• Freezing Panes and Split
• Hiding Formula
• Protecting Worksheet and Workbook