JMD Training and Consultancy courses

...opening, creating a new spreadsheet, saving, closing, using Help functions, converting documents, compatibility checker, switching between open worksheets... Learn about: Header and footer, Microsoft excel training, Page size...

...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: Filtering Data, Hiding rows, Financial functions...

...document Setting default file locations for workgroup templates... Learn about: Word Internet features, Workgroups

, Modifying notes...

...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: Word Internet features, MS Excel, Ms Word...

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

...Comparing documents side by side The Document Inspector Document properties Master documents Creating a new master document Adding and removing subdocuments... Learn about: Protecting a form, Stained Glass, Excel workbooks...

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

...case changes, shadowing, using subscripts and superscripts, applying different colours to text font, centring and aligning text, adjusting line spacing... Learn about: Slide numbering, Zoom tool, Resizing pictures...

...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: MS Excel, Scenario manager, Tracing errors...

...TODAY, DAY, MONTH, YEAR Using mathematical functions: SUMIF, SUMIFS, ROUND Using statistical functions: COUNT, COUNT, COUNTBLANK, COUNTIF, COUNTIFS... Learn about: Microsoft Excel, Microsoft excel training, Excel table...

...case changes, shadowing, using subscripts and superscripts, applying different colours to text font, centring and aligning text, adjusting line spacing... Learn about: Microsoft Powerpoint, Ms PowerPoint, Slide Show Effects...

...jpeg and bmp formats Pictures, images and drawn objects Converting pictures to drawn objects Grouping and ungrouping drawn objects Bringing images backwards... Learn about: PowerPoint 2007, Microsoft Powerpoint, Inserting sounds...

...deleting - copying and moving text and images between slides and between presentations, resizing pictures, deleting text and images Graphics and Charts Charts... Learn about: Compatibility checker, Applying shadow, Changing shape attributes...

...changing slide orientation Preparing for Distribution - adding notes for the presenter to slides, numbering the slides, using spell-check Printing... Learn about: Microsoft Powerpoint, Resizing pictures, PowerPoint 2007...

...adding text, adding an image from an image library, using a master slide Copying, Moving, Deleting Text Copying, Moving, Deleting Images Copying... Learn about: Microsoft Powerpoint, Organisational Chart, Ms PowerPoint...

...a formula Use Lookup Functions Auditing a worksheet Using the Auditing Toolbar Tracing errors Tracing dependents Tracing precedents PivotTables and Reports... Learn about: MS Excel, Report Manager, Running macros...

...PivotTables and Reports Creating a PivotTable report Creating a PivotChart report Resetting a summary function in a PivotTable report Creating a PivotTable... Learn about: Microsoft Excel, Microsoft excel training, Printing workbooks...

...the Name Manager, importing text files, using Paste Special options Formatting - applying formatting to a cell range by the use of styles, creating custom number formats... Learn about: Excel table, Editing

, Lookup functions...

...link charts within a worksheet, between worksheets and between workbooks, linking to a word-processing documents, consolidating data in adjacent worksheets... Learn about: MS Excel, Database functions, Formula AutoComplete...

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