This fall we’re featuring some of our top posts of all time. This great Excel series, which starts with the post below, is a perennial favorite. Check it out If you’ve not yet had the pleasure. Keep an eye out for more all-time favorites through the end of the […]Read the rest of this entry »
Excelling With Excel
Learn about custom functions using VBO, pivot tables, macros, and indirect references as chemical engineer Todd Krueger shares his Excel expertise with the ChEnected Community.
When I say “pivot table”, what comes to mind? For me, I think of cardboard boxes. However, if you’re like most humans, you’re probably drawing a blank right now.
This is unfortunate because pivot tables are awesome. Awesome in general, but more specifically awesome for processing large flat tables of data.
.. […]Read the rest of this entry »
To many, this term is shrouded in mystery. Between the ‘hard problem’ of consciousness and talking cats, does this world really need another unsolved mystery? I don’t think so. For this reason, I, Greg the orange cat, have chosen macros as my third Excel tip.
According to Wikipedia, […]
It’s Greg the orange cat again with a (very short) Microsoft Excel tip.
Tip#4: Indirect References
Much of Excel’s usefulness comes from an ability to reference cells in formulas. In this case, the cells themselves function as variables.
Indirect referencing allows you to go one step further, allowing you to put a […]Read the rest of this entry »