Prices are on sale. Training isn’t.
Black Friday
Don't miss
✂
3 modules 50% OFF
2 modules 40% OFF
1 module 30% OFF
✂
www.test4u.eu
Γνωρίζετε τις 38 πιο σημαντικές συναρτήσεις στο 𝗘𝘅𝗰𝗲𝗹;
Παρακολουθήστε το βίντεο για να μάθετε πώς να τις χρησιμοποιείτε για να κάνετε την ζωή και την δουλειά σας πιο εύκολη!
Ενδιαφέρεστε για πιστοποιητικό πληροφορικής (π.χ. για 𝗘𝗖𝗗𝗟, κάποιο πιστοποιητικό Αναγνωρισμένο από το Ελληνικό Δημόσιο); Τότε σίγουρα πρέπει να τις μάθετε!
Βασικές Συναρτήσεις
00:00:00 Εισαγωγικά και συνάρτηση 𝗦𝗨𝗠
00:05:12 Συναρτήσεις: 𝗔𝗩𝗘𝗥𝗔𝗚𝗘 (μέσος όρος), 𝗠𝗔𝗫 και 𝗠𝗜𝗡 (μέγιστη και ελάχιστη τιμή)
00:10:13 Συναρτήσεις 𝗖𝗢𝗨𝗡𝗧 και 𝗖𝗢𝗨𝗡𝗧𝗔 (καταμέτρησης)
00:12:39 Συνάρτηση 𝗖𝗢𝗨𝗡𝗧𝗕𝗟𝗔𝗡𝗞
00:13:47 Συνάρτηση 𝗜𝗙
Συναρτήσεις Ημερομηνίας και Ώρας
00:21:24 Συνάρτηση 𝗧𝗢𝗗𝗔𝗬
00:22:41 Συναρτήσεις 𝗗𝗔𝗬, 𝗠𝗢𝗡𝗧𝗛, 𝗬𝗘𝗔𝗥
Μαθηματικές Συναρτήσεις
00:26:43 Συνάρτηση 𝗦𝗨𝗠𝗜𝗙
00:30:06 Συνάρτηση 𝗥𝗢𝗨𝗡𝗗
00:34:42 Συνάρτηση 𝗥𝗢𝗨𝗡𝗗𝗨𝗣
00:36:12 Συνάρτηση 𝗥𝗢𝗨𝗡𝗗𝗗𝗢𝗪𝗡
Συναρτήσεις Στατιστικής
00:37:34 Συνάρτηση 𝗖𝗢𝗨𝗡𝗧𝗜𝗙
Συναρτήσεις Κειμένου
00:39:45 Συνάρτηση 𝗨𝗣𝗣𝗘𝗥
00:41:14 Συνάρτηση 𝗟𝗢𝗪𝗘𝗥
00:42:29 Συνάρτηση 𝗣𝗥𝗢𝗣𝗘𝗥
00:43:40 Συνάρτηση 𝗖𝗢𝗡𝗖𝗔𝗧𝗘𝗡𝗔𝗧𝗘 (𝗖𝗢𝗡𝗖𝗔𝗧)
00:45:12 Συνάρτηση 𝗟𝗘𝗙𝗧
00:46:39 Συνάρτηση 𝗥𝗜𝗚𝗛𝗧
00:48:04 Συνάρτηση 𝗠𝗜𝗗
Οικονομικές Συναρτήσεις
00:49:51 Συνάρτηση 𝗣𝗠𝗧
00:54:33 Συνάρτηση 𝗣𝗩
00:58:03 Συνάρτηση 𝗡𝗣𝗩
01:05:46 Συνάρτηση 𝗙𝗩
01:07:56 Συνάρτηση 𝗥𝗔𝗧𝗘
Συναρτήσεις Αναζήτησης και Αναφοράς
01:10:24 Συνάρτηση 𝗩𝗟𝗢𝗢𝗞𝗨𝗣
01:14:44 Συνάρτηση 𝗛𝗟𝗢𝗢𝗞𝗨𝗣
Συναρτήσεις Βάσεως Δεδομένων
01:18:43 Συνάρτηση 𝗗𝗦𝗨𝗠
01:21:54 Συνάρτηση 𝗗𝗖𝗢𝗨𝗡𝗧
01:24:28 Συναρτήσεις 𝗗𝗠𝗜𝗡, 𝗗𝗠𝗔𝗫
Λογικές Συναρτήσεις
01:31:02 Συνάρτηση 𝗔𝗡𝗗
01:35:42 Συνάρτηση 𝗢𝗥
01:40:07 Συνάρτηση 𝗜𝗦𝗘𝗥𝗥𝗢𝗥
#TEST4U #Excel #exceltips #exceltutorial #exceltricks #Πιστοποίηση
#ECDL #συναρτήσεις
A new 🎬 YouTube series for Excel is born:
📊 𝗘𝘅𝗰𝗲𝗹 𝗳𝗿𝗼𝗺 𝟬 𝘁𝗼 𝟭.𝟬𝟰𝟴.𝟱𝟳𝟲
Wait…what is that number?
Well, 1.048.576 is the number of rows that a standard Excel worksheet contains in its newer versions. We have used it on the title to indicate our goal: That’s where we promise to take you. All the way from start to becoming a powerful Excel user 💪 .
💻 Watch all the episodes here: www.youtube.com/playlist?list...
👉 In case you are not a subscriber, click here: youtube.com/@TEST4U-eu?sub_confirmation=1
Are you a project manager who wants to make your life easier?
Then you need to check out our YouTube channel, where we have a series of tutorials on Microsoft Project.
You will learn how to:
• Customize the interface to suit your preferences
• Create and view your projects in different ways
• Use calendars, tasks, and resources effectively
• Track the progress and performance of your projects
• And many more
All the parts of this series are already available on our channel.
www.youtube.com/playlist?list...
10 000 subscribers!!!
Our YouTube channel is growing!
Many thanks to our 10.000 subscribers!
Stay tuned for many more videos to come!
.-.-.-.-.-.-.-.-
Το κανάλι μας στο YouTube διαρκώς μεγαλώνει!
Ευχαριστούμε πολύ τους 10.000 συνδρομητές μας!
Μείνετε μαζί μας για πολλά περισσότερα νέα βίντεο!
.-.-.-.-.-.-.-.-.-
¡Nuestro canal de YouTube está creciendo!
¡Muchas gracias a nuestros 10.000 suscriptores!
¡Estén atentos porque vendrán muchos más videos!
Ο διαγωνισμός του TEST4U ολοκληρώθηκε.
Σας ευχαριστούμε όλους για την συμμετοχή σας!
Ο τυχερός νικητής που αναδείχτηκε έπειτα από την κλήρωση του WinThisGift και κερδίζει μια δωροεπιταγή των €100 από την Amazon είναι ο Zygakis George
Συγχαρητήρια Γιώργο!
Παρακαλούμε επικοινώνησε μαζί μας για τις λεπτομέρειες παραλαβής της δωροεπιταγής σου.
TEST4U has just turned 17 years old!
We are celebrating the TEST4U 17th Birthday by giving you 10 free hours of practice for the module of your choice!
1. Subscribe to the TEST4U channel youtube.com/user/test4ueu?sub_confirmation=1 and
2. Comment below the video https://www.youtube.com/watch?v=U-jfT... to let us know your TEST4U username and the module you want training time for.
We will then assign your TEST4U account with the free hours.
This offer refers to our existing End-User customers only (with either active or inactive TEST4U subscription). The offer ends on March 6th 2021, 12:00 PM (GMT). The free training will be available for the next two months.
For NEW End-User customers who complete their purchase by March 6th 2021, 12:00 PM (GMT), we provide 50% discount. Use the coupon code: TEST4U-17-YEARS during your checkout at www.test4u.eu.
All National Champions get unlimited free training on #TEST4U.
Every School which will participate in the National Championship gets free training for the Candidates.
TEST4U has helped over 700 000 Candidates since 2003
www.facebook.com/groups/MOSWC...is a facebook group supported by TEST4U, the ultimate Preparation Guide for MOS Certiport Exams.
We are celebrating the use of TEST4U in Austrian Schools and giving away 1 hour of TEST4U practice to every subscriber.
Just contact us www.test4u.eu/contactus by 30 November 2018.
The Austrian Federal Ministry of Education, Science and Research has commissioned the Greek Company infolearn and the TEST4U software the evaluation and assessment of pupils at the software LibreOffice and the Operating System Windows, under digi.check.8.
TEST4U www.test4u.eu, the Greek IT skill assessment platform will be used by students in Austria to assess their skills in the suite of Free Software / Open Source Software LibreOffice (Writer, Calc, Impress applications), and the Operating System Windows.
The Austrians in charge of the project approached infolearn for the development of an exclusive automated testing version of TEST4U, the only software in the world that uses in-application technology for the objective assessment of students. The use of the automated evaluation platform for the LibreOffice suite began in the academic year 2018-2019 and is expected to be used by 20% of Austrian schools (around 60,000 students per year).
The project was delivered ahead of the deadline, despite the short time that infolearn had in order to complete the development and the scrutiny of the implementation and customization of the platform.
Besides the evaluation of students, the TEST4U assessment platform offers comprehensive information on the performance of students, through analytical and statistical data, both at total level and per module.
Last but not least important, it is worth noting that students gain access from wherever they want to, as the use of the assessment platform is not limited to school area.
A few words about TEST4U
TEST4U is used by companies for the evaluation of candidates or existing employees, by those interested in improving their skills or acquiring new ones and by those interested in obtaining a Recognized IT Certificate. Its first version was released in 2003. Since then, it counts more than 700,000 satisfied users. It covers more than 19 applications and is currently available in 5 languages.
Related Resources:
The official website of the project: digicheck.at/index.php?id=562&L=0
The official TEST4U website: www.test4u.eu/
Welcome to the 𝗟𝗘𝗔𝗥𝗡 𝗜𝗧 𝗶𝗻 𝟯𝟬 𝘀𝗲𝗰𝗼𝗻𝗱𝘀 𝗯𝘆 𝗧𝗘𝗦𝗧𝟰𝗨 YouTube channel!
This channel is designed to improve your productivity and enhance your learning skills.
Brief how-to videos, tips and tricks for Excel, Word, Outlook, Access, PowerPoint, OpenOffice, LibreOffice, AutoCAD etc., in 6 languages English, Greek, Spanish, German, Italian, Russian and various levels. No blah-blah included!
The answer you are looking for is right here... in under 30”
* Quick
* Categorized
* Right to the point
* For different software versions
A TEST4U initiative
TEST4U is a self-training and learning platform, with an impressive number of 40.000+ videos incorporated. Use these videos to gain new skills, became computer literate or prepare for a job assessment.
TEST4U:
1. Assesses your skills on the use of 20+ applications.
2. Prepares you for a successful participation in certification examinations. [MOS Microsoft Office Specialist - Certiport, DIPLOMA, ECDL/ICDL, e.tc.].
3. Assesses your personnel.