Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Advanced Functions
- Logical functions
- Mathematical and statistical functions
- Financial functions
Searching and Data
- Lookup and matching techniques
- MATCH and INDEX functions
- Advanced handling of value lists
- Data validation for cell entries
- Database functions
- Summarizing data using pivot tables
- Circular references - practical considerations
Tables and Pivot Charts
- Dynamic 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
- Establishing connections to databases or XML files
- Online data analysis via Web Queries
Analytical Tools
- Goal Seek functionality
- Analysis ToolPak add-in
- Scenarios and Scenario Manager
- Solver and data optimization
- Macros and custom function creation
- Recording and starting 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 calculations
- Nominal and effective interest rates
- Cash flows
- Depreciation
Trends and Financial Forecasts
- Trend types and functions
- Forecasting techniques
Securities
- Rate of return
- Profitability
- Investing in securities and risk assessment
Requirements
Requires a solid understanding of Microsoft Excel. Basic knowledge of finance is also recommended.
14 Hours
Testimonials (1)
active interaction between trainer and participants