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.

October 29th, 2014

Excelling With Excel #1 – Custom Functions Using VBA

By Todd | Comments (21)
This entry is part 1 of 4 in the series Excelling With Excel

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 »
July 8th, 2010

Excelling with Excel #2 – Pivot Tables

By Todd | Comments (3)
This entry is part 2 of 4 in the series Excelling With Excel

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 »
July 21st, 2010

Excelling with Excel #3 – Macros

By Todd | Comments (3)
thoughtful cat
This entry is part 3 of 4 in the series Excelling With Excel


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, […]

Read the rest of this entry »
July 28th, 2010

Excelling with Excel #4 – Indirect References

By Todd | Comments (2)
This entry is part 4 of 4 in the series Excelling With Excel

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 »