Advanced MS Office Course

This training course is designed to help you accomplish office tasks easily and with greater efficiency, Microsoft Office is the choice of many office professionals. You’ll likely find it in nearly every business around the globe, and this training will help ensure you stay on top of ever-changing improvements in office productivity.

Microsoft Office products help improve work efficiency with user friendly features that enable easy and secure information sharing. Microsoft Office products provide resources for professional presentation of data that is compatible with most operating systems. This course is designed for individuals and office professionals who need to master the capabilities of the latest edition of Microsoft Office.

Ms Excel

• Basic Functions
• Sum Ifs And Countifs
• Vlook Up & Hlookup
• Data Validation
• Goal Seek & Hyperlink
• Name & Scenario
• Advance Filter
• Quick Access Toolbar
• Formula Auditing
• Data Table
• Remove Duplicates
• Consolidation
• Watch Window
• Text To Columns
• Custom Views
• Comment & Paste Special
• Track Changes

Ms Word

• Different Views
• Using Hyperlink
• Autotext And Autocorrect
• Setting Colums
• Mail Merge
• Track Changes
• Envelopes And Labels
• Basic Macro Functions
• DOCUMENT PROTECTION
• Fax And Mailing

Ms Access

• Introduction To Database
• Building Databuilding Database Management
• Using Forms, Filters, Queries, And Reports
• Linking With Other Microsoft Applications
• Relationship
• Macros
• Database Utilities

Ms Outlook

• Setting Up And Managing Your Email
• Personal Folder
• Calender
• Contacts
• Tasks
• Notes
• Outlook Configuration