Schedule

Training Course Schedule
Webinar - Microsoft Excel- Basic Level

Code: ED20A41
Type: IT InstructorLed Courses
Category: Microsoft Office 2013, Microsoft Office 2016/365
Course: Microsoft Excel- Basic Level
Date: 6 Jul 2020 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.


Duration: 7 hours (1 day)
Location: Webinar
Language: Greek
Attendance: 4-20
Speaker: Maria Knais
 

Price: €145.00
Subsidy: €0.00
Total: €145.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: Printing

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

Unit11: Inserting Graphics (If time permits)

  • Pictures
  • Shape
  • Using SmartArt
  • Inserting and Formatting Graphs


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.



TimeTable
Monday, 06/07/2020, 08:15 - 16:00


Find Training Programmes
Name
Type
v
Category
v
Period
v
-
v
 

© EDUCATION & INFORMATION TECHNOLOGY CENTRE (EDITC). All Rights Reserved. Developed by CMP POLYMEDIA LTD