EDITC - Education & Information Technology Centre

Schedule

Training Course Schedule

Microsoft Excel Basic Level

Code:	ED17B10
Type:	IT InstructorLed Courses
Category:
Course:	Microsoft Excel Basic Level For Technical, Scientific and Supervisory Personnel

Date:	1 Nov 2017 08:15 - 16:00

Microsoft Excel is an essential application in today’s work environment. Microsoft Excel is a tool for the creation of spreadsheets and graphs, for performing calculations, data analysis and much more. . Microsoft Excel is useful for the company’s financial administration and monitoring and can also be useful in sales, expense monitoring , creation of lists, converting data into visuals (graphs) etc. This course is the first of a series of two courses and covers the basic features of the application.

Duration:	7 hours (1 day)
Location:	EDITC & MMC Conference Center, 16 Imvrou Street, 1055 Nicosia
Language:	Greek
Attendance:	4-12

Price:	€130.00

Subsidy:	€0.00

Total:	€130.00

Topics

Unit1: Introduction

How Excel can help you in every day work
Understanding the screen
Organizing the Ribbon
Understanding the Τabs και Groups, Dialog Launcher Buttons

Unit2: Working with Files

Workbooks and Sheets
Creating a new Workbooks
Creating a folders
Saving a Files
Opening and Closing a Files

Unit3: Working with Sheets

Inserting and Deleting Sheets
Naming Sheets
Moving and Copying Sheets

Unit4: The Fill Handle

Working with the Fil Handle
Exercise

Unit5: Creating a table

Data Entry—The various data tyoes
Using AutoSum
Copying a Formula
Exercise

Unit6: Columns and Rows

Inserting and Deleting rows and columns
Formatting rows and columns
Hiding/Unhiding rows and columns

Unit7: Creating Simple Formulae

Creating a Formula
Correcting a Formula
Absolute and Relative References
Exercise

Unit8: Functions

Using the Function Today
Using the Insert Function
The Functions Average, Count, CountA, Min and Max
Exercise

Unit9: Formatting

Automatic Formatting
Copying Formatting
Formatting Fonts
Formatting Numbers
Changing the Alignment
Borders and Shading
Removing Formatting
Exercise

Unit10: Inserting Graphics

Pictures
Shape
Using SmartArt
Inserting and Formatting Graphs

Unit11: Printing

Headers and Footers
Repeat Titles
The
Setting Paper Orientation and Margins
Printing

Who Should Attend
This course is for beginners wishing to gain the basic knowledge in Excel

Objectives

Upon completion the participants will be able to:

Create tables
Format tables
Insert and format columns and rows
Create simple formulae and functions
Insert Graphics and Graphs
Print

Prerequisites
Good knowledge of Windows

Methodology

The course is 100% practical. The topics are delivered with short presentations by the instructor followed by a step-by-step demonstration by the instructor and repetition by the students, examples and discussions on how a feature may be used with real life examples and practice through written exercises.

Equipment
The classrooms are equiped with computers (one for each student) projector, Internet access, whiteboard, flipchart and printing facilities.
Each student has a step by step book.

TimeTable
Wednesday, 1/11/2017 8:15 - 16:00