Learn advance Microsoft excel and vba macro programming with finance examples

Van 22.43 $ /h

This course will help to build your skill in MS excel advance formulas like vlookup, hlookup, sumifs, countifs. Also we will look on analytics side covering Excel pivoting. We will also build small application covering excel formulas, vba macros and finally see the results via pivot reporting. Finally we will cover excel dashboarding also.

Locatie

Online vanuit Duitsland

Leeftijd

Kinderen (7-12 jaar oud)

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

Hindi

Vaardigheden

Vb.net

Microsoft excel

Beschikbaarheid typische 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

Learn Programming from basics to advance python, c#, vba etc.

29.52 $ /h

You can learn programming basics, object oriented programming basics. For beginners start with basic programming concepts and then gradually advancing to advance real world projects based on advance modelling approached or based AI ML solutions.

Lees meer

Learn SQL scripts, stored procedures, stored functions

22.43 $ /h

In this class I start with teaching simple SQL like joins, cte functions etc. Later we will jump to advance sql like writing stored procedures, stored functions etc. Also I will cover very basic database designing concepts. Like the approach how to design good data base depending on the volume, performance etc.

Lees meer

Toon meer

Ben

5.0

(2)

How do you use Excel and Power BI effectively?
You have been tasked with setting up a new report. Where do you start? How do you help your client clarify their information needs? How do you avoid spending a lot of time and effort building a report that isn't used? What data do you need, and how do you ensure it is reliable? Which visualizations do you use? How do you build a dashboard? How can AI (Copilot) help you with this? 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 smartly? When do you use macros in VBA? How do you automate the weekly manual update of the report so that you no longer waste time on this tedious routine task?

My mission:
I help you spend as little time as possible building and maintaining automated Excel reports and Power BI dashboards that move the business forward!

Who am I?
I have over 10 years of experience creating ad-hoc analyses and reports for organizations such as SNS REAAL, Coolblue, Energie Samen, and the NEN. I am happy to put that knowledge to use to make you faster, smarter, and more confident in Excel and Power BI.

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!

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!

Ingo

5.0

(2)

Do you use Excel for your job or training and want to learn how to work more efficiently?

Do you want to understand how formulas actually work instead of simply copying them?

Or are you facing a specific problem you can't solve on your own?

I offer targeted Excel coaching tailored to your level and objectives. From basic formulas to pivot tables and more.

Whether you:
- start without prior knowledge,
- want to deepen your basic knowledge,
- want to learn how to work more efficiently for your job,
- or want to optimize a specific file or problem,

We start from your current knowledge level and build up gradually. No standard course, but coaching tailored to your specific needs.

About me:
In my role as a purchaser and data analyst, I use Excel daily for reporting, analysis, forecasting, and optimization.
Thanks to my analytical background and structured approach, I explain complex functions clearly and logically. My goal is not just for you to be able to apply something, but for you to understand why it works—so you can continue using it independently.

Interested? Please feel free to contact us!

Ben

5.0

(2)