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
- 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
Requirements
Good Excel, maths and basic finance knowledge may be beneficial.
14 Hours
Testimonials (4)
the clarity with which he explained the entire course, as well as the willingness to return to the syllabus when necessary
Carlos Eloy - AMERICAN EXPRESS COMPANY MEXICO
Course - Data Analytics With R
Machine Translated
I liked that the trainer made sure we all understood and were following the lectures. if we had a problem, he stopped and helped us fix it.
Cesar - AMERICAN EXPRESS COMPANY MEXICO
Course - Data Analytics With R
I really was benefit from the real life practical examples.
Wioleta
Course - Data and Analytics - from the ground up
The flexible and friendly style. Learning exactly what was useful and relevant for me.