This one-day MS Access intermediate course will provide you with the understanding and hands-on ability to create Access queries and reports using your Access database. Other design considerations are the screens for the input of data and display of reports for output.
You will learn about the rules for tables in a database, the relationships between the data in different tables understand different data types and create validation rules for checking the input of data.
An Access database is used to hold data about things that exist in the real world, for example people in a personnel system. This course will equip you with the necessary understanding and hands-on skills to build a simple MS Access database.
You will learn how to set up tables to hold your data and how to link these tables together in a meaningful manner. You will then learn how to use filters and queries to retrieve useful data from your tables.
Building on your existing knowledge of MS Excel this course includes tools for handling large Excel spreadsheets and managing lists of data. You will also understand how to control Excel worksheets that are being edited by several people.
This course will enable you to create, build and customise graphs including plotting trend lines and summarise a large Excel worksheet using the outlining tools. You will also learn about making decisions using conditional statements and formatting.
Excel spreadsheets can become very complex with one formula calculating from the results of several others. This course covers the tools to trace problems with complex formulae and methods for consolidating several Excel worksheets.
You will also learn about the analytical tools in Excel and how to use them for goal seeking. You will learn about macros, how to create templates for commonly used worksheets and how to protect data using security features.
This Microsoft Excel Introduction course focuses on quick ways to get started with Excel. You will learn about the layout of the Excel screen and be aware of the features of the workbook and worksheet structure.
You will learn quick methods for entering, editing and formatting data and understand Excel formulae and functions to a level where you will be able to compile sales figures, create purchase orders or analyse bank statements.
Microsoft Outlook enables you to communicate and exchange information with your colleagues through the use of email, calendars and tasks. It also helps you to organise your time and data to enhance the way you work.
This MS Powerpoint advanced course is designed for delegates who have had some experience of Powerpoint to create or edit presentation and who now whish to consolidate and build on their existing knowledge.
You will learn how to create templates and master layouts for a consistent style to your presentations. You will also learn about sharing you presentations with other people, importing data from other applications and advanced slide show techniques.
Effective presentations are essential to get your message across. PowerPoint allows you to create professional, high quality presentations suitable for clients and colleagues with the minimum of time and effort.
In this course you will learn how to create a MS Powerpoint presentation containing text, graphics, charts and tables and how to set up simple animation effects for use in a slide show. You will also learn how to print handouts from your MS Powerpoint presentation.
This one-day MS Project course introduces the scope of Microsoft Project to users involved in project management. It gives you practical experience in using MS Project as a tool to help break projects into manageable parts and keep them under control.
You will gain an understanding of project planning and methodologies for projects of all sizes. You will learn to create and maintain a project plan, using tasks and resources.
This course will enable you to create and design professional Process Maps, Flow Charts, Organisation Charts and much more. It is a drawing package with flexibility. From this course you will learn how to use the drawing tools to make professional charts with ease.
This Microsoft Word Intermediate training program expands on basic Word skills and shows you how to handle long Word documents using columns, paragraph numbering and tables to make them easier to read. You will learn how to organise your MS Word documents using different page layouts or headers and footers in the same document.
You will also understand how to control documents that are being edited by several people and how to conduct a mail shot using the Mail Merge feature.
This Microsoft Word Advanced training course focuses on creating Word documents and templates for other people to use. It will enable you to use style sheets to apply formatting to longer documents, insert MS Word fields to display or capture information and add a table of contents or an index.
You will see how to create and use templates for telephone messages, faxes and memos. You will also learn how to record and play macros to automate repetitive or tedious tasks.
This introduction to Microsoft Word course will give you the skills to type, save and print simple Word documents such as letters and memos. No previous word processing experience is necessary.
The course focuses on quick ways to select, edit and format text. it is full of time-saving tips including how to teach Word your repetitive typing so that you never have to type it again.