Search

Welcome to Thought Asylum a place for me to share my thoughts, ideas and experiences with the rest of the world.  I try to post reasonably regularly and if you like the content consider subscribing to the site feeds.  If you're trying to find something specific try the search, otherwise just have a browse.


Entries in Excel (16)

Sunday
Apr302017

Batch Generating Worksheet Hyperlinks in Excel

In my work I often find myself building spreadsheets to carry out calculations, manage sophisticated processes and capture information. These spreadsheets can often extend to covering many worksheets and as a result it can be awkwardly slow to navigate to particular worksheets just by paging back and forth with the navigation buttons.

In this post I'm going to illustrate a couple of useful techniques to help you navigate around.

Click to read more ...

Saturday
Jan162016

ThoughtAsylum 2015 Review

Happy new year everyone. We've passed another year's end so once again it's time to take a look back at what's been most popular on thoughtasylum.com in the past twelve months and what's I've been up to.

Click to read more ...

Saturday
Jan102015

ThoughtAsylum 2014 Review

It's the new year so once again it's time to review the past 12 months and see what's been going on at thoughtasylum.com and with me.

Click to read more ...

Sunday
Jun292014

Extracting Excel File Path Information Using Excel Formulas

In several of the template Excel spreadsheets I use in my work there are references to clients and version numbers that are included. This is for reference purposes, particularly if the spreadsheet might be printed or exported as a soft copy (e.g. PDF). Whilst it is possible to maintain this information manually I decided that this should be something that could be improved by virtue of the file name containing such information (as these are the very basis of file management on projects). I'd referenced the file path and elements of it in the past and I thought that this would be something that should be relatively straight forward to achieve; and here's how I got on ....

Click to read more ...

Saturday
Jun292013

Auto Incrementing in Excel

In this post I'm going to share a tip about auto incrementing numbers in Excel. I've frequently found myself creating incremental number lists (e.g. 1,2,3,4,5,...,etc.) and whilst Excel is quite helpful at providing ways to create such lists I find its methods are often a bit limited for my needs - so I came up with another way that I think you might find more resilient.

Click to read more ...

Wednesday
Dec282011

24 Hour Clock Calculations in Excel

Recently I've been doing some work with Excel to carry out some time calculations based on the results of an automated job. The job is sometimes triggered one night and finishes in the early hours of the next morning. After loading the figures into Excel I discovered that time calculations aren't always as simple as subtraction when times cross midnight. A quick test later and I had a workable solution that I thought might be useful to share.

Click to read more ...

Friday
Apr022010

Excel Text Limit

Did you know that sometimes it's better to format text in Microsoft Excel 2007 as something other than text?

Click to read more ...

Wednesday
Jan132010

Excel 2007 Hyperlink Limitation

For a couple of years now I've been pulling IT service desk statistics into a spreadsheet and setting up worksheets to break down and analyse the data in various ways.  The number of worksheets has subsequently grown a significant amount and I wanted to create a front worksheet that contained hyperlinks to and brief descriptions for each of the subsequent worksheets.

Click to read more ...

Sunday
Jan102010

Finding the size of a Microsoft Office 2007 file

Prior to Microsoft Office 2007 (MSO2007), office provided a quick and simple way to find out just how big your file was.  This was done by selecting the properties option from the file menu which then displayed the same file properties dialog box that you could select from the file in Windows Explorer.

In MSO2007 the information is still available, but has been annoyingly 'hidden' somewhat deeper in the application.  In fact it is so awkwardly hidden that I know many people have not come across how to access it ... so I thought I'd share.

Click to read more ...

Thursday
Jan072010

Get Value from the Text Function in Excel

I've been doing a little bit more work with some spreadsheets recently and I came across a situation where I needed to work with a date and carry out a comparison to a string of text.  My first attempt fell short as it wouldn't get the value I wanted, but Excel's TEXT() function came to my rescue.

Click to read more ...