The tutor opens the discussion about how to display, automatically, a cell’s content according to its value. What if, in Excel, you want to display any value between 78 and 93 in green? Well, you can, using conditional formatting. On …
The tutor attempts to explain a possible misunderstanding. A few days ago I posted about buying my kids each a 16GB flash drive by PNY. Today I showed my younger kid how to access it on Windows (he’s used to …
Home computer use: why 16GB might become 14.8GB from the computer’s point of view Read more »
The tutor shares a trick he just learned. While I use and even program computers, I lack knowledge of the everyday tricks a typical office worker or middle school student might know. People who use computers in group settings learn …
The tutor points out an elegant feature of spreadsheets. Formulas in Excel default to relative referencing. Consider the following illustration: Let’s imagine you input 101 in cell e10. Then, in f11, you input the formula =e10. Of course, when you …
The tutor reflects on the coming and going of operating systems. As I’ve mentioned, my household has numerous computers. Two are Windows 7, two are Linux, and one is XP. My wife and I also have Nexus 4 phones. While …
The tutor points out a handy hint that will be obvious to spreadsheet veterans, yet perhaps very useful to beginners. Let’s imagine you’ve entered a city name in a cell: Medicine Hat, Alberta. However, you notice you mistyped the name: …
The tutor points out how a spreadsheet can show holiday awareness. Most holidays, such as Valentine’s Day, Halloween, or Christmas, happen on a set date. However, Easter is different. As a child, I overheard it’s the Sunday after the first …
Continuing about css3 gradient effects, the tutor discusses some of the browsers that do or don’t support them. In my previous two posts (here and here), I’ve been talking about the css3 gradient effect. I’ve acknowledged that not everyone viewing …
Web design: css3 gradient, part III: browser support Read more »
The tutor shows how to use a spreadsheet (Excel) to compute a recursive deduction rate using a circular reference. In yesterday’s post I brought up an example in which a deduction depends upon the income minus that same deduction. It’s …
Spreadsheets: Excel circular reference: recursive deduction calculation Read more »
The tutor shows an example of naming items in a spreadsheet for use in a formula. This post focuses on Microsoft Excel; hopefully I’ll do a similar one for a generic spreadsheet soon. Let’s imagine Jones faces two tax rates: …