Get in Touch

Course Outline

Advanced Functions

  • Logical functions
  • Mathematical and statistical functions
  • Financial functions

Search and Data Management

  • Search and matching techniques
  • MATCH and INDEX functions
  • Advanced handling of value lists
  • Data validation in cells
  • Database functions
  • Summarizing data using histograms
  • Circular references - Practical considerations

Tables and PivotCharts

  • Data summarization using PivotTables
  • Calculated fields and elements
  • Data visualization with PivotCharts

Working with External Data

  • Exporting and importing data
  • Exporting and importing XML files
  • Importing data from databases
  • Connecting to databases or XML files
  • Online data analysis - Web Queries

Analytical Tools

  • Goal Seek
  • The Analysis ToolPak add-in
  • Scenarios and Scenario Manager
  • Solver and data optimization
  • Macros and custom functions
  • Recording and creating 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
  • Compounding and discounting
  • Simple interest
  • Nominal and effective interest rates
  • Cash flows
  • Depreciation

Trends and Financial Forecasts

  • Trend types (functions)
  • Forecasting techniques

Securities Analysis

  • Rate of return
  • Profitability metrics
  • Investment in securities and risk measures

Requirements

Requires a solid understanding of Microsoft Excel. Basic knowledge of finance is also recommended.

 14 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories