Course Outline

Advanced functions

  • The logic functions
  • Mathematical and statistical functions
  • Financial functions

Search and data

  • Search and matching
  • Functions MATCH (MATCH) and INDEX (INDEX)
  • Advanced management of lists of values
  • Validate the value entered in the cell
  • Database Functions
  • Summary data by using the histogram
  • Circular references - Practical Aspects

Tables and Pivot Charts

  • The dynamic description of the data using PivotTables
  • Elements and calculated fields
  • Visualize data using pivot chart

Working with external data

  • Exporting and importing data
  • Exporting and importing XML file
  • Importing data from databases
  • Connections to a database or an XML file
  • Analyzing data online - Web Query

Analytical issues

  • Option Goal Seek
  • The Analysis ToolPack addition
  • Scenarios, Scenario Manager
  • Solver and optimization data
  • Macros and create your own functions
  • Starting and recording macros
  • Working with VBA code

Conditional Formatting

  • Advanced conditional formatting using formulas and form elements (eg box - checkbox)

Time value of money

  • The current and future value of capital
  • Capitalization and discounting
  • Interest made ​​simple
  • Nominal and effective interest procetowa
  • Cash flows
  • Depreciation

Trends and financial forecasts

  • Types (functions) trend.
  • Forecasts

Securities

  • The rate of profit
  • Profitability
  • Investing in securities and risk measures

Requirements

Requires good knowledge of Microsoft Excel. Basic knowledge of finance is also indicated.

 14 Hours

Number of participants



Price per participant

Testimonials (2)

Related Courses

FinOps

7 Hours

Open Bank Project for Developers

14 Hours

Learning Xero

14 Hours

GnuCash for Business Accounting

7 Hours

Introduction to Fixed Income

14 Hours

A Practical Guide to Successful Pricing Strategies

7 Hours

Basics of Customizing for Financial Accounting: GL, AP, AR in SAP S/4 HANA (S4F12)

35 Hours

Investment Banking: Introduction to Structured Products

21 Hours

Financial Markets and Trading

14 Hours

Financial Markets

14 Hours

Anti-Money Laundering (AML) and Combating Terrorist Financing (CTF)

14 Hours

CRS: Foreign Financial Reporting and Automatic Exchange of Information

14 Hours

eCommerce Fraud Strategy for Managers

14 Hours

Related Categories

1