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.
Monthly Archives: December 2012
Flexible Dashboard Technique for reports
A Camera technique in Excel
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.
Pinning your file hopes with Excel
A time saver
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.
Excel’s writing skills
Tick and create
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.
Creating Dynamic Text Box entries in Excel
Flexible text
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.
Calculating Excel
F9 shortcuts and tips
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.
DO NOT PASS GO TO in Excel
A quick way to select cells
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.