Office 2007

• Windows Essentials
  This course assumes that the student has very little or no experience with Windows.  It also assumes that the student has little or no experience with a mouse.  We prepare the student for the use of a personal computer and we also cover topics like operating systems, Hardware & Software, Files & Folders, the Help feature and the Network Neighborhood.  This course also covers the My Computer feature very extensively and we also associate the student with all the icons on the Desktop.
  Attendance: 2 half days
  
  
• MS Word Level One
  In Word Level One we introduce the student to Word and working in the Word Program Environment.  The student learns Opening, Moving Around and closing Word Documents. Displaying different views of a document, creating and saving a document as well as previewing and printing. This course extensively covers Changing Case, Formatting Paragraphs, Templates and Wizards and all the tools contained in the Standard, Formatting and Drawing Toolbars.  Headers and Footers, Spelling and Grammar and Styles are also some of the features covered in Word Level One. Finding the most appropriate word and reorganizing a document outline as well as replacing text, correcting spelling and grammatical errors. Word’s basics are extensively covered in this course.  The student will also be familiarized with the Envelope and Labels feature and we give an introduction to Publishing Web Pages with Word. 
  Attendance: 2 half days
  
  
• MS Word Level Two
  This course is more extensive than Level 1 and entails advanced features of the Word Program.  The student will learn advance features available in Page Setup, Page Borders, Foot- and Endnotes. Watermarks, Styles and Mail Merge topics will also be extensively covered.  Changing the look of text and paragraphs, formatting text and paragraphs as well as manually changing the look of characters and paragraphs are also covered. The student is also introduced to the Linking and Embedding Options.  Items like Charts, Macro Creation, Tracking Changes and all the other features of the Word Program are covered in detail. Word Level 2 covers columns, creating tabular lists, presenting information in a table and formatting tables, and performing calculations in the table.   On completion of this course the student will be able to use tables and control layout, toolbars and options available for the user in the Word Program.
  Attendance: 2 half days
  
  
• MS Excel Level One
  The Excel Level One course is an introductory course into Excel.  For a student with little or no experience of this Program it would benefit the student to complete the Word Level One course before attempting this course.  The Basics of Excel is also comprehensively covered.  The most important feature of Excel, Formulas, is one of the items covered in this course. Working and modifying workbooks and worksheets. Customizing the Excel 2003 program window.
  Zooming in on a worksheet. Arranging multiple workbooks in Windows. Adding buttons to the quick Access toolbar. Working with data and data tables. Entering and revising data. Moving data within a workbook. Correcting and Expanding upon a worksheet data w Excel Files, Charts, Hyperlinks and Collaborating between Worksheets are features covered in this course.
  Attendance: 2 half days
  
  
•  MS Excel Level Two
  Excel Level Two is one of our most advanced corporate courses and it is strongly advised that the student first completes the Excel Level One course.  The more advanced options of Excel are broadly covered in this course.  Importing Data, Linking, Collaborating with Microsoft Access and Exporting from Excel are a few of the topics enclosed and the student will have comprehensive knowledge of Microsoft Excel after completion of this course. Performing calculations on data. Naming groups of data. Creating formulas to calculate values. Summarizing data that meets specific conditions. Finding and correcting errors in calculations. Changing document appearance. Formatting cells. Defining styles.
  Applying workbook themes and table styles. Making numbers easier to read. Changing appearance of data based on its value. Adding images to a document
  Attendance: 2 half days
  
  
• MS PowerPoint
  PowerPoint is the component of Microsoft Office that is used to construct professional presentations.  After completion of this course the learner will be able to create new professional presentations using the AutoContent Wizard, Templates and Masters.  The blank Presentation Option is broadly explored in our PowerPoint course and the student will be able to create a presentation from scratch, using Transitions, Animations, Speaker notes, Hyperlinks and Importing. Creating a database form a template, Starting a new presentation, Quickly creating a presentation. Creating a presentation based on a ready made design. Converting an outline to a presentation. Reusing existing slides, Working with slide text. Entering text w Adding and manipulating text boxes, Correcting and sizing text while typing, Checking spelling and choosing the best words, Changing size, alignment, spacing and look of the text, Adjusting the slide layout, order and look, Changing layout and rearranging slides in a presentation, Applying theme, Switching to a different color scheme, Using colors that are not part of the scheme, Adding shading and texture to the background of a slide, Delivering a presentation electronically, Adapting a presentation for different audiences, Rehearsing a presentation, Preparing speaker notes and handouts, Preparing a presentation for travel
  Attendance: 2 half days
  
  
• MS Access
  Access is a Relational Database Management System and in this course Tables, Forms, Queries, Reports and Web Pages are covered in depth.  The student will learn how to enforce Referential Integrity and will be able to plan and create a whole Relational Database upon completion of this course. Creating a table manually, Creating a table using a template,  Manipulating table columns and rows, Simplifying data entry by using forms, Creating a form by using the form tool, Refining form properties, Changing the arrangement of a form, Adding controls to a form, Entering data in a form by using VBA, Creating a form by using auto form, Adding a subform to a form, Locating specific information, Sorting information, Filtering information in a table, Filtering information by using form, Locating information that matches multiple criteria, Creating a Query manually, Creating a query by using a wizard, Performing calculations by using query, Keeping information accurate, Restricting the amount of data in a field, Restricting data by using validation rules, Creating simple lookup list, Creating a multi column lookup list, Updating information in a table, Deleting information from a table, Preventing database problems
  Attendance: 3 half days
  
  
• Outlook
  Outlook and E-Mail covers the Software used for forwarding and receiving messages on Outlook Express. The student will be fully equipped to use Outlook after completion of this course. Getting started with Outlook 2003, Connecting to your primary e-mail account, Trouble shooting the startup wizard, Connecting to additional email accounts, Creating additional Outlook profiles, Personalizing your outlook workspace, Exploring the advanced toolbar, Sending e-mail message, Working in the message window, Creating and sending messages, Addressing messages, Sending courtesy copies, Saving message drafts Attaching files to messages, Creating and formatting business graphics, Personalizing the appearance of a message, Adding signatures to messages automatically, Managing your inbox, Quickly locating messages, Arranging messages in different ways, Organizing messages by using color categories, Organizing messages in folders, Archiving messages, Managing appointments, events and meetings, Working in the calendar item window, Scheduling and changing events, Scheduling, updating and canceling meetings, Responding to meeting request, Manage your calendar, Displaying different views of a calendar, Defining your available time, Printing a calendar, Sending calendar information in an e-mail message, Linking to an internet calendar, Working with multiple calendar
  Attendance: 1 half day

Duration:
1 month