There are links to eleventy million pages explaining how to install modules in your home dir here
. Of them all, these days I recommend using local::lib. At least, I do on Unix. No idea how well it works on Windows.
To install without internet access you'll need to get the distribution (the Some-Module-1.234.tar.gz) file or its contents onto the machine. Untar it, then ...
Adjust as necessary for other CPAN clients. These days cpanminus is probably the best choice.
Installing dependencies can be a gigantic pain in the arse if you don't have internet access (or you don't have a copy of the CPAN already on the target machine). If you have lots of dependencies, then I suggest that you build another machine similar to the target - same OS, same word length - which could be a virtual machine on your desktop which *does* have internet access, and build all your modules there. Once that's done, copy the results to the target machine and hope for the best.