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 three courses and covers the basic features of the application.

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

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: 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

Τρίτη, 23 Απριλίου 2024, 08:15 – 14:45
Πέμπτη, 25 Απριλίου 2024, 08:15 – 14:45

Κόστος:
€355

Επιχορήγηση:
€240

Τελικό Κόστος:
€115