Excel Dashboard

Excel dashboards are excellent way of presenting data... 

Here are few dashboards we can use.

6 part tutorial for Excel Dashboards

http://chandoo.org/wp/2008/08/20/create-kpi-dashboards-excel-1/

Match two excel files

The best tool that will help you to compare,
update and synchronize your Excel spreadsheets.

Synkronizer is an easy-to-use, yet extremely powerful, Excel tool for comparing and synchronizing Excel spreadsheets and Excel databases.

Synkronizer makes your life easier by saving your time and speeding up your data processing. It's a must-have Excel add-in for everyone from power users to beginner users.

http://www.synkronizer.com/

Extracting Text from Names using Find

Here Are A Few Examples Of How You Can Use Excels Text Functions To Extract Parts Of Peoples Names From A List. The Same Formulas Could Also Be Used On Any Text, They Don't Have To Be Names

Full Name	Formula Used	Result
A2=David Hawley	=LEFT(A2,FIND(" ",A2))	David
A3=Ray Goodwin	=MID(A3,FIND(" ",A3,1)+1,LEN(A3))	Goodwin
A4=Graeme Dee	=LEFT(A4)&MID(A4,FIND(" ",A4)+1,1)	GD
A5=Suzanne Greenhouse	=LEFT(A5)&MID(A5,FIND(" ",A5),LEN(A5))	S Greenhouse
A6=Fred Baker	=LEFT(A6,FIND(" ",A6))&MID(A6,FIND(" ",A6)+1,1)	FredB
A7=Mary Hardwick	=MID(A7,FIND(" ",A7,1)+1,LEN(A7)) & " " & LEFT(A7,FIND(" ",A7))	Hardwick Mary
A8=Banana	=LEN(A8)-LEN(SUBSTITUTE(A8,"a",""))	3 i.e occurence of "a"

http://www.ozgrid.com/Excel/TextFormulas.htm