Courses in Twickenham

...a cross-reference Field codes Inserting a field code Editing or updating a field code entry Locking or unlocking a field Deleting a field code Footnotes... Learn about: Compressing images, Protecting a form, Ms Word...

...SmartArt graphic layout Changing SmartArt graphic colours Macros Recording macros Running macros Editing macros... Learn about: Goal seek, Microsoft Excel, Scenario manager...

...Delegates should also gain the ability to accomplish basic operations with graphics and charts and to use various slide show effects. Getting Started First... Learn about: Open presentations, Zoom tool, Resizing pictures...

...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: Microsoft excel training,
Solver, Scenario manager...

...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: Structured references, Microsoft Excel, Formula AutoComplete...

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

...skills in using Microsoft PowerPoint 2007. They will be able to: Create and edit slides using a variety of layouts and styles Add additional objects... Learn about: PowerPoint 2007, Drawn objects, Animating objects...

...changing slide orientation Preparing for Distribution - adding notes for the presenter to slides, numbering the slides, using spell-check Printing... Learn about: Changing shape attributes, Applying shadow, Compatibility checker...

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

...adding slide transition effects Viewing a Slide Show Delivering a Presentation - starting a slide show on any slide, using onscreen navigation tools... Learn about: Organisational Chart, Zoom tool, Ms PowerPoint...

...workbooks Printing and previewing multiple worksheets Using the Report Manager Named ranges Add a named range Delete a named range Use a named range... Learn about: Tracking changes, Recording macros, Editing macros...

...SmartArt graphic layout Changing SmartArt graphic colours Macros Recording macros Running macros Editing macros... Learn about: Microsoft excel training, Printing workbooks, Performing custom sorts...

...logical and date/time functions Manage Excel tables Customise charts Use Excel in conjunction with other applications Editing Data - naming cell ranges in a worksheet... Learn about: Excel table, MS Excel, Microsoft Excel...

...Microsoft Excel 2010. They will be able to: Manipulate worksheets Apply conditional formatting Use various functions, including financial, logical... Learn about: Database functions, Table quick styles, Mathematical Functions...

...Microsoft Excel 2013. They will be able to: Manipulate worksheets Apply conditional formatting Use various functions, including financial, logical... Learn about: Financial functions, Excel table, Lookup functions...

...protection from a workbook Creating a shared workbook Tracking changes Highlighting Accepting Rejecting Sorting Sorting data by multiple columns Performing... Learn about: SmartArt graphics, Microsoft Excel, Goal seek...

...multi-table queries Use calculations in a query Design custom entry forms Design custom reports Access Database Design Primary and Foreign Keys Relationships... Learn about: Form Sections, Form Controls, Default Values...

...outer and self joins Applying and using referential integrity Applying automatic deletion of related records Relating or joining data when designing records... Learn about: Report Design, Database training, Microsoft Access...

...default values in a field Setting a mandatory field Fields with multiple values Table Relationships Understanding the basis for creating a valid relationship... Learn about: Query 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: Multimedia

, Automatic slide shows, Drawn objects...