Courses in Twickenham

...an index, footnotes, endnotes, cross-references Work with paragraphs Use Word Internet features Write macros to automate tasks Create forms Collaborate with workgroups... Learn about: Excel workbooks, Stained Glass, MS Excel...

...This course aims to give delegates an in-depth knowledge of Excel 2007 features. On completion of the course delegates will have advanced skills in using Microsoft Excel... Learn about: SmartArt graphics, Microsoft Excel, Auditing a worksheet...

...creating different types of chart Drawing Objects - adding lines, moving lines, changing line colour, modifying line width, adding various shapes... Learn about: Resizing pictures, Zoom tool, Slide orientation...

...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 training, Goal seek, MS Excel...

...This course aims to give delegates a greater understanding of MS Excel 2007. On completion of the course delegates will have improved their skills in using... Learn about: Excel table, MS Excel, Microsoft excel training...

...animation effects Transitions - adding slide transition effects Printing and Distribution Slide Setup - selecting appropriate output formats... Learn about: Ms PowerPoint, Pie Charts, Microsoft Powerpoint...

...or forwards Positioning and aligning pictures images and drawn objects Omitting background graphics from slides Applying semi-transparent... Learn about: Inserting sounds, Action buttons, Document Inspector...

...adding a new slide with a specific slide layout, changing between built-in slide layouts, changing slide background colour Master slides - Inserting images into a master slide... Learn about: Ms PowerPoint, Changing shape attributes, Applying shadow...

...images Inputting and Formatting Text - adding text to a presentation, editing slide content, changing font type, applying italics, bold, underlining... Learn about: PowerPoint 2007, Resizing pictures, Ms PowerPoint...

...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: Microsoft Powerpoint, Organisational Chart, Zoom tool...

...a formula Use Lookup Functions Auditing a worksheet Using the Auditing Toolbar Tracing errors Tracing dependents Tracing precedents PivotTables and Reports... Learn about: Microsoft Excel, Recording macros, MS Excel...

...report for the World Wide Web Data Analysis Tools Goal Seek Solver Scenario manager SmartArt graphics Creating a SmartArt graphic Formatting SmartArt Changing... Learn about: Printing workbooks, Microsoft Excel, Performing custom sorts...

...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: Editing

, Structured references, Microsoft Excel...

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

...hiding/unhiding worksheets, grouping and ungrouping worksheets Using subtotalling features Linking - Linking data within a worksheet, between worksheets and between workbooks... Learn about: Formula AutoComplete, Microsoft Excel, Statistical functions...

...custom sorts Querying/filtering Creating a single or multiple criteria query using available options Using advanced query/filter options Templates Using... Learn about: Tracing errors, Scenario manager, Data Analysis Tools...

...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: Relationships Defined, Form Controls,
Relationship Types...

...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: Database training, Report Design, Field templates...

...outer and self joins Applying and using referential integrity Applying automatic deletion of related records Relating or joining data when designing records... Learn about: Database training, Table Relationships, Multiple values



...

...objects will dim to a specified colour after animation Animating chart elements Managing presentations Hyperlinks Creating action buttons Applying timings... Learn about: Drawn objects, Multimedia

, Custom slide shows...