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.
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):
- Introduction to Excel: Course overview, importance of Excel, and instructor introduction.
- Excel Interface: Installation, opening Excel, and understanding the Excel screen layout.
- Basic Calculations: Performing addition, subtraction, multiplication, and division without functions.
- Core Excel Elements: Cells, rows, columns, formulas, charts, and functions.
- Charts & Functions: Using SUM and AVERAGE functions.
- Conditional Functions: Using CONT.SE(), MÁXIMO(), and MÍNIMO().
- IF Statements: Implementing the IF function.
- Text Functions: Using CONCATENAR() and SEERRO().
- Formula & Function Mastery: Working with formulas, structuring Excel, naming and organizing worksheets, and managing column/row dimensions.
- Data Entry & Management: Inserting/deleting rows/columns, hiding/showing elements, saving/opening workbooks.
- Data Editing: Autocomplete, copying/moving cells, and using Paste Special.
- Transfer Panel & Data Cleaning: Utilizing the Transfer Panel, finding/replacing data, and clearing cells.
- Formula Fundamentals: Quickly locating cells, creating formulas and functions.
- Working with Percentages: Calculating and applying percentages.
- Logical Functions: Using the E and OUÁ functions.
- Conditional Formulas: Building SE() and SOMASE() formulas.
- Lookup Functions: Using PROCV() and PROCH().
- Data Conversion: Converting measurements using the CONVERTER() function.
- Date & Time Functions: Working with AGORA(), DIA(), MÊS(), ANO(), HORA(), MINUTO(), SEGUNDO(), and TEMPO().
- 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.
- Mathematical Functions: Using POTÊNCIA(), RAIZ(), ABS(), and LOG().
- Insert Function Button: Utilizing the Insert Function button.
- Worksheet Formatting: Number and currency
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.