Category Archives: Microsoft Excel

In a business environment, the Excel analyst will often be asked to prove theories and test concepts, one of the common theories to test is whether there is any correlation… Read more »

Excel has its own autocomplete option that by default is switched on when you get Excel out the box. Depending on your task this feature can be a helpful one… Read more »

When creating reports with history, such as a weekly sales report, it is very useful to add a percentage change column against the data. It is useful for managers to… Read more »

Converting a date into a month name is an extremely easy thing to do in Excel, but like everything it is only easy if you know how There are a… Read more »

A common problem for the Excel newcomer is how to remove the page number watermarks from an Excel worksheet along with the page breaks. It can be a distracting view… Read more »

If you need to add leading zeros to a value in Excel there are two methods that you can use, depending on whether the result you want is a numeric… Read more »

There are times as a Data analyst where you will need to lookup a value in a table based on the row and column, or based on two values. This… Read more »