Excel Course - beginners to intermediate - just to excel yourself. - Schaerbeek, Bruxelles - Cours particulier

Donner des Cours

Excel Course - beginners to intermediate - just to excel yourself.

Àpd 133.9 CNY /h

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.

Informations supplémentaires

First we need to talk to find what are your needs.
We will use Excel 2016 or 2010 in English (it is standard for most companies).

Lieu

|

Utilisez Ctrl + molette pour zoomer !

Cours chez le professeur :

1030 Schaerbeek, Belgium

Age

Enfants (7-12 ans)

Adolescents (13-17 ans)

Adultes (18-64 ans)

Seniors (65+ ans)

Niveau du Cours

Débutant

Intermédiaire

Durée

60 minutes

Enseigné en

anglais

Compétences

Microsoft excel

Disponibilité semaine type

(GMT -05:00)

New York

Cours chez le professeur

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

aide pour renforcer votre matiére et apprendre avec des mémo techniques. Je suis en dernière année et comptez sur moi pour apprendre plus facilement
Les cours de mathématiques avec tous les chapitres ainsi que ma spécialité qui est la chimie,la biologie et la physique.

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

Apprendre à maîtriser Microsoft Office. Adaptation selon les besoins de chaque personnes

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

Je suis formateur Informatique expérimentés, je donne cours d'informatique pour débutant avec beaucoup de patience des leçons privées d’ordinateur, de tablette ou de portable à des personnes n’ayant peu voir aucune connaissance informatique préalable. (Internet, Word, Excel, PowerPoint, Mail, smartphone, tablette, créer un site web, programmation et autres...).

N'hésitez pas à me contacter :-)

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.

L'univers de l'informatique est fascinant et simple malgré sa complexité. Chacun, chacune, et ce , peu importe l'âge, peut apprendre à maitriser ces outils! Que ce soit le navigateur web, la boite mail, la suite Office pour ecrire du texte, créer des tableaux, ou des présentations. Tout est dans la volonté. N'hesitez pas a me contacter pour quelconque information, je suis disponible et répond rapidement!

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

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

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.

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.

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

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!

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!

Ce cours de bureautique de niveau débutant est conçu pour toute personne souhaitant acquérir les compétences de base nécessaires à l’utilisation d’un ordinateur et des logiciels bureautiques les plus courants. Il s’adresse aux débutants ou aux utilisateurs ayant peu d’expérience en informatique. À l’issue de la formation, les apprenants seront capables d’utiliser efficacement un ordinateur dans un contexte personnel, scolaire ou professionnel

aide pour renforcer votre matiére et apprendre avec des mémo techniques. Je suis en dernière année et comptez sur moi pour apprendre plus facilement
Les cours de mathématiques avec tous les chapitres ainsi que ma spécialité qui est la chimie,la biologie et la physique.

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

Apprendre à maîtriser Microsoft Office. Adaptation selon les besoins de chaque personnes

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

Je suis formateur Informatique expérimentés, je donne cours d'informatique pour débutant avec beaucoup de patience des leçons privées d’ordinateur, de tablette ou de portable à des personnes n’ayant peu voir aucune connaissance informatique préalable. (Internet, Word, Excel, PowerPoint, Mail, smartphone, tablette, créer un site web, programmation et autres...).

N'hésitez pas à me contacter :-)

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.

L'univers de l'informatique est fascinant et simple malgré sa complexité. Chacun, chacune, et ce , peu importe l'âge, peut apprendre à maitriser ces outils! Que ce soit le navigateur web, la boite mail, la suite Office pour ecrire du texte, créer des tableaux, ou des présentations. Tout est dans la volonté. N'hesitez pas a me contacter pour quelconque information, je suis disponible et répond rapidement!

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

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

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.

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.

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

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!

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!

Ce cours de bureautique de niveau débutant est conçu pour toute personne souhaitant acquérir les compétences de base nécessaires à l’utilisation d’un ordinateur et des logiciels bureautiques les plus courants. Il s’adresse aux débutants ou aux utilisateurs ayant peu d’expérience en informatique. À l’issue de la formation, les apprenants seront capables d’utiliser efficacement un ordinateur dans un contexte personnel, scolaire ou professionnel

Garantie Le-Bon-Prof

Contacter Joanna