8. Get tables from a web
On many occasions we have to transfer data that we have searched for on the Internet to our spreadsheets. We may think that using commands (Ctrl + C and Ctrl + V) to copy and paste its content into our workbook is the easiest option. But this will only generate more work for us, since we will have to review and edit it manually to ensure that all the data is in the right place.
The program itself has a tool to import data from a website, saving us time and effort.
The first thing to do is copy the URL of the page brazil telegram data where the data table we want to include in our Excel is located. Then, in our spreadsheet, we have to select “Data” in the top menu, and then click on “Get external data” and “From web” .
In the dialog box that appears, paste the URL and click “OK” . Next, select the type of access you want to use. You can leave the default settings and continue.
Excel will show you all the tables that the program has found on that page, all you have to do is select the one you need and press the “Load” button .
Essential formulas
Excel has almost 400 formulas to help you work with your information and work efficiently. Below is a list of formulas that you absolutely need to know.