In an effort to spread knowledge throughout the newsroom, those of us who are not reporters have been asked to give workshops to share some of our skills. The thing I chose to share this first time was Microsoft Excel.
As I pitched it, it was Excel 101: Starting out with the very basics, and getting as far as we could go in the scheduled half hour.
It seemed to go well. We covered:
- Basic navigation
- Cell References, relative and absolute
- Formulas, values and formatting
- Basic cell calculations
- Excel Formulas (SUM and AVERAGE)
Then we got into a real-world dataset and looked at sorting and filtering and calculations. At the very end I gave a peek at PivotTables just to demonstrate what Excel is capable of.
Here’s an Excel tipsheet (PDF) that I created for an earlier workshop that also covers these basics.