Microsoft Advanced Excel Training Course in Lagos

Developing mastery over Excel 2010 requires an understanding of each feature of Excel and its use.This MS Excel 2010 Advanced Training Course provides skill building in logical and statistical functions, importing and exporting, VBA functions, data tables,macros, analytical tools, and more.
This course in the Excel series empowers the participant to gain a
higher level of expertise in Excel. In addition, participants will learn about data validation and database functions such as DSUM. They will learn how to import and export data, and how to query external databases.

By the end of this training course, participants will:
* Use logical functions (IF, OR, AND & NOT)
* Use math & statistical functions
* Use the PMT function
* Use data functions (YEAR, DAYS360 & NETWORKDAYS)
* Calculate time
* Create array formulas
* Use VLOOKUP, MATCH & INDEX functions
* Validate data
* Use database functions
* Import & export text files
* Import & export XML data
* Use Goal Seek & Solver
* Use the Analysis ToolPak
* Create scenarios
* Run and record macros
* Edit VBA modules
* Create custom functions

New Class Start: July 28-29, 2016.
Time:9am-5pm
Duration:2days
Fee:Contact us.( Discount Available for Early Bird)

Fee Cover:

▪ Comprehensive courseware
▪ Writing materials
▪ Tea break and Lunch
▪ Certificate of course completion

Enquiries: 08168510709,08092595489
Email: [email protected]
Website: www.cedarsandoaks.com

Register Now!