Excel

Excel 2013 – Zoom Worksheets

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 […]

Excel 2013 – Find & Replace

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 Explained

Excel_Worksheet_Function

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 […]