Courses in Twickenham

...Security Adding password protection to a document Removing password protection from a document Forms Creating and editing a form Deleting fields in a... Learn about: Microsoft Word, Protecting a form, Advanced image techniques...

...They will be able to: Create a workspace Print workbooks Audit a worksheet Create and use PivotTables and reports Use Solver, Scenario Manager and... Learn about: Auditing a worksheet, MS Excel, Data Analysis Tools...

...images Inputting and Formatting Text - adding text to a presentation, editing slide content, changing font type, applying italics, bold, underlining... Learn about: Master slide, Slide orientation, Compatibility checker...

...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, Scenario manager,
Solver...

...Microsoft Excel 2007. They will be able to: Manipulate worksheets Apply conditional formatting Use various functions, including financial, logical... Learn about: Functions




, MS Excel, Freezing panes...

...creating different types of chart Drawing Objects - adding lines, moving lines, changing line colour, modifying line width, adding various shapes... Learn about: Resizing pictures, Microsoft Powerpoint, Ms PowerPoint...

...Merging slides and presentations Merging a word-processed outline into a presentation Applying background effects to slides Exporting slides in... Learn about: Inserting sounds, Ms PowerPoint, Automatic slide shows...

...animation effects Transitions - adding slide transition effects Printing and Distribution Slide Setup - selecting appropriate output formats... Learn about: Applying shadow, Ms PowerPoint, Compatibility checker...

...presentations for distribution and display. Delegates should also be able to create a variety of presentations for different target audiences or situations... Learn about: Microsoft Powerpoint, Resizing pictures, PowerPoint 2007...

...adding notes for the presenter to slides, numbering the slides, using spell-check Printing - previewing the presentation document in different views... Learn about: Microsoft Powerpoint, Organisational Chart, Ms PowerPoint...

...Creating a PivotTable report Creating a PivotChart report Resetting a summary function in a PivotTable report Creating a PivotTable report for the World... Learn about: Microsoft excel training, Microsoft Excel, Report Manager...

...and previewing multiple worksheets Custom views Display Using one-input or two-input data tables Protection Protecting and unprotecting a worksheet... Learn about: Querying


, Printing workbooks, Performing custom sorts...

...widening the gap between columns or bars in a 2D chart, inserting an image in a 2D chart Functions Resizing the Formula Bar, Formula AutoComplete Using date and time functions... Learn about: Structured references, Converting text, MS Excel...

...This course aims to give delegates a greater understanding of MS Excel 2010. On completion of the course delegates will have improved their skills in using... Learn about: Lookup functions, Mathematical Functions, Database functions...

...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 training, Lookup functions, Formula AutoComplete...

...SmartArt graphic layout Changing SmartArt graphic colours Macros Recording macros Running macros Editing macros... Learn about: Data Analysis Tools, Tracing errors,
Solver...

...Importing Data from Other Sources Using Microsoft Access 2003 Tools Backing up and restoring a database Compacting and repairing a database... Learn about: Database training, Form Sections, 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: Field templates, Table design, Query Design...

...Creating a one-to-one or a one-to-may relationship between tables Understanding and modifying a many-to-many relationship between tables Applying inner... Learn about: Report Design, Multiple values



, Table Relationships...

...jpeg and bmp formats Pictures, images and drawn objects Converting pictures to drawn objects Grouping and ungrouping drawn objects Bringing images backwards... Learn about: Automatic slide shows, Custom slide shows, Drawn objects...