Access | Excel | Outlook | PowerPoint | Word | Other MS Products | Adobe | Soft skills

90 Minute Bitesize Course Profiles

Access

Is Access the Right Tool for My Project?

This seminar provides a general overview of what Access can do. The intention is help delegates determine whether Access is the right tool for their needs plus provide an overview of how Access functions.

Designing Queries in Access

This workshop is aimed at those who already use Access and want to design and manipulate queries. During the hands on 90 minute session you will learn how to extract meaningful and useful data from your database using Access' querying tools.

Excel

Excel Formulae and Functions

This workshop is for anyone that wants to get more done in less time when working with Excel. The ability to carry out calculations in Excel gives you the power to really get the job done. In this bite-sized workshop you'll learn how to create simple formulas and how to use simple preset functions. Once you have mastered formulae and functions in Excel, you'll never go back to a calculator!

Mastering Advanced Excel Functions

Excel’s functions are many and various... and sometimes confusing! Get to grips with IF, LOOKUP and the DATE functions, discover the benefits of range names, ways of validating your data results and even how to design custom functions specific to your data.

Creating Charts in Excel

Learn just about everything there is to know about charts: how to create dynamic looking charts, edit and format, plus working with different chart types. With our bitesize workshops, creating and working with charts is easier than you think.

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, creating multiple worksheets, and using Sort and Filter commands - and make Pivot Tables do the work for you!

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!

Recording Simple Macros in Excel

If you’ve ever thought, “there must be a better, faster way” to handle repetitive tasks in Excel, then join our Recording Excel Macros workshop. 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 with Microsoft’s number one spreadsheet program.

Outlook

Working with Meetings in Outlook

Do you want to schedule meetings with your co-workers and ensure you pick a time during which they are available? Do you want an easy way to track whether invitees are planning to attend a meeting you scheduled? Join our Meetings workshops and learn how to do just that.

PowerPoint

PowerPoint for Presenters

If you’ve dabbled with PowerPoint then this workshop will help you take your presentations to the next level with tips for navigating your presentation with the keyboard, mouse or remote device, ideas for designing powerful presentations, plus guidelines for the meaning and use of colours and using the recommended number of words per slide for maximum results.

PowerPoint, Word and Excel

Do you ever want to insert an Excel chart or Word document into your PowerPoint presentation? Do you want the chart to automatically update when changes are made to the Excel data? Have you ever wanted to put a graphic created in PowerPoint into your Word document? Then this is the workshop for you!

Word

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

Working with 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, modify tables, draw free-form tables for graphics and forms, sort tables, and use simple calculations in tables.

Working with Long Documents in Word

This workshop explores the best method for structuring long documents in Word and demonstrates how to reliably assemble long documents from multiple source files plus it highlights Word's advanced publishing features and automated functions.

Word Reviewing, Collaborating and Tracking Changes

Do you need to create and edit text documents with another person or with a group? Word comes equipped with a number of features that make the process easier, faster, smarter. Come and learn how to use these powerful features in this fast moving workshop.

Creating Posters and Handouts in Word

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.

Agendas and Minutes in Word

This workshop is aimed at regular users of Word who have a need to create documentation for meetings such as agendas and minutes. It will concentrate on usability and improving layout using templates, tables and Word’s numbering commands.

Other Microsoft Products

Get to know Visio

This workshop will give you a head start putting this powerful and flexible tool to work creating various types of process flow diagrams, organization charts, floor plans and other illustrative line graphics. Explore Visio's extensive catalogue of shapes; learn how to enter and edit shapes, text and lines, and how to 'connect', move, and reshape them.

What Project can do for You - Seminar

Failing to plan properly leads to problems. Plan a successful outcome for your project: identify and schedule tasks and key dates, check costs and review resource loadings. Avoid potential hold-ups and other issues. Update your plans to match what’s really happening and report what matters so you can make the right decisions. Could your projects be more successful?

Get to know Microsoft OneNote

OneNote is a program specially designed to help all note takers. No longer do you have to use stop gaps and workarounds; in OneNote you can do so much more than on a pad of paper. Learn about the basics of using OneNote and customizing features so that it looks the way you like.

Perfect Publisher

Want your own brand of gift cards or need to make invitations for a party? Then Publisher is the answer. In this 90 minute class, we explore this program and learn to make many different types of documents such as brochures and flyers.

Getting to Know Microsoft SharePoint - Seminar

This seminar is for business users who would like to know how Microsoft SharePoint can help them better track information, as well as share information and collaborate with others.

The Office 2007 Ribbon

With Office 2007, Microsoft has significantly changed the Office user interface as the old-style menus, toolbars and task panes have been replaced by the tabbed Ribbon area. With these changes each application now has new ways to edit and format your documents. This workshop provides a tour of the new interface and how to get the most from it.

Adobe Products

Adobe Photoshop Elements I

Learn how to improve that scanned image or to make that picture from your digital camera just the way you want it. This workshop teaches you how to quickly remove red eye, straighten and crop, color, and focus to create that perfect picture.

Adobe Photoshop Elements II

Looking for more basics of graphic enhancement? Learn the basics of Layering. This workshop will teach you how to use filters, resize and brighten, use selection tools or keyboard shortcuts to create the perfect picture.

Creating PDFs with Acrobat

Adobe Acrobat lets you create PDFs that will retain the exact look and feel of the original documents. You can e-mail PDF files or post them to your web site, and feel confident that they can be viewed and printed by anyone, anywhere across a broad range of hardware and software.

Soft Skills

Simple telephone techniques

How customers are spoken to on the telephone can either enhance or damage a company's reputation. This very practical workshop is aimed at employees who communicate with customers or clients by ‘phone. During the workshop we will cover three strategies for improving your communication techniques.

Making meetings matter

This workshop will show you how to generate more interaction, enthusiasm and commitment when running meetings. Looking at some core skills when planning, preparing and conducting meetings we can help you to stop wasting valuable time and hold meetings that matter to all. Delegates will examine the principles of a good agenda plus tips for getting your message across.

Managing your time effectively

Critical deadlines, competing priorities and an avalanche of e-mail often leave individuals feeling overwhelmed. Being able to set priorities and allocate time appropriately are critical skills for achieving your goals. Take control of your time and schedule, reduce your stress levels and increase your confidence with our Time Management workshop.

Reducing absence

Absence costs UK employers £12 billion per year. This affects business performance, customer satisfaction and employee motivation and is often a sign of wider business performance issues. Learn how to take a proactive approach to reduce both the cost and the impact of absence in the workplace.

Managing performance

This workshop will help participants develop some simple yet effective techniques to ensure staff achieve peak performance. It covers dealing with poor performers, enhancing the performance of those performing at a satisfactory level and developing the stars.

Writing effective reports

Creating easy-to-read documents with a good logical structure helps the reader understand and make decisions. This practical workshop will help delegates with planning a framework, structuring and ordering material plus tips for better presentation and layout.

Getting to grips with delegating

Effective delegation benefits everyone whether they are delegating or accepting delegated tasks. This session will look at the advantages to effective delegation from the viewpoint of the organisation, the person delegating and the person accepting delegation.

Interview skills

Would you like to be more effective when interviewing potential employees? If so, whether you are a first time interviewer or are looking to improve upon your existing interview skills, this is an ideal workshop to attend. With tips for attracting the right type of applicant to your organisation plus discussion on preparing for interviews and the structure they should take.