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
- The logic functions
 - Mathematical and statistical functions
 - Financial functions
 
Search and data
- Search and matching
 - Functions MATCH (MATCH) and INDEX (INDEX)
 - Advanced management of lists of values
 - Validate the value entered in the cell
 - Database Functions
 - Summary data by using the histogram
 - Circular references - Practical Aspects
 
Tables and Pivot Charts
- The dynamic description of the data using PivotTables
 - Elements and calculated fields
 - Visualize data using pivot chart
 
Working with external data
- Exporting and importing data
 - Exporting and importing XML file
 - Importing data from databases
 - Connections to a database or an XML file
 - Analyzing data online - Web Query
 
Analytical issues
- Option Goal Seek
 - The Analysis ToolPack addition
 - Scenarios, Scenario Manager
 - Solver and optimization data
 - Macros and create your own functions
 - Starting and recording macros
 - Working with VBA code
 
Conditional Formatting
- Advanced conditional formatting using formulas and form elements (eg box - checkbox)
 
Time value of money
- The current and future value of capital
 - Capitalization and discounting
 - Interest made simple
 - Nominal and effective interest procetowa
 - Cash flows
 - Depreciation
 
Trends and financial forecasts
- Types (functions) trend.
 - Forecasts
 
Securities
- The rate of profit
 - Profitability
 - Investing in securities and risk measures
 
Requirements
Requires good knowledge of Microsoft Excel. Basic knowledge of finance is also indicated.
             14 Hours
        
        
Testimonials (4)
The communication with Fernando has been very clear and open.
Carlos Ernesto Martinez Munoz - Bienes Programados S.A. de C.V.
Course - FinOps
Machine Translated
Personal service and orientated to my needs
ANN - New Vitality Clinic
Course - GnuCash for Business Accounting
The lecturer is very knowledgeable and can substantiate theories with his own personal experiences.
Harry Estipona
Course - Financial Markets
I was benefit from the interesting and clear ideas and suggestions.