
How to Calculate Correlation Coefficients in Excel 2010?
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 »
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 »
Excel Sparklines were introduced in Excel 2010 and are great for displaying the trend of data over time and making sense of a sea of numbers. Just take this before… 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 »
Rather than use the Excel Comments boxes, which can be a bit clumsy and/or intrusive, you cab use the N() function to add a comment inside a formula. For example … Read more »