Get in Touch
 Duration 14 hours

Course Outline

Advanced Functions

  • Logical Functions
  • Mathematical and Statistical Functions
  • Financial Functions

Search and Data

  • Search and Matching Techniques
  • Using MATCH and INDEX Functions
  • Advanced Management of Value Lists
  • Validating Cell Inputs
  • Database Functions
  • Aggregating Data Using Histograms
  • Circular References - Practical Applications

Tables and Pivot Charts

  • Dynamically Describing Data with PivotTables
  • Elements and Calculated Fields
  • Visualizing Data with Pivot Charts

Working with External Data

  • Data Export and Import
  • Exporting and Importing XML Files
  • Importing Data from Databases
  • Establishing Connections to Databases or XML Files
  • Online Data Analysis via Web Query

Analytical Tools

  • Using Goal Seek
  • The Analysis ToolPak Add-in
  • Scenarios and the Scenario Manager
  • Solver and Data Optimization
  • Macros and Custom Function Creation
  • Initiating 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

  • Types of Trend Functions
  • Forecasting Techniques

Securities

  • Profit Margins
  • Profitability
  • Securities Investment and Risk Measurement

Requirements

A solid understanding of Microsoft Excel is required. Fundamental knowledge of finance is also recommended.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories