Using these courses you will familiarise yourself with the applications at several levels of proficiency – from the basic application settings to using styles and templates and advanced techniques such as mail merge and form creation, using formulas and functions, data analysis, creation of charts and macros, the effective creation of catchy presentations and working with extensive databases and with a digital signature. You will now be able to make real use of the entire potential of the Office 2010 applications.
Office Suite 2010 Online Course
Microsoft Office 2010 Suite is one complete training package containing a number of individual Microsoft Office components, including MS Excel, MS Word, MS Access, MS Outlook and MS PowerPoint. After training, the user can create professional reports, manage and view important data quickly and efficiently, produce impressive PowerPoint presentations, perform statistical analysis with Excel sheets, integrate animation into their Word documents, build, design and manage databases, and manage forms and table data.
MS Word 2010: Introduction – In this course, you will learn how to create and format simple text documents. You will learn how to use correction tools and help. After completing the course, you will know how to set page numbering, how to insert simple headers and footers, and how to print a document.
MS Word 2010: Intermediate – In this course, you will learn to work with styles and templates. You will acquire the requisite knowledge in formatting large documents, working with tables, including calculations, and working with charts. You will also insert graphics into your documents.
MS Word 2010: Advanced – In this course, you will familiarize yourself with advanced methods for working with large documents. You will learn to create a table of contents, indexes and tables of figures. You will also be creating envelopes, labels and a catalog making use of mail merge. You will learn how to work with graphics and organization charts. You will understand the basics of creating forms and learn how to use fields in your documents. You will familiarize yourself with creating macros, with the XML format and its usage in MS Word, with security and management of permissions for accessing documents.
MS Excel 2010: Introduction – In this course, you will learn to create tables in the Microsoft Excel program, to enter data in them, to format the data and edit the table format. You will provide calculations through simple functions and formulas and will familiarize yourself with the basics of chart creation and formatting.
MS Excel 2010: Intermediate – In this course, you will learn advanced techniques for data processing in Excel (formatting, locking, using templates, advanced copying etc.). You will be creating complex formulas and using functions belonging to the date & time and text categories, as well as the logical, financial and database functions. You will learn how to filter lists on a sheet and create pivot tables. You will also practice advanced chart editing.
MS Excel 2010: Advanced – In this course, you will learn to work with the advanced Microsoft Excel functions for data manipulation and analysis. You will familiarize yourself with macro creation, with the XML format and its use in MS Excel, with protecting and managing permissions for accessing workbooks.
MS PowerPoint 2010: Introduction – This course will teach you how to create presentations containing text, images, charts, tables, organization charts and other elements. You will be using already-prepared slide layouts. You will discover an easy method for how to display a presentation.
MS PowerPoint 2010: Advanced – In this course, you will learn advanced methods for formatting and showing presentations. You will be creating and using templates, color schemes and masters. You will be setting-up the properties for presentations, including transitions, animations, timing and notes. You will learn to review, print, export and import presentations.
MS Outlook 2010: Introduction – Microsoft Outlook is a program for managing information that will help you to coordinate e-mail messages, calendars, contacts and tasks. This course will provide you with an opportunity to learn how to send, receive and organize messages. You will familiarize yourself with the Outlook folders.
MS Outlook 2010: Advanced – In this course, you will learn how to use the Calendar, Tasks, Journal and Notes folders. Other topics include Outlook settings, import and export options, creation of forms and other advanced skills.
MS Access 2010: Introduction – In this course, you will become familiar with the basics of using the Microsoft Access program. You will learn how to use and design tables and create various types of queries over them for purposes of an effective information retrieval.
MS Access 2010: Intermediate – In this course, you will learn advanced techniques of designing tables and queries. You will acquaint yourself in depth with the creation and use of forms.
MS Access 2010: Advanced – This course focuses on the creation of reports, data access pages and macros. It will also familiarize you with the options for database management, data import and export, as well as with the SQL language.