This simple tutorial will show you how to download data into an excel spreadsheet, creating a web query.

Download data into excel

select “data” tab

select “from web”

input the desidered web URL

click “go” button

**select **data you want to download

click “import” button

Refresh downloaded data

select “data” tab

tags: data /excel /excel spreadsheet /tutorials /web query /

as part of the** excel functions in R,** I have developed this custom function, reproducing the excel right() function in th R language. Feel free to copy and use it.

[code language=“r”] right = function (string, char){ substr(string,nchar(string)-(char-1),nchar(string))} [/code]

you can find other function in the Excel functions in R post.

tags: analytics /data /data analysis /data analytics /excel /excel spreadsheet /functions /R /

as part of the excel functions in R, I have developed this custom function, emulating the excel left() function in th R language. Feel free to copy and use it.

left = function (string,char){

 substr(string,1,char)}

you can find other function in the** Excel functions in R post**.

tags: analytics /data /data analysis /data analytics /excel /functions /R /

I have started my “data-journey” from Excel, getting excited by formulas like VLookup(), right() and left().

then datasets got bigger, and I discovered that little spreadsheets were not enough, and look for something bigger and stronger, eventually coming to R.

But as you know, ones never forget the first love.

So, for fun and for practice, I have written down some of excel functions in R.

I hope you will enjoy.

tags: analytics /excel /excel spreadsheet /R /