Excel for beginngers and andvanced users

من 91.46 AED /س

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.

المكان

عبر الانترنت من المجر

من أنا؟

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.

المستوى التعليمي

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

الخبرة / المؤهلات

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.

السن

شباب (13-17 سنة)

الكبار (18-64 سنة)

الكبار (65 سنة فأكثر)

مستوى الطالب

مبتدئ

متوسط

متقدم

المدة

30 دقيقة

45 دقيقة

60 دقيقة

الدرس يدور باللغة

الإنجليزية

المجرية

مهارات

مايكروسوفت إكسل

Visual basic

الجاهزية في الأسبوع العادي

(GMT -05:00)

نيويورك

على الانترنت عبر كاميرا ويب

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Anas

4.75

(12)

>>> What is Excel?
Microsoft Excel is a spreadsheet that allows you to do calculations, analyze data with formulas, tables and graphs.

>>> What about pedagogy?
I favor the learning by doing method

>>> Who am I?
For information, I am consultant / trainer and certified Microsoft Excel Expert.
I have considerable experience in training. Indeed, I have trained hundreds of people whether in groups, or in private.

>>> Location of the training?
The place is to be agreed with the apprentice.
Training can also be organized remotely (Teams, Zoom, Google Meet, Skype...)

>>> Content of the training
I can adapt to your level and your needs in terms of content.
Here is a non-exhaustive example of the subjects taught.

**** Excel Training (Beginner and Intermediate) ****

Part I: Basic Concepts
What is Excel?
Discover the Excel window.
Workbooks, spreadsheets, cells.
Use the toolbars, the menu, the help.

Part II: Working in a spreadsheet
Identify basic concepts
Manage cells: capture and copy
Set up formulas.
Master the modes of referencing cells: absolute, relative.
Insert, delete rows or columns, move fields.

Part III: Formatting a spreadsheet
Format cells: present numbers, text, titles.
Define conditional formatting.
Print the entire sheet or part.
Build the layout: titles, pagination

Part IV: Workbook Management
Save, edit a workbook.
Divide your data over several sheets.
Insert, delete, move, copy a sheet.
Edit multiple sheets simultaneously

Part V: Data Analysis Using Functions
Calculate percentages, establish ratios.
Perform statistics: AVERAGE, MAX, MIN
Apply conditions: SI.
Use functions: NOW, TODAY.
Consolidate multiple sheets of a workbook with the SUM function.

Part VI: Linking spreadsheets
Transfer data from one table to another
Copy / paste with link.
Create summary tables.

Part VII: Illustrate with graphics
Create a chart from a table
Change the type: histogram, curve, sector.
Add or delete a series.

**** Excel Training (Advanced) ****

Part I: Configure Excel Options
Set up Excel options.
Customize the interface.

Part II: Gaining time to present his paintings
Define styles, use themes.
Define conditional formats.
Insert Sparklines charts.

Part III: Creating simple and complex calculation formulas
Master the various modes of referencing: relative, absolute, mixed.
Name cells.
Set up simple and complex conditions: IF, OR, AND.
Calculate statistics: NBVAL, NB, NB.SI.
Use mathematical functions: Sum and SUM.
Retrieve data with search functions: VLOOKUP
Calculate dates, times: DATE(), DAY() and MONTH() ...
Manipulate text: CAPITAL, MINISCULE and CONCATENATE.
Protect formulas, sheets or binders.

Part IV: Consolidation of data
Link multiple cells in a workbook.
Manage connections between workbooks.
Consolidate tables in a workbook.
Consolidate data from multiple workbooks.

Part V: Exploiting Data Lists
Tris multicriteria.
Custom sorting: Numeric, Textual and Chronological.
Extract data: advanced filters.
Delete duplicates.

Part VI: Implementing Pivot Tables / Charts
Create charts / pivot tables
Group the information by period and by slice.
Filter and sort
Segment filters
Show / hide data.
Add ratios and percentages.

Hajar

4.75

(12)

Throughout my engineering student studies, I worked on multiple projects which require mastery of office automation tools ("Word", "Excel", "PowerPoint", ...). I would therefore like to share my knowledge with you, whether you are a student or not, in order to introduce you to office automation, to train you, and to guide you in your projects.

Salah

4.75

(12)

Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level!

If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office.

Why Choose Microsoft Office?

Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations.

Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features.

Available Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want.

Join the Microsoft Office Revolution!

Don't let daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential.

Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.

Amine

4.75

(12)

Course description: Introduction to Office Tools 💼📊📎

This introductory office tools course is designed to provide participants with a solid foundation in the effective use of commonly used business software, such as Microsoft Word, Excel and PowerPoint, as well as other essential applications such as e -emails. 🖥️📧

Graduate teacher in Information Systems and Service Science (Bachelor) and holder of a Bachelor's degree in Computer Networks, as well as an M1 in Digital Systems and Services, I am passionate about teaching essential digital skills to succeed in the modern professional world. 🎓💻

This course covers the basics of creating professional documents, managing data, and designing visually appealing presentations, while emphasizing effective communication via email. By the end of the course, participants will have acquired the skills to use these tools confidently and effectively, improving their productivity and employability. 🚀📈

Kamal

4.75

(12)

The purpose of this session is to allow the learner to understand the usefulness of Excel, to understand its principle and how it can be used at the school and professional level. It is also about Excel formulas, application exercise.
contact me

Yasser

4.75

(12)

Are you ready to embark on a journey to fluency? Our online French classes are designed for learners of all levels, from beginners to advanced speakers. With engaging lessons, experienced instructors, and interactive resources, you’ll build the skills you need to communicate effectively in French.

Join a supportive community where you can practice speaking, listening, reading, and writing in a fun and dynamic environment. Whether you’re preparing for travel, work, or personal enrichment, our classes will empower you to express yourself with ease and confidence.

Don’t let language barriers hold you back. Sign up today and take the first step toward speaking French fluently!

Morad

4.75

(12)

You want to boost your Excel skills and unlock the full power of spreadsheets? Our online Excel classes are designed for everyone, from beginners to advanced users. Learn how to organize data, create powerful formulas, generate charts, and streamline your workflow with ease.

Led by expert instructors, our interactive lessons offer hands-on practice, covering everything from basic functions to advanced Excel techniques. Whether you're looking to improve your job performance, manage data more efficiently, or learn new skills, our flexible online classes allow you to learn at your own pace, from anywhere.

Take control of your data—sign up for our online Excel classes today and become an Excel pro!

Amar

4.75

(12)

Unlock the beauty of the Arabic language from the comfort of your home. With personalized lessons tailored to your pace and schedule, you'll gain confidence and fluency in no time.

🌟 What You’ll Get:
✅ Engaging, interactive lessons
✅ A supportive, experienced instructor
✅ Flexible timings to fit your lifestyle
✅ Customized resources for faster learning

Whether you're starting from scratch or polishing your skills, this is your chance to achieve your goals. Don't wait—take the first step toward fluency today!"

Rayah

4.75

(12)

Master Microsoft Word, Excel and Power Point with Personalized Online Private Lessons!
Boost your confidence with one-on-one Microsoft Word, Excel and Power Point classes tailored to your level and goals. Whether you're a beginner or advanced, our flexible online sessions fit your schedule and focus on what you need today from the comfort of your home!

Farass

4.75

(12)

Online Private Classes in Excel for Beginners

Master Excel from the comfort of your home with personalized, one-on-one training!

Why Choose Our Excel Classes?
✅ Tailored for Beginners – No prior experience needed!
✅ Flexible Scheduling – Learn at your own pace.
✅ Hands-On Training – Practical exercises & real-world examples.
✅ Certification – Get a completion certificate to boost your resume.

What You’ll Learn:
📊 Basic spreadsheet navigation & formatting
🔢 Essential formulas & functions (SUM, AVERAGE, IF, VLOOKUP)
📈 Creating charts & graphs
📑 Data sorting, filtering & basic analysis
💡 Time-saving tips & tricks

How It Works:
1️⃣ Book a Session – Choose a convenient time.
2️⃣ 1-on-1 Live Training – Interactive lessons via Zoom/Teams.
3️⃣ Practice & Improve – Get assignments & expert feedback.

Who Should Join?
🔹 Students 🔹 Professionals 🔹 Job Seekers 🔹 Small Business Owners

📩 Enroll Now! Limited slots available.

Yassin

4.75

(12)

Master Word, Excel & PowerPoint with Private Online Classes!
Boost your productivity and skills with one-on-one sessions tailored to your level and goals. Learn at your own pace—from beginner to advanced. Perfect for students, professionals, and job seekers!

✅ Personalized Lessons
✅ Flexible Scheduling
✅ Real Projects & Practical Skills

Book your class today and start mastering Microsoft Office!

Fatima

4.75

(12)

Master Microsoft Office, the essential tools of the professional world!

Do you want to gain efficiency and confidence with Excel, Word, and PowerPoint? Whether you're a beginner or already familiar with the basics, my customized course will guide you step by step to become independent and efficient.

What you will learn:
Excel: from data entry and formatting to advanced formulas, pivot tables, etc.

Word: Professional document creation, styles, table of contents, mail merge, and advanced layout.

PowerPoint: Design impactful presentations, animations, and visual storytelling techniques.

Why choose this course?
✔️ Adapted progression: from total beginner to advanced user, everyone progresses at their own pace.
✔️ Practical and personalized approach: concrete exercises linked to your personal or professional projects.
✔️ Flexible: online courses, individual
✔️ Complete educational support: documents, tips and personalized follow-up between sessions.
✔️ Certified expertise: experienced trainer with an engineering background and several years of professional training

Youssef

4.75

(12)

Master Microsoft Office with Expert Online Private Classes! 🔹

Boost your skills with one-on-one training in:

📝 Microsoft Word – Professional document formatting, tables, mail merge, reports, and more.
📊 Microsoft Excel – Formulas, functions, pivot tables, charts, data analysis, and macros.
🎨 Microsoft PowerPoint – Stunning presentations, animations, slide design, and storytelling.

Why Choose Our Classes?
✔ Personalized Lessons – Tailored to your skill level & goals.
✔ Flexible Scheduling – Learn at your own pace, anytime.
✔ Practical Training – Real-world exercises & tips.
✔ Certified Instructors – Experienced & patient teachers.

Hamed

4.75

(12)

Online Private Classes: Microsoft Word, Excel & PowerPoint
Unlock your productivity potential with personalized one-on-one training!

📘 Microsoft Word: Master document formatting, reports, and professional layouts.

📊 Microsoft Excel: Learn formulas, charts, and data analysis with ease.

🎤 Microsoft PowerPoint: Create impactful presentations that impress every audience.

👩‍🏫 Private & Flexible: Classes tailored to your level, schedule, and goals. 🌍 Online Access: Learn from anywhere, at your own pace. 🎯 Practical Skills: Focus on real-world applications for work, study, or personal projects.

👉 Start today and gain the confidence to use Microsoft Office like a pro!

Achref

4.75

(12)

Master Microsoft Word, Excel, and PowerPoint through personalized online private classes designed to meet your unique goals and skill level. Whether you're just starting out or aiming to refine advanced techniques, these sessions are tailored to help you succeed.

What You Will Explore:

Word: Develop professional-quality documents, reports, and resumes using advanced formatting, styles, tables, and mail merge tools.
Excel: Craft dynamic spreadsheets, leverage formulas and functions, create compelling charts, and perform data analysis with confidence.
PowerPoint: Design visually captivating presentations featuring animations, seamless transitions, and impactful visual elements.