お問い合わせを送信いただきありがとうございます!当社のスタッフがすぐにご連絡いたします。        
        
        
            予約を送信いただきありがとうございます!当社のスタッフがすぐにご連絡いたします。        
    コース概要
Advanced functions
- Logical functions
- Math and statistical functions
- Financial functions
Lookups and data tables
- Using lookup functions
- Using MATCH and INDEX
- Advanced list management
- Validating cell entries
- Exploring database functions
PivotTables and PivotCharts
- Creating Pivot Tables
- Calculated Item and Calculated Field
Working with External Data
- Exporting and importing
- Exporting and importing XML data
- Querying external databases
- Linking to a database
- Linking to an XML data source
- Analysing online data (Web Queries)
Analytical options
- Goal Seek
- Solver
- The Analysis ToolPack
- Scenarios
- Macros and custom functions
- Running and recording a macro
- Working with VBA code
- Creating functions
Conditional formatting and SmartArt
- Conditional formatting with graphics
- SmartArt graphics
要求
Good Excel, maths and basic finance knowledge may be beneficial.
             14 時間
        
        
お客様の声 (3)
I learned new things so that is a good point
Daria - LKQ Polska Sp. z o. o.
コース - Analysing Financial Data in Excel
many exercises
Julia - LKQ Polska Sp. z o. o.
コース - Analysing Financial Data in Excel
The tips for many of the functions that the trainer presented, which we can easily remember and implement in our future work
 
                    