1st lesson free
Rodrigo's profile and contact details have been verified by our team
Rodrigo
- Rate R258
- Response 24h
-
Students13
Number of students Rodrigo has accompanied since joining Superprof
Number of students Rodrigo has accompanied since joining Superprof
R258/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. A trusted partner on your learning journey.
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
- +1
levels :
Beginner
Intermediate
Advanced
Professional
- English
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 are written by the tutor's friends, family, and acquaintances.
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.
See more recommendations
See more
Rates
Rate
- R258
Package rates
- 5h: R1289
- 10h: R2578
online
- R258/h
free lesson
The free first lesson with Rodrigo allows you to get to know the tutor and discuss your needs and expectations.
- 30min
Details
Any eventuality can be discussed and the value adjusted according to the student's needs.
Similar Microsoft Excel tutor profiles
Christopher
Cape Town & online
- R200/h
- 1st lesson free
Tapiwa
Sandton & online
- R450/h
- 1st lesson free
Oleksandr
Randburg & online
- R349/h
- 1st lesson free
SEMENYA
Polokwane & online
- R262/h
- 1st lesson free
Antionette
Randfontein & online
- R250/h
- 1st lesson free
Mpho
Burgersfort & online
- R140/h
- 1st lesson free
Dylan
Randfontein & online
- R350/h
- 1st lesson free
Valentino
Pretoria & online
- R250/h
- 1st lesson free
Irfan
Berea & online
- R145/h
- 1st lesson free
Siyanda
Middelburg & online
- R150/h
- 1st lesson free
Newman Blessing
Durban & online
- R200/h
- 1st lesson free
Sally
Cape Town & online
- R200/h
- 1st lesson free
Louise
Cape Town & online
- R250/h
- 1st lesson free
Kagiso victor
Rustenburg & online
- R120/h
- 1st lesson free
Tamryn
KuGompo City & online
- R200/h
- 1st lesson free
Don Quintin
Johannesburg & online
- R100/h
- 1st lesson free
Nomthandazo
Bloemfontein & online
- R200/h
- 1st lesson free
EL-ROHY
Randburg & online
- R150/h
- 1st lesson free
Virgilio Mbotjhwa
Phuthaditjhaba & online
- R200/h
- 1st lesson free
Tahriq
Cape Town & online
- R150/h
- 1st lesson free
-
See Microsoft Excel tutors
