JMD Training and Consultancy courses

...date, text in a cell Selecting Data - cells, range of adjacent or non-adjacent cells, rows, columns Copying, Moving, Deleting Editing Data – Inserting additional cell content... Learn about: Cell styles, Microsoft excel training, Formatting Cells...

...Applying templates Editing templates Creating templates Formatting Applying number formats Creating conditional number formats Using conditional formatting... Learn about: Microsoft excel training, Data validation, Microsoft Excel...

...paragraphs and tables Word Internet features Saving a Word document as a Web page Linking a Word document to a Web page Macros Creating a macro Applying... Learn about: Modifying notes, Workgroups

, Inserting an index...

...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: Word 2007, Excel workbooks, Document styles...

...Security Adding password protection to a document Removing password protection from a document Forms Creating and editing a form Deleting fields in a... Learn about: Document Inspector, Excel workbooks, Collaborative editing...

...an image Applying different available effects such as: negative effect, blurred, sharpened, stained glass, embossed, etc to an image Converting an image... Learn about: Ms Word, Advanced image techniques, Excel workbooks...

...SmartArt graphic layout Changing SmartArt graphic colours Macros Recording macros Running macros Editing macros... Learn about: Data Analysis Tools, Auditing a worksheet, Scenario manager...

...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: Master slide, Open presentations, Zoom tool...

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

...Microsoft Excel 2007. They will be able to: Manipulate worksheets Apply conditional formatting Use various functions, including financial, logical... Learn about: Functions




, Excel table, Microsoft Excel...

...On completion of this course delegates should understand and be able to accomplish basic operations associated with creating, formatting and preparing... Learn about: Microsoft Powerpoint, Resizing pictures, Pie Charts...

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

, Animating objects...

...adding a free drawn line, rotating, flipping, changing shape attributes, applying shadow Slide Show Effects Preset Animation - adding and changing preset... Learn about: Microsoft Powerpoint, Compatibility checker, 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: Microsoft Powerpoint, PowerPoint 2007, Resizing pictures...

...This course aims to introduce delegates with little or no understanding of the Microsoft PowerPoint 2003 software to the basic features of the package... Learn about: PowerPoint 2003, Ms PowerPoint, 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: Microsoft Excel, Editing macros, Report Manager...

...custom sorts Querying/filtering Creating a single or multiple criteria query using available options Using advanced query/filter options Templates Using... Learn about: Printing workbooks, Querying


, Performing custom sorts...

...formatting worksheet backgrounds, freezing row and/or column titles, splitting worksheet window into panes, freezing panes, hiding/unhiding rows and columns... Learn about: Microsoft excel training, Mathematical Functions, Excel table...

...with tables Totals Removing duplicate rows from worksheets Creating a dropdown list for table entry Structured references... Learn about: Excel table, Microsoft excel training, Financial functions...

...This course aims to give delegates a greater understanding of MS Excel 2013. On completion of the course delegates will have improved their skills in using... Learn about: Database functions, Statistical functions, MS Excel...