![Genesis [logo]](images/logo.jpg){kind=logo}
Pitman Training Microsoft Excel 2007 Part 1 Certificate
Course Title: Pitman Training Excel 2007 Part 1 Certificate (PTXPCT)Awarding Body: Pitman Training
Pitman Training is the largest independent training network in Ireland offering local solutions to businesses and individuals alike. With Pitman Training you have the best choice of training options:
· Career Solutions with its renowned National Diploma Programme
· Fully flexible IT and Office Skills training – attend when you like
· Classroom training courses tailored for all levels
· Seminar courses to develop personal skills
· Online training and Home Study options
· IT Technical learning tracks with full mentoring support
·
Intended Audience: Those who wish to learn this popular spreadsheet program to Microsoft Office Specialist (MOS) level.
Entry Requirements: Familiar with Windows Environment and basic keyboarding experience.
Exemptions: Exemptions are granted by modules based on previous Pitman Training Certification.
Course Details
Lesson One – Including: The opening Excel 2007 screen, creating a worksheet with text and numbers, entering simple formulas, adjusting column widths, editing cells, navigating a workbook and worksheets, using AutoSum, saving, naming and closing a workbook, adding a button to the Quick Access Toolbar, opening an existing worksheet, accessing Help in Excel
Lesson Two – Including: Formatting text, changing font type and size, using the mini toolbar, changing the font colour, selecting cells and ranges, aligning text horizontally, merging and splitting cells, formatting numbers, printing the active sheet, creating a folder, saving in a different format
Lesson Three – Including: Inserting and deleting rows, hiding and unhiding rows and columns, modifying column widths and cell heights, aligning cells vertically, wrapping and indenting text, adding colour to cells and ranges, applying borders to cells and ranges, moving and copy cells, undo and redo, cut, copy and paste, AutoFill
Lesson Four – Including: AutoComplete, text orientation, selecting non-adjacent data, freezing and unfreezing panes horizontally and vertically, using Zoom, page break preview, naming and renaming a worksheet, inserting a worksheet, repositioning worksheets, deleting a worksheet
Lesson Five – Including: Using styles to enhance a worksheet, creating a custom style, the Page Layout ribbon, using themes to enhance a worksheet, creating and deleting a custom theme, page orientation, adjusting margins and scaling, centring the sheet horizontally and vertically, print preview, displaying gridlines, printing row and column headings, setting and clearing a print area
Lesson Six – Including: Inserting headers and footers, copying and pasting data between worksheets, grouping and ungrouping worksheets, creating a new workbook, switching between workbooks, viewing multiple workbooks, hiding and unhiding a workbook, saving as a template, creating a workbook from a template, using existing templates and online resources
Lesson Seven – Including: More complex formulas, absolute as well as relative cell references, AutoCalculate, functions SUM, DATE/TIME, COUNT, IF, adding, viewing and editing comments
Lesson Eight – Including: AVERAGE, MAX and MIN functions, sort columns using ascending and descending order, the PMT and FV functions, entering formulas into grouped worksheets, recognising errors, using the IFERROR function, using 3D referencing to link worksheet data
Lesson Nine – Including: Inserting charts, changing chart type, formatting a plot area, formatting a data series, inserting and resizing a picture, applying picture effects, aligning multiple objects, inserting WordArt, inserting and modifying a drawing object, creating and modifying SmartArt
Lesson Ten – Including: Using Spell check, using Filter to display specific data, finding and replacing text within a worksheet, saving a workbook as a web page, publishing a web page, inserting and using hyperlinks, using conditional formatting
Duration: 24 Hours flexi study
Cost: Contact us for more details
Further Study: Pitman Training Office Certificate or Diploma Range of courses
News
2009-10-27 21:41 by Genesis
New Sage 50 2010 allows you to work faster, smarter and more efficiently and adhere to new VIES legislation.
Newsletter
Wexford Training Centre
Tel: 053 9122492
Email: Click to send
Carlow Training Centre
Tel: 059 9182415
Email: Click to send
Gorey Training Centre
Tel: 053 9481749
Email: Click to send
Kilkenny Training Centre
Tel: 056 7770425
Email: Click to send
Copyright Genesis Business College, All Rights Reserved
Genesis Management Services and Genesis Business College are trading names for GMS Genesis Management Services.
Registered in Ireland. Registration No: 336033