You can’t make document modifications more convenient than editing your spreadsheet files on the web. With DocHub, you can get instruments to edit documents in fillable PDF, spreadsheet, or other formats: highlight, blackout, or erase document fragments. Include textual content and images where you need them, rewrite your copy entirely, and more. You can download your edited record to your device or share it by email or direct link. You can also transform your documents into fillable forms and ask others to complete them. DocHub even has an eSignature that allows you to certify and send paperwork for signing with just a couple of clicks.
Your documents are securely stored in our DocHub cloud, so you can access them anytime from your PC, laptop, mobile, or tablet. Should you prefer to use your mobile phone for file editing, you can easily do it with DocHub’s mobile app for iOS or Android.
all right so slicers are finally here so lets take a look at them and see what we can do with this to use a slicer lets start by building a pivot table from this data set so if I quickly just take a look here if I do control down or command down see we have 1400 lines so were gonna do a quick pivot table out of this going under data Im gonna do a pivot table Im gonna put it on a new worksheet thats fine to make sure this pivot table updates going forward I will just unselect this and as a data range Im gonna select the entire column going down Im gonna hit OK and create again so to build the pivot table Im gonna go on their values here Im gonna add sales as values and Ill go on the rows and do sales reps as rows and to get rid of this blanks because we selected the whole column Im gonna scroll down here and under filters - sales rep and as a filter I will filter by condition and instead of none I will select is not empty ok that should take care