Document editing comes as a part of many professions and jobs, which is why instruments for it must be reachable and unambiguous in their use. An advanced online editor can spare you plenty of headaches and save a substantial amount of time if you need to Interactive table form.
DocHub is a great example of a tool you can master right away with all the important features at hand. You can start modifying immediately after creating an account. The user-friendly interface of the editor will help you to discover and make use of any feature right away. Notice the difference using the DocHub editor as soon as you open it to Interactive table form.
Being an important part of workflows, file editing should stay straightforward. Using DocHub, you can quickly find your way around the editor and make the required alterations to your document without a minute wasted.
in this video Ill show you how to create an interactive form with power query now this is also good be known as creating a parameter query where youre passing some user-defined parameters into a query so in this example I just have an example where Im looking at the top movies and this is actually taken from a website this is taken from this website the numbers calm and you can see the the top-selling DVDs here is the top one is the Magnificent Seven in the year 2017 so we have this pretty simple URL telling us a year now if we change that to 2010 now press Enter it changes from the Magnificent 7 and avatar is the top-selling DVD in 2010 lets go back into Excel UC 2017 here if I change that to 2010 and then Im going to let me get out of that Im going to refresh this query under data refresh all youre going to see now the table its going through the queries down here and its going to change this table and the avatar is going to come back so this is something that could be done