Excel Worksheet

An Excel worksheet is the sheet with cells on which you make all your work. Using different worksheets you can easily separate different types of analyses in different places so you can easily keep oversight of what you’re doing.

In this tutorial I’ll teach you all there is to know about Excel worksheets using lots of images to make things clear. I also made a video tutorial walking you through all the options.

continue reading »

Workbook in Excel

When people say Excel workbook they basically just mean to say Excel file. When you open Excel, automatically it will open up an empty workbook for you. A workbook consists of multiple worksheets that can be accessed at the bottom part of your screen. … continue reading »

Usar INDIRECTO para dinamicamente referir a hojas de trabajo en Excel y Google Sheets

A veces quieres hacer referencia a ciertas hojas de trabajo (worksheets) dinámicamente. Por ejemplo si tienes datos en el mismo formato dividido o repartido en multiples worksheets y quieres seleccionar datos desde diferentes hojas de manera dinámica.

En este caso, puedes usar la función de INDIRECTO(), que está disponible tanto en Excel como Google Spreadsheets. Les mostraré como utilizarlo con … continue reading »

Number of weekdays between two dates in Excel and Google Spreadsheets

Normally just getting the amount of days between to dates in Excel isn’t enough. At times, you need to get the number of weekdays specifically. For this, there’s a very useful function in both Excel and Google Spreadsheets: … continue reading »

Removing the first X number of characters from a string in Excel and Google Spreadsheets

Occasionally you need to convert a specific string to remove some x number of characters at the beginning of the string. There is a very nifty function you can use for this: … continue reading »

How to get WeekNumber function in Google Spreadsheets

Sometimes you want to have the week number of a certain date in your spreadsheet. In Excel you can use the WEEKNUM() function for this purpose, however in Google Spreadsheets there is no such function built in.

If you want to get a function that does the same as WEEKNUM() in Google Spreadsheets, use the following trick … continue reading »

How to get letter in alphabet based on number in Excel and Google Spreadsheet

Suppose you have a number between 1 and 26 in cell A1, you can get the corresponding letter in the alphabet using the following trick:

=mid("ABCDEFGHIJKLMNOPQRSTUVWXYZ";A1;1)

Of course, you can extend and modify this with your own letters to suit your particular needs.

Removing the last number of characters from a string in Excel and Google Spreadsheets

Sometimes you want to remove some number of last letters from a string in your spreadsheet. For this you can use a very handy function … continue reading »

Use Excel INDIRECT to dynamically refer to worksheets

Sometimes you want to make a reference to certain worksheets dynamically using the Excel indirect function. For example if you have data in the same format split over multiple worksheets and you want to select data from different sheets dynamically.

In this case, you can use the INDIRECT() function, which is available in both Excel and Google Spreadsheets. I’ll show you how to use it by running through … continue reading »

How to import Google Analytics data into Google Spreadsheets in 3 simple steps

Almost everybody that owns a website uses Google Analytics to analyze their visitor’s behaviour. While the Google Analytics web interface is useful, sometimes you just need a little more flexibility with your data by exporting it from Google Analytics into your spreadsheets.

In this post I will show you how you can set up a spreadsheet that allows you to import Google Analytics data with the push of a button and make custom graphs about your visitors like … continue reading »