Log in
Follow us
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.
Could you imagine your workplace without Microsoft Excel? Absolutely not.
Excel is the language of business from corporate offices on down to manufacturing facilities. When a firm hires a new employee, it is assumed they are 1) breathing and 2) have acceptable Excel expertise.
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 »
Macros.
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.
Tip#3: Macros
According to Wikipedia, […]
Hi guys.
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 »
