I have a short trip here to Solidworks World so doing everything to maximize. That means hitting up each of the events listed on the press agenda for Sunday. First up, the Solidworks 2014 Demo, put on by Ian Hogg, which is hopefully a showcase of the many new features that those beta testers have […]
Solidworks Worlds, an annual summit of engineers, designers, resellers, and press, is going off this week in San Diego. With their headquarters in chilly Massachusetts it should come as no surprise that the good people of Solidworks have picked a beautiful Southern California city to play host. The Convention Center along the harbor, and bordering
Sun, Happy Hours, and Solidworks… Must Be Solidworks World Time Again Read More »
With the recent news coverage surrounding the 3D printing industry, Mediabistro’s Inside 3D Printing Conference and Expo, taking place at the Javits Center on April 2-4, is set to be an unmissable event, featuring new product demonstrations, exhibitions, panel sessions, and keynotes. I personally attended last year’s event and had a wonderful time while being exposed to a fantastic array
3DEngr.com Joins Inside 3D Printing Conference in NYC April 2-4 – Get 15% OFF Read More »
As both an engineer and a marketer I have found myself working a great deal in and with Microsoft Excel. Over time I have learned many tricks and workflows that are useful, some of which have saved me hours. The best resource for picking up new tricks has been friends and colleagues because they have
Paste As Value When pasting excel data the default option is to paste the contents of the cell. For formulas that means the actual formula, and not the result of the formula, will be pasted. Often a pasted fomula will cause an error or simply reference the wrong location (absolute functions with the $ included
When inputting lists into Excel there is often a need to have a unique instance of every list item. For example item numbers or product names are very important to avoid confusion. Sequential serial numbers can be done with a formula but logical numbers (first digit denotes product category, second digit is subcategory, third and
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
