Course / Program Title Days Who Should Attend
Microsoft Access 2016 - Level 1    
Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.  1 Day New User Microsoft Officew Access 2016

Microsoft Access 2016 - Level 2

   

The training and experience using Microsoft Access 2016 Level 1 has given basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, the participant will expand the knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for the users.

1 Day
  • Using Microsoft Windows 10
  • Microsoft Windows 10: Transition from Windows® 7
  • Microsoft Office Access 2016: Level 1

Microsoft Access 2016 - Level 3

   

This course is suited for those using Microsoft Access Level 3. This course will be taught using Microsoft Access. The participants have covered many of the basic functions of Microsoft Office Access in Level 1 & 2 n and now they are ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

1 Day
  • This course is intended for participants who wish to gain the understanding of Microsoft Office Access 2010, 2013 or 2016.
  • The participants taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills.

Microsoft Excel 2013 Macro & VBA

   

This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VB code and assign macros to screen items.

2 Days

Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users' work) in the application using macros

Microsoft Excel 2016 - Level 1

   

Identify basic worksheet and workbook concepts and terms
Enter & edit data
Modify the worksheet
Use functions to calculate and return values
Format cells to enhance the appearance of your worksheet
Use drawing features and other enhancements
Change the page set-up to define how the printed worksheet appears.

1 Day

Microsoft Excel 2016 combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Delegates will learn the basics of creating, editing, and saving worksheets in our Essentials level class. They will work with formulas and functions to calculate and return values.  Delegates will learn to change the appearance of a page, including adding headers and footers, format data and create charts.

Microsoft Excel 2016 Level 2

   
  • Using multiple worksheets, workbooks and workspaces
  • Working with Financial functions
  • Use advanced formatting techniques
  • Using the Auditing Tools to track information
  • Using charts to display financial data
  • Use Templates.
1 Day

This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.

Microsoft Excel 2016 Level 3

   
  • Creating, Maintaining, Filtering and using Subtotals in a List
  • Recording, Assigning and Using Macros
  • Creating and Using User‑Defined Functions
  • Performing “What If” Analyses
  • Working with Scenarios
  • Querying a Database
  • Importing and Exporting Files and Data
  • Protecting Data
  • Pivot Tables, Reports and Charts.
  • Other Advanced Business Analysis Tools
2 Days This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts. 

Microsoft Powerpoint 2016 Level 1

   
  • Create and edit simple presentations
  • Enhance presentations by formatting
  • Use the drawing tools to create and edit logos & pictures
  • Insert objects
  • Apply Slide design
  • Set-up presentations for printing purposes
  • Create and automate screen shows
1 Day PowerPoint is a powerful presentations application, which allows the user to create intuitive presentations for paper, screen or web output. 

Microsoft Powerpoint 2016 Level 2

   

This course takes students beyond the basics and gives them higher-level skills for Microsoft PowerPoint 2016. The 12 modules in this course cover key topics, including using slide, handout, and note masters; working with templates; working with comments; reviewing a presentation; advanced presentation techniques; advanced animation techniques; custom shows; and file management tools.

1 Day PowerPoint is a powerful presentations application, which allows the user to create intuitive presentations for paper, screen or web output. 

Microsoft Project 2016 Level 1

   

Welcome to Microsoft® Project 2016: Part 1.
This course is designed to familiarize you with the basic features and functions of Microsoft Project Professional 2016 so you can use it effectively and efficiently in a real-world environment.

1 Day

This course is designed for a person with an understanding of project management concepts and who is responsible for creating and maintaining project plans. The course will give the student a fundamental understanding of Microsoft Project 2016 necessary to create and save project plans.

Microsoft Project 2016 Level 2

   

Microsoft® Project 2016: Part 2 covers the advanced knowledge and skills a project manager needs to update a project plan in Project 2016 during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scopeIn this course, you will learn to create and engage in basic management of a project using Microsoft Project Professional 2016.

2 Days

This course is designed for students with an understanding of project management concepts who are responsible for creating and maintaining project plans. Target students will be looking to acquire the advanced knowledge and skills a project manager needs to update a project plan in Project 2016 during the execution, monitoring, and controlling phases of a project.

Microsoft Visio 2016 Level 1

   

To give an introduction to the tools and features of Microsoft Visio.

1 Day People who intend to design various kinds of charts using Microsoft Visio as the software.

Microsoft Visio 2016 Level 2

   
To deliver more advanced features to the Visio user. 1 Day People who intend to design and create various kinds of drawings to a high level.

Microsoft Word 2016 - Level 1

   

Participant will learn below topics:

  • Create and save documents for easy retrieval.
  • Insert and delete text to edit a document.
  • Move, copy, and replace text.
  • Modify text for emphasis.
  • Learn document and paragraph formatting.
  • Set and remove tab stops to enhance document appearance.
  • Use margins, indents, bullets, and numbering to change text layout.
1 Day Basic knowledge on any Microsoft Operating System or basic user of any previous version.
Microsoft Word 2016 - Level 2    
Microsoft Word 2010 Level 2 combines a powerful word processing application with the user-friendly atmosphere of Windows. Training participants will learn the printing and sharing Document,  customizing the interface, creating templates. Working with styles and reviewing documents. 1 Day Basic User or the user those attended Microsoft Office Word 2016 Level 1.
Microsoft Word 2016 - Level 3    

Participant will learn advanced such as:

  • Mail Merge
  • Protection
  • Working with Multiple Documents
  • Outlines
  • Table of Contents
  • Table of Index
  • Macros
1 Day