Training for Excel and VBA in Lynda

Download PDF

Here a nice training course in Lynda for Excel and VBA to learn how to manage and data:

You can learn how to filter data, open and closing files, use built-in worksheets functions in VBA, create charts and forms.

It is pretty simple but many tricks are nice and not everybody knows them!

As always you have voice transcripts, the list of chapters so you can jump from one to the other and take advantage of what you really need and finally a notebook for you directly online.

Happy listening!

Molti studi scientifici contengono errori di Excel

Download PDF

il Post riporta un interessante articolo al proposito. Un semplice commento, non si tratta di un errore del software o del formato utilizzato ma di semplici sviste nella formattazione, è infatti molto semplice evitare questi errori prestando attenzione alla formattazione dei dati durante gli inserimenti (o le successive conversioni di formato)

Extract data from an image or a PDF

Download PDF

It may happen to access a PDF file over the internet with a graph and no data available in numeric format..

this is an example from the European Parliamentary Research Service Blog:

Annual public expenditure on tertiary education as a % of GDP, 2008

Continua a leggere