Get certified with the Microsoft Office Level 1 (Intermediate) and Level 2 (Advanced) training. These courses will expose you to more of what is required on the job. Building charts in excel, creating mail merge documents, designing professional presentations and building relational databases are a few of the areas you will cover.
This Microsoft Word training course aims to provide students with the skills necessary to create everyday documents required either at work or at home. Level I covers the basic to intermediate features of Word such as text manipulation and enhancement, creating and using tabs and tables, enhancing documents with clip art, pictures and Illustrations, creating multiple documents through merging and printing documents.
Level II training takes document creation and functionality to the next level with the use and development of Word document templates, creating macros for custom actions, sharing and collaborating on documents, creating sections and page breaks to include standard and custom headers and footers. Also covered are Word’s reference lists (index, table of contents, citations, bibliography, footnotes), working with styles, quickparts and form features.
Microsoft Excel is an electronic spreadsheet program used in the business world and for personal use. Generating invoicing systems, payroll and personal budgets are just a few features covered. The package includes basic spreadsheet layouts, formulas and functions, creating charts, using data management tools, such as applying multi-level sorts, custom and advance filters and building secure templates. Proper page setup, printing and data formatting are also included.
Having covered Microsoft Excel Level I, Level II explores many of the Excel’s advanced features used by business executives and other decision makers. Advanced reference, date, logical, financial and conditional functions are included along with developing macros for applying custom actions to workbooks. Data validation, auditing tools, importing and exporting data, using What If Analysis tools (goal seek, solver) and designing Pivot Table Reports and Charts are some of Excel’s other tools covered.
Microsoft Access is a sophisticated relational database management system (RDMS). The course includes designing relational tables and data entry forms to store records of information, creating a variety of queries to filter sort and calculate data. Also generating reports from tables and queries.
The Advanced training in Microsoft Access following completion of the Microsoft Access Level I. This course includes working with table’s field property settings to customized data types and thus data entry. Designing custom data entry forms, creating customized menu forms or Switchboards with control buttons and other form objects. Creating and executing macros for custom function and designing custom reports. Also included is setting database passwords and other security measures
PowerPoint is a presentation program that is designed to allow you to create slide shows. You can create simple presentations, using slide transitions and timings, work with animation features, apply master slide elements and print slides and handouts.
Outlook is an information management program geared to help you manage messages, tasks, appointments, meetings, activities, letters and files in your office. Integration of all of Outlooks features operate seamlessly in any office environment.
The premier project management application used by Project Managers, Project Coordinators and anyone on a career path with Project Management. This software helps in developing plans, assigning resources to tasks, tracking progress, managing budgets and analyzing workloads with tools like Gannt Charts and Timelines.
This application can be used by anyone in the work place or at school to create a variety of diagrams. These include flowcharts, organization charts, building plans, floor plans, data flow diagrams, process flow diagrams, business process modeling, swim lane diagrams, 3D maps, and many more.