JMD Training and Consultancy courses

...centring a title over a cell range, adding border effects Cell styles Applying table formats Charts and Graphs Using charts/graphs – producing different... Learn about: Editing Data, Cell styles, Header and footer...

...Data validation Charts Plotting non-contiguous data ranges Pie charts Adding new data to an existing chart Chart formatting techniques Use of Excel... Learn about: Microsoft Excel, Hiding rows, Applying templates...

...a style to text Modifying a style for the current document Deleting a style Printing a list of styles Displaying the styles in a document Bookmarks Creating... Learn about: Inserting an index, Ms Word, Microsoft Word...

...and endnotes Creating and deleting footnotes and endnotes Modifying existing footnotes and endnotes Modifying format and positioning of footnotes and endnotes... Learn about: Word Internet features, Ms Word, Microsoft Word...

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

...in using Microsoft Word 2010. They will be able to: Create and use master documents Use document styles to automate formatting Insert bookmarks Create tables of contents... Learn about: Microsoft Word, Stained Glass, Advanced image techniques...

...workbook Creating a shared workbook Tracking changes Highlighting Accepting Rejecting Sorting Sorting data by multiple columns Performing custom sorts... Learn about: Auditing a worksheet, Scenario manager, Microsoft excel training...

...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, Slide orientation, Master slide...

...This course aims to give delegates an in-depth knowledge of Excel 2013 features. On completion of the course delegates will have advanced skills in using Microsoft Excel... Learn about: Scenario manager, MS Excel, Goal seek...

...TODAY, DAY, MONTH, YEAR Using mathematical functions: SUMIF, SUMIFS, ROUND Using statistical functions: COUNT, COUNT, COUNTBLANK, COUNTIF, COUNTIFS... Learn about: Excel Tables, Freezing panes, Excel table...

...presentations for distribution and display. Delegates should also be able to create a variety of presentations for different target audiences or situations... Learn about: Resizing pictures, Pie Charts, Ms PowerPoint...

...or forwards Positioning and aligning pictures images and drawn objects Omitting background graphics from slides Applying semi-transparent... Learn about: Drawn objects, Custom slide shows, PowerPoint

...

...changing bullet type, text in columns, using undo and redo Pictures and Images - inserting pictures and images into slides Duplicating, moving... Learn about: Changing shape attributes, Applying shadow, Compatibility checker...

...deleting - copying and moving text and images between slides and between presentations, resizing pictures, deleting text and images Graphics and Charts Charts... Learn about: Resizing pictures, PowerPoint 2007, Ms PowerPoint...

...adding border effects to an object Printing and Distribution Slide Setup - selecting appropriate output formats, changing slide orientation Preparing for Distribution... Learn about: Organisational Chart, Microsoft 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: Tracking changes, Lookup functions, Microsoft excel training...

...a password Protecting and unprotecting designated cells in a worksheet with a password Security Adding password protection to a workbook Removing password... Learn about: Printing workbooks, Querying


, Microsoft Excel...

...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, Converting text, MS Excel...

...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: Structured references, Database functions, Formula AutoComplete...

...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: Nested functions, Microsoft Excel, Statistical functions...