Learning Excel through Football

December 12, 2017

Market Dojo have put together a learning spreadsheet to help procurement professionals gain a better understanding of excel. This spreadsheet uses premier league, international and club football data to provide engaging educational statistics.

Included in the spreadsheet is:

Basic Excel Formulas – SUM, Average, Min/Max, Count etc

Intermediate Excel Formulas – IF & IF(AND)

Text Excel Formulas – TRIM, Concatenate etc

Excel Lookups – Standard Lookups & VLookups

Conditional Formatting Rules

Pivot Tables – Layouts, filters etc

Graphs – Editing graphs, Trendlines, Combo Graphs etc

Macros – Turning on macros and creating macros

You can download the spreadsheet here on our resources page under miscellaneous.

In the modern age of data, being able to decipher large amounts of data can be invaluable in both saving you time and analysing data in new ways. Whether you trying to formulate data into an importable file or simply improve your employability.

We believe that having a good understanding of Excel is essential for the modern day procurement professional. Without being able to use Vlookups or create conditional formatting rules you would struggle to organise and interpret large volumes of data that is crucial in modern roles.

This spreadsheet isn’t meant to be a thorough understanding of all the different aspects of Excel. However, if you have anything else that you believe should be included just get in contact and we will do our best to include in an amended version.

For more information on tools that can help procurement professionals get the most out of their activities go to www.marketdojo.com

Market Dojo helps procurement professionals negotiate better with our on-demand eSourcing tools. If you’d like to find out more, get in touch or register for free and play around with our software for yourself!

Get A Demo Today

Kontakt

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
Vorname*
Nachname*
Firmañía*
Telefonnummer*
Email*
Ihre Wünsche -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

Contacto

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
Nombre*
Apellido*
Compañía*
Teléfono*
Email*
Me interesa -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

Contactez-Nous

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
Prénom*
Nom*
Société*
Téléphone*
Email*
Interessé par -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

tr , td { padding:6px; border-spacing:0px; border-width:0px; }
Consultation Call
First Name*
Last Name*
Company*
Phone*
Email*
I'm interested in -None- eSourcing/eAuctions Supplier Information Management Contracts Management Savings Tracking Opportunity Analysis Quick Quotes Supplier Collaboration
Lead Gen -None- Demo form Consultation call form Landing Page form Demo Form Spam
Lead Source -None- Advertisement Adwords Web Research Online Social Networking Live Chat Lecture/Talk Professional Org Public Relations Seminar-Internal Seminar Partner Trade Show Network Event Employee Referral External Referral Partner Agent Reseller Cold Call Registration Chat AR Contact NM Contact ND Contact Existing Customer Gov Website Google AdWords Facebook Twitter
Lead Source Detail
var mndFileds=new Array('First Name','Last Name','Company','Email','Phone'); var fldLangVal=new Array('First Name','Last Name','Company','Email','Phone'); var name=''; var email=''; function checkMandatory() { for(i=0;i<mndFileds.length;i++) { var fieldObj=document.forms['WebToLeads232068000023635057'][mndFileds[i]]; if(fieldObj) { if (((fieldObj.value).replace(/^\s+|\s+$/g, '')).length==0) { if(fieldObj.type =='file') { alert('Please select a file to upload.'); fieldObj.focus(); return false; } alert(fldLangVal[i] +' cannot be empty'); fieldObj.focus(); return false; } else if(fieldObj.nodeName=='SELECT') { if(fieldObj.options[fieldObj.selectedIndex].value=='-None-') { alert(fldLangVal[i] +' cannot be none'); fieldObj.focus(); return false; } } else if(fieldObj.type =='checkbox'){ if(fieldObj.checked == false){ alert('Please accept '+fldLangVal[i]); fieldObj.focus(); return false; } } try { if(fieldObj.name == 'Last Name') { name = fieldObj.value; } } catch (e) {} } } }

GET IN TOUCH

Test