Homepage Help
Help Become a Tutor
$10/h
1st lesson free!
Profile Verified
Response Time 6h
Lessons offered by Leonardo
  • Individual
  • Group
Lessons can be held..
  • at your place
  • by webcam
Subjects taught
  • Basic computer
  • Microsoft Excel
  • Office automation
  • OpenOffice Calc
Levels
  • Primary School
  • Early High School
  • Year 10
  • Year 11-12
  • TAFE
  • Adult Education
  • Diploma/Certificate
  • PhD
  • Beginner
  • Intermediate
  • Advanced

Professional developer gives classes of enterprise app development with Excel in Petrópolis

Methodology

Classes guided by the student base in the tool, passing through all development characteristics of automations with Excel. The student should ultimately be able to develop apps of any kind using Excel and its native tools. Become an Excel ninja.

Background

1ª Aula: Obter dados externos
1. Introdução ao recurso de obter dados externos
1.1 Obter dados externos de um arquivo de texto
1.2 Atualizar a conexão
1.3 Visualizar as conexões existentes
1.4 Obter dados externos do Access
1.5 Obter dados externos da Web

2ª Aula: Formatar como tabela
2. Qual a utilidade do recurso Formatar como Tabela?
2.1 Vantagens do comando Formatar como Tabela
2.2 A tabela do Excel como banco de dados
2.3 Utilizando o recurso Formatar como Tabela
2.4 Como localizar registros duplicados
2.5 Como excluir registros duplicados
2.6 Como acrescentar uma linha de totais na tabela
2.7 A função SUBTOTAL
2.8 Fórmulas na Tabela

3ª Aula: Funções Matemática/Trigonometria e Estatística
3. A função SOMASE
3.1 Estrutura da função SOMASE
3.2 A função SOMASES
3.3 A função CONT.SE
3.4 Estrutura da função CONT.SE
3.5 A função CONT.SES
3.6 A função CONT.NÚM
3.7 Estrutura da função CONT.NÚM
3.8 A função CONT.VALORES
3.9 Estrutura da função CONT.VALORES
Laboratório da 3ª Aula – Funções Matemática/Trigonometria e Estatística
4ª Aula: Funções Lógica e Informações
4. Funções Lógica e Informações
4.1 Funções de informação: ÉERRO e ÉERROS
4.2 Função lógica: SEERRO


5ª Aula: Segurança dos dados
5. Protegendo seus dados
5.1 Protegendo a pasta de trabalho
5.2 Retirando a senha
5.3 Atribuindo uma senha para gravação
5.2 Protegendo a estrutura da pasta de trabalho
5.3 Protegendo as células da planilha

6ª Aula: Funções de Texto
6. NÚM.CARACT
6.1 LOCALIZAR
6.2 ESQUERDA
6.3 EXT.TEXTO
6.3.1 ARRUMAR
6.4 DIREITA
6.5 CONCATENAR
Laboratório da 6ª aula – Funções de Texto

7ª Aula: Auditoria de Fórmulas
7. O que é a Auditoria de Fórmulas?
7.1 Utilizando a Auditoria de Fórmulas durante a digitação
7.2 Rastreando células precedentes
7.3 Rastreando células dependentes
7.4 Rastreando Erros
7.5 Tipos de erros do Excel
7.5.1 Erro ###
7.5.2 Erro #DIV/0!
7.5.3 Erro #N/D
7.5.4 Erro #NOME?
7.5.5 Erro #NULO!
7.5.6 Erro #NUM!
7.5.7 Erro #REF!
7.5.8 Erro #VALOR!
7.5.9 Erro Referência Circular
7.6 Avaliando Fórmulas
7.7 A Janela de Inspeção
7.8 Modo Auditória de Fórmulas


8ª Aula: Subtotais
8. Subtotal
8.1 Acrescentando Subtotais
8.2 Removendo Subtotais

9ª Aula: Consolidação de Dados
9. O que é Consolidação de Dados?
9.1 Tipos de Consolidação de Dados
9.2 Consolidação por Posição
9.3 Exemplo de Consolidação por Posição
9.4 Consolidação por Categoria
9.5 Exemplo de Consolidação por Categoria
9.6 Consolidação por Fórmula
9.7 Exemplo de Consolidação por Fórmula

10ª Aula: Validação de dados
10. O que é a Validação de dados?
10.1 Aplicando a validação de dados
10.2 Adicionando uma mensagem de entrada
10.3 Definindo Alertas de Erro
10.4 Tipos de Alertas de Erro
10.5 Validação de Dados do tipo Lista
10.6 Validação de Dados do tipo Lista de outra planilha
10.7 Validação de Dados do tipo Lista de uma região nomeada
10.8 Utilizando fórmulas para validar dados
10.9 Localizando dados inválidos
10.10 Removendo a validação de uma célula

11ª Aula: Função de Pesquisa e Referência
11. Restrições da função de procura
11.1 Função CORRESP
11.2 Função DESLOC
11.3 Função ÍNDICE


12ª Aula: Atingir Meta
12. O que é o recurso Atingir Meta
12.1 Utilizando o recurso Atingir Meta
12.2 A aproximação de resultados
12.3 Análise da aproximação de resultados
12.4 Múltiplas Soluções

13ª Aula: Macro
13. O que é Macro?
13.1 Principais benefícios da utilização das macros
13.2 Relação entre Macros e o VBA
13.3 Segurança na utilização de macros
13.4 Criando a sua primeira macro
13.5 Como salvar pastas de trabalho que possuem macros
13.6 Diferenças entre macros com Referências Absolutas e Relativas
13.7 Gravando uma macro com referências relativas
13.8 Macros e a janela VBE (Visual Basic Editor)
13.9 Utilidade real das macros
13.10 VBA - Exemplo 1
13.11 VBA - Exemplo 2
13.12 Considerações finais sobre VBA – Visual Basic for Applications

14ª Aula: Introdução ao VBA para Excel
14.1 A guia Desenvolvedor no Excel
14.1.1 Procedimentos para ativar a guia Desenvolvedor
14.2 Digitando uma macro no editor do VBA (Visual Basic Editor – VBE)
14.2.1 Inserindo um novo módulo
14.2.2 Criando uma macro chamada Cadastro
14.2.3 Formas de endereçamento de células no VBA
14.2.4 Comando para inserir um texto na célula B3
14.2.5 Como executar a macro Cadastro
14.2.6 Resultado da execução
14.3 Inputbox – Caixa de entrada
14.3.1 Exemplo de macro com Inputbox
14.3.2 Resultado da execução de Inputbox
14.4 Como gravar uma macro e reutilizar o código gerado em outra macro
14.4.1 Gravando uma macro para salvar um arquivo
14.4.2 Onde está gravada a macro Salvar?
14.4.3 Copiando o comando para Salvar a planilha ativa para a área de transferência
14.4.4 Copiando o comando para a macro Cadastro
14.5 Msgbox – Caixa de Mensagem
14.5.1 Inserindo o comando Msgbox na macro Cadastro
14.6 Associando as macros com os botões: Controle de Formulários e Controle Active X
14.6.1 Desenhando um botão e associando com a macro Cadastro
14.6.2 Botão criado na planilha ativa
14.6.3 Comando para fechar a pasta de trabalho com o botão ActiveX
14.6.4 Como alterar a propriedade do botão ActiveX
14.6.5 A janela de propriedade do botão ActiveX
14.6.6 Atribuindo o comando Fechar arquivo para o botão ActiveX

15ª Aula: Elaboração de Formulários através dos Controles de Formulário
15. Formulários através dos Controles de Formulário
15.1 Formulários e suas principais aplicações
15.2 Caixa de Controles de Formulário
15.2.1 Caixa de Controles de Formulário - Botão
15.2.2 Caixa de Controles de Formulário-Caixa de Combinação
15.2.3 Caixa de Controles de Formulário-Caixa de Seleção
15.2.4 Caixa de Controles de Formulário-Botão de Opção
15.2.5 Caixa de Controles de Formulário - Caixa de Grupo
15.2.6 Caixa de Controles de Formulário – Os demais controles
15.2.6.1 Caixa de Controles de Formulário – Botão de Rotação
15.2.6.2 Caixa de Controles de Formulário – Caixa de Listagem
15.2.6.3 Caixa de Controles de Formulário – Rótulo
15.2.6.4 Caixa de Controles de Formulário – Barra de Rolagem

Rates

Travel Fee : $40
Rate for online lessons : $10/h
Rate for 5 hours of lessons : $40
Rate for 10 hours of lessons : $84

Details

Displacements imply charging of the cost of transportation.

Lessons offered by Leonardo
Individual
Group
Lessons can be held..
at your place
webcam
Subjects taught
  • Basic computer
  • Microsoft Excel
  • Office automation
  • OpenOffice Calc
Levels
  • Primary School
  • Early High School
  • Year 10
  • Year 11-12
  • TAFE
  • Adult Education
  • Diploma/Certificate
  • PhD
  • Beginner
  • Intermediate
  • Advanced

Leonardo's CV

I have been an Excel Developer for 3 years and developed apps of all kinds for companies of all sizes, nationally and internationally. I was also responsible for the development of most of the spreadsheet portfolio of the largest spreadsheet store in Brazil.

Similar tutors

basic computer lessons closeby? Here's a selection of tutor listings that you can check out.
Superprof can also suggest microsoft excel lessons to help you.
Learning isn't a problem, office automation lessons for all!
Taking openoffice calc lessons has never been easier: you're going to learn new skills.

Punchbowl
Graduate with years of experience and qualifications , feel free to ask any queries in relation to your subjects. Happy learning !
$25
Elie
1st lesson free!

My teaching method is solely based on the individual client needs, i will gain a level of understanding of current knowledge...

Lessons by webcam Face to face lessons Approved profile
Paris 19e, France
How to acquire the basics to become an ethical hacker? On Paris (face) or elsewhere (web)
$65
Laurent
  • (45 reviews)
1st lesson free!

I am a computer enthusiast. My classes are for those who want to discover this beautiful science. My teaching is based on...

Lessons by webcam Approved profile
Paris, France
Former Apple specialist teaches introduction to iPhone, iPad, and MacBook in Paris
$97
Victor
  • (56 reviews)
1st lesson free!

You have just purchased your first Apple device and you do not know how to use? You have an iPhone or iPad since a long...

Lessons by webcam Face to face lessons Approved profile
Madrid, Spain
Professor of Computer Programming, Creating Web Pages, Databases, Systems Security Office, OOP
$57
Alberto
  • (9 reviews)
1st lesson free!

I've been teaching 6 years and also working in the private sector, more specifically in systems development. My method...

Lessons by webcam Face to face lessons Approved profile
Coorparoo
As a Master's in Computer Application along with three years experience in IT industry Ginia is highly experienced in computer languages
$25
Ginia
  • (1 review)
1st lesson free!

As experience in IT industry I have a practical knowledge of how we actually make use of programing languages and others in...

Lessons by webcam Face to face lessons Approved profile
Parkwood
Griffith PhD student with 7 years teaching experience in Computer Science lessons to high school or university students in Gold Coast.
$40
Shikha
1st lesson free!

I like to give lessons with real life examples so that my students can understand it quickly and very well. I try to make...

Lessons by webcam Face to face lessons Approved profile
São Paulo, Brazil
Excel Classes/Consulting for beginner, intermediate and advanced users. If you are interested in getting started or using more advanced features I can help you!
$20
Adriano
  • (65 reviews)

* Do you need to set up a spreadsheet and have difficulties? I can help you. * Whether through a class or consulting...

Lessons by webcam Face to face lessons Approved profile
Caulfield North
RMIT Master's of Data Science student gives SQL Lessons to High school and Uni students in Melbourne
$20
Sarath
1st lesson free!

This course does not need previous knowledge regarding Databases. With this course we will explore the building blocks of...

Lessons by webcam Face to face lessons Approved profile
Sherwood
Do you need lessons on C, Python, Matlab, linux and Arduino? As a QUT Electrical Engineering student I can help you in Brisbane.
$30
Thilacsan
1st lesson free!

I customise my teaching method based on the student's ability and time. In general my teaching method is hands on, where I...

Lessons by webcam Face to face lessons Approved profile
Hawthorn East
Melbourne University computer science student looking to teach aspiring students who have an interest in computer science
$20
Umair
1st lesson free!

I am usually a slow learner and therefore I know what it feels like to have the class zoom ahead while i try to catch up....

Lessons by webcam Approved profile Responds within the hour
Underdale
University of Adelaide student teaches fundamentals and foundations of computer science .
$25
Vedaanth K
1st lesson free!

My teaching methodology is quite different when compared with fellow teachers. I focus on conceptual learning rather than...

Lessons by webcam Face to face lessons Approved profile
Ludhiana,
Former Assistant Professor, now a freelance tutor working from home, gives computer science classes to all levels in most of the subjects. Let's work together to develop your love for learning :)
$16
Kiran
  • (7 reviews)
1st lesson free!

Explaining the concepts using analogy and examples, and making a foundation in the subject through study material,...

Lessons by webcam Face to face lessons Approved profile
Marcoola
Mechanical engineer love to teach Autocad, basic computer, internet, word excel in sunshine coast, qld
$30
Shaileshkumar
1st lesson free!

I am Mechanical Engineer and teaching since 2006. I am Graduate Mechanical engineer. I awarded in 2nd prize in painting...

Lessons by webcam Face to face lessons Approved profile
Carlisle
Qualified Secondary Computing Teacher and IT Professional available for Digital Technologies or Computer Science Tutoring
$25
Roger
1st lesson free!

I ascertain what the curriculum requirements are. I then try to ascertain what the student already knows regarding the...

Lessons by webcam Face to face lessons Approved profile Responds within the hour
Prospect
Australian National University (ANU) IT graduate gives Computer Science and IT courses to the high school and university students in Adelaide
$18
Muhammad Usman
1st lesson free!

01. Delivering lectures with the help of Ms PowerPoint and writing code for different problems in the Integrated Development...

Lessons by webcam Face to face lessons Approved profile
Canning Vale
Former tutor graduated in Masters of Information Technology (Professional Computing) gives training of basic computing, Microsoft Office Suite including MS Word, PowerPoint, Excel and Outlook.
$25
Charan
  • (1 review)
1st lesson free!

My teaching method depends on individuals' needs. Generally, I prefer demonstration and reflective strategies where I...

Lessons by webcam Face to face lessons Approved profile
Coogee
High School and College Advanced Mathematics, Extension 1 and Computer Programming Tutoring
$50
Abhishek
1st lesson free!

As your kid's tutor, I would assist in explaining concepts they may have difficulty understanding or simply improve their...

Lessons by webcam Face to face lessons Approved profile
Epping
La Trobe Computer Engineering Student give computer lessons to high school students in Whittlesea area
$20
Prabhjot
1st lesson free!

My favorite subject have been computer and i have been a great student in computer subject. Most of the students i taught...

Lessons by webcam Face to face lessons Approved profile
Eastlakes
University graduate experienced tutor! Home tuition in mathematics, physics and computer science.
$30
Imran
1st lesson free!

Simplicity is key to effective delivery and learning. I am a strong advocate of logic, conceptual reasoning and...

Lessons by webcam Face to face lessons Approved profile
at their place at your place by webcam
1 hour Not available $50 $10
5 hours Not available $240 $50
10 hours Not available $484 $101
Book a lesson