Excel Aplicado a Matemática Financeira e Comercial

Aplicação de excel para matemática financeira e matemática comercial
4.66 (123 reviews)
Udemy
platform
Português
language
Financial Modeling & Ana
category
Excel Aplicado a Matemática Financeira e Comercial
1 641
students
2 hours
content
Aug 2021
last update
FREE
regular price

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

Excel Aplicado a Matemática Financeira e Comercial – Screenshot 1
Screenshot 1Excel Aplicado a Matemática Financeira e Comercial
Excel Aplicado a Matemática Financeira e Comercial – Screenshot 2
Screenshot 2Excel Aplicado a Matemática Financeira e Comercial
Excel Aplicado a Matemática Financeira e Comercial – Screenshot 3
Screenshot 3Excel Aplicado a Matemática Financeira e Comercial
Excel Aplicado a Matemática Financeira e Comercial – Screenshot 4
Screenshot 4Excel Aplicado a Matemática Financeira e Comercial

Loading charts...

4215304
udemy ID
31/07/2021
course created date
13/08/2021
course indexed date
Bot
course submited by