Microsoft Excel 2007 & 2010
Course Aim
The aim of this training course is to provide clients with the necessary skills required to produce reports using spreadsheets incorporating various calculations, professional formatting & graphical charts.
Client Profile
It is important that each client has previous experience and a basic working knowledge of Microsoft Excel or Lotus 123 Spreadsheets. Ideally each client would have access to a computer system where Microsoft Excel is available to maximum learning post training
Basic Working knowledge – Open Close Save files, understand the formatting menu i.e. Font, Font size, Text colour and importantly to be able to navigate within a spreadsheet.
Course Outline
Microsoft Excel 2000 / XP & 2003
• Intermediate MS Excel Commands Functions,
• Open & Close, Save & Print Files
• Font Type, Font Size, Bold Itialics, underline
• Font colour, Page Setup & Margins
• Columns & Rows
• Borders
• Editing Cells
• Headers & Footers
• Spreadsheet Layout
• Formulas, Addition & Subtraction
• Multiply & Division
• Percentage
• Sum, Average, Min & Max
• Worksheets
• Page Styles
• Graphs
• Templates
• Linking Sheets
• Embedded objects within Excel & Word
Course Location:
Killarney | Macroom | Cork City
Course Duration:
1 Full Day |