u

Q - How did I come up with my fabulous business name?

Well, I’m fortunate to have twin nieces and two nephews. I took the first two letters from each of their names, you may notice Delacol is only 7 letters long… the youngest two share the letter O so instead of calling my business Delacool I opted for Delacol 🙂

u

Q - What is conditional formatting?

It’s formatting that automatically adjusts depending on the contents of the cells in the worksheet. Check out our blog for more info on this.

u

Q - What would I use conditional formatting for?

Highlighting important trends in your data i.e. a rise in a stock price, a sudden spurt in colleague/employee expenses, highlight upcoming deadlines. There are many more uses, one of which is to highlight where duplicates appear in your data.

u

Q - What would I use freeze panes for?

This is a valuable feature when you have a data heavy worksheet and you want to be able to keep certain columns and headers in view no matter where you are in the worksheet. We have a blog that might help you further with this query.

u

Q - What's a hyperlink?

A hyperlink provides a simple way for you to display slides or other documentation that you have on your web site instead of them taking up valuable hard disk space. You can also send a hyperlink via email rather than sending a large document/attachment.

u

Q - How can I make my worksheets look more professional?

There are many ways you can make your worksheets look professional and here we list just a few:

  • Format numbers using the built in number formats
  • Horizontally or vertically align the contents of cells i.e. align left, right, centre or justify
  • Merge cells, wrap text
  • Add colour & gradient effects to cells
  • Add borders & lines
  • Use simple conditional formatting
  • Insert a sparkline into a range of cells
  • Use format painter
  • Check out our blog for further tips

 

u

Q - Is there a quick way to personalise an email to multiple contacts?

You can use a mail merge for this

 

u

Q - Is there a quick way to enter details on address labels?

A mail merge is the simplest & quickest way, you enter the tags in the locations you want, format how you want it to look on the first label & update the rest

 

u

Q - How do I shorten a file name when there's no rename option and I can't open the file?

If the option to rename isn’t there you can try clicking on the filename and pressing F2. If it says the filename/path is too long then you should look to shorten the folder name it sits in. Keep them short rather than typing long drawn out file names

 

Share This