TRAINING

Enroll Now

Microsoft Office Online Training

We ensure that our MS Office training course gives you robust office management tools with the right mixture of usability, power, and flexibility, so you can manage your job more efficiently and productively. This course will cover MS Word, MS Excel, MS PowerPoint, Access & Outlook. Learn core and advanced Microsoft Office products through our MS office training classes and improve your skillset to meet the market demand.

Nearly every office or home use Microsoft Office package to perform several routine tasks such as sketching a letter, making a financial statement, generating a slide show, etc. Microsoft Office is considered as an essential skillset for today’s business professional’s. It includes programs that help you solve problems, answer questions, express ideas, organize data and communicate. Sharpen your skillset and learn tips and tricks that you haven't discovered yet on all Microsoft products, including Microsoft Office 2007, 2010, 2013 and the newest in Microsoft Office 2016 training.

MS Office and its applications are the ones which is used by most of the businesses and organizations in this vast world. Admittedly, it requires being appreciated as an incredible invention that was ever made. But, even this sometimes leads to experience at a workplace, if not operated correctly. So, in order to sustain in this technology world, it is extremely needed to gain specialized knowledge in MS Office. There are groups of training solutions feasible which helps to learn directly and cleverly with no strain and pressure.

Our faculties are IT specialists with more than 14 years of real-time experience in the industry. All training classes are In-Person, Instructor-led, and hands on. Our fully customizable courses are offered both on-site (at the client site) and off-site (at UGS Training Center). Our focus is our students’ successful transformation into an MOS professional. Upon successful completion of this MS Office course, all students will be awarded with MS Office course completion certificate. This would also enable you to take up MOS certification.

GETTING STARTED WITH WORD

• Touring the New Office 2007 Interface
• Formatting Basic Text
• Applying Formatting to a Paragraph
• Creating Bulleted & Numbered Lists
• Working with Styles
• Making Changes to the Styles
• Saving & Removing Formatting
• Changing Style Sets
• Proofing Your Work

REFINING WORD® DOCUMENTS

• Adding Headers & Footers
• Inserting Watermarks
• Formatting the Overall Document
• Inserting Graphical Elements
• Inserting Clip Art
• Using SmartArt
• Inserting Tables
• Formatting Tables
• Creating a Cover Page with Themes
• Saving a Document
• Outputting to PDF

EXPLORING EXCEL

• Touring the Excel Interface
• Inserting, Moving & Selecting Content
• Format Numerical Data & Reference Cells
• Building a Table & Using AutoFill
• Inserting & Deleting Rows & Columns
• Introducing Formulas
• Introducing Functions
• Using the Insert Function Dialog Box
• Using Statistical Functions & the Status Bar
• Using Auditing Commands
• Exploring Absolute Cell Referencing
• Naming Cell Ranges & Using Name Manager
• Pasting Data & Using the Clipboard

FORMATTING & STYLIZING IN EXCEL

• Formatting Cells
• Using Format Painter
• Number Formatting
• Using Cell Styles
• Creating Cell Styles
• Changing Styles
• Using & Creating Table Styles
• Filtering a Table Layout
• Using Conditional Formatting
• Formatting Worksheets with Themes
• Inserting Graphical Elements
• Managing Multiple Worksheets
• Outputting a Document
• Saving a Document

POWERING UP WITH POWERPOINT

• Touring the PowerPoint Interface
• Formatting Text
• Changing the Slide Layout
• Adding Additional Slides
• Creating a Slide Design
• Customizing Slides
• Inserting Objects
• Using SmartArt
• Creating & Formatting Charts
• Using WordArt Styles
• Changing Chart Types
• Applying Themes
• Setting Animation Effects
• Working with Different Views
• Setting Up a Slide Show
• Running a Slide Show
• Outputting a Presentation

STAYING CONNECTED IN OUTLOOK

1. Touring the Outlook Interface
2. Using E-mail
3. Creating Signatures & New Folders
4. Using a Calendar & Adding Events
5. Working with Multiple Calendars
6. Sharing Calendars
7. Adding & Viewing Contacts
8. Creating, Viewing & Flagging Tasks

MANAGING DATA WITH ACCESS

1. Introducing Access & Touring the Interface
2. Adding & Deleting Contacts
3. Filtering Data
4. Creating & Exporting Forms
5. Creating Reports
6. Exporting Data

A SEAMLESS OFFICE 2007 WORKFLOW

1. Formatting & Sorting Data
2. Using Freeze Panes
3. Grouping Data into Outlines
4. Creating Charts in Excel
5. Sharing Workbooks
6. Using Excel with Word
7. Protecting a Document
8. Using Cross-References
9. Inserting Objects
10. Using Excel with PowerPoint
11. Publishing Handouts to Word
12. Going from Word to Outlook
13. Sending Invites with Outlook