Skills Review Training Workshops
The workshops available include:
Excel: Managing your data with lists
New to Excel 2003, you can now manage data quickly effectively by converting it to a ‘List’. Lists take seconds to create and Rows and columns can be added or removed without affecting any other data. Totals can be added or removed at will and data management features are but a click away.
Excel: Pivot Tables - get a handle on your data
Excel's Pivot Tables enable you to quickly create concise reports from large data sets, spot trends by consolidating information and display results for multiple variable questions - plus you can easily create Pivot Charts to visually represent your data. Stop writing complicated formulas and make Pivot Tables do the work for you!
Excel: Mastering Advanced Functions
Excel's functions are many and various … and sometimes confusing! Get to grips with IF, VLOOKUP and array functions, discover the benefits of using range names and ways of validating your data results.
Excel: Creating Charts
Learn just about everything there is to know about charts: how to create dynamic, stylish and meaningful charts, edit and format, plus working with different chart types and adding moving average, trend lines and error bars.
Excel: Linking workbooks and worksheets
Are you currently saving every Excel spreadsheet in a separate file? Do you struggle to create formulas that span multiple worksheets? Are you familiar with sharing workbooks with other users? If not, then join our hands-on workshop and discover how easy it is!
Excel: Making a start with macros
If you've ever thought "there must be a better, faster way" to handle repetitive tasks in Excel, then this workshop is for you. Excel Macros are one of the most powerful, yet least understood and most underused tools, in Excel. This hands-on session will show you how to start increasing your efficiency.
PowerPoint: Deliver with Confidence
Worrying about the technical elements of your presentation can make the delivery appear jaded and unprofessional. Learn the skills required to set up and control the presentation efficiently, leaving you free to concentrate on the message you are delivering.
PowerPoint: Tips, Tricksand Techniques
If you want your presentation to have impact and keep the attention of your audience then this workshop is for you. Learn techniques and tips to ensure that your message is delivered in a way that will keep even those in the back row interested by the careful application of fonts, colours, custom animation, graphics and sound effects.
Word: Creating Posters and Handouts
Word has a whole host of desktop publishing features that you can use to create eye-catching documents. Learn how to harness Word’s DTP power to give impact to your posters and handouts.
Word: Creating Stylish Documents
They say style defines a person; this applies to your documents as well. Effective styling will not only enhance a document’s appearance, it will allow you to access many of Word’s time saving features. This course explores styles in Word: what they are, how they behave, and how to use them to your benefit.
Word: TOCS for Docs
Readers of long documents will greatly benefit from features that will allow them to navigate those documents quickly and easily. Suitable for both electronic and printed versions, a TOC (Table of Contents) will automatically enable them to find relevant sections of the document and the inclusion of an index saves time searching for key words. TOCs and hyperlinks are a vital aid to the navigation of on screen documents.
Word: Creating Forms using Tables
Tables are an effective way to present ordered information in your Word documents. In this workshop you will learn how to create and format tables, convert text into tables and create professional-looking forms using table layout.
Word: Whizzy Electronic Forms
Take control of the data users enter on to your forms by learning these valuable and time-saving form automation techniques. Using Fill-In field controls including text boxes, check boxes and drop-down lists you can validate at point of entry and extract this data to use in other applications.
Word: Mail Merge
Ever been frustrated trying to create mailing labels or form letters, or a customized email? This workshop explores the ways that Word can be used to create merged documents with data pulled from a variety of sources.
Project 2003: Task ListsTasks are the basic building blocks of any project. Tasks describe project work to in terms of sequence, duration, and resource requirements through the information panel.
Project 2003: Resource ManagementProjectresources are the people, equipment and material needed to complete the tasks in a project. Project 2003 concentrates on two main areas, their availability and their costthrough the information panel.
Project 2003: Resource to tasksAssigning resource to tasks enables you to track progress and cost. It will also provide time spent and time left on any task.
Project 2003: PrintingLearn how to setup your project document to print on A3 or A4. You will learn how to change the view and printing area of you plan. Identify if you need to print plans or reports.
Project 2003: Base Lining your Project
Base lining your project at the beginning of your project will enable you to compare your project plan to the outcome of activities, costs, resources and finish dates. Base lining your project will take a snap shot of your project plan for future comparison but allow you to add additional resource and tasks.
Project 2003: Formatting
Customise a view, how your fonts and bars look. Learn how to distinguish between milestones, tasks and summary areas of Project.
Visio: Share Diagrams
Learn to create and share diagrams in other Microsoft packages. Create hyperlinks to other documents, web pages or diagrams.
Visio: Create Shapes, Stencils and templatesCreate and format shapes, formatting, rotate and copy shapes.You will learn to stack, align and group shapes finally creating stencils and templates.
Visio: Other diagram types
Understand the different types of diagram’s available to you such as block, organisation charts, and office layouts as well as were to find and apply them.
Visio: Page Setup
Learn to resize the page, diagrams, and charts. Print areas of interest by selecting the correct paper size.
Outlook: E-Mail
Manage your inbox, filter emails, creating rules for delivering incoming emails to different folders as well as delaying emails being sent by you.
Outlook: Calendar & SchedulingShare or create multiple calendars, colour code holidays, time off, meetings and private appointments. Delegate access to your calendar to other colleagues and learn to print different views of your calendar.
Outlook: Contacts
Attach your contact info for others. Make a common change to multiple contacts. Learn how to use vCards and customising, importing and exporting your contacts list.
Outlook: Managing Attachments
Blocking attachments, the feature you love to hate. Customise how the screen reader sees attachments. How to remove unsafe attachments. How to insert attachments.
Outlook:Automating tasks
How to create Macros and set the correct Macro security for your needs.
Outlook:Finding, Searching and Managing Items
Copy, paste, delete and back up emails. Understand read receipts and who needs them. Retrieve or recover deleted emails and learn to select multiple items.
Outlook:Managing PST & Personal folders
Add a public folder short cut to your favourites. Create or modify a rule to a public folder. Creating, moving and renaming .PST files.
Outlook: Formatting fonts, signatures, and E-Mail noticesCheck Spelling, format text, fonts, create signatures and manage how Outlook notifies you of your incoming mail.
Outlook:Web AccessHow to access your email via the web, at home or via 3G. Identifying the differences between Web Outlook and Microsoft Outlook.
Outlook:Recalling E-Mails
Learn to recall or replace an email message you may have sent in error.
Outlook:BCC
Understand the difference to Carbon Copy ‘Cc’ and Blind Carbon Copy ‘Bcc’
1