Author Archives: admin

WDTV Live and 4TB HDD (Seagate)

I recently bought a 4TB Seagate Expansion Drive for my WD TV Live and couldn’t get it setup initially. So thought I’d do a quick post outlining the final solution. Firstly, a 4TB does work with the WD TV Live … Continue reading

Posted in Other | Tagged , | Leave a comment

Excel Formula / Vlookup / Index Match To Get A Hyperlink

So just combining a few tutorials and code from the net here. Basically, this allows you to do a vlookup, or index match, to grab a cell’s value WITH the hyperlink. You may have found this because you realised after … Continue reading

Posted in Excel, VBA | Tagged , , , , | Leave a comment

Excel: How To Select A Certain Number Of Cells Within A Range

Ok, I tried searching for this and eventually found some results, but thought I’d put up a piece to make it a bit easier for people to find. Basically we want to select a certain number of cells within a … Continue reading

Posted in Excel | Tagged , , | Leave a comment

Excel: How To Select A Cell X Cells Away From Another

To select a cell that is x cells away from another we can use the =offset() formula. Example of how this is very useful: I often have daily or monthly return series, and need to calculate the annual return. So … Continue reading

Posted in Excel | Tagged , , | Leave a comment

How To Insert A User Form With Checkboxes In Excel

Looking for a way to add¬†checkboxes that allow users to tick what they want in Excel?   Check out these¬†excellent guides:   http://www.fontstuff.com/ebooks/free/fsUserForms.pdf http://www.exceltip.com/st/Create_User_Forms_in_Microsoft_Excel/629.html

Posted in Excel, VBA | Tagged , , , | Leave a comment

Excel Paste Values Shortcut: CTRL+ALT+V, Or ALT, E, S

2 options here. CTRL + ALT + V This will bring up the dialog box, which will allow you to choose the type of paste you want to do ALT, E, S This will navigate through the ribbon. Pretty sure … Continue reading

Posted in Excel | Tagged , | Leave a comment

Excel Connect Data Points On A Chart When There’s A Gap

Quick post on connecting data points on a chart in Excel when you have a gap in the time series. Basically I export a lot of time series that when paired together has gaps for certain periods. Basically looks like … Continue reading

Posted in Excel | Tagged , | Leave a comment

Excel Shortcut To Edit A Cell Formula: F2

Another short… well shortcut post. Just wanted a helpful piece that has the shortcut actually in the title. So shortcut for editing a cell formula in Excel is F2 Apparently on a Mac it is CTRL + U. But that … Continue reading

Posted in Excel | Tagged , | Leave a comment

PowerPoint Shortcut To Add A New Slide: CTRL + M

This is an extremely short post to just provide the shortcut for adding a slide in powerpoint, which is CTRL + M. Thought I’d create a post with the shortcut in the title – because, well I hate searching for … Continue reading

Posted in PowerPoint | Tagged , | Leave a comment

Windows Shortcut To Maximise A Program To Full Screen

Easy little time saving shortcut: hit ALT + spacebar. This then reveals the available shortcuts. ALT + Space + X = Maximise ALT + Space + N = Minimize ALT+ Space + R = Restore See screenshot below.   Here’s … Continue reading

Posted in Windows | Tagged , | Leave a comment