Hiya,
If you meant the tabs that have - Introduction & Overview, Extremely Flexible - and so on and so forth then this is done using Javascript (jQuery). Not too sure of the exact name for it I think it is just a tabbed interface.
This can definitely be done in conjunction with ExpressionEngine but it isn’t a built-in option as such. Basically if you can build it using standard HTML and javascript then this can be integrated into ExpressionEngine in your templates.
Some links to tabbed interfaces are :
jQuery Documentation
jQuery UI Tabs
jQuery For Designers - jQuery Tabs
ID Tabs
There are a lot lot more out there and I’m sure other users in these forums will have some great links to others as I don’t generally use this sort of effect but hopefully those will provide a starting point. You could also peek into the source code of the main index page of this site to see how it was done too 
Best wishes,
Mark