Excel Database Training Course

Excel Training Courses London
Expert Excel Training Course Provider
 
 
line decor
Our Expertise: Excel Training Course in London | Advanced Excel Training Courses | VBA Excel Training Course | London's Best Excel Training Courses
line decor
 
 
 
 
 
 

Excel Database Course London

Our Excel Database Training Course is designed for users whom primarily use Excel to manipulate and extracts of data from servers. The Excel Database training course will focus only on using Excel List Management tools. If you wish to add other content from any of our other Excel Training Courses, thats no problem. All of our Excel trainers are experienced and qualified to take your Excel Database training course into any direction as required.

Excel Database Training Course Information

Duration :
   Our Excel Database training course is a 1 day course. The course will start at 09:30 and run until 16:30 to 17:00
Venue :
   We can run your Excel Database training course in London either at our Excel Training center in the City or on-site at you office. We can even provide the training equipment if you do not have a dedicated IT training room
Dates:
   We run the Excel Database training course when you need it, not to a predefined schedule. That means your team can decide a date that is suitable for all.
Cost :
  

We have a unique pricing structure for our Excel Database training course. We charge per day, not per delegate which means last minute changes to your Excel Database course is not affected.

1 to 1 training = £450 per day*. The Excel Database course will be tailored to your exact needs and you will not be help up (or holding up) other users on your Excel Database Course.

2-8 delegates = £695 per day*. If you have 8 delegates on the course, this equates to less than £100 per person. You will not find a more cost effective rate anywhere else. As mentioned on our home page, clients like Google, HSBC and many more make use of us, as we are the best Excel training course provider with a cost that won't rob your training budget

Excel Database Training Course Content

Basic List Manipulation
  • Sorting
  • Auto and Advanced Filters
  • SubTotals
  • Pivot Tables
  • Using Excel Lists
  • Using Text to Columns+
  • Using Data Form
List Functions
  • Lookup Functions including H and V Lookup, Match, Index
  • Database Functions - DSum,DAverage, DMax etc
  • Offset Functions
  • Transpose
Importing Text and CSV Files
  • Importing and Exporting of Text Files
Connecting to External Data Sources
  • Connecting to Access Databases
  • Connecting using ODBC Connections
Database Functions
  • Creating User Defined Functions
  • Using VB Functions
  • Referencing Excel Worksheet Functions
  • Calling Functions from a procedure
  • Creating Addins
XML Lists
  • Importing XML Lists
  • Reading XML Lists

Please note the above Excel Database training course content can be customized to suit your exact needs depending on your existing knowledge of Database. Feel free to contact us to help you build the perfect Excel Database Training Course. We believe that we are the best Excel Database Training Provider in London.

* All prices are excluding VAT and subject to a 5 day cancellation period. Also have a look at our Excel Training Courses from MTC
 
 
 

Contact Us
Tel: 020 7920 9500 info@exceltraininglondon.co.uk

Excel Database Training Course Offer
Book your Excel Database Training course before the 01/03/2011 and we will give you an Excel Bible free!

Free Excel 2010
Advnaced Manual!
You can now download our Excel 2010 Advanced training manual for free!
Excel 2010 Advanced Manual

If you wish to purchase the entire suit of Office 2010 manuals, please contact us

 
 
  
 
Excel Training London is part of the MTC Group of Training Providers  

Mini Site Map