Microsoft WordMicrosoft Word
Microsoft Excel
Microsoft Access
Microsoft PowerPoint
Microsoft Outlook
Microsoft Excel
Introduction Create, edit, format, and print basic worksheets and charts using Excel. Work with cells and cell data by using a variety of moving and copying techniques. Perform calculations on data by using functions and formulas and change the appearance of worksheet data by using a variety of formatting techniques. You will also learn to manipulate multiple worksheets in a workbook.
Intermediate Discover techniques to use Excel and user-defined templates to create templates and workbooks, sort and filter data, and reuse and share data by importing and exporting. Use various functions and auditing features to create advanced formulas and audit worksheets. Use pivot table reports, pivot chart reports and tools to analyze data. Explore Web features to collaborate with others.
Microsoft Access
Introduction Create tables to hold data and then establish table relationships. Modify the design of tables, select queries, organize and print forms and reported. Use table relationships and referential integrity, integrate data with other applications, and modify a table design to streamline data entry. Implement data filters and parameter and action queries. Create data access pages and joins between tables.
Intermediate Learn to analyze data by creating complex queries, producing more efficient forms, normalizing databases, using functions and speeding-up repetitive tasks by creating macros. Control; object properties to enhance form design and learn about cross-tab queries and action queries to update data. Join tables and work with join properties, create sub forms to include multiple table information on one form.
Microsoft PowerPoint
Deliver your message with an effective PowerPoint presentation. You will learn to add notes to a slide, create and enhance graphs, incorporate Clip Art and Word Art, change design and use the Slide Master. Discover how to advance slides automatically, add sound, narration, movies and animation effects.
Microsoft Outlook
Microsoft Outlook is a powerful tool that can help you better organize your life and increase your productivity by utilizing the e-mail, calendar and task functionality built into the software
MOS Certification - Benefits to you:
MOS Certification - Benefits to Employers: