Get in Touch
 Duration 14 hours

Course Outline

Advanced Capabilities

  • Logical operations and functions
  • Mathematical and statistical analysis tools
  • Financial calculation functions

Search and Data Management

  • Data retrieval and matching techniques
  • Utilization of MATCH and INDEX functions
  • Sophisticated management of value lists
  • Cell input validation protocols
  • Database-specific functions
  • Data summarization via histograms
  • Practical considerations regarding circular references

Tables and Pivot Charts

  • Dynamic data description using PivotTables
  • Configuration of elements and calculated fields
  • Data visualization through pivot charts

Working with External Data

  • Data export and import procedures
  • Handling of XML file exports and imports
  • Importing data from database sources
  • Establishing connections to databases or XML files
  • Online data analysis via Web Query

Analytical Methodologies

  • Application of the Goal Seek option
  • Integration of the Analysis ToolPak
  • Scenario creation and management
  • Data optimization using Solver
  • Macro creation and custom function development
  • Initiation and recording of macros
  • Utilization of VBA code

Conditional Formatting

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

Time Value of Money

  • Calculation of current and future capital values
  • Processes of capitalization and discounting
  • Simple interest calculations
  • Comparison of nominal and effective interest rates
  • Analysis of cash flows
  • Depreciation methods

Trends and Financial Forecasts

  • Identification and application of trend functions
  • Financial forecasting techniques

Securities Analysis

  • Determination of profit rates
  • Assessment of profitability
  • Investment analysis and risk measurement for securities

Requirements

Proficiency in Microsoft Excel is required. Foundational knowledge of finance is also recommended.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories