Microsoft Excel functions are over 100 built in functions that can be used to simplify many of the most repetitive and complex tasks that spreadsheet creators are likely to need to implement in their work. To enter an Excel function in to a worksheet cell, simply select the cell by clicking on it and then […]
By default Excel 2013 worksheets are displayed at 100% of their normal size, but there are times when it is useful to zoom either in and show less on the screen, but make it larger, or if you have a large worksheet you can zoom out to see more of the Worksheet. The easiest way […]
Microsoft Excel 2013 has a very handy ‘Find & Replace’ function that is useful for both locating certain text strings within your worksheet, and optionally, replacing those strings with different strings if you need to. This functionality can be very useful if you are working on a large spreadsheet with many rows or columns. To […]
Excel formulas and calculations are the basic building blocks of any Excel Workbook, and without these things any Excel workbook or worksheet is just a collection of static tabulated data that could be created in any word processor package. A formula at its most basic basic level is a sequence of commands that that when […]