Courses in Twickenham

...Collaborative editing Adding and removing text comments Editing text comments Tracking changes in a document Accepting and rejecting changes in a document... Learn about: Microsoft Word, Stained Glass, Excel workbooks...

...Seek tools Use Excel workgroup features Create and use macros Using multiple workbooks Using a workspace Printing workbooks Printing and previewing multiple... Learn about: Scenario manager, Auditing a worksheet, Goal seek...

...starting a slide show, starting a slide show on any slide... Learn about: Slide orientation, Compatibility checker, Slide numbering...

...custom sorts Querying/filtering Creating a single or multiple criteria query using available options Using advanced query/filter options Templates Using... Learn about:
Solver, SmartArt graphics, Microsoft excel training...

...PMT, PV, RATE Using lookup functions: IF, AND, OR, ISERROR Using available database functions: DSUM, DMIN, DMAX and DCOUNT Using nested functions Excel... Learn about: Microsoft Excel, Excel Tables, Freezing panes...

...This course aims to introduce delegates with little or no understanding of the Microsoft PowerPoint 2013 software to the basic features of the package... Learn about: Pie Charts, Microsoft Powerpoint, Compatibility checker...

...objects will dim to a specified colour after animation Animating chart elements Managing presentations Hyperlinks Creating action buttons Applying timings... Learn about: PowerPoint 2007, Document Inspector, Automatic slide shows...

...removing images from a master slide, adding text to slide footers, applying automatic slide numbering, automatically updating dates on slides Text... Learn about: Changing shape attributes, Ms PowerPoint, Microsoft Powerpoint...

...adding a free drawn line, rotating, flipping, changing shape attributes, applying shadow Slide Show Effects Preset Animation - adding and changing preset... Learn about: Ms PowerPoint, Resizing pictures, Microsoft Powerpoint...

...adding border effects to an object Printing and Distribution Slide Setup - selecting appropriate output formats, changing slide orientation Preparing for Distribution... Learn about: Microsoft Powerpoint, PowerPoint 2003, Organisational Chart...

...workbooks Tracking changes Creating, editing and removing comments Applying and removing file passwords Applying and removing worksheet and workbook protection... Learn about: Microsoft excel training, Report Manager, Tracking changes...

...PivotTables and Reports Creating a PivotTable report Creating a PivotChart report Resetting a summary function in a PivotTable report Creating a PivotTable... Learn about: Microsoft Excel, Printing workbooks, Microsoft excel training...

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

...hiding/unhiding worksheets, grouping and ungrouping worksheets Using subtotalling features Linking - Linking data within a worksheet, between worksheets and between workbooks... Learn about: Excel table, MS Excel, Financial functions...

...the Name Manager, importing text files, using Paste Special options Formatting - applying formatting to a cell range by the use of styles, creating custom number formats... Learn about: Microsoft excel training, Nested functions, Database functions...

...and previewing multiple worksheets Custom views Display Using one-input or two-input data tables Protection Protecting and unprotecting a worksheet... Learn about: Microsoft excel training,
Solver, Microsoft Excel...

...This course aims to give delegates a greater understanding of MS Access 2003. On completion of the course delegates will have improved their skills... Learn about: Relationships Defined, Form Sections, Foreign Keys...

...check box and option groups Inserting a data field to appear within form header or footer on the first page or all pages Stacked and tabular layout controls... Learn about: Report Design, Database training, Form Design...

...check box and option groups Inserting a data field to appear within form header or footer on the first page or all pages Stacked and tabular layout controls... Learn about: Multiple values



, Microsoft Access, Table Relationships...

...Merging slides and presentations Merging a word-processed outline into a presentation Applying background effects to slides Exporting slides in... Learn about: Automatic slide shows, Animating objects, Document Inspector...