Opera Wand is a very good password manager..........I would be lost without it as I constanly forget my log-in details and passwords..
Assuming for the moment that you have never used the Wand, opwn a site where you need to log in and enter the required data into the site....a narrow yellow ( in my case...in may be a different colour if you have a different skin ) band will open along the top of the page asking if you want that data remembered, say yes or save to that by clicking the appropriate box on that yellow band........that saves it into the Wand password manager.
The next time you want to go to that site, no need to enter detail.....just click on the Wand icon and the detail will be fed in and you will be auto logged in........when you open a site where you have already entered data to the Wand it will become highlighted...if you have not previously entered data or if you are already logged in it will stay greyed out and sulking.
Where is the Wand icon, I hear you cry.....well, it used to look like a little wand but now it is a little horizontal key which should be sitting next to the icons for home, reload, back and forward etc.
If that icon is not there go view>toolbars>customise>buttons>browser and in there you will find all the available buttons. Look for a little key icon with the word "log in" and simply drag and drop that to your preferred location on the toolbar.
To see what if any passwords/log in detail you have loaded into Wand go tools>preferences>forms>password manager.
Have fun...
Edit to add.....
In order that the Wand can apply the correct log-in details to the correct site, that site and your browser must recognise each other, so it is important that you set your browser to accept cookies. toole>preferences>advanced>cookies (Mine is set to "accept cookies only from sites that I visit")