Microsoft Office 2010

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

Sign up for our free newsletter!