Excel Formulas and Functions

Typing a formula into cell C3

If there is one tutorial you must read when learning about Excel, I’d probably say it’s this one about Excel formulas and functions. This topic will introduce you to the most powerful feature Excel has – I promise you, after reading this, your world will never be the same again. … continue reading »

Video Tutorial: How to use Excel Worksheets

continue reading »

Excel Format Cells

Right-click the cell and press Format Cells

Excel formatting is changing the way a cell or it’s contents look. There are two ways you can format cells in Excel: you can format the content type of the cell or format the visual look of the cell. … continue reading »

How to make columns and rows in Excel the same size

Select and drag multiple columns to resize them proportionally

Sometimes you have worked in a file for so long that you have made multiple changes to your Excel sheets column and row sizes.

Often your sheets looks very messy if columns or rows aren’t the same size. … continue reading »

Excel Rows and Columns

Click on the number of a row to select the entire row

A worksheet in Excel is basically a grid and each cell has it’s own coordinates. Every cell in Excel is named by it’s row number and column letter, for example the first cell in top-left of a sheet is called A1, the one to the right of that is B1 and below it is A2.

In this tutorial I’ll teach you all you need to know about manipulating rows and cells in Excel. … continue reading »

Excel Cells and Ranges

You can insert numbers, text, and dates into cells

Cells are the basic building blocks of your Excel work – everything you do in Excel you do in your cells.

In this tutorial I’ll teach you all the basics about cells and ranges in Excel. … continue reading »

Video Tutorial: How to use Excel Workbooks

Read more about this topics in my Excel workbook tutorial.
continue reading »

Excel Worksheet

Use the tabs to switch between worksheets

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 »

Excel Workbook

Saving a workbook under a different name

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

No podemos usar una referencia variable para D1 en BUCARV

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 »