How to Improve an Excel Line Chart
Line charts are frequently used in Excel but their default settings leave a lot to be desired. See the transformation of a standard line chart to a simpler and easier to read line chart. (more…)
Flexible Dashboard Technique for reports
It’s easy to move and re-size charts on a sheet. It’s a different story when you want to include small reports on a dashboard. Reports are affected by the existing row heights and column widths. (more…)
Pinning your file hopes with Excel
There’s a little icon that was introduced in Office 2007 that is very useful but sadly, many people don’t know about it. It’s a pin icon and it allows you to “pin” files to the recently used file list in Excel 2007. (more…)
Excel’s writing skills
Excel is great with numbers but what about sentences? Check out this example of how you can create a paragraph builder. The user ticks boxes to select sentences to include in a paragraph. (more…)
Creating Dynamic Text Box entries in Excel
Text boxes are flexible because you can place them anywhere on your spreadsheet.
You can link a text box to the contents of a cell. (more…)
Calculating Excel
When you set calculation to manual in Excel you have turned off calculation. You can press F9 at any time to update the calculations. F9 doesn’t turn on calculation, it just does a recalculation. (more…)
DO NOT PASS GO TO in Excel
Excel’s Go To feature provides a quick way to select certain types of cells. For example, if you wanted to apply the same fill colour to all formula cells on a sheet, you can do that in five easy steps using Go To. (more…)