Udemyintermediatept

Aprenda Excel2016-Básico e Intermediário, pelo Método VOF

Learn Excel 2016 with this step-by-step, hands-on course! Master practical skills for data management and analysis. Perfect for beginners.

Related:Excel Tables
4.8(2)
22students
6h 37m
Certificate
Luiz Carlos de Castro
Luiz Carlos de CastroMestre em Gestão, Adm de Empresas e professor universitário

Course Content

Aprenda Excel2016-Básico e Intermediário, pelo Método VOF is an intermediate-level Udemy course taught by Luiz Carlos de Castro. It runs 6h 37m, is taught in Portuguese, and includes a certificate of completion. Learners rate it 4.8 out of 5 from 2 reviews, with 22 students enrolled. It is a paid course, first published April 2023.

Explore the power of Excel with this comprehensive video course, designed to take you from a beginner to an intermediate user! Learn to master essential Excel skills and unlock its full potential.

This course provides a practical, hands-on approach, built around the VOF method: Veja (See), Ouça (Hear), and Faça (Do). You'll receive valuable learning materials covering everything from fundamental concepts to advanced techniques.

What you'll learn:

  • Excel Basics: Get comfortable with the Excel interface, including the ribbon, cells, rows, and columns.
  • Essential Formulas: Master basic and intermediate Excel formulas for calculations like sum, multiplication, division, subtraction, and more – without relying on functions!
  • Data Analysis: Learn to use powerful Excel functions such as CONT.SE(), MÁXIMO(), and MÍNIMO() to analyze your data.
  • Conditional Logic: Implement IF statements and SUMIF to make data-driven decisions.
  • Text Manipulation: Utilize functions like CONCATENAR() and SEERRO() for effective text handling.
  • Data Management: Effectively manage your spreadsheets with techniques like autopopulation, copying and moving cells, and Paste Special.
  • Advanced Formatting: Customize your spreadsheets with professional number and currency formats, date and time settings, and conditional formatting.
  • Charts & Graphs: Create compelling charts and graphs to visualize your data, including customizing legends and titles.
  • Data Sorting & Filtering: Quickly find and organize data using advanced filtering and subtotals.
  • Data Validation: Ensure data accuracy with data validation rules.
  • Pivot Tables: Build insightful pivot tables for powerful data summarization and analysis.
  • Macros Automation: Automate repetitive tasks by recording and executing macros.
  • Data Import & Export: Integrate Excel with other applications and import data from the internet.
  • Workbook Security: Protect your work with password protection and workbook security features.

Course Outline (40 Lessons):

  1. Introduction to Excel: Course overview, importance of Excel, and instructor introduction.
  2. Excel Interface: Installation, opening Excel, and understanding the Excel screen layout.
  3. Basic Calculations: Performing addition, subtraction, multiplication, and division without functions.
  4. Core Excel Elements: Cells, rows, columns, formulas, charts, and functions.
  5. Charts & Functions: Using SUM and AVERAGE functions.
  6. Conditional Functions: Using CONT.SE(), MÁXIMO(), and MÍNIMO().
  7. IF Statements: Implementing the IF function.
  8. Text Functions: Using CONCATENAR() and SEERRO().
  9. Formula & Function Mastery: Working with formulas, structuring Excel, naming and organizing worksheets, and managing column/row dimensions.
  10. Data Entry & Management: Inserting/deleting rows/columns, hiding/showing elements, saving/opening workbooks.
  11. Data Editing: Autocomplete, copying/moving cells, and using Paste Special.
  12. Transfer Panel & Data Cleaning: Utilizing the Transfer Panel, finding/replacing data, and clearing cells.
  13. Formula Fundamentals: Quickly locating cells, creating formulas and functions.
  14. Working with Percentages: Calculating and applying percentages.
  15. Logical Functions: Using the E and OUÁ functions.
  16. Conditional Formulas: Building SE() and SOMASE() formulas.
  17. Lookup Functions: Using PROCV() and PROCH().
  18. Data Conversion: Converting measurements using the CONVERTER() function.
  19. Date & Time Functions: Working with AGORA(), DIA(), MÊS(), ANO(), HORA(), MINUTO(), SEGUNDO(), and TEMPO().
  20. Rounding Functions: Using ARREDONDAR.PARA.CIMA(), PAR(), IMPAR(), ARREDONDAR.PARA.BAIXO(), and TRUNCAR(). Also covers ÉERROS(), TIPO.ERRO(), ÉCÉL.VAZIA(), ÉNÚM(), ÉTEXTO(), ÉREF(), ÉLOGICO(), and É.NÃO.TEXTO.
  21. Mathematical Functions: Using POTÊNCIA(), RAIZ(), ABS(), and LOG().
  22. Insert Function Button: Utilizing the Insert Function button.
  23. Worksheet Formatting: Number and currency
$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0(5)
1h 31m
beginner
5.0(83)
9h 13m
all
5.0(16)
1h 26m
all