facebook
favorite button
super instructor icon
Trusted teacher
This teacher has a fast response time and rate, demonstrating a high quality of service to their students.
member since icon
Since July 2021
Instructor since July 2021
Translated by GoogleSee original
Excel course to organize your budget and personal finances.
course price icon
From 58 C$ /h
arrow icon
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.
Location
green drop pin icongreen drop pin icon
|
Use Ctrl + wheel to zoom!
zoom in iconzoom out icon
location type icon
At student's location :
  • Around Brussels, Belgium
location type icon
At teacher's location :
  • Avenue du Renouveau, Evere, Belgique
location type icon
Online from Belgium
About Me
I use Excel on a daily basis in my private life (and of course at work). It's a very flexible management tool and that's why I like it. But it is also a powerful and complex tool that it is better to learn accompanied so as not to spend hours getting worked up about a function that does not give the expected result. This is what I suggest you do together, learn Excel step by step, without getting upset, by working on a project that will be useful to you. For example, we can jointly make the budget for the purchase and renovation of a property and monitor its evolution. Do you have a restaurant and would like to analyze your costs? Can we import all your invoices into Excel, process them and analyze where your money goes? In short, there are many examples of projects that can be done with Excel that I can help you set up so that you can manage them on your own.
Education
License in management science, University of Montpellier.
Courses taken: compatibility, taxation, management control, statistics, financial mathematics, financial analysis, management IT (Excel, Access, SQL) ...
Experience / Qualifications
Office automation teacher.
Business manager
Freelance consultant in SME management.
Web development consultant.
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
45 minutes
60 minutes
The class is taught in
French
English
Dutch
Availability of a typical week
(GMT -04:00)
New York
at teacher icon
At teacher's location and via webcam
at home icon
At student's home
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Similar classes
arrow icon previousarrow icon next
verified badge
Anas
>>> 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.
verified badge
Sebastian
📊 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.
message icon
Contact Serge
repeat students icon
1st lesson is backed
by our
Good-fit Instructor Guarantee
Similar classes
arrow icon previousarrow icon next
verified badge
Anas
>>> 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.
verified badge
Sebastian
📊 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.
Good-fit Instructor Guarantee
favorite button
message icon
Contact Serge