This site under reconstruction.
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…
I’m going to try something new here. A couple of weeks ago, someone was questioning my calculations of averages and it got me thinking: why use weighted average rather than average? I think most people understand the use of averages but I am not so sure they understand weighted averages. The concept of weighted average…
You must be logged in to post a comment.