Spreadsheets

Lesson 2:
• Modifying a Worksheet
• Manipulate Data
• Insert, Manipulate, and Delete Cells, Columns, and Rows
• Search for and Replace Data
• Spell Check a Worksheet

Lesson 3:
• Formatting a Worksheet
• Modify Fonts
• Add Borders and Colour to Cells
• Apply Number Formats
• Align Cell Contents
• Apply Cell Styles

Lesson 4: Printing Workbook Contents
• Define the Basic Page Layout for a Workbook
• Refine the Page Layout and Apply Print Options

Lesson 5:
• Managing Large Workbooks
• Format Worksheet Tabs
• Manage Worksheets
• Manage the View of Worksheets and Workbooks

Lesson 6:
• Organising Worksheet Data with Tables
• Create and Modify Tables
• Sort and Filter Data
• Use Summary and Database Functions to Calculate Data

Lesson 7:
• Visualising Data with Charts
• Create Charts
• Modify and Format Charts
• Create a Trendline
• Create Advanced Charts

Module 2
File Management – learning to use the computer and manage files and folders.

Module 3
Word Processing – creating, editing and printing documents using Microsoft Word

Module 4
Spreadsheets – use Microsoft Excel to generate worksheets and graphs.

Module 5
Databases – gather, analyse and extract data using Microsoft Access.

Module 6
Presentations – create meaningful, professional presentations using Microsoft PowerPoint.

Module 7
Information & Communications – surf the web and send email using Microsoft Internet Explorer and Outlook.

All participants will have detailed notes and sample exams for each module. These will be supplied in pdf format on CD at the start of the course.

A typical schedule would look like this:
Day 1 – Module 1 course
Day 2 – Module 1 exam – Module 2 course
Day 3 – Module 2 exam – Module 3 course
Day 4 – Module 3 exam – Module 4 course
Day 5 – Module 4 exam – Module 5 course
Day 6 – Module 5 exam – Module 6 course
Day 7 – Module 6 exam – Module 7 course
Day 8 – Module 7 exam – Repeat exams if required

Lesson 2: Collaborating with Others
• Password Protect Files
• Share a Workbook
• Set Revision Tracking and Review Tracked Revisions
• Merge Workbooks

Lesson 3: Auditing Worksheets
• Trace Cell Precedents and Dependents
• Locate Errors in Formulas
• Locate Invalid Data and Formulas
• Watch and Evaluate Formulas

Lesson 4: Analysing Data
• Create Scenarios
• Perform What-If Analysis – Goal Seek, Solver, Data Tables
• Develop a PivotTable and PivotChart Reports

Lesson 5: Working with Multiple Workbooks
• Consolidate Data
• Link Cells in Different Worksheets and Workbooks
• Edit Links

Lesson 6: Importing and Exporting Data
• Export to Microsoft Word and PowerPoint
• Import a Word Table
• Import Text, HTML, CSV Files

18th June - Clonmel
14th June - Cashel