DocHub enables you to link cross in Restaurant Evaluation swiftly and quickly. No matter if your form is PDF or any other format, you can effortlessly modify it leveraging DocHub's intuitive interface and robust editing capabilities. With online editing, you can change your Restaurant Evaluation without downloading or setting up any software.
DocHub's drag and drop editor makes customizing your Restaurant Evaluation straightforward and efficient. We securely store all your edited documents in the cloud, enabling you to access them from anywhere, anytime. On top of that, it's easy to share your documents with users who need to check them or create an eSignature. And our deep integrations with Google products allow you to transfer, export and modify and endorse documents right from Google applications, all within a single, user-friendly platform. Plus, you can quickly turn your edited Restaurant Evaluation into a template for repetitive use.
All completed documents are securely stored in your DocHub account, are easily handled and shifted to other folders.
DocHub simplifies the process of completing form workflows from the outset!
(playful cartoon music) Lets take a look at Excels 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 its 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. Its 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. Its a condition, right? The formula I would be using is the SUMIF or the SUMIFS function, but I