Target Audience

People wishing a basic to Intermediate use of MS Excel in an office environment.
Programme Standards

- Maximum 8 attendees
- 30 days of one to one support
- Handouts
- Programme director/s with at least a Masters Degree in the subject
- Convenient morning timings or in-house at any time for a minimum of two bookings
- Can be configured to address a number of professions and industry sectors

Price

EUR235 ex VAT per participant.

​Participants have to provide their own laptop.
MS Excel for the Office Workshop

This is a programme to get attendees up to speed in using MSExcel in an office environment, create spreadsheets, create non-logical formulii, format, print, work with charts and cross referencing links from various sheets.
Topics Covered

Familiarising Oneself with MSExcel interface
Run through the different aspects, menu functions of MSExcel for use in the modern office.

Output -Create an Employee/Contact List Database

Creating Mathematical Functions
Learn how to create, edit and compound mathematical formulii

Output - Create a TimeSheet for Internal Use

Cell Management
Learn how to manage Cells, import data from another source, export data, make cell comments and create absolute and relative cell references

Output - Create an Inventory Catalog of Company Assets

Formating Sheets
Learn how to format MSExcel sheets to look professional, consistent and logical

Output - Create a Branded 5 line Quotation Worksheet

Charts and Graphics
Learn how to do a Linear Chart from a set of imported data

Output - Create a Year-On-Year Sales Chart from Imported Data

Printing MSExcel Sheets
Learn how to print and save into PDF formats and print a range of data/reports using multiple A4 paper sheets with fixed headers and footers.

​Output - Create a PDF print out of an imported list of products.