This site under reconstruction.
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…
Late yesterday’s afternoon, I started to play around with my Excel file to develop a tool that will help me figure out my Sudoku puzzles faster and I succeeded! I actually designed something that will help me solve the easy puzzles. Please note the stress on the word easy. This file only works for easy puzzles. I’m…
This is a very short post but I did learn something new about pivot tables. I don’t know if this feature has always been present or just got implemented in Excel 2013, but it is a very, very nifty feature. And in the words of my boss, “It is big.” I learned that you can…
(Re-posting because I had trouble accessing the post. Original entry was around May 9th.) Two weeks ago, I created a cool, nifty spreadsheet to do most of the heavy lifting. Previously, I used to download 2 sets of data, one from the prior week and one for the current week, and try to look at…
You must be logged in to post a comment.