Microsoft Excel Advanced
Duration : 8 hours (2x 4 Hours)
OS Platforms : Windows XP, Windows Vista
Purpose :To become an advanced user of Microsoft Excel
Purpose :
To become an advanced user of Microsoft Excel
Audience :Business users who want to learn how to rapidly analyse data and build small Excel applications for other users
Audience :
Business users who want to learn how to rapidly analyse data and build small Excel applications for other users
Prerequisites : Intermediate Excel and at least 3 monts experience using Excel at that level in a business environment
Prerequisites :
Intermediate Excel and at least 3 monts experience using Excel at that level in a business environment
Content : Introduction and advanced use of pivot tablesAdvanced functions: Sumproduct, Indirect, Importing data - MS query, web queriesIntroduction to Visual Basic for Applications (VBA)Advanced charts
Content :
Introduction and advanced use of pivot tables
Advanced functions: Sumproduct, Indirect,
Importing data - MS query, web queries
Introduction to Visual Basic for Applications (VBA)
Advanced charts
Language : - English
Courses are conducted at Locii Solutions training facilities in Cyprus.
