Get in Touch

Course Outline

Advanced functions

  • Logical functions
  • Mathematical and statistical functions
  • Financial functions

Search and data

  • Searching and matching data
  • MATCH and INDEX functions
  • Advanced management of value lists
  • Data validation for cell entries
  • Database functions
  • Data summarization using histograms
  • Circular references - Practical aspects

Tables and PivotCharts

  • Dynamic data description using PivotTables
  • Elements and calculated fields
  • Data visualization using PivotCharts

Working with external data

  • Data export and import
  • Exporting and importing XML files
  • Importing data from databases
  • Connections to databases or XML files
  • Online data analysis - Web Queries

Analytical topics

  • Goal Seek feature
  • Analysis ToolPak add-in
  • Scenarios and Scenario Manager
  • Solver and data optimization
  • Macros and creating custom functions
  • Starting and recording macros
  • Working with VBA code

Conditional Formatting

  • Advanced conditional formatting using formulas and form controls (e.g., checkboxes)

Time value of money

  • Present and future value of capital
  • Capitalization and discounting
  • Simple interest
  • Nominal and effective interest rates
  • Cash flows
  • Depreciation

Trends and financial forecasts

  • Trend types and functions
  • Forecasting

Securities

  • Rate of return
  • Profitability
  • Investing in securities and risk measures

Requirements

Requires strong proficiency in Microsoft Excel. Basic knowledge of finance is also recommended.

 14 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories