![]() |
Word - Level 1An essential course – not just a basic course - introducing Word and providing lots of tips and tricks to ensure it works for you. Covering all the fundamentals some of which are margins, headers & footers, indentation, tabulation and inserting pictures. Word - Level 2 Continuing Word, using Tables, creation of newspaper style columns, search and replace, envelopes and labels. You will also learn about auto text, auto correct and much more. Word Improving Efficiency - Templates & Styles Incorporates creating and using templates - those preinstalled in Microsoft Word and user defined. In addition, you will cover working with styles, which is essential for creating uniformity in longer documents. Creating and running simple macros, using footnotes & endnotes, and the creation of a table of contents will be addressed. Word for Minute Taking Instruction on minute taking at meetings with guidance on the role of the minute taker. Delegates will concentrate on the more complex features of Microsoft Word’s bullets and numbering, indentation and table features. Learn how to create a template for future preparation of minutes and agendas. Word - Mail Merge & Macros Mail Merge techniques using both Microsoft Word and external data sources e.g. Excel & Access files. Filter & Sort Records, use Microsoft Word Field Codes for formatting e.g. to insert text only in letters that meet set criteria and to further customise the mail merge. Learn how to record a Macro to automate procedures. Excel - Level 1 Introduction to Excel covering all the essentials e.g. how to create formulas. Learn about referencing, formatting, printing and basic charts. Excel - Level 2 Linking worksheets and workbooks, working with more advanced formulas to include IF functions, Pivot Tables, creation of drop-down list, conditional and auto formatting. Excel - Level 3 Creating macros and advanced charting. Using Excel as a database to include auto filter and advanced filtering. Linking Excel files with other software packages. Creating custom views, templates, working with VLook-up and HLookup plus Goal Seeking. PowerPoint - Level 1 Learn how to create and design your own presentation with slides containing text, graphics, charts, organisation charts and sound. Learn about slide transition, timings, running and editing your presentation and having "speaker’s notes" to guide you through your presentation. PowerPoint - Level 2 This is a course about delivering professional presentations. No more moving in and out of PowerPoint to show a video, another document, or going to your company’s website – all this can happen from within the presentation and this course teaches this and more. Learn how to create and run a Macro in PowerPoint, create hyperlinks and enhance skills on constructing slides and much more. Access - Level 1 Create an Access database using Wizards, Data Entry and Design View. Amend field types and sizes. Input and Validation rules, Sort, filter and find records within a table. Create a Select Query. Access - Level 2 Using Queries, Forms, and Reports. This will involve the use of linking tables, relational work, multi-page forms and commands on forms. Email & Internet Learn how to create, send and receive email messages with file attachments. Create signatures for your messages, address book entries and groups. Learn about search engines and refining searches, keeping safe on the internet and the creation of secure passwords. |