No, there isn't an Excel function that can do this.
Factor Analysis is difficult in Excel, you would be better off using a Statistics Programme - for example SPSS or Stata however this type of Software is very expensive if you are not a professional user.
R is worth trying for this sort of application and is free.
I haven't got any suitable data to create output from SPSS that I can post but here's what you do to get it:
Run Factor Analysis (Analyze>Dimension Reduction>Factor) and check the box for”KMO and Bartlett’s test of sphericity.” If you want the MSA (measure of sampling adequacy) for individual variables, check the “anti-image” box. An anti-image box will show with the MSAs listed in the diagonals.
The test can also be run by specifying KMO in the Factor Analysis command. The KMO statistic is found in the “KMO and Bartlett’s Test” table of the Factor output.
This is what SPSS Help says under Factor Analysis Scores:
Bartlett Scores. A method of estimating factor score coefficients. The scores that are produced have a mean of 0. The sum of squares of the unique factors over the range of variables is minimized.