list how many people are in each department) list every sales person who grossed > 100k last quarter) list employees grouped department and role) Sort records based on a combination of fields (e.g.It’s one of those areas where spreadsheets overlap with databases. Categories/Pivot tables? What’s the point?Ī pivot table lets you group, summarise and filter tables of data in a spreadsheet. If you don’t want to step through it, there’s a link to the Numbers spreadsheet at the end. Oh yes, you also might learn some handy new spreadsheet skills. I’ll show you how, and you can find out what your chances were. Categories works well, and it allowed me to download a dataset from the Internet and do something meaningful with it. Was Numbers up to forecasting my fate? As it turns out, it is. If by some chance of fate, I were flung back in time on to the doomed ship, what would my chances be of surviving? I decided to give the feature a whirl by analysing the passenger list of the Titanic. Apple (for reasons that escape me) call pivot tables categories. The company has now added pivot table functionality, which helps make sense of data. Apple Numbers and the Titanic (illustration by author)Īpple Numbers, free with any of its phones, tablets and computers, is often sniggered at, but Apple is continually adding features to what is a friendly and capable spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |