Browsing for a specialized tool that handles particular formats can be time-consuming. Regardless of the vast number of online editors available, not all of them are suitable for Excel format, and certainly not all enable you to make adjustments to your files. To make things worse, not all of them provide the security you need to protect your devices and documentation. DocHub is an excellent solution to these challenges.
DocHub is a well-known online solution that covers all of your document editing needs and safeguards your work with enterprise-level data protection. It supports different formats, such as Excel, and enables you to edit such paperwork easily and quickly with a rich and user-friendly interface. Our tool fulfills important security certifications, such as GDPR, CCPA, PCI DSS, and Google Security Assessment, and keeps enhancing its compliance to provide the best user experience. With everything it provides, DocHub is the most reliable way to Slide period in Excel file and manage all of your personal and business documentation, no matter how sensitive it is.
Once you complete all of your alterations, you can set a password on your edited Excel to make sure that only authorized recipients can work with it. You can also save your document containing a detailed Audit Trail to find out who made what edits and at what time. Select DocHub for any documentation that you need to adjust safely. Subscribe now!
hi Im Mindy Tracy from my online training hub in this tutorial going to look at how we can create a slicer that allows us to filter for a rolling period now my rolling period happens to be the last 12 months or older than the last 12 months but yours could be any period you like now unfortunately we dont have any way to automatically filter by rolling periods in tables and pivot charts so what we need to do is add a field to our source data mine is on this sheet here and Im going to put it into column C so the way well do this is I need to classify every date in column a into a period whether thats the last 12 months or older than the last 12 months now my dates are in day month year format and Ive just got some stock trading volumes that were analyzing so what well do is in column C well put an if formula in that compares this date in column a to this date in cell f1 which Ive created using the today function and all that does is returns the date from your computers clock so