JMD Training and Consultancy courses

...This course aims to introduce delegates with little or no understanding of the Microsoft Excel software to the basic features of the package. On completion... Learn about: Header and footer, Inserting Data, Redo buttons...

...Microsoft Excel 2003. They will be able to: Manipulate worksheets Use templates Apply conditional formatting Use various functions, including financial... Learn about: Hiding rows, Creating Templates, Manipulating Worksheets...

...This course aims to give delegates an in-depth knowledge of Microsoft Word 2003 features. On completion of the course delegates will have advanced skills... Learn about: Inserting an index, Microsoft Word, Ms Word...

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

...Comparing documents side by side The Document Inspector Document properties Master documents Creating a new master document Adding and removing subdocuments... Learn about: Style sets, Field codes, Editing text comments...

...Comparing documents side by side The Document Inspector Document properties Master documents Creating a new master document Adding and removing subdocuments... Learn about: Microsoft Word, Advanced image techniques, Stained Glass...

...Seek tools Use Excel workgroup features Create and use macros Using multiple workbooks Using a workspace Printing workbooks Printing and previewing multiple... Learn about: Microsoft Excel, Scenario manager, SmartArt graphics...

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

...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:
Solver, Microsoft Excel, Goal seek...

...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: Functions




, Microsoft excel training, Excel Tables...

...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: Compatibility checker, Microsoft Powerpoint, Pie Charts...

...Merging slides and presentations Merging a word-processed outline into a presentation Applying background effects to slides Exporting slides in... Learn about: Microsoft Powerpoint, PowerPoint 2007, Custom slide shows...

...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: Changing shape attributes, Applying shadow, Ms PowerPoint...

...animation effects Transitions - adding slide transition effects Printing and Distribution Slide Setup - selecting appropriate output formats... Learn about: Resizing pictures, Microsoft Powerpoint, PowerPoint 2007...

...using zoom tool, modifying toolbar display Document Exchange - saving an existing presentation in another file format, saving in a format appropriate... Learn about: Ms PowerPoint, Microsoft Powerpoint, PowerPoint 2003...

...workbooks Printing and previewing multiple worksheets Using the Report Manager Named ranges Add a named range Delete a named range Use a named range... Learn about: Microsoft Excel, Running macros, Tracking changes...

...Scenario Manager and Goal Seek tools Use Excel workgroup features Create and use macros Using multiple workbooks Using a workspace Printing workbooks Printing... Learn about: Printing workbooks, Performing custom sorts, Microsoft Excel...

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

...

...link charts within a worksheet, between worksheets and between workbooks, linking to a word-processing documents, consolidating data in adjacent worksheets... Learn about: Table quick styles, Excel table, 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: Mathematical Functions, Microsoft excel training, Formula AutoComplete...