JMD Training and Consultancy courses

...replacing existing cell content, using the undo and redo buttons Finding and Replacing Rows and Columns - inserting rows and columns, modifying row height and cell width... Learn about: Microsoft Excel, Inserting Data, Editing Data...

...Microsoft Excel 2003. They will be able to: Manipulate worksheets Use templates Apply conditional formatting Use various functions, including financial... Learn about: MS Excel, Filtering Data, Microsoft Excel...

...Managing existing notes Modifying notes Creating cross-references Working with paragraphs Applying paragraph and section shading Using text flow options Sorting lists... Learn about: Ms Word, Word Internet features, Inserting an index...

...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: Document styles, Word Internet features, Ms Word...

...in using Microsoft Word 2013. They will be able to: Create and use master documents Use document styles to automate formatting Insert bookmarks Create tables of contents... Learn about: Field codes, Editing text comments, Document Inspector...

...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: Stained Glass, Excel workbooks, MS Excel...

...for the World Wide Web Data Analysis Tools Goal Seek Solver Scenario manager SmartArt graphics Creating a SmartArt graphic Formatting SmartArt Changing... Learn about: Microsoft excel training, Scenario manager, Goal seek...

...Developing a Presentation Presentation views - understanding the uses of different presentation view modes, changing between presentation view modes Slides... Learn about: Master slide, Slide orientation, Open presentations...

...They will be able to: Link multiple workbooks Print workbooks Use one and two-way data tables Audit a worksheet Create and use PivotTables and reports Use Solver... Learn about: Microsoft Excel,
Solver, Goal seek...

...using a 3D sum function Charts and graphs - Changing angle of pie chart slices, formatting chart axes numbers or text, re-positioning title... Learn about: Formula AutoComplete, Excel Tables, Structured references...

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

...the comment text in the presentation The Document Inspector Packaging a presentation for... Learn about: Document Inspector, Ms PowerPoint, Automatic slide shows...

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

...This course aims to introduce delegates with little or no understanding of the Microsoft PowerPoint 2007 software to the basic features of the package... Learn about: Microsoft Powerpoint, Ms PowerPoint, PowerPoint 2007...

...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: Ms PowerPoint, Organisational Chart, 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: Tracking changes, Report Manager, Merging workbooks...

...SmartArt graphic layout Changing SmartArt graphic colours Macros Recording macros Running macros Editing macros... Learn about: Querying


, Performing custom sorts, 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: Editing

, Mathematical Functions, Microsoft Excel...

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

...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: Table quick styles, Microsoft Excel, Statistical functions...