Excel for beginngers and andvanced users
From 24.93 $ /h
Excel Basics
At the beginner level, participants get familiar with the Excel interface, managing workbooks and worksheets, as well as the fundamentals of data entry and formatting. They learn how to perform calculations in cells, use basic functions (SUM, AVERAGE, MIN, MAX), and understand the difference between relative and absolute references. In addition, they practice sorting and filtering data, creating simple charts, and adjusting print and PDF export settings.
Excel Advanced
At the advanced level, the focus is on more complex functions (IF, VLOOKUP, INDEX+MATCH, date and text functions), as well as structured tables, conditional formatting, and data validation. Participants learn how to create and customize pivot tables and pivot charts, explore advanced visualization tools, and use macros for basic automation. The training also covers importing and cleaning data, an introduction to Power Query, and is complemented with tips, shortcuts, and named ranges to make work not only more accurate but also more efficient.
At the beginner level, participants get familiar with the Excel interface, managing workbooks and worksheets, as well as the fundamentals of data entry and formatting. They learn how to perform calculations in cells, use basic functions (SUM, AVERAGE, MIN, MAX), and understand the difference between relative and absolute references. In addition, they practice sorting and filtering data, creating simple charts, and adjusting print and PDF export settings.
Excel Advanced
At the advanced level, the focus is on more complex functions (IF, VLOOKUP, INDEX+MATCH, date and text functions), as well as structured tables, conditional formatting, and data validation. Participants learn how to create and customize pivot tables and pivot charts, explore advanced visualization tools, and use macros for basic automation. The training also covers importing and cleaning data, an introduction to Power Query, and is complemented with tips, shortcuts, and named ranges to make work not only more accurate but also more efficient.
Location
Online from Hungary
About Me
I can show you, Excel can be your friend.
I have been using Excel on a daily basis for years. At first, I delved into it to make my work easier, and later it became second nature. I am happy to help anyone who wants to expand their Excel knowledge
Évek óta napi szinten használom az excelt HR kontroller és kompnezációs szekmberként, eleinte a munkám megkönnyítése érdekében mélyedtem el benne, később már egész egyszerűen ment. Szívesen segítek bárkinek az excel ismeretek bővítésében.
I have been using Excel on a daily basis for years. At first, I delved into it to make my work easier, and later it became second nature. I am happy to help anyone who wants to expand their Excel knowledge
Évek óta napi szinten használom az excelt HR kontroller és kompnezációs szekmberként, eleinte a munkám megkönnyítése érdekében mélyedtem el benne, később már egész egyszerűen ment. Szívesen segítek bárkinek az excel ismeretek bővítésében.
Education
Human Resurces Management MSC, Babes Bolyai University
Laba Excel courses, SQL course
Humán erőforrás mendzsment MSC diploma
Laba excel kurzusok, SQL képzések
Laba Excel courses, SQL course
Humán erőforrás mendzsment MSC diploma
Laba excel kurzusok, SQL képzések
Experience / Qualifications
Several years of experience in the HR field, both at expert and managerial levels
HR területén több éves tapasztalat szakértői és vezetői szinten egyaránt.
HR területén több éves tapasztalat szakértői és vezetői szinten egyaránt.
Age
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Intermediate
Advanced
Duration
30 minutes
45 minutes
60 minutes
The class is taught in
English
Hungarian
Skills
Availability of a typical week
(GMT -05:00)
New York
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Good-fit Instructor Guarantee