You can’t make document changes more convenient than editing your xls files online. With DocHub, you can access instruments to edit documents in fillable PDF, xls, or other formats: highlight, blackout, or erase document elements. Include text and pictures where you need them, rewrite your copy entirely, and more. You can download your edited file to your device or submit it by email or direct link. You can also turn your documents into fillable forms and invite others to complete them. DocHub even offers an eSignature that allows you to certify and send paperwork for signing with just a couple of clicks.
Your records are securely stored in our DocHub cloud, so you can access them anytime from your desktop computer, laptop, mobile, or tablet. Should you prefer to use your mobile device for file editing, you can easily do so with DocHub’s app for iOS or Android.
(playful cartoon music) Letamp;#39;s take a look at Excelamp;#39;s INDIRECT function. Now INDIRECT is a bit of a strange function and it takes a little bit of time to get the hang of. But itamp;#39;s very useful because it can easily handle cases where you have different ranges that you need to feed other formulas. Let me give you an example. Here I want to get the total revenue depending on the year that I select. Just have two years in this example of the divisions that I have listed here. Now the tricky part is, my data is not set up in one single data table and one single tab. Itamp;#39;s actually split between two different tabs. So this tab is for 2016 data only and this tab is for 2017 data only. You can see I formatted my table as an official Excel table and this one is called datapy for previous year and the other one is called datacurrent. So what I want to do is to get the full revenue depending on this. Itamp;#39;s a condition, right? The formula I would be using is
