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.

• 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.

• 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.

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.

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.

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

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

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.

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.

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.

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.

Microsoft Visio 2016 Level 2

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.

Participant will learn advanced such as:

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