Databases by nature are intended to hold a lot of information, often they contain entries for different instances of very similar information. This means when even a small thing changes it has the potential to be a replicated change in a number of areas. Of course there are also regular reports that are output in […]
Record a Macro to Capture Keystrokes – Excel Tip Read More »
For complicated excel formulas there are often “What-If” scenarios. Questions such as “How many do we have to sell to make $1,000,000” and “How long until we run out of inventory”. Excel has a helpful built in tool that lets you define what you want the outcome of a formula to be. By showing excel
There are two easy ways to highlight every other row or column in a worksheet, which makes it much easier to read mind-numbing rows of data. Mind-Numbing hard to follow rows The first method is to highlight the necessary cells and find “Format As Table” on the toolbar. Choose the style of table and then
One of the most useful things about Excel is that you can navigate everything without having to move to a mouse. When working in the program a lot knowing a variety of hot keys greatly reduces speed and can also help maintain focus (which we all know is required for mind-numbing data sets). An amazingly
There are tons of times where inserting an image helps make a spreadsheet of data look more professional and function much better. Getting the right image can be a bit cumbersome, but knowing the tools included can go a long ways. Built into Excel is a very useful feature that lets you take a screenshot
When adding text and headers to spreadsheets things can get tricky. Often the data in the cells below the header cell are only a few digits, but they need a lot of explanation. This can create columns that are very wide for no real reason (other than that they have long titles). There are a
Alt + Enter For New Line in Excel Cell – Excel Tip Read More »
A few months ago I backed the widely popular kickstarter campaign for the 3Doodler, a hand-held “3D Printer”. The team at Wobble works surely got what they asked for as the project surpassed their funding goals by more than $2.3 Million. With a total of 26,000 backers fulfilling the campaign certainly had to be a
There are plenty of kit 3D printers out there that can make things out of everything from chocolate and sugar to plastic…. and now metal. A team at Michigan Tech managed to turn a traditional delta style printer on it’s head and combine it with a MIG Welder to create a device that can be
This article is a guest post by Jim Lucas A few confessions of a competitive guy that has average intelligence and mediocre athletic abilities: In my college organic chemistry lab, I would increase the quantities of the ingredients, because a component of our grade was the overall “yield” of lab work. In lacrosse, I kept a
This article is a guest post by Jim Lucas First week of training is done. When I first started, I had the youthful optimism that, with a little work, I might be able to sweep the Model Mania top award easily. It doesn’t appear that will be the case. My times are all over 10
