Tuesday, February 28, 2012

SharePoint 2010 Administration

This exam which is a requirement for many a Gold Partner to get the SharePoint Fast software included in their Partner package is an interesting one.
According to one of our guys who passed the second attempt:
It was quite scenario based is what he said.

So there are four main areas, but what is is really that we need to do to pass?
a) One needs to be able to plan therequird hardware as well as how what needs configuring inside SharePoint
b) Then there is the deployment - and there are various ways to do this
c) Then there is a maintence, monitoring and backup/restore strategies
d) Finally there is the all imortant search, content management and Business Intelligence side of things.

#

Excel Chart - Line Chart Marker Styles

Sometimes clients want various settings for their line charts.

The markers on their line charts can be circles, squares, crosses etc

Today we'll just focus on the four main styles

The VBA code is ActiveChart.SeriesCollection(1).MarkerStyle = 1
And you would loop through each series collection.

So the critical numbers are:
None --> 0
Square --> 1
Diamond --> 2
Triangle --> 3
Circle --> 8