Wow... that is a rather large order.
Mechanica is a FINITE ELEMENT ANALYSIS environment. To oversimplify, that means that there is a generated spring/damper matrix between nodes. The spring/damper matrix is solved as a system of equations..... a very large system of equations.... one that excel could not even contain, much less solve "in a few seconds".
The whole idea of finite elements is to break down whatever structure is under consideration to small enough parts that relatively simple equations (spring/damper) will approximate reality closely enough to be useable. In order for the analysis to be useable, there has to be many parts... hence, the use of computer.
There is no function of a fastener, any more than there is a function for a bridge.
I recommend taking a course in finite element theory. Short of that, you might start with the wiki on the subject. ANSYS used to have quite a bit of information publicly available... perhaps it is still there.
After a few hours, perhaps you will begin to understand what you just asked for.
A man somewhat smarter than me once said "All analyses are wrong, it is the engineer's job to understand how wrong". (Or something like that) The idea of a hand calc is not to duplicate the work that FEA just did. It is an alternate method to arrive at a simplified answer for the purpose of checking the validity of your model.
Enjoy your lab.