Kezdőlap Excel és MS Office Excel felhasználói szint Excel basics and intermediate / advanced level (in English)
Excel basics and intermediate / advanced level (in English)
ISMERTETŐ
Sämling provides high quality trainings and workshops for more than 30 years. And also trainings in Hungarian for many aspects of using Excel. Starting with 2020 Excel trainings will be also provided in English.
 
The one day Excel course is structured as an introduction to Excel for the beginner users covering some intermediate topics as well.
 
 
In this course, you will learn: 
  • How to be a better, faster, stronger Excel user
  • How to save yourself hours of time and boost your productivity in Excel
  • How to navigate the Excel interface
  • How to use math, statistical, logic and text functions
  • How to find a value with VLOOKUP
  • How to sort and filter your data to find exactly what you are looking for
  • How to use data validation to restrict data entry
  • How to customize your page setup options for printing
  • How to impress your boss and colleagues with your super sharp Excel skills
Excel is the most used spreadsheet software across the globe, and is considered essential in many industries like administration, accounting, construction, real estate, sales and marketing to name a few.
 
Attend our Excel basics training and take the FIRST-STEP in becoming a proficient user of Excel.
 
First CLASSROOM TRAINING in English:
 
The course is compatible with Office 365 and Excel for Windows 2019, 2016, 2013, 2010.
 
Whether you are just learning how to create spreadsheets or need to perform advanced data analysis with functions, formulas, this course will help you unlock the maximum potential of this popular data-analysis program.
 
We are also happy to support your team in developing their Excel knowledge. Feel free to contact our training organizer for more information about INHOUSE TRAININGS.
 
Our professional training courses can be customized, expanded, or combined with other courses according to the company’s needs and goals. Our trainers have also developed personalized concepts and tasks. Moreover, during the workshops, they are available as personal consultants, too. 
Kinek ajánljuk
Whether you are just learning how to create spreadsheets or need to perform advanced data analysis with functions, formulas, this course will help you unlock the maximum potential of this popular data-analysis program.
Bizonyítvány
Certificate of Attendance. On completion of the workshop we will provide for the participants a “Certificate of Attendance” confirming their participation and the duration of the training session.
CÉL, KOMPETENCIA, EREDMÉNY
In this course, you will learn how to be a better, faster, stronger Excel user. A great opportunity to get the fundamentals of Excel.
Tematika
Series
Solutions for COPY and PASTE
Relative and absolute cell referencing
Data types
How to insert a function (Type in and Insert function icon)
Statistical functions (SUM, AVERAGE, MIN, MAX and COUNT, SUMIF, AVERAGE IF, COUNTIF)
Date functions (TODAY, NETWORKDAYS, EDATE, EOMONTH)
Logical functions (IF, IF with AND, OR)
Text functions
Lookup and reference functions (VLOOKUP, HLOOKUP)
Name manager
Format Table
Text to columns
Remove duplicates
Data validation
Group and Ungroup
Keyboard shortcuts, several tips and tricks
Recommendation - Links, websites to improve your Excel knowledge
Időbeosztás:
16 tanóra, 9:00-12:20-ig
Részvételi díj:
1 55080 Ft
(+27% ÁFA)
69952 Ft		 Élő online képzés díja, mely tartalmazza a 15% egységes kedvezményt, továbbá az elektronikus segédanyagot, az elektronikus tudásszintfelmérő kitöltését és igény szerint a tanúsítványt. További kedvezmény nem vehető igénybe.
2 64800 Ft
(+27% ÁFA)
82296 Ft		 Tantermi képzés: tartalmazza a nyomtatott és elektronikus segédanyagot, az elektronikus tudásszintfelmérő kitöltését, igény szerint a magyar nyelvű tanúsítványt, valamint a reggeli bekészítést (kávé, tea, üdítő, édes és sós sütemény). A díj bruttó 1500 Ft/fő/nap étkezést tartalmaz.
Legkedvezőbb ár: Best price with 15% discount: 29.665FT+VAT (37.675 FT)
Kedvezmények:
A kedvezmények nem összevonhatóak, minden esetben az Önnek járó legmagasabbat vesszük figyelembe!
 8% Hírlevélre történő feliratkozás esetén
 12% 2 együttes jelentkezés - 2 fő vagy 2 különböző képzésre történő együttes jelentkezés esetén
 15% 3 vagy több modul megrendelése esetén
Kihelyezett vállalati képzés
We are happy to support your team in developing their Excel knowledge. Feel free to contact our training organizer for more information.