Excell Advance 

 

 

Course Description

 

We have design this course to help you to achieve an edge in your career. Advanced Excel Course is designed for those who are working with Microsoft Excel. Whether you are an experienced Business Analyst, Accountant, Administrative/HR Officer or Project Manager, Advanced Excel  will enrich your computer skills and will get your work done faster!

 

 

Course Objectives

 

After completion of the Advanced Excel course, you will gain specialised expertise in handling difficult data-intensive tasks requiring complex Excel usage. Your expertise will be focused on the following domains of MS Excel.

 

• Advanced functions and Formulae
• Advanced Charts and Graphics
• Advanced Conditional Formatting
• PivotTables
• PivotTable Reporting
• Goal Seek + Solver
• Macros

 

 

Course Outline

 

• Working with Custom & Conditional Formats
• Using Formulas & Functions
• Working with Range Names
• Using Advanced Functions (like Nested If, Sum if, Count If etc.)
• Using Lookup Functions (Hlookup & Vlookup)
• Creating and Managing Tables
• Using Auto Filter
• Getting Most from your Data using Microsoft Excel
• Working with Charts in Excel
• Creating PivotTables
• Managing Reports by Pivot Table
• Creating and Using Shared Workbooks using Excel
• Working with Worksheet Protection
• Working with Multiple Workbooks in Excel
• Working with Macros in Excel

 

 

Course Duration

 

Course Duration is 20 Hours, Fast track coaching for Advanced Excel Course is also available.

 

 

MS ACESS

 

Course Description

 

Microsoft Access is a relational database management system used for storing information from various sources for reference, reporting, and analysis. MS Access is a powerful program to create and manage your databases. MS Access has many built in features to assist you in constructing and viewing your information.

 

Ms Access Course is designed for those who would like to know how to manage and store information for reference, reporting and analysis in Microsoft Access.

 

Course Duration 

 

Course Duration is 10 Hours, which can be completed by One Week.

 

 

Course Outline

 

• Exploring the Access Environment
• Creating & Modifying tables in Different Views
• Table Relationships
• Retrieving the Data you want
• Working with Joined Tables
• Working with Forms-Creating & Modifying Forms
• Designing Reports
• Working with Reports in different views
• Harnessing the Power of Queries

 

 

MS Office

 

Course Description

 

Global HRd Experts provides the Microsoft Office Course in Abu Dhabi to the beginners and intermediate users of MS Office packages. Our MS Office Course is the bundle of five Microsoft Courses which includes Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft PowerPoint and Microsoft Outlook. Microsoft Office Course  will give you access to all the module of ms office..

 

Course Duration

 

Course Duration is 40 Hours, Fast track coaching for MS Office course is also available.