1) No, there isn't unfortunately. There's a good chance that the training mission is the last one you're missing.
2) You can attain all multiplayer achievements in social matches with bots. I don't think there are any achievements exclusive to ranked matchmaking. If there are, it would say so in the achievement description.