In need of software tutorial books

Hey, guys.

I'm in need of some recommendations. I'm working with large databases in Excel and I have to find a way to make some reports easier and less time consuming that when doing it on my own ways. So what I decided is to learn a little bit of what the Office applications offer (namely excel but if the others work well the better) and also to create a program/software/script that would let me do some tedious and repetitive work faster than doing it manually as I currently do them.

So in the end, I'm asking you guys for recommendations on good books in MS Office and C++ (or visual basic...whatever windows run or if you have a better recommendation, even better) because I lack experience in coding and I don't know even where to start when using the help menu. So any pointers would be really appreciated.

 

It's hard to find books on coding for Excel. I tried some time ago and failed...you can find internet resources however. The best way in my opinion is to experiment, that is how I got into the coding thing (macros, not scripts). It's easy to create a simple macros using the Record function and then take a look at the coding of the sheet. The recorder does the initial coding for you and then if you want to expand it, it's a matter of copy/paste of the lines and chaning the cell numbers.
Here's a link that you may find helful: http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

Hit up the library, tons of tutorials books

 

Thanks, the thing is I don't live in the US so libraries here aren't really up to date. Besides, I want to purchase books so I can check them up later on. I already have a pdf tutorial I found somewhere but lacks examples and I find it tiresome to be switching from Adobe to Excel and back and forth. That's why I chose to look for books. I also want books on Photoshop or mainly photoediting whether is Photoshop, Corel, or ACDsee or whatever. Let's just say I want to cram up as much as necessary.

So to summarize:
Book on MSOffice (Excel specifically).
Book on coding (C++, Visual Basic, Java).
Book on Photoediting (Adobe Illustrator, Photoshop, or Corel).

 

There are lots of books and tutorials online, but my suggestion is your local public library.



Cheers,
Mike

 

I suggest you focus on Visual Basic for Applications (VBA) so that it will work directly from within Excel.
Sorry I don't know what books are good