STANDARD COURSES Access ACT! Dreamweaver Excel Introduction Intermediate Advanced Flash FrontPage Illustrator InDesign Office 2007 Outlook Photoshop Powerpoint Project Soft Skills Technical Skills Visio Windows Vista Word Course Fees	EXCEL INTRODUCTION Duration: 1 day Versions Available: 97, 2000, XP, 2003 , 2007, 2010 COURSE OUTLINE     Introduction What is a Spreadsheet Starting Excel Parts of the screen The office assistant Quitting Excel Basic Skills Cursor movement Using Go To Highlighting areas of the worksheet Entering data Editing a cell entry Deleting a cell or range of cells Undoing the last command Redoing the last command Drag and drop Filling a range Insert and delete AutoComplete Inserting deleting rows and columns Smart Tags Opening, closing and saving Creating a new file Viewing a list of open files Version compatibility Email a spreadsheet File search Entering Formulae Entering simple calculations Circular references Using AutoSum Using Paste Function Statistical functions Relative and absolute cell referencing Formula auditing mode Printing cell formulae Using AutoCalculate Error correction Screen tips for function arguments Formatting Using the formatting toolbar Adjusting column widths and row heights Changing cell alignment Formatting numbers Changing fonts and attributes Borders and patterns Using the shortcut menu Copying styles Cut, copy and paste Copying data into Word Printing Print preview Changing the page setup Defining the print area Printing Inserting a page break Page break preview Charts and Drawing Creating a chart Changing the chart type Using the drawing tools EXCEL INTERMEDIATE Duration: 1 day Versions Available: 97, 2000, XP, 2003 , 2007, 2010 COURSE OUTLINE     Refreshing the basics Functions IF function Creating multiple IF statements Look ups Information functions Data calculations Testing for errors Naming ranges Working with multiple sheets  Creating a new workbook Selecting cells across worksheets Entering formulae across worksheets Using paste link Splitting the worksheet into panes Saving a workspace Fixing worksheet titles Copying and moving between worksheets Copying and linking between workbooks Insert, delete and group worksheets       Data Consolidate Working with lists Sorting data Using the automatic filter Tools Spell check AutoCorrect Find and replace Cell and workbook protection Using Zoom Introduction to Pivot tables Charts and Drawing Creating a chart Changing the chart type Chart options Formatting a chart 3D View Printing Using the drawing tools EXCEL ADVANCED Duration: 1 day Versions Available: 97, 2000, XP, 2003, 2007, 2010 COURSE OUTLINE     Refreshing the intermediate More formulae Summing conditionally Lookup tables  Text functions   Views and Reports Outlining a worksheet        Creating worksheet views Printing reports Templates and Auditing Creating templates Conditional formatting Auditing a worksheet Adding a comment Tracking changes Sharing workbooks Drawing and graphics Diagrams and organisation charts Working with Lists Using the data form Entering subtotals Data validation Pivot Tables Summarising data using pivot tables Formatting the pivot table Creating a pivot table chart What If Analysis Goal seek Solver Scenarios Data tables Toolbars Editing an existing toolbar Creating a new toolbar Introduction to Macros Recording and running a Macro		"Projects have included Outlook, Office 97 and 2000. On every occasion they have been completed with success to very tight deadlines. Very focused on client needs. Merrill Consultants' trainers are of a very high standard". Paul Smith, IT Manager State of the art plasma technology