Excel

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…

I ran across a new variation on hidden characters. In the past, I have written about invisible characters such as an “insert line” in this post. I wrote about how to use the function “code” to get at the hidden character and how to use function “char” to create that hidden character. I also may have…