Microsoft Excel and VBA. From beginner to advanced level with experienced corporate trainer.

From 26.8 £ /h

Excel is one of the most desirable skills by employers. If you want to increase your Excel of knowledge or you are going to begin your adventure with this software I can offer you a lessons. Your are going to go trough most basic comads in excel to advanced programming. As a corporate Excel trainer I can train you to pass Excel tests during recruitment process for job. Welcome to my class.

Extra information

I can bring my laptop.

Location

Use Ctrl + wheel to zoom!

At student's location :

Around Brussels, Belgium

At teacher's location :

Rue Wayenberg, 1050 Ixelles, Belgium

Age

Children (7-12 years old)

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

Polish

Skills

Microsoft excel

Availability of a typical week

(GMT -05:00)

New York

At teacher's location

At student's home

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Lionel

5.0

(1)

I help you master the practice of Excel which will make your life easier.
And I help you achieve your concrete projects.

Veronique

5.0

(1)

I can adapt to your request or your needs.
I can also show you all the inexhaustible resources that Excel offers.
Whether you are a novice or need to deepen a particular aspect (graph, formula, database management, pivot tables ....), you want to prepare for interview or a new job? Can I help you.
You want to prepare for interview?
Excel is first and foremost a practice, so after a little introduction, it's time for exercises

Joanna

5.0

(1)

Excel is a basic tool for almost every smaller company and huge corporation. It serves as a tool for analysis or optimization of daily work, environment for databases or creating templates.

The purpose of tutoring with me is not a series of lessons in which you look as I write formulas, but to achieve some understanding of how Excel works. I would like to become superfluous after a few lessons - I would like you to be able to discover Excel yourself.

About me:
Biotechnology and Industrial Management graduate at Technical University of Lodz. My big passion is Data Science and Business Intelligence. I was working for Philips, currently I am intern for NATO.

Pavan

5.0

(1)

VBA is a tool which is easily within People's reach and can take productivity, accuracy to levels beyond imagination. When data and complexity of projects are not very huge to get into fancy IT applications, VBA comes into picture to get things done efficiently with satisfactory results.

Some of the projects (VBA based) that I have personally undertaken in the past include Building financial and deal models to simulate best/worst case scenarios, Automated Legal contract generation with appropriate wordings and clauses based on specific inputs, Outlook/Mail automation to handle data through attachments or within body of mail, automated market analysis or financial analysis, data consolidation etc...

Based on the level, the training is designed to help and understand VBA and Macros and the power of building custom modules. To reinforce what is taught, there will be a few hands on sessions with a problem statement or example data/files.

Suranjit

5.0

(1)

Specialized in English Language, Grammar and Computer and teaching for 15 years
Experienced as English Teacher for all classes of students and TOEFL, IELTS GRE etc.
specialized for University Admission Test
Learn with pleasure and new technique that i have invented and one can easily learn reading, writing, speaking, listening English.
I like to prefer computer application program, just try one class and feel.

Anas

5.0

(1)

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

Edgar

5.0

(1)

I give private lessons in this extraordinary tool that is MS Excel for all levels (beginner, advanced, expert).

You will learn among others:
• The basics (save, print, basic options, the ribbon, etc.)
• Formatting (fonts, colors, formats, borders, etc.)
• Tables and Charts (data model, pivot tables, chart types, filters, slicers, etc.)
• Illustrations (geometric objects, images, smart art
• Functions (Mathematics and Trigonometrics, Research, Logic, Financial, Text, ...)
• External data
• Data connections
• Data analysis (Scenarios, Goal seek, etc.)
• Database
• Macros with VBA

...and much more.

Learning always takes place through concrete examples.
Also, if you are facing a particular problem, I help you find a solution with Excel.

For your information, I am a Management Engineer, specialized in Finance, graduated from the Solvay Brussels School of Economics and Management, with professional experience in the financial and data analysis fields.

Edgar

Ilias

5.0

(1)

Whether you are asked to create a spreadsheet for statistical analysis, a database of customers, or an engaging presentation of a new product, Microsoft Office is usually your choice. Many users know the basics of what Office can do, but being aware of the more advanced capabilities of Office programs gives you many opportunities for impressive results.

This course includes one or more of the following modules:
- Documents with Word
- Spreadsheets with Excel
- E-mail with Outlook
- Presentations with PowerPoint
- Communication with Teams
- 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.

Sebastian

5.0

(1)

📊 Unlock the Power of Excel with Personalized (Online) Courses! 📊

Are you ready to conquer the world of spreadsheets and harness the true potential of Microsoft Excel? Look no further – I'm here to guide you on an Excel journey that's tailored precisely to your needs.

🔹 Who am I?
Hello, I'm Sebastian, and I'm not just an Excel enthusiast – I'm a part-time Excel aficionado who's passionate about helping others unravel the magic of Excel. From newcomers seeking an introduction to seasoned users aiming to master advanced functionalities, I'm here to be your Excel companion.

🔹 What I Offer:
📌 A Custom Learning Experience: No two learners are the same, and that's why I craft a learning path that aligns with your unique goals and pace.
📌 Mastering Formulas: From the foundational to the complex – whether it's VLOOKUP, HLOOKUP, INDEX, MATCH, or even their intricate combinations, I've got you covered.
📌 Visualize Data Like a Pro: Graphs, charts, and interconnected dashboards – I'll equip you with the skills to present data in compelling and visually appealing ways.
📌 Multilingual Learning: Fluent in English, French, and German, I ensure language isn't a barrier to your Excel success.
📌 For All Ages and Roles: Whether you're a student or a seasoned professional, age is just a number when it comes to Excel mastery.
📌 Flexibility in Learning: Choose between in-person sessions at your location or the convenience of online lessons.

🔹 Excel Made Easy:
Navigating spreadsheets, deciphering formulas, and conducting insightful data analysis can be overwhelming – but not with my expert guidance. Whether you're taking your first steps or aiming for advanced proficiency, together, we'll demystify Excel and empower you to create dynamic spreadsheets with confidence.

Ready to transform your Excel skills? Let's dive in and explore the boundless possibilities that Excel offers. Your Excel journey starts now!

Connect with me today to embark on a learning experience that will forever change how you interact with data.

Salah

5.0

(1)

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.

Salomé

5.0

(1)

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

Kamal

5.0

(1)

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

Morad

5.0

(1)

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!

Gwendoline

5.0

(1)

I teach interactive courses on Excel, Word, and PowerPoint for all levels, whether for high school, college, or the workplace. I also offer introductions to information and office automation.

My approach is practice-based: I guide students step by step, using concrete examples and exercises tailored to their needs. I also teach methods to help them become more organized, more efficient, and more independent in using these tools. Each session is personalized to target the skills they need to develop, while building a climate of trust and motivation.

I always suggest discussing and defining the learner's needs before starting classes so that you can effectively prepare the course materials and support. It is crucial for me to respond correctly to the student's request.

I am a mathematician by training, with over 10 years of experience in private tutoring and assisted coaching. I currently work as a biostatistician and also provide training in this field. I am very patient and passionate about what I teach. I adapt to each student or learner to provide personalized support and I share my methods and tips for progressing quickly and effectively.

I invite you to contact me to best determine the support you need!