People wishing a basic to Intermediate use of MS Excel in an office environment.
- Maximum 8 attendees
- 30 days of one to one support
- 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
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.
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
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
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.