Excel for beginngers and andvanced users

From 37.63 C$ /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.

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.

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

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.

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

Microsoft excel

Visual basic

Availability of a typical week

(GMT -04:00)

New York

Online via webcam

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.

Matías

4.75

(12)

Are you looking for efficiency, creativity and productivity in your daily tasks? Do not look any further. Microsoft Office is there to meet all your expectations.

Why choose Microsoft Office?

Create with Power: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether it's for a professional document, a financial dashboard or a stunning presentation.

Collaborate with ease: OneDrive and Teams allow you to collaborate with your colleagues or friends, no matter where you are. Work together in real time, share files and communicate easily.

Save Time with Automation: Excel simplifies complex tasks with smart formulas, while Outlook organizes your emails and calendar so you can focus on what matters.

Advanced Security: Protect your data and privacy with advanced security features, such as two-step verification and access management.

Advanced Programming: As a specialist, I master programming in VBA (Visual Basic for Applications) to automate your tasks and personalize your Office applications. Additionally, in the latest version of Microsoft Office you also have the option to program in Python, a language that I also master.

Available Everywhere: 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 everyday challenges slow you down. Invest in the power of Microsoft Office and unlock your potential.

Transform the way you work, create with ease, and reach new heights with Microsoft Office.

Ilias

4.75

(12)

Whether you are asked to create a spreadsheet for maths or science assessments, a database of pupils, or an engaging presentation for a school project, Microsoft Office is usually your choice. The more you know about advanced capabilities of Office programs the more impressive your work can be.

This course includes one or more of the following modules:
- Documents with Word
- Spreadsheets with Excel
- E-mail with Outlook
- Communication with Teams
- Presentations with PowerPoint

- Databases with Access

If learners are advanced or not interested in any of the above modules, I could happily exclude those modules from the course.

Yanis

4.75

(12)

Repeater for over 8 years, my students are only improving their grades.

Satisfied or refunded!

Always save time for the student to bring exercises, theories, homework, failed tests and corrections ...
I am patient, used, cool, flexible and honest.

See you soon!

Amin

4.75

(12)

Microsoft Office skills are expected in almost every professional environment — yet most people have never been properly taught how to use these tools efficiently.
This course covers Word, Excel, and PowerPoint at whatever level you need, from basic document formatting to advanced Excel functions and automation.
Excel (most popular):

Formulas and functions (VLOOKUP, INDEX/MATCH, IF, SUMIFS, and more)
PivotTables and data analysis
Charts and professional dashboards
Macros and VBA automation — eliminate repetitive tasks entirely

Word: Professional document formatting, styles, tables, mail merge
PowerPoint: Clean, professional presentation design and structure
This is a hands-on course — we work directly on your files and your real-world tasks, not generic exercises. You'll leave each session knowing exactly how to apply what you learned to your actual work.
Ideal for students, job seekers, administrative professionals, and anyone who wants to stop wasting time on manual work.

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. 🚀📈

Yassine

4.75

(12)

Unlock Your Microsoft Office Potential! Private online classes available in Microsoft Word, Excel, and PowerPoint. Struggling with Microsoft Office? Get personalized help with private online classes in Word, Excel, and PowerPoint. Boost your productivity, create professional documents, analyze data effectively, and design engaging presentations. Learn from the comfort of your home! Inquire today.

Brent

4.75

(12)

Stuck in Excel? Want to finally understand how those formulas really work? Do you need to create a pie chart of your expense report for work or school, but feel completely lost? Don’t worry! I’m here to help... at your pace, with no jargon or complicated explanations.

Whether you:
- are starting completely from scratch,
- already have some basic knowledge,
- or want to solve a specific problem,
we’ll tailor the session to your needs. No one-size-fits-all course, just practical help that actually works for you.

👨‍🏫 About me
I’ve been using Excel since I was a teenager — for personal use (like budgeting tools or calorie trackers) and professionally as part of my work and studies in data analysis. Thanks to my experience and structured approach, I explain Excel in a clear and understandable way. I know how frustrating it can be when something technical doesn’t work... and how satisfying it feels when it finally clicks.

🎯 Topics we can cover
- Smart formulas (IF, VLOOKUP, INDEX, MATCH, etc.)
- Creating charts, pivot tables, and dashboards
- Using Excel for budgeting, planning, or managing projects
- Data analysis and basic programming in Excel
- Preparing for Excel tests or improving job-related Excel skills

💻 Practical info
- Having your own laptop/PC is helpful, but not required
- Online or in-person sessions possible
- Have specific questions or files you’d like to work on? Let me know! I also have my own practice materials.

Feel free to send me a message with your question or goal. I’ll gladly look at how I can help you out!

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

Issam

4.75

(12)

Discover everything Microsoft Office can do with custom online training that is made just for you.

Our individual lessons go deeper than just the basics, changing you from someone who uses Microsoft Word, Excel, and PowerPoint occasionally into someone who uses them with confidence and skill. It doesn’t matter if you are a student, worker, job hunter, or just want to improve your abilities; we offer a learning experience that is adaptable and purposeful, leading to actual improvements.

Max

4.75

(12)

Learn to investigate human behavior by combining psychology, statistics, and data analysis.
Master practical tools like Excel and Python to analyze real-world information and build scientific evidence.
Develops applied projects, interprets results, and transforms data into intelligent decisions.
Ideal for those seeking to differentiate themselves professionally in research, education, human resources, or data science.
A modern training program that combines critical thinking, technology, and highly sought-after skills.

Laroussi

4.75

(12)

1. Microsoft Word: Word Processing
The goal is to learn how to create, format and finalize a professional document (letter, report or CV).

The interface: Discovering the ribbon, tabs and toolbar.

Input and editing: Learn to type text, select, copy/paste and correct spelling mistakes.

Formatting: Change the font, size, color, and manage paragraph alignment.

Layout: Adjust margins, orientation (portrait/landscape) and insert page numbers.

Insert: Add images, simple shapes, or tables.

2. Microsoft Excel: The Spreadsheet
The goal is to understand the structure of a table and to automate simple calculations.

Basic structure: Understanding the concept of cells, columns, rows and spreadsheets.

Data entry: Enter text, numbers, and dates into cells.

Elementary calculations: Use the basic operators (+, −, ∗, /).

Automatic functions: Learn how to use Auto Sum and Average.

Table formatting: Create borders, merge cells and sort lists alphabetically.

Charts: Transforming a data table into a simple chart (line or pie).

3. Microsoft PowerPoint: The Presentation
The goal is to design a dynamic visual aid to accompany an oral presentation.

Slide design: Create new slides and choose a layout (title, content, image).

Themes and Design: Apply a consistent graphic charter to the entire slideshow.

Visual content: Insert text boxes, icons, photos and videos.

Animations and Transitions: Add transition effects between slides to make the presentation smooth.

Slideshow Mode: Learn how to project the presentation and use the navigation tools.

Key points of the training
Prerequisite: Ability to use a keyboard and mouse.
Method: Alternating between theory and practical exercises.
Purpose: Autonomy in basic administrative and school tasks.
Important note: A good introduction should also include file management: knowing how to "Save As", organizing folders and exporting documents in PDF format.

For who ?
Students wishing to improve their assignments and presentations.

Individuals wishing to better organize their daily lives or administrative documents.

Anyone preparing for a career change or professional integration.

Bonus: At the end of each session, I provide you with cheat sheets to remember essential keyboard shortcuts and key manipulations.

Alain

4.75

(12)

This class is designed for studentswho want to improve their accounting knowledge and Excel skills in a practical and easy-to-understand way.

You will learn the fundamentals of accounting, including bookkeeping, financial statements, journal entries, and basic financial analysis, while also developing strong Microsoft Excel skills used in real business environments.

The sessions are hands-on and interactive, covering essential Excel tools such as formulas, functions, formatting, charts, data organization, and financial reporting. Whether you are a beginner or looking to strengthen your existing skills, the class will help you build confidence and apply what you learn to academic, professional, or personal projects.

Classes are tailored to the student’s level and learning goals to ensure steady progress and practical results.

Omar

4.75

(12)

Master Microsoft Office from the comfort of your home with personalized online private classes in Excel, Word, and PowerPoint. Learn essential skills for school, university, business, and everyday professional tasks through interactive and practical lessons tailored to your level and goals.

With over 16 years of teaching experience, lessons focus on building confidence, improving productivity, and helping students achieve real results. Whether you are a beginner or looking to advance your skills, each session is designed to make learning simple, engaging, and effective.

Topics include:

Microsoft Excel (formulas, charts, spreadsheets, data analysis)
Microsoft Word (document formatting, reports, CVs, professional writing)
Microsoft PowerPoint (presentations, animations, design techniques)

Flexible schedules, one-to-one support, and step-by-step guidance available for students, professionals, and job seekers of all ages.