Microsoft Excel Advanced

This online course looks at what anger is, what causes it, and the negative effects that it has on your body. It looks at how different people react to different triggers, and gets you to think about what triggers you specifically. It covers both groups of people that suffer from anger issues, those that bottle it up, and those that explode and vent their anger. In order to manage anger, it teaches techniques on what to do in the heat of the moment, as well as long term solutions.

This online course looks at what anger is, what causes it, and the negative effects that it has on your body. It looks at how different people react to different triggers, and gets you to think about what triggers you specifically. It covers both groups of people that suffer from anger issues, those that bottle it up, and those that explode and vent their anger. In order to manage anger, it teaches techniques on what to do in the heat of the moment, as well as long term solutions.

To give staff members appropriate tools to influence a range of situations at work encouraging others to 'give of their best' and promoting workable compromises.

Improve your interpersonal skills and boost self-confidence, get more out of others with proven techniques.

This one-day workshop helps delegates to understand the impact that communication skills have on other people and how improving these skills can make it easier to get better results.

Learn how to get more out of every day with better prioritisation, more structure and productive ways of setting your routine.

Get the Most From Your Databases. The Advanced course takes you to a level that will leave behind other office users of Access. You'll learn about advanced data management, working with forms and automating reports at the highest level. We'll introduce you to SQL, and take you to advanced queries, sub queries and joins, before covering macros, procedures and VBA. If that sounds a little daunting, remember that because of the modular nature of our courses, you can choose what you want to learn, and cover them one at a time. Watch the modules, revisit them time and again ... and have fun with improving your skills!

Step Up to Real Functionality, If the Introduction course showed you how to set up the basics, the Intermediate course shows you how to work at a higher level. You learn about Database Management and working with, saving, exporting, and linking, files. You then move on to Table properties and data validation, formatting and controlling your Forms, and working effectively with Reports and Queries. The skills you acquire in this course will enable you to set up commercial-standard databases with a whole host of practical uses. Watch the modules, revisit them time and again ... and have fun with improving your skills!

Create Great Access Databases Creating Great Access Databases. Microsoft Access is a powerful application which needs careful setting up. So learning the basics in a structured way is essential. You start by learning how to get started, use the Access interface and create a simple database that contains your data. You then move on to simple Forms, Queries, Reports and Filters which enable you to analyse and display your data. You will now have a solid basis for understanding and using Access to create solid and reliable databases.

This is the course where you move from mastering the basics to getting really productive with Excel. We start you off with advanced Excel file tasks, then move on to working with Functions and Formulas. You than learn how to manage Tables, Data Tools and Charts, and finish with a great feature called Sparklines. Your Excel skills will now enable you to produce impressive spreadsheets with little effort. Watch the modules, revisit them time and again ...and have fun with improving your skills!

A Great Foundation in Excel Skill. Whether you're a complete beginner, or someone who wants to learn the basics using best practice, this is the course for you. We show you how to get started, how to use the Excel interface and we outline the basics of running the software. We then move to editing your workbook, printing and viewing your work, and we show you how to create and use Charts. You will now have a solid basis for understanding and using Excel confidently and effectively. Watch the modules, revisit them time and again ...and have fun with improving your skills!

Become an Excel Power User. This course will enable you to get more out of Excel than other people will think possible! You begin with Advanced Conditional Formatting, Form Controls and Templates, then learn about Advanced Lookup Functions We teach you Advanced Functions, Array Formulas and Advanced Pivot Table Tools before introducing you to User Defined Functions and VBA. When you have mastered all this and put it into action, you will be able to call yourself a true Excel Power User! Watch the modules, revisit them time and again ...and have fun with improving your skills!

Supercharge Your Ability to Impress Your Audience. The Advanced course takes your presentations to the highest levels. We show you how to utilise pictures, add multimedia, as well as using charts, tables and diagrams to create that WOW factor. Then we show you how to set up, and customise, your presentation. Microsoft PowerPoint is an incredibly useful tool to make an impact on your audience. So ask yourself, why aren't you using it to its fullest capacity? Watch the modules, revisit them time and again ... and have fun with improving your skills!

A Fantastic Grounding in PowerPoint Skills. Whether you've never touched PowerPoint before, or you've used it for a while but want to make sure that you're using it properly, this is the course for you! We show you how to get started, how the interface works, and all you need to know about creating and formatting a presentation. We then build on that by showing you how to add shapes, art and transitions to really liven up your presentations. You will have a solid grounding in how to use PowerPoint to deliver presentations that give you the full credit you deserve. Watch the modules, revisit them time and again ... and have fun with improving your skills!

Increase Your Control and Mastery of Your Projects. The Advanced course takes you to a level that will put you in complete control of your projects. You'll learn about importing and exporting data, about advanced scheduling and calendar options, and advanced resource allocation. We'll show you how to work with multiple projects, customising fields, tables, views and filters, and creating custom project reports. Microsoft Project is an incredibly powerful application, and with the benefit of our two courses, you will have more awareness, control ... and general expertise ... than you thought possible. Watch the modules, revisit them time and again ... and have fun with improving your skills!

Create a Great Project Plan, Microsoft Project is a powerful application which needs to be set up and run properly. So learning from "ground up" in a structured way is essential. You start by learning how to use the Project interface and create a simple project plan with tasks, dependencies, constraints and deadlines. You then move on to adding resources, calendars and costs, and assigning them to tasks. You then learn to format the plan, use a Gantt Chart, and print out the plan to professional standards. You will now have a solid foundation for understanding Project and using the software to create solid and resilient project plans. Watch the modules, revisit them time and again ... and have fun with improving your skills!

Become a Professional in Designing Graphics with Microsoft Visio. This course is for anyone who knows the basics of Visio, but wants to improve their capabilities, and their speed, in using the software. We teach you the skills you need to create graphics at a faster pace than the basic user, saving time, reducing mistakes and enhancing quality. Please note that the course assumes you have a full understanding of what's covered in the Introduction course. This Microsoft Visio skills training course, like all our courses, has been developed over many years of classroom delivery. Content has been thoroughly researched and is constantly updated so it's always leading edge. It's delivered by professional presenters and is full of practical knowledge and solutions.

A Fantastic Grounding in Using Microsoft Visio. Microsoft Visio is probably the most popular application for creating diagrams for use in flowcharts, decision diagrams, plans and network schemes. It doesn't only make these jobs easier, but it greatly improves the quality of what you produce. Our course starts from the beginning, by introducing Visio to you, and then covering the four building bricks of all Visio diagrams, shapes, stencils, text and objects. We then show you how to finish your diagrams, and how to create three of the most popular types of diagrams, namely flowcharts, process diagrams and organisation charts. You then will have a solid base for using Visio to create high quality diagrams that enhance your documents and presentations. Watch the modules, revisit them time and again ... and have fun with improving your skills!

Create Documents That Truly Impress, One of the key elements of producing documents is to know how to provide what the people who read them expect to see. So we teach you how to use advanced features of Word to add those key elements. Our course also teaches you how to collaborate with others by tracking changes, using comments to guide others, and combine multiple versions into one document. From there, you'll learn how to add all the elements that readers of reports, assignments etc. are expecting, including reference tools like a table of contents, bibliographies, tables, charts, equations and other kinds of graphics. You will then be a truly professional creator of documents! Watch the modules, revisit them time and again ...and have fun with improving your skills!

Getting Your Documents to Do You Justice, For many people, the documents they create in Microsoft Word are going to be seen by others. Regardless of whether you're creating them on behalf of an organisation, or for yourself to send to other people, you want them to be as high quality as possible. This course looks first at how to manage your documents, before moving on to how to make them look professional by using formatting, headers and footers, pictures and shapes. It then shows you how to perform a mail merge for when you need to send a document out in bulk. By the end of this course, you'll be able to use Word to an impressive standard.

A Strong Foundation in Utilising Word Properly. So many people take Microsoft Word for granted. They simply open it up, and get started. Then they struggle with basic mistakes, and take too long to do the simplest things. Our course teaches you how to get started, understand the interface, and how to use and customize the tabs. We then show you how to create and save your own documents, and work with text, before ending on how to view and print your work properly. By the end of the course you'll have a great grounding in how to use Word quickly, effectively and professionally. Watch the modules, revisit them time and again ...and have fun with improving your skills!

This one-day workshop gives you proven ways to deal with the growing problem of stress in our lives. A little stress is good for us but too much can destroy us. The course explains its origins, how it builds up, and its harmful long-term effects on our mental and physical health. Most important it gives you ways to eliminate stress where you can, and manage it effectively where you cannot. You will come away from this course understanding what is contributing to your own stress and have a comprehensive strategy for dealing with it.