A brief introduction to Pivot Tables, explaining what they are and why you might want to use them.

Using a scaffolding technique to build complex formulas in Excel

I am the first to admit that when it comes to Excel, I don’t know it all. Hard to believe, I know (LOL!!) I’ve had students who don’t seem to believe that. Like any good instructor, I can appear to walk on water from time to time. It’s all illusion, though, trust me. There’s a quote I’ve always liked: Any sufficiently advanced technology is indistinguishable from magic. - Sir Arthur C. Clarke That’s why I sometimes seem magical to my students. I’m using the sufficiently advan