by Fiona Hannon | Oct 17, 2013 | Blog, Excel Formulas, Excel Formulas, Excel Tips, Uncategorized
Let’s take a look at the following really useful functions that will help us every day in Excel. Functions that help with CASE This set of 3 functions are very handy to use when text has been imported into Excel and it has not arrived in the correct case. Maybe... by Fiona Hannon | Oct 17, 2013 | Blog, Excel Formulas, Excel Formulas, Excel Tips, Uncategorized
Let’s look at a scenario where data is given to you in .CSV format or already has been imported into Excel for you. It may be the case that you have a list of ID numbers, when they are pasted or imported into Excel, the leading Zero which was there in the... by Eoin Lynch | Oct 17, 2013 | Blog, Excel Formulas, Excel Tips
Locking down all Cells: There are times when working in Excel that you want to protect an entire worksheet from someone making changes to it, without protecting the entire workbook. Excel allows you to protect a particular sheet. To simply protect the sheet your... by Eoin Lynch | Oct 16, 2013 | Blog, Excel Formulas, Excel Tips
In this example we cannot use the function Min (Minimum), because it will only find the smallest value in a range of cells. However the Small Function allows you to choose the Smallest and also the second smallest, third smallest and so on. The challenge with the... by Eoin Lynch | Oct 16, 2013 | Blog, Excel Tips
Format Painter is a great tool, it can be used in any of the Office Applications, it allows you to copy formatting from one area/object to another, but did you know that’s only half of what it’s capable of? What if you need to copy formatting to more than... by Shane Broadberry | Aug 14, 2013 | Excel Formulas, Excel Tips
New in Microsoft Excel 2010, a sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and...