Excel Mastery: From Basics to Advanced Applications

Van 57.38 $ /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 informatie

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.

Locatie

Online vanuit Luxemburg

Leeftijd

Tieners (13-17 jaar oud)

Volwassenen (18-64 jaar oud)

Senioren (65+ jaar oud)

Niveau van de leerling

Beginner

Gemiddeld

Gevorderden

Duur

60 minuten

De les wordt gegeven in

Engels

Italiaans

Vaardigheden

Microsoft excel

Beschikbaarheid typische week

(GMT -05: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

50.21 $ /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!

Lees meer

Ben

5.0

(2)

How do you use Excel effectively, including macros?
You will be instructed by your boss to set up a new report. Where do you start How do you get the information requirement in practice? How do you help your client to get her information needs clear? How do you avoid putting a lot of time and effort into building a report that is not being used? What data do you need? Which visualizations do you use? How do you build a dashboard? How do you ensure that management understands and trusts your report? Which formulas do you use? How do you build a data model using Power Query and Power Pivot? How do you use tables, pivot tables and charts in a smart way? How do you automate the weekly manual update of the report by means of macros in VBA, so that you no longer spend time on this boring routine job?

In short: My goal is to help you spend as little time as possible on building and maintaining automated Excel reports and dashboards that help the business move forward!

Who am I?
I have more than 6 experience in making ad hoc analyzes and reports for SNS REAAL, Coolblue and as a Freelancer for various clients.

Isabel

5.0

(2)

This workshop is designed for introducing you to Excel. It includes basic features, formulas and graphs. After you have completed this workshop you will be able to:
- Create a new Excel workbook
- Save a new Excel workbook
- Add data to your worksheet
- Sort & filter data
- Change fonts & text size
- Choose the correct format of a cell, row or column
- Learn basic formulas such as sum, average, vlookup, subtotal etc.
- Learn to create basic graphs from data

Ward

5.0

(2)

Through these sessions I try to teach the student in question in a positive way how he / she can work with the different Microsoft applications.
I have been tutoring both students (privately or in groups) and companies for 4 years now.

The Microsoft Office package has many useful and important functions, but these are sometimes quite complicated. I myself am very well trained in the use of Excel, Word and PowerPoint.
For the Excel part I had 2 years of lessons and 3 years of self-study.

I teach both beginners and people who already have a certain basic knowledge, group lessons are also possible and I am also open to companies!

In addition, I also provide a self-made tutoring course that can be used by the student during and after classes. I made these with the aim of explaining certain aspects in Excel step by step with a lot of images and examples, which makes processing even so easy.

If you have any questions or are interested, you can always send me a message.

Thierry

5.0

(2)

Microsoft Office applications contain a development environment which allows the operation of these applications to be adapted to the concrete needs of its users.
I offer you an introduction to programming in Visual Basic for Applications, in order to allow you to get started with macros and the interaction that you can bring to your Excel files.
On the menu :
* Editor interface
* Macro recording
* Analysis of the code generated by the macro recorder
* Programming basics: types of variables, execution flow control instructions and common functions
* Preview of the Excel object model

Serge

5.0

(2)

Did you know that in Excel you can create a smartphone application that manages your personal budget? Or that you can program reminders so you don't forget to pay your bills? You can even play chess remotely using Excel! Starting from your project on Excel, I guide you in setting up your spreadsheet, organizing the data, integrating the formulas and the layout so that you have created a tool that suits you, whether you understood and are proud of.

Ruan

5.0

(2)

I can teach you the skills listed below or specific skills you want me to. I can also help with school, personal or work projects. Please feel to contact me anytime to ask / enquire about my services!Specific requirements can be discussed.
I having been using a computer daily for the past 20 years.

Microsoft Excel:
Managing Worksheets, Formatting Cells, Printing, Excel Functions, Sorting Data, Find and Replace, Shortcuts, Drop Down Lists, Conditional Formatting, Filters, Page Layouts, Converting to PDF, Grouping and more

Computer Skills:
How to use your computer, Installing software, Updating Software, Keeping your data safe, How to purchase and install computer security software, How to use the internet, How to setup and use email, How to set a sleep timer, How to take screenshots, How to create a PDF, How to use Microsoft Outlook Excel, Word and Power Point, How to use LinkedIn, How to use a VPN, How to use a translator and more

Online or in person lesson.
I can help / teach all ages.
Personal , school or work

Salomé

5.0

(2)

A 34-year-old university graduate, business engineer, with 12 years of professional experience, offers her teaching services.

Lessons (1 hour online only) - 1.5 or 2 hours depending on the subject/level/location
Educational and organized teacher with excellent revision and organizational techniques
Microsoft Office - Excel/Word/PowerPoint - email - typing - ...

Educational and patient with a good methodology adapted to each student

97% success rate with regular monitoring

Feel free to contact me for more information!
See you soon

Loren

5.0

(2)

From simple sums to cost overviews and pivot tables, Excel is a powerful tool that has become an indispensable part of the workplace for many of us!
Do you have a specific problem or would you like a general introduction to Excel? Feel free to message me!

Patricia

5.0

(2)

Microsoft excel lessons for beginners and intermediates. I will take you from the start in learning excel.
Whether or not using your own examples or projects. I teach you things like working with formulas, formatting, graphs, pivot tables, data logic, data editing.

Support with your Excel assignment or project is also possible.

In various functions I have gained experience with excel in recent years. I have also designed small applications. I taught myself the basic and advanced steps, after which I followed a small-scale and interactive expert training where mainly many tips and tricks were discussed.

Milan

5.0

(2)

I offer Microsoft Excel tutoring for anyone looking to improve their skills, from high school students to aspiring professionals. Whether you’re just starting out and want to learn the basics like formulas, graphs, and pivot tables, or you’re more advanced and want to set up automated models, I’m here to help.

You determine the curriculum: we can work on specific tasks, such as school projects or work-related analyses, but I can also put together a structured curriculum to build your skills step by step.

For advanced users, I offer guidance in developing smart templates and models, so that you can perform analyses faster and more efficiently in the future. With my lessons, you will not only learn to understand Excel, but also to apply it practically to save time and make an impression. Suitable for anyone who wants to distinguish themselves with strong Excel skills!

Besides MS Excel, we can also delve deeper into the other Office applications and how to create attractive presentations in Powerpoint or Word.

Brent

5.0

(2)

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!

Vanessa

5.0

(2)

Do you finally want to get the most out of Office 365 and AI?
I help freelancers, students, and professionals work smarter and faster with Word, Excel, PowerPoint, Outlook, and AI tools like ChatGPT and Copilot.

👩‍💻 Who am I?
With over 20 years of IT experience, I know how frustrating it can be when programs seem complicated. I'll teach you step-by-step how to master Office and AI, so you can immediately save time and become more productive.

📚 What will you learn from me?
• Microsoft Word → reports, templates, automatic tables of contents
• Excel → formulas, pivot tables, graphs, smart data analysis
• PowerPoint → create persuasive presentations
• Outlook → organize your mailbox and calendar smartly
• AI tools (ChatGPT & Copilot) → write texts, make summaries, work faster in Office

🎯 For whom?
• Beginners who want to learn the basics well
• Professionals who want to work more efficiently
• Students who want to score better on assignments
• Self-employed people who want to save time on administration & communication

💬 Why choose me?
• Patient, practical, in clear language
• Many examples, directly applicable
• You determine the pace: basic or advanced
• ADHD-proof learning: short blocks, structure & repetition

📅 Book your first lesson today and discover how to use Office and AI truly intelligently!

Ben

5.0

(2)