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.

June 24th, 2010

Excelling With Excel #1 – Custom Functions Using VBA

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

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.

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 »