Excel Worksheet Tips: Adding ticks and crosses Have you created a list and you want to tick off an item? 1. Select the cell you wish to add the tick to. 2. Change the font to “webdings” 3. To enter a tick – enter the letter a. To enter a cross – enter the letter…
Read More
Excel VBA Tips: Running macros using hyperlinks At work today I had to create a workbook that provided links between different sheets within a workbook and turned on a filter. However, I didn’t want to use buttons, as it would be become extremely cluttered. I discovered that you can run macros using hyperlinks, so commandbuttons…
Read More
Excel Worksheet Tips: Table from PDF to Excel At work today, I was asked if there was a way to extract the data from a table in a PDF in Adobe Reader and paste it into an excel workbook. You can, if you have the expensive adobe acrobat version; however, for the rest of us,…
Read More
Excel Worksheet Tips: Creating Navigation Buttons In a previous excel post, I explained how to create hyperlinks. Extending from this, you can link this ability with some simple VBA to create navigation buttons, similar to ones that you would find on websites. 1. Firstly, click on the developer tab. 2. Click on the “Insert” icon.…
Read More
Excel VBA Tips: Introduction Within excel, there are two sides to the program. The “front end” is the worksheet area where data is entered and the “back end” is the visual basic editor side. There are many different things that excel can do to help save time and allow you to become more productive. Why…
Read More
Excel Worksheet Tips: Hyperlinks When you have multiple sources of data and you wish to reference them all in one worksheet, it can get a bit messy to put all the data on one worksheet. Maybe you want to link to a web page? No problem! Creating hyperlinks in excel 1. Create some text which…
Read More
Excel String Tips – Part 3: TRIM and CLEAN functions When using data from the internet, either copied from a website or contained within a downloaded file, string data can be “dirty”. This could be unprintable characters or white space at either the front or end of the string. To remove excess space at the…
Read More
Excel Worksheet Tips: Functions Part 1 – IF, OR & AND functions I mentioned in a previous post about the IF function. I thought it would be appropriate to go into further detail about these common worksheet functions. IF The IF function is a decision-making function which performs task A or B depending on the…
Read More
Excel Tips: LEFT, RIGHT and MID functions Three of the most useful functions in excel are the LEFT, RIGHT and MID functions. The LEFT function returns the number of specified characters, starting from the left of the string. If you had a string as below: Thisis a test string And you used the function: LEFT(A1,…
Read More
Excel Tips: String skills – part 1 There are MANY things that you can do in excel. These can be split into one of two groups: 1. Sheet formulae – These are formulae that are entered into cells on the worksheet. 2. Macros – These are created in the visual basic editor and are run…
Read More
SUBMEG 