Information Technologies Trainings
IT Training Search
Want to save time on routine tasks in Microsoft Excel? Macros are the answer. In this course, the instructor will explain how macros can be used to automate tasks in Excel, and how you can create simple macros of your own. Learn when and how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting mailing list data into a database-friendly format.
In this 3-day course, you will learn how to use Visual Basic to control Excel and to automate processes to speed up and simplify their work with Excel data. You will also learn how to create interactive procedures using message boxes and custom dialog boxes using Visual Basic controls...
This PowerPoint training course is aimed at those with no experience of presentation or graphics programs. Users will be shown what PowerPoint can be used for, and how to use its basic features to create presentations and produce graphics.
Learn how to best create, edit, and share presentations with PowerPoint, the popular presentation platform. We will show how to build a slideshow from scratch or leverage PowerPoint templates and themes for quick construction. Then demonstrates how to add and edit text, images, graphs, video, and animation; format slides for consistency; and add speaker notes and transitions to ensure a smooth delivery. Plus, discover how to collaborate on changes and then share the final presentation via print, PDF, or a recorded slideshow.
Microsoft Outlook is a very powerful Personal Information Manager (PIM) designed to save you time and make integrating tasks, email, calendar and contact information simple. This Microsoft Outlook training course will provide you with an understanding of the huge range of features of MS Outlook that relate primarily to the individual user.
Be more productive in Outlook. This class will help you review your email quickly, organize and find messages, and automate some email tasks. How to be more efficient using Outlook advanced functions in order to organize yourself better.
The course teaches participants how to stop "living in their inbox" and start prioritizing tasks, messages, and appointments to achieve what's most important to the organization and themselves.
Most businesses have a lot of data, from customer details and employee records to product specifications data and invoicing and scheduling systems. By learning the basics of Microsoft Access, you can get to grips with how to store that data effectively in ways that make it easy to update, query and report on it for a range of outputs. This is an intensive Access training course, introducing delegates to the concepts of creating relational databases using MS Access. Microsoft Access is a very powerful database application designed to save you time and make creating relational databases easier.
Many organisations have large databases in Access that have built up over the years; staff have learned enough to build a database with a good relational structure, create forms to enter data and write queries to generate some useful reports. However, when databases get big making your queries and forms effective can become more complex and it is worth investing in advanced Access training to get the most from your data and save time. And our Advanced Microsoft Access course teaches delegates how to analyse data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros.
In this course students will get acquainted with an overview of the features and functions of Microsoft Office Visio 2016/2019/365. Work with block diagrams and move, size, rotate and copy shapes...