Excel Aplicado a Matemática Financeira e Comercial

Why take this course?
🎉 Excel Aplicado a Matemática Financeira e Comercial - Curso Online com Antonio J. G. Pedrosa peculiarly designed for professionals, entrepreneurs, and students who wish to master the application of Excel in solving real-world financial and commercial mathematical problems. 📊✨
Curso Headline: Aplicação de excel para matemática financeira e matemática comercial
Sobre o Curso:
In this course, you'll find clear and accessible content tailored for practical application within your organization. Structured into three comprehensive modules, it covers the fundamental and intermediate functions of Excel as they relate to financial and commercial mathematics. 🛠️💫
Módulo 1: Operações Aritméticas Básicas no Excel
Dive into the basics of arithmetic operations within Excel, including:
- Addition (+), Subtraction (-)
- Multiplication (×), Division (/)
- Powers and Roots
- Numerical Expressions
Master these elements to create mathematical formulas for a variety of financial problems. 🧮💼
Módulo 2: Cálculos com Porcentagem no Excel
Here, we focus on percentage calculations and their graphical representation:
- Percentage Calculations
- Increase/Discount
- Participation and Variable Percentage
- Building Graphics with Relative Numbers and Conditional Formatting with Icons
This module will empower you to build user-friendly, informative planilhas and charts. 📈🎨
Módulo 3: Funções Financeiras no Excel
Learn about the core financial functions in Excel such as:
- Future Value (VF)
- Present Value (VP)
- Period/Duration (NPER)
- Interest Rate (TAXA)
- Payment/Receipt (PGTO)
- Internal Rate of Return (TIR)
- Net Present Value (VPL)
Resolve complex problems involving the value of money over time. 🏦⚙️
Sistemas de Amortização de Empréstimos
This section covers two of the most common amortization systems for loans, Price and SAC, providing you with practical tools to manage financial planning. 💲🔍
Recursos do Curso:
- Comprehensive lectures to guide you through each concept
- Hands-on activities to reinforce your learning
- Fully completed examples for clarity and understanding
By the end of this course, you'll have a robust skill set to apply Excel effectively in finance and commercial mathematics. 🚀📚
Enroll now and transform the way you handle numerical data with confidence! ✅🎓
Course Gallery




Loading charts...