Courses in Twickenham

...in using Microsoft Word 2010. They will be able to: Create and use master documents Use document styles to automate formatting Insert bookmarks Create tables of contents... Learn about: Protecting a form, Stained Glass, Compressing images...

...and unprotecting designated cells in a worksheet with a password Security Adding password protection to a workbook Removing password protection from... Learn about: MS Excel, SmartArt graphics, Goal seek...

...adding a free drawn line, rotating, flipping, changing shape attributes, applying shadow Slide Show Effects Preset Animation - adding and changing preset... Learn about: Resizing pictures, Master slide, Zoom tool...

...This course aims to give delegates an in-depth knowledge of Excel 2013 features. On completion of the course delegates will have advanced skills in using Microsoft Excel... Learn about: Goal seek,
Solver, Scenario manager...

...with tables Totals Removing duplicate rows from worksheets Creating a dropdown list for table entry Structured references... Learn about: Structured references, Excel Tables, MS Excel...

...Creating and modifying column, bar, line and pie charts Organisation charts - creating an organisational chart, modifying the structure of an organisational chart... Learn about: Resizing pictures, Compatibility checker, Pie Charts...

...rescaling an image Rotating, mirroring and flipping an image Applying effects to images Converting an image into greyscale or black and white format Converting... Learn about: Inserting sounds, Custom slide shows, Microsoft Powerpoint...

...changing slide orientation Preparing for Distribution - adding notes for the presenter to slides, numbering the slides, using spell-check Printing... Learn about: Microsoft Powerpoint, Ms PowerPoint, Compatibility checker...

...using Help functions Adjusting Settings - using zoom tool, modifying basic options such as user name, and default folder to open and save presentation... Learn about: Ms PowerPoint, Microsoft Powerpoint, PowerPoint 2007...

...importing images from other files, resizing and moving an image in a slide, importing other objects, copying an imported object to a master slide... Learn about: Zoom tool, Microsoft Powerpoint, Organisational Chart...

...Macros Recording macros Running macros Editing macros... Learn about: Recording macros, Editing macros, Tracking changes...

...Scenario Manager and Goal Seek tools Use Excel workgroup features Create and use macros Using multiple workbooks Using a workspace Printing workbooks Printing... Learn about: Performing custom sorts, MS Excel, Printing workbooks...

...tables Creating an Excel table Editing an Excel table Table quick styles Inserting and deleting rows and columns in tables Sorting Using the AutoFilter... Learn about: Lookup functions, Mathematical Functions, Structured references...

...AVERAGEIF, AVERAGEIFS Using text functions: PROPER, UPPER, LOWER, CONCATENATE Converting text to columns Using financial functions: FV... Learn about: Excel table, Structured references, MS Excel...

...link charts within a worksheet, between worksheets and between workbooks, linking to a word-processing documents, consolidating data in adjacent worksheets... Learn about: Excel table, Lookup functions, Database functions...

...a password Protecting and unprotecting designated cells in a worksheet with a password Security Adding password protection to a workbook Removing password... Learn about: SmartArt graphics, Goal seek, Microsoft excel training...

...Queries Multi-table Queries Adding Calculated Fields to Queries Access Forms Form Sections Form Controls Layout of Form Controls Properties of Form Controls... Learn about: Database training, Form Controls, Relationships Defined...

...multi-table queries Use calculations in a query Design custom entry forms Design custom reports Displaying the Access 2007 database The Navigation... Learn about: Microsoft Access, Field templates, Query Design...

...This course aims to give delegates a greater understanding of MS Access 2010. On completion of the course delegates will have improved their skills... Learn about: Form Design, Database training, Table Relationships...

...an image into a file format such as: bmp, gif, jpeg format Compressing images SmartArt - creating, formatting, changing layout, changing colours Converting... Learn about: Action buttons, Ms PowerPoint, Custom slide shows...