1st lesson free
Rodrigo profile and its contact details have been verified by our team.
Rodrigo
- Rate €14
- Response 24h
-
Students13
Number of students Rodrigo has accompanied since arriving at Superprof
Number of students Rodrigo has accompanied since arriving at Superprof
€14/h
Contact
1st lesson free
- Microsoft Excel
Be an Excel expert and guarantee an extra income of up to 3 thousand reais
- Microsoft Excel
Lesson location
Recommended
Rodrigo is a respected tutor in our community. He is highly recommended for his commitment and the quality of his lessons. An excellent choice to progress with confidence.
About Rodrigo
I have more than 5 years of professional experience with Excel, currently a teacher and consultant at a reference school in Excel, with classes from beginners to experts. I use solid concepts and my own experience to solve the most diverse problems that may arise. I believe that everything can be done with Excel and any problem can be solved, and with my knowledge I will help you solve your problems and show you valuable tips that will transform your level in Excel.
See more
About the lesson
- Beginner
- Intermediate
- Advanced
- +2
levels :
Beginner
Intermediate
Advanced
Professionnel
Autres
- English
All languages in which the lesson is available :
English
Currently an Excel teacher with more than 100 students, I have knowledge from the basics to an expert level, in addition to providing mentoring to solve problems with people and companies.
I can teach you Excel in a professional way to leverage your career and that can generate you an extra income of up to 3 thousand reais with classes or mentorships.
Feel free to propose what you want to learn, if you want the teaching modules to follow, or else I can solve a case as a form of mentoring.
Course modules we offer below:
1. Module - Summary + most used formulas
Excel layout
cell reference
Operator Symbols
Formatting Brush
Types of Collage
Classification
Exercises
Main Shortcuts
2. Module - Essential Formulas and Conditional Formatting
Summary of essential formulas
SUM AND SUMIF & SUMIFS (+ Sum with logical operators)
MAXIMUM, MAXIMUM
MINIMUM, MINIMUM
CONT.IF
PROCV
IF
Professional formation of a table + essential tips for presentation
Types of Conditional Formatting
challenge
3. Module - Function nesting, drop-down list, PROC and logic formulas
Function nesting (all in one column)
Logical AND and OR Functions
Data Validation Types (Dropdown List)
VLOOKUP with SE logical condition
text to columns
challenge
4. Module - Working with data, times and text
Working behind datetime excel
Performing calculations with date and time
Formulas involving data
Text formatting formulas + custom format
5. Module - Graphics
chart types
Defined range of days chart (warmed horizontal axis)
Best practices for professional graphics
How to assemble a Dashboard screen
Dynamic chart with dynamic row and column selection (Selecting products in rows and months in columns)
6. Module - Automate reports with Power Query
What is PowerQuery
How Power Query works, understanding step by step
Importing data with PowerQuery
Transforming data with Power Query
How to customize a data transformation with the advanced editor (M language)
How to create sequels and measures in PowerQuery and generate a pivot table/table
See more
Recommendations
Recommendations come from relatives, friends and acquaintances of the tutor.
2
Excelente profissional. Competente, dedicado e atencioso com o trabalho. Recomendo sem ressalvas.
Um excelente profissional. Rodrigo ensina de forma clara e extremamente atenciosa. É estupendo o conhecimento que ele detém sobre Excel. Do básico ao avançado, consegue explicar de forma lúcida sobre todos os temas.
View more recommendations
See more
Rates
Rate
- €14
Pack rates
- 5 h: €68
- 10 h: €136
online
- €14/h
free lessons
This first lesson offered with Rodrigo will allow you to get to know each other and clearly specify your needs for your next lessons.
- 30mins
Details
Any eventuality can be discussed and the value adjusted according to the student's needs.
Other tutors in Microsoft Excel
Zat
Valletta & online
- €20/h
- 1st lesson free
Tasha
Pietà & online
- €21/h
- 1st lesson free
Rogers
Kalkara
- €50/h
- 1st lesson free
Mourad
Paris 12e, France & online
- €45/h
- 1st lesson free
Erica
Fairfield, Australia & online
- €37/h
Ireneusz
Gdańsk, Poland & online
- €28/h
- 1st lesson free
Arbaz
New York, United States & online
- €34/h
- 1st lesson free
Matthieu
Tigery, France & online
- €30/h
- 1st lesson free
Adi
Toronto, Canada & online
- €31/h
- 1st lesson free
Ben
Southampton, United Kingdom & online
- €52/h
- 1st lesson free
Ilian
Paris 8e, France & online
- €25/h
- 1st lesson free
Marc
New York, United States & online
- €107/h
Patricia
Madrid, Spain & online
- €25/h
Inès
Paris 1er, France & online
- €45/h
Zammad
New York, United States & online
- €43/h
- 1st lesson free
Doğukan
Küçükçekmece, Turkey & online
- €15/h
Moreno
Monza, Italy & online
- €50/h
- 1st lesson free
Cassandre
Lehigh Acres, United States & online
- €51/h
Massimiliano
Ancona, Italy & online
- €30/h
- 1st lesson free
Matthew
London, United Kingdom & online
- €45/h
- 1st lesson free
-
More Microsoft Excel tutors
