These workshops cover the basic concepts of using an Excel workbook for organizing data and doing simple calculations. Great for an introduction or refresher, and especially good if you want to get on sure footing for the more advanced workshops in January.
Excel Formulas and Functions
Mac – January 8, 2014 – 10 a.m.
Windows – January 10, 2014 – 10 a.m.
Get a good handle on some of Excel’s more useful features. We guarantee that at least one thing in this class will prove a time-saver for you.
Learn how to:
- Import data from a text file
- Use Filters to sort and limit your view of your data
- Have Excel add automatic subtotals
- Copy or re-use a formula
- Have that copied formula do what you actually want it to: learn about absolute vs relative cell references.
- Use conditional formatting to have cells with certain values automatically look the same.
- Use Functions to quickly answer complicated questions like “How many students do we have from Connecticut, and how many of them live in Dakin?” or “How many orders did I place that were over $500 between July and October of last year?”
- Split text in one cell into two cells (for example, separate out first & last names), and combine text in two cells into one cell.
Excel Pivot Tables
Mac – January 16, 2014 – 10 a.m.
Windows – January 17, 2014 – 10 a.m.
Q: What are pivot tables?
A: Tools in Excel that automatically summarize your data. They let you see the “big picture” and are easily adjustable to provide different ways of looking at your data.
Q: Why would I care about them?
A: Because they allow you to answer complicated questions in a snap. Quick: How many orders did you place with Staples last year? And what was the total of those orders? And how many orders per month did you place? And what was the average per month of those orders?
If you have information you want your data to provide, pivot tables will give it to you quickly and easily. They will save you time, and they just might change your life!
RSVP to email@example.com