You can download the PSpice student version (now known as Lite Version) can be downloaded from http://www.cadence.com/products/orcad/pages/downloads.aspx#pspice
After installing these products, you can access the PSpice Tutorial from Capture >help > learning PSpice menu pick. This would launch a self based basic electronics circuits simulation examples.
You can also get a set of example design under <installdir>/tools/pspice/demo_sample/*. Navigate to different sub-folders this location and open "opj" files. This would open up ready to use design.
You can also get step by step detailed instruction on how to create and simulation design using OrCAD Capture-PSpice in PSpice user's guide. You can access this guide from <INSTALLDIR>/doc/pspug/pspug.pdf