Microsoft Office 2010 Course Overviews
| Courses | Level | Description | Delivery | |||
| Onsite | Live Online | Modular Webinar | Self Tutor | |||
| What’s new in Office 2010 |
For experienced users of Office 2007, Office 2003 or Office XP who require familiarisation with the new 2010 interface, and changed or updated features in commonly used Microsoft applications. | √ | √ | √ | ||
| Access | Level 1 | MS Access 2010 Introduction – Familiarise yourself with the concepts and features of Access 2010. Learn to create, use and edit tables, queries, forms and reports. Using fields and records. Basic data entry rules. | 1 Day | √ | ||
| Access | Level 2 | MS Access 2010 Intermediate – Comprehend the principles of table relationships; perform complex queries with calculations. Make forms aesthetically pleasing and easier to use; improve the layout and organisation of reports. | 1 Day | √ | ||
| Access | Level 3 | MS Access 2010 Advanced – Quickly analyse data using Pivot Tables, group and summarise data. Use macros to automate tasks, enhance forms with tab pages and create advanced queries. Learn and understand SQL code and integrate a database with the web. Replicate and synchronise a database. | 1 Day | √ | ||
| Excel | Level 1 | MS Excel 2010 Introduction – Create spreadsheets and input data. Create simple calculations. Learn to edit, delete, move, copy and manipulate data. Chart wizard, formatting a spreadsheet and printing. | 1 Day | √ | ||
| Excel | Level 2 | MS Excel 2010 Intermediate – Creating formulas over multiple worksheets and workbooks. Sorting and filtering data. Learn advanced formatting techniques. Protecting data, creating advanced charts, using standard templates and creating your own templates. | 1 Day | √ | ||
| Excel | Level 3 | MS Excel 2010 Advanced – Creating advanced formulas to make decisions. Importing and exporting data. Create and use look-ups and queries. Learn to work with Pivot Tables and other analytical tools. Record and use macros to automate your work. | 1 Day | √ | ||
| Excel | Level 4 | Macros | 1 Day | √ | ||
| Productivity Tips in Excel |
Bespoke Excel course | 1 Day | √ | √ | ||
| InfoPath | Level 1 | 1 Day | √ | |||
| InfoPath | Level 2 | 1 Day | √ | |||
| Outlook | Level 1 | 1 Day | √ | |||
| Outlook | Level 2 | 1 Day | √ | |||
| PowerPoint | Level 1 | At the end of this course you will have a good working knowledge of PowerPoint basics. You will feel more confident using PowerPoint and be able to create a presentation from scratch. You will learn how to improve the format of your text as well as getting to grips with importing and manipulating graphics, using the Powerpoint drawing tools and the chart and table design tools to make your presentation much more visually stimulating. You will also learn how to make modifications to your presentation before you learn how PowerPoint is used in a live presentation. | 1 Day | √ | ||
| PowerPoint | Level 2 | On completion of this course you will be proficient in Microsoft PowerPoint. You will be able to use templates to build custom presentations and introduce much more stimulating graphical and animated content. We will show you how to use the advanced delivery options, customise your workspace and interrelate your presentation with both Excel and Word files. | 1 Day | √ | ||
| Project | Level 1 | At the end of this course you will have a good working knowledge of MS Project basics. You will feel confident using Project and be able to define, schedule and monitor tasks using a variety of tools and views. | 1 Day | √ | ||
| Project | Level 2 | This course is designed for those users who wish to improve their current knowledge of Project to take advantage of the more complex features. On completion of the course, delegates will use project to help manage their resources and costs; to set plans, deadlines and schedules. At this level they will be able to track their project and create and print Gantt charts and reports. | 1 Day | √ | ||
| Project | Level 3 | At the end of this course you will have a complete understanding of the higher functions of Project. You will be able to perform the most advanced functions of managing a project and operate multiple projects. Your Project expertise will enable you to customise your layouts and take your macro skills on to new levels of sophistication while your ability to create and use templates will speed up your future Project process. |
1 Day | √ | ||
| Publisher | Level 1 | 1 Day | √ | |||
| Publisher | Level 2 | 1 Day | √ | |||
| Visio | Level 1 | At the end of this course you will have a good working knowledge of Visio basics. You will feel more confident using Visio and be able to able to create a diagram or a chart. Understanding and using some of the built-in drawing and object manipulation functionality will enable you to progress to creating concise and clear diagrams and charts. Structures that you create will be easier to build, amend, read and will be professionally formatted. | 1 Day | √ | ||
| Visio | Level 2 | This course is designed for those users who wish to advance their current knowledge of Visio to take advantage of the more complex features. You will feel more confident using Visio and be able to create technical layouts, work flow & fishbone diagrams and many more advanced diagram types. Understanding and using the built-in interoperability between your diagrams and data, such as the databse wizard, will allow for much more complexity. Finally you will learn how to work with far more advanced custom shape designs. | 1 Day | √ | ||
| Productivity Tips in Word |
1 Day | √ | √ | |||
| Word | Level 1 | At the end of this one day Word training course you will have a good working knowledge of Word basics. You will feel more confident using Word and be able to create a document from scratch. Understanding and using some of the built in layout and text editing functionality will enable you to produce far more striking and effective documentation in your work and home Word environments. Documents that you create will be easier to read and look more presentable. |
1 Day | √ | √ | |
| Word | Level 2 | This Microsoft Word training course is designed for those users who wish to improve their current knowledge of Word and take advantage of the more complex features. You will be able to divide a document into sections and columns, to format tables and populate them with data directly from Excel spreadsheets. You will also learn how to add recurrent data to documents in a series such as page numbers and headers. Finally you will be shown how to prepare labels and envelopes, add your company logo to a letter and set up a template for future mail. | 1 Day | √ | √ | |
| Word | Level 3 | At the end of this Word 2010 course you will have a complete understanding of the higher functions of Word. You will be able to perform the most advanced functions, including merging your documents with databases for mail-shots and producing well-defined forms. You will learn how to work with extremely large documents and how to use macros to speed through any repetitive functions. | 1 Day | √ | √ | |
| MS SharePoint | √ | |||||
