JMD Training and Consultancy courses

...standard error messages Cell referencing - relative cell referencing, absolute cell referencing, mixed cell referencing Working with Functions... Learn about: Sorting Data, Cell styles, MS Excel...

...Microsoft Excel 2003. They will be able to: Manipulate worksheets Use templates Apply conditional formatting Use various functions, including financial... Learn about: Editing templates, Applying templates, Freezing panes...

...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: Ms Word, Microsoft Word, Modifying notes...

...a shadow of a specified colour on a picture Modifying brightness and contrast Cropping and proportionately rescaling an image Rotating, mirroring and flipping... Learn about: Compressing images, Field codes, Word Internet features...

...an image Applying different available effects such as: negative effect, blurred, sharpened, stained glass, embossed, etc to an image Converting an image... Learn about: Style sets, Document Inspector, Collaborative editing...

...to a table of contents Document styles Styles Style sets Referencing Adding or deleting a bookmark Creating and editing an index Creating and deleting... Learn about: Ms Word, Microsoft Word, Advanced image techniques...

...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, SmartArt graphics, 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: Slide numbering, Slide orientation, Master slide...

...PivotTables and Reports Creating a PivotTable report Creating a PivotChart report Resetting a summary function in a PivotTable report Creating a PivotTable... Learn about:
Solver, Tracing errors, 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: Functions




, Microsoft Excel, Formula AutoComplete...

...using Help functions Adjusting Settings - using zoom tool, modifying basic options such as user name, and default folder to open and save presentation... Learn about: Ms PowerPoint, Compatibility checker, Slide Show Effects...

...a data series Changing scale of value axis Drawing flowcharts Changing or deleting flowchart shapes Changing connector types between flowchart shapes Multimedia... Learn about: Drawn objects, Document Inspector, Action buttons...

...starting a slide show, starting a slide show on any slide... Learn about: Applying shadow, Ms PowerPoint, Microsoft Powerpoint...

...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: PowerPoint 2007, Resizing pictures, Microsoft Powerpoint...

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

...This course aims to give delegates an in-depth knowledge of Excel 2003 features. On completion of the course delegates will have advanced skills in using Microsoft Excel... Learn about: MS Excel, Tracking changes, Microsoft excel training...

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


, Microsoft excel training...

...link charts within a worksheet, between worksheets and between workbooks, linking to a word-processing documents, consolidating data in adjacent worksheets... Learn about: Structured references, Converting text, Lookup functions...

...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: Table quick styles, Formula AutoComplete, Excel table...

...TODAY, DAY, MONTH, YEAR Using mathematical functions: SUMIF, SUMIFS, ROUND Using statistical functions: COUNT, COUNT, COUNTBLANK, COUNTIF, COUNTIFS... Learn about: Nested functions, Statistical functions, Lookup functions...