OAG Training Subjects
Microsoft Excel - Advance Level [Excel Level 2]
Duration: 1 Day
This program is designed for executives who are already have a good knowledge of Microsoft Excel, and who would like to work with more very advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports and Dashboard.
Basic Statistical Analytic using Excel
Duration: 1 Day
Transforms data into meaningful information, enabling organizations to make better decisions and predictions. Hence, it is a valuable skill to learn in business.
Business Intelligence tools using Power BI
Duration: 2 Days
This course is designed for anyone who works with large set of data facing problem in excel because of the volume of data and want to create a dashboard and share with your team member – regardless of technical or analytical background.
Business Intelligence tools using Tableau Desktop
Duration: 2 Days
This course is designed for anyone who works with data – regardless of technical or analytical background. It starts with simple visualizations and moves to an in-depth look at the different chart and graph functions available, calculations, parameters, mapping, and other functionality.
QlikView
Duration: 2 Days
This program is designed for covering the fundamentals required to get started building QlikView applications. Which include user interface layout, design fundamentals, how to create a QlikView application with sheets as well as best practices in design.
Data Analytics Using Excel
Duration: 2 Days
Organizations today have huge volumes of data being ingested from a wide range of sources. Gaining valuable insights from this data to make strategic business decisions is a high priority for many organizations.
Data Analytics with Power Query & Power Pivot
Duration: 1 Day
This course takes a project-based approach and is designed to guide you through the entire BI workflow from start to finish. Using fictional data, we'll load and transform raw CSV files with Power Query, build our own relational data model from scratch, and explore and analyze our model using Power Pivot and DAX expressions, and present the data using different Charts.
Microsoft Excel Level 2
[Intermediate to Advance Excel]
Duration: 2 Days
This program is designed for executives who has basic knowledge of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks using Macros [Recording Macro].
Microsoft PowerPoint
Duration: 1 Day
This program is designed for executives, who are already familiar with the basics of Microsoft Office, and who would like to work with more advanced features of Microsoft PowerPoint. In Microsoft PowerPoint, we will be looking powerful features of PowerPoint for drawing, formatting, and animation; you will learn how to create impressive professional-quality presentations.
Microsoft Project 2016
Duration: 2 Days
Microsoft Project is a popular and powerful tool for project planning and monitoring. This two-day program provides detailed exposure to various features and aspects of MS Project that can simplify the job of project managers to handle the complexities of managing single and even multiple projects.
Primavera 6 Project Management
Duration: 2 Days
Primavera is a popular and powerful tool for project planning and monitoring. This two-day program provides detailed exposure to various features and aspects of Primavera that can simplify the job of project managers to handle the complexities of managing single and even multiple projects.
Microsoft Excel with Macros using Excel VBA
Duration: 2 Days
This program is designed for executives who are already have a very good knowledge of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks using Macros [Recording and Writing Macro]
Microsoft Excel VBA
Duration: 2 Days
This course introduces the participants to advance topics of MS Excel and the basics of programming using Visual Basic for Applications (VBA). The course starts with introduction to recording of keystrokes as macros, and gradually builds up to cover the basic language constructs of VBA, writing functions and procedures, designing forms, and working with add-ins.