Pleased that worked.
As I said in my first post, Fedora, and indeed most distributions these days are built on the assumption of Internet Access. You can usually install software other ways but unless you are lucky it rapidly becomes such a nightmare that getting internet access is seen as a small price to pay.
However you can get software in other ways, the first problem is that some software - ndiswrapper is just one example - is packaged by the fedora maintainers in a way that is slightly different to the way you would be able to install it easily for yourself and so you may just find that using the methods below will still give you a non-functioning install.
Some but not all packages when you install them yourself will not put icons in the start menu for example and you have to add those manually.
The main other methods of getting software are:
download rpm's manually from the fedora and associated repositories. When you have you should be able to right click on them and select "open with" and "Software Installer". The problems are that packages are often not stand alone and as soon as you try to install demand some other package, so you get that, and find you need a third......... This is called "dependency hell", each package depending on another. This is automatically dealt with when you install such packages from the internet.
download other rpm's. The Opera browser is available as a stand alone rpm which is dealt with as above, but as it is stand alone there are no dependencies to worry about.
bin files. Google Earth for example can come as a bin file and for that there is generally a command to issue to install it.
tar and tar.gz files are just compressed files as is a zip file in Windows. Those you would usually right click on and select "Extract Here". There would usually be a readme file included in the extracted archive detailing what to do next. It's usually something like ./configure, ./make. and ./install issued as three separate commands but I wouldn't want to try without reading the readme.
I'm lucky enough to have an internet connection and so don't have to worry.
I can't guarantee to be able to help, but if you have trouble with a specific example post back and we'll see what we can work out.