AndyTampa
Board Regular
- Joined
- Aug 14, 2011
- Messages
- 199
- Office Version
- 365
- 2016
- Platform
- Windows
I was recently put in the position at work to take over some of the daily and weekly reporting. That entails taking data from several workbooks that I get in email and putting that data into a workbook that then gets emailed to a bunch of people.
I would like to take some of these repetitive operations and automate them. For that I need to learn more about Excel Functions, macros and VBA.
Work is not going to buy a book for me to do this and I have very limited funds. I understand the basics of Excel and am very good with formulas. I haven't used macros since they were simply recorded keystrokes in Lotus 1-2-3. Every time I update the report, I add a column, so the charts and graphs have to be adjusted for the last 'x' columns each and every time.
Here's what I need to learn, as far as I know so far:
Excel Functions -- (what each one does and how to properly choose the variables/ranges)
Macros
Charts and Graphs
Dynamic Ranging -- (This is a new concept that I only heard about in this forum and I believe it might be useful for the charts and graphs.)
VBA
If I can only afford to get one book, which book should I get? I've seen several recommendations in this forum and that only confuses me more.
Ultimately, I want to get to the point of creating a single workbook with enough programming to ask me for information it needs or data that can't be harvested by it (like the three pieces of information I get in a PDF) and then create the report in mere minutes instead of hours.
I also found a site with examples of interactive dashboards that were awesome. Dashboards had scroll bars so you could scroll back in history. You could select which data you wanted to see details about. That would be a feather in my cap if I could get that far.
I would like to take some of these repetitive operations and automate them. For that I need to learn more about Excel Functions, macros and VBA.
Work is not going to buy a book for me to do this and I have very limited funds. I understand the basics of Excel and am very good with formulas. I haven't used macros since they were simply recorded keystrokes in Lotus 1-2-3. Every time I update the report, I add a column, so the charts and graphs have to be adjusted for the last 'x' columns each and every time.
Here's what I need to learn, as far as I know so far:
Excel Functions -- (what each one does and how to properly choose the variables/ranges)
Macros
Charts and Graphs
Dynamic Ranging -- (This is a new concept that I only heard about in this forum and I believe it might be useful for the charts and graphs.)
VBA
If I can only afford to get one book, which book should I get? I've seen several recommendations in this forum and that only confuses me more.
Ultimately, I want to get to the point of creating a single workbook with enough programming to ask me for information it needs or data that can't be harvested by it (like the three pieces of information I get in a PDF) and then create the report in mere minutes instead of hours.
I also found a site with examples of interactive dashboards that were awesome. Dashboards had scroll bars so you could scroll back in history. You could select which data you wanted to see details about. That would be a feather in my cap if I could get that far.
