Courses in Twickenham

...Macros Recording a simple macro Copying a macro Running a macro... Learn about: Compressing images, Ms Word, Stained Glass...

...and unprotecting designated cells in a worksheet with a password Security Adding password protection to a workbook Removing password protection from... Learn about: Scenario manager, SmartArt graphics, Auditing a worksheet...

...presentations for distribution and display. Delegates should also be able to create a variety of presentations for different target audiences or situations... Learn about: Open presentations, Slide orientation, Master slide...

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

...hiding/unhiding worksheets, grouping and ungrouping worksheets Using subtotalling features Linking - Linking data within a worksheet, between worksheets and between workbooks... Learn about: Functions




, Excel table, Microsoft Excel...

...images Inputting and Formatting Text - adding text to a presentation, editing slide content, changing font type, applying italics, bold, underlining... Learn about: Ms PowerPoint, Microsoft Powerpoint, Slide Show Effects...

...into a PowerPoint presentation Design Considerations Audience and environment Assimilation Delivery Slides Creating and saving a new presentation template... Learn about: Automatic slide shows, PowerPoint

, Microsoft Powerpoint...

...starting a slide show, starting a slide show on any slide... Learn about: Changing shape attributes, Compatibility checker, Ms PowerPoint...

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

...Steps with Microsoft PowerPoint - opening, creating a presentation, saving, closing, using Help functions Adjusting Basic Settings - changing display modes... Learn about: Organisational Chart, Ms PowerPoint, Microsoft Powerpoint...

...Wide Web Data Analysis Tools Goal Seek Solver Scenario manager Excel workgroup features Changing workgroup properties Creating a shared workbook Merging... Learn about: Lookup functions, Microsoft Excel, Report Manager...

...SmartArt graphic layout Changing SmartArt graphic colours Macros Recording macros Running macros Editing macros... Learn about: MS Excel, Microsoft excel training, Querying


...

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

, Excel table, Converting text...

...TODAY, DAY, MONTH, YEAR Using mathematical functions: SUMIF, SUMIFS, ROUND Using statistical functions: COUNT, COUNT, COUNTBLANK, COUNTIF, COUNTIFS... Learn about: Excel table, Structured references, Statistical functions...

...formatting worksheet backgrounds, freezing row and/or column titles, splitting worksheet window into panes, freezing panes, hiding/unhiding rows and columns... Learn about: Nested functions, Database functions, MS Excel...

...a template Editing a template Auditing a worksheet Tracing errors Tracing dependents Tracing precedents Adding, removing and editing worksheet comments... Learn about: MS Excel, Tracing errors, Data Analysis Tools...

...using Microsoft Access 2003. They will be able to: Use field properties for protection Understand table relationships and referential integrity Create... Learn about: Default Values, Relationships Defined, Form Sections...

...dBASE and Paradox formats Linking external data to an Access 2007 database... Learn about: Database training, Report Design, Form Design...

...date and time in a field Understanding the consequences of modifying data types such as text, memo, hyperlink, currency, date and time in a field Creating... Learn about: Form Design, Table Relationships, Multiple values



...

...into a PowerPoint presentation Design Considerations Audience and environment Assimilation Delivery Slides Creating and saving a new presentation template... Learn about: Automatic slide shows, Inserting sounds, Drawn objects...