A couple of weeks ago we were preparing for a presentation. Much of the presentation is constructed from linked Excel worksheets into PowerPoint. This technique is great because the presentation automatically updates each time the Excel worksheets change. In the presentation, there are also some PowerPoint tables in the default blue striped layout. Then came … Read more
Have you ever wanted to display a character in Excel which isn’t on the keyboard? Maybe you’ve wanted to use a ÷ or maybe an ü, but you just weren’t able to find it. A standard keyboard can produce 96 characters, but lots fonts include up to 255 characters. Most countries have different keyboard layouts to … Read more
PDF files are pretty much the norm for distributing reports these days. They provide a nice easy way to collate documents from different sources for distribution. However, once a document is in a PDF format getting that information back into a usable form is a nightmare. If we try to copy and paste a data table … Read more
The camera tool is probably one of the most underutilized tools in Excel. The reason it is underutilized is because it is hidden. This simple tool will take a picture of a range of cells and place the picture of those cells on another part of the workbook. You can move, re-size and add picture formatting options the picture. … Read more
In the last few days I’ve been asked a few questions by work colleagues regarding the visibility of sheets: This cell references a sheet, why I can’t find the sheet? Is it possible to unhide multiple sheets at the same time? So, let’s take a look the process of hiding, unhiding and making sheets invisible. … Read more