Excel Mastery: From Basics to Advanced Applications

From 80.22 C$ /h

Excel is more than just a spreadsheet—it’s a powerful tool for data analysis, problem-solving, and automation. This course is designed to take you from foundational skills to advanced techniques, enabling you to harness Excel's full potential in real-world scenarios. Whether you're managing data, building models, or optimizing workflows, this hands-on course will equip you with the knowledge and practical expertise to excel (pun intended) in any professional environment.

Introduction & Foundations
- Overview of Excel’s interface and advanced formatting tools
- Key functions like LOOKUP for efficient data handling

Working with References & Logical Functions
- Mastering relative and absolute references, INDIRECT function
- Using ranges, lists, and logical/information functions

Formatting, Functions, & Shortcuts
- Conditional formatting for data insights
- Text functions and essential keyboard shortcuts

Data Import & Advanced Operations
- Importing data from external sources
- Working with dates, times, and matrices

Data Analysis Tools
- Creating and managing data tables
- Data validation and pivot tables for deep analysis

Advanced Functions & Formula Auditing
- Math, statistical, and financial functions
- Troubleshooting and auditing worksheets

Advanced Analysis & Automation
- Form controls, regression analysis, and scenario building
- Introduction to macros for automation

Extra information

The student can either choose the full course, which will be composed of 10 classes, or a reduced syllabus based on selected modules, or even a single class on a specific topic among the ones presented above.

Location

Online from Luxembourg

Age

Teenagers (13-17 years old)

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Advanced

Duration

60 minutes

The class is taught in

English

Italian

Skills

Microsoft excel

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

Guitar Classes for Beginners in Luxembourg - Learn the Basics, Play with Confidence

70.19 C$ /h

My beginner guitar classes are designed to help you build a solid foundation, whether you're picking up the guitar for the first time or want to revisit the basics.

What You’ll Learn:

- Basic chords and strumming patterns
- Simple songs to practice and enjoy
- Guitar tuning and maintenance tips
- How to read tablature and understand music basics

Why Choose My Classes?

- Patient, supportive teaching approach
- Customized lessons based on your pace and interests
- Flexible scheduling to fit your routine
- A fun and engaging learning environment

Whether you aspire to play for yourself, family, or friends, my goal is to make your learning experience enjoyable and rewarding. Let’s make music together!

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!

Hector

4.75

(12)

In this class you are taught everything related to the analysis, design and construction of computational solutions in this spreadsheet.

The correct way to create macros and process automation in VISUAL BASIC FOR APPLICATIONS (VBA) of Microsoft® Excel is explained.

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

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.

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

Tobi

4.75

(12)

I typically conduct my accounting sessions from a place of patient exploration by ascertaining what students understand and what they need help with. I then try to connect what they understand to areas of challenges so that lessons can be brought to educationally sound conclusions. I also use audio-visual aids in helping students understand concepts better.

I tutor concepts in accounting like the accounting equation, T-accounts, journal entries, ledger postings, trial balances, financial statement preparation, cash flow (direct and indirect), inventory valuation (FIFO, LIFO, weighted average & Specific Identification), receivables/payables, bad debts, bonds, asset acquisition, depreciation and disposal, petty cash & bank reconciliation, partnership accounting, and stockholder equity accounting amongst others.

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)

Who should attend ?
This course is specifically designed for seniors, young retirees, or anyone wishing to update their computer skills at their own pace. No prior technical knowledge is required. Patience, clarity, and a supportive approach are at the heart of this training.

Why take this course?
Information technology should no longer be a barrier, but a tool to simplify your daily life and keep you connected with loved ones. This program has two objectives: to make you completely proficient with standard software (Word, Excel) and to introduce you, in a simple and engaging way, to the new Artificial Intelligence (AI) technologies that everyone is talking about.

Educational goals :
At the end of this learning cycle, you will be able to:

Drafting and formatting administrative or personal documents.

Managing a family budget or creating simple organizational lists.

Understand what Artificial Intelligence is (like ChatGPT or Gemini) and use it as a personal assistant on a daily basis.

Detailed program (Syllabus)
The program is adaptable to your initial level. Each session includes simplified theory and plenty of practice.

Module 1: The basics of office software (Microsoft Word)

Exploring the interface: the keyboard, the mouse, and the word processing screen.

Enter, correct and format text (bold, italics, colours, alignment).

Write an official letter or a letter to loved ones.

Save, find your document on the computer, and print it.

Module 2: Daily Organization (Microsoft Excel)

Understanding the principle of tables and cells.

Create simple lists (address book, shopping list).

Create a tracking table for the monthly budget (expenses, income).

Use basic formulas (automatic sum) to have the computer calculate for you.

Module 3: The Arrival of Artificial Intelligence (Chatbots)

What is Artificial Intelligence (AI)? A simple explanation and demystification.

Discover virtual assistants (ChatGPT or Gemini): how to access them for free and securely.

The art of the "Prompt" (the query): how to ask the right questions to the machine to get the best answers.

Practical workshops with AI:

Ask him to draft a complex email.

Looking for recipe ideas using leftovers from the fridge.

Have him summarize a long newspaper article.

Organize a travel itinerary from A to Z.

Module 4: Safety and Best Practices

Recognizing reliable information in the face of AI "hallucinations" (errors).

The golden rules for protecting your personal data on the internet and in Office documents.

My Pedagogical Methodology
The approach is entirely personalized. I adapt to your learning pace. Each new concept is immediately followed by a practical, concrete exercise directly related to your everyday needs (writing to an administration, planning your vacation, etc.). Simplified course materials can be provided at the end of each session to help you review on your own.

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.