Stop working for your data. Make your data work for you.
A visitor to the site was recently seeking information on viable alternatives to using Monarch software. Exactly what those alternatives are is a fair question, and one that should be properly addressed.
Here are just ten ways you could achieve Monarch’s results without using Monarch:
Re-key all of the data from the outputs of one system into […]
From time to time you may run into a report designed by some renegade programmer who thought that having values shift positions from line to line on the report was actually a good idea. Additionally, maybe she thought that, rather than display zero values, it would be best if the report simply doesn’t display anything […]
You can save yourself a lot of manual editing, or even copying and pasting, in Excel by using the search and replace (Ctrl-h) feature. This will replace all occurrences of one value, or even a part of a formula, with a different value.
Say you defined a lookup range improperly, setting the rightmost column to H, […]
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
| « Feb | Apr » | |||||
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | 31 | |||||
