Microsoft Excel Basic Level For Technical, Scientific and Supervisory Personnel

Παρασκευή, 21 Φεβρουαρίου 2025, 08:15 - 14:45
Παρασκευή, 28 Φεβρουαρίου 2025, 08:15 - 14:45

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

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

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.