EXCEL 2003: CORE

Click here for Expert

Course Objectives: To teach the Excel 2003 program to Microsoft Office Specialist Level

Pre-requisites:  Familiar with Windows environment and basic keyboarding experience

Course Content:

  • The Excel 2003 screen, creating a worksheet, entering text and numeric data, navigation, saving, naming and closing, opening an existing spreadsheet, editing cell contents, accessing help

  • Changing font type and size, text enhancement, selecting cells and ranges, text alignment, merging and splitting cells, modifying column width and row height, printing the active sheet, creating a folder, saving in a different format

  • Inserting and deleting rows, switching between multiple workbooks, moving and copying cells, cut, copy and paste, AutoFill, Office clipboard

  • AutoComplete, Hide and unhide columns and rows, freezing and unfreezing panes, inserting columns, change text orientation, page break preview, changing to landscape orientation, adjusting margins and scaling, centring between margins, displaying gridlines, inserting headers and footers, setting a print area, selecting non-adjacent data, naming and deleting a worksheet, saving a workbook as a template, creating a workbook from a template

  • Applying borders, formatting numbers, defining and applying styles, Auto Calculate, complex formulas, absolute cell references

  • Inserting a new worksheet, formatting a worksheet tab, grouping and ungrouping worksheets, 3-D references, applying wrap text formatting, indenting text, printing row and column headings, centring text horizontally and vertically in a range, adding, viewing and editing comments

  • Using the SUM and COUNT functions, AVERAGE, MAX and MIN functions, sorting columns, using NOW and IF functions, PMT and FV functions, AutoFilter, find and replace

  • Using the Chart Wizard, creating a two series line chart, formatting the plot area, creating a pie chart, saving selected data and a workbook as a web page, inserting a picture, resizing and repositioning, inserting and modifying an object, inserting and using a hyperlink, creating, modifying and positioning a diagram

Benefits

  • Learn how to use this popular spreadsheet program to Microsoft Office Specialist level

  • The flexibility and value of a self-study course designed to enable you to work at your own pace

  • A personalised workbook to use as a reference guide on completion of the course

  • The opportunity to gain the widely recognised Pitman Training Certificate

Duration: 20 hours

 


EXCEL 2003: EXPERT

Course Objectives: To teach Excel 2003 to Microsoft Office Expert level

Pre-requisites:  Working knowledge of the Excel 2003 program, ideally having completed the first Microsoft Office Excel 2003 course

Course Content:

  • Creating a template, using an existing template, editing a template, creating custom views, deleting custom views, consolidating data, creating a workspace file, using workspace files, creating and modifying custom number formats, using conditional formatting, deleting conditional formatting

  • Printing grouped worksheets and multiple workbooks, naming and modifying cell ranges, moving a named range, using range names to locate data, deleting a named range, using range names in calculations, formatting and resizing graphics, formatting charts and diagrams, finding trends in data

  • Setting security levels for macros, creating macros, running macros, editing a macro, creating a toolbar and menu to hold macros, deleting macros, deleting a toolbar button, deleting a custom toolbar and menu

  • Applying data validation rules, adding input messages and error alerts, locating invalid data, tracing precedents and dependents, tracing errors, evaluating formulas, using the watch window, using AutoFilter and Advanced Filter, using a data form

  • Compiling subtotals and consolidations, summarising data using outlining tools, using the database functions DSUM and DAVERAGE, using the Query Wizard with an external data source, analysing data using pivot tables, creating a pivot table chart, creating a pivot table from external data

  • Using data analysis to calculate rank and percentile, solving a problem using goal seek, using solver to calculate a quotation, creating What-If Analyses using the scenario manager

  • Protecting worksheets and workbooks, applying and removing passwords, sharing a workbook, merging workbooks, understanding workbook history, track changes, accept or reject changes, using digital signatures

  • Inserting an embedded object, inserting a linked object, retrieving data from the web, saving as a web page, publishing worksheets, editing a web page and republish, saving an Excel workbook as an XML document, mapping data in a workbook, importing an XML document into an existing mapping


Benefits

  • Know how to use Excel 2003 to Microsoft Office Specialist level

  • The flexibility and value of a self-study course designed to enable you to work at your own pace

  • A personalised workbook to use as a reference guide on completion of the course

  • The opportunity to gain the widely recognised Pitman Training Certificate

Duration: 18 hours each






 

 

 


 

( 020 7256 6668

     



  HOME   INVEST IN YOUR TEAM   INVEST IN YOUR CAREER   ABOUT US   COURSES   CONTACT US  

MICROSOFT   SHORTHAND   KEYBOARD SKILLS   DIPLOMAS   BOOKKEEPING   SEMINARS   QUALIFICATIONS   COURSE DATES  

PITMAN TRAINING LONDON
CITY WEST END BANK OXFORD CIRCUS
MICROSOFT OFFICE SKILLS KEYBOARD TYPING IT SHORTHAND ACCOUNTS BOOKKEEPING SECRETARIAL DIPLOMAS
ECDL MOS EXAMS MICROSOFT WORD EXCEL POWERPOINT ACCESS OUTLOOK FRONTPAGE 2003 2007
WARNFORD COURT 29 THROGMORTON STREET LONDON EC2N 2LT
WALMAR HOUSE 288 REGENT STREET LONDON W1B 3AL