An office manager has won a £37,000 payout after her boss told her she used the menopause as an "excuse for everything".