Excel

This is a continuation of a prior post but this time, I will talk about a really interesting kind of macro that I have recently been learning. I knew that you could record macros, you could have a button for starting macros, you could use ctrl+key to start a macro, you could have a macro…

I’ve been working on a set of new projects – some of it pertains to gathering data and performing analysis and some of it requires a bit of automation. The analytical piece is not done and probably will be ongoing. The analysis is only at the beginning stage so there is not much to relay…

In the last post, I mentioned that there was a problem with the random technique that I was doing. There are two problems: I figured out one problem – more or less – but haven’t figured out the second problem. The first problem is the fact that every time you enter something, the spreadsheet will…

Earlier this week, my boss and I were reviewing on the status of our automation project. We were really pleased at how everybody was coming along on the report, even figuring out what to do when errors popped up. It’s such a good feeling to see it come along so well. There were just a…

I’m working on a new project that entails a lot of data which unfortunately Excel does not handle well – not on top of all of the formulas I need to use to generate categories and analyses, plus the pivot tables. Eventually, I scrunched the data down to just what my boss needed but then…