Courses in Twickenham

...within a master document Table of contents Creating a table of contents Updating and modifying an existing table of contents Applying formatting options... Learn about: Excel workbooks, Protecting a form, Microsoft Word...

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

...starting a slide show, starting a slide show on any slide... Learn about: Slide orientation, Open presentations, Master slide...

...protection from a workbook Creating a shared workbook Tracking changes Highlighting Accepting Rejecting Sorting Sorting data by multiple columns Performing... Learn about: Data Analysis Tools, MS Excel, Microsoft Excel...

...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, MS Excel, Microsoft excel training...

...Steps with Microsoft PowerPoint - opening, creating a presentation, saving, closing, converting presentations, compatibility checker, switching between open presentations... Learn about: Ms PowerPoint, Pie Charts, Microsoft 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: Action buttons, Animating objects, Ms PowerPoint...

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

...On completion of this course delegates should understand and be able to accomplish basic operations associated with creating, formatting and preparing... Learn about: Ms PowerPoint, Resizing pictures, Microsoft 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: Zoom tool, Ms PowerPoint, PowerPoint 2003...

...workbooks Tracking changes Creating, editing and removing comments Applying and removing file passwords Applying and removing worksheet and workbook protection... Learn about: Running macros, Microsoft Excel, Editing macros...

...a password Protecting and unprotecting designated cells in a worksheet with a password Security Adding password protection to a workbook Removing password... Learn about: Performing custom sorts, MS Excel, Microsoft Excel...

...legend or data labels in a chart, 'exploding' all the segments in a pie chart, adding or deleting a data series in a chart, modifying the chart type for a defined data series... Learn about: MS Excel, Converting text, Structured references...

...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: MS Excel, Microsoft excel training, Database functions...

...tables Creating an Excel table Editing an Excel table Table quick styles Inserting and deleting rows and columns in tables Sorting Using the AutoFilter... Learn about: Excel table, Microsoft excel training, Database functions...

...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: Data Analysis Tools, Goal seek, SmartArt graphics...

...Importing Data from Other Sources Using Microsoft Access 2003 Tools Backing up and restoring a database Compacting and repairing a database... Learn about: Relationships Defined, Input Masks, Database training...

...customising the Navigation pane Database display Table design - fields Applying and modifying data types such as text, memo, hyperlink, currency... Learn about: Microsoft Access, Table design, Field templates...

...multi-table queries Use calculations in a query Design custom entry forms Design custom reports Displaying the Access 2010 database The Navigation... Learn about: Form Design, Table Relationships, Microsoft Access...

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