ICT Application in Data Management (SEMIs)
dc.contributor.author | Nyang'anga, Hillary | |
dc.date.accessioned | 2018-07-30T06:51:05Z | |
dc.date.available | 2018-07-30T06:51:05Z | |
dc.date.issued | 2018 | |
dc.identifier.uri | http://hdl.handle.net/11295/103497 | |
dc.description | Many Excel experts believe that pivot tables are the single most powerful tool in Excel. According to Bill Jelen (a.k.a. Mr. Excel) "No other tool in Excel gives you the flexibility and analytical power of a pivot table". I agree completely. Excel Pivot Tables are fun and powerful. So, in no particular order, here are some things you should know about them. 1.You can build a pivot table in about one minute 2.Perfect your source data 3.Count the data first 4.. Plan before you build 5.Use a table for your data to create a "dynamic range“ 6. Use a pivot table to count things 7.Show totals as a percentage 8.Use a pivot table to build a list of unique values 9.. Create a self-contained pivot table etc | en_US |
dc.language.iso | en | en_US |
dc.publisher | University of Nairobi | en_US |
dc.rights | Attribution-NonCommercial-NoDerivs 3.0 United States | * |
dc.rights.uri | http://creativecommons.org/licenses/by-nc-nd/3.0/us/ | * |
dc.subject | ICT; Data Management | en_US |
dc.title | ICT Application in Data Management (SEMIs) | en_US |
dc.type | Presentation | en_US |
Files in this item
This item appears in the following Collection(s)
-
Presentations [489]