Blog

Tip 1: Inserting a static date and/or time.

Current date     Select a cell and press CTRL+;

Current time     Select a cell and press CTRL+SHIFT+;

Current date and time     Select a cell and press then SPACE then CTRL+SHIFT+;

Tip 2: Inserting a date that updates.

Choose the Formulas tab and click the Insert Function command and select the function TODAY.

Alternatively, you can type the formula =today() into a cell.

Tip 3: Displaying a series of dates.

To display the dates for a series of days, in the example shown below we have used Mondays. Type the date for the first Monday, in the cell below insert the date for the second Monday. Highlight both cells and then place your mouse pointer over the bottom right corner of the cell (Fill handle) until the mouse pointer changes to a small black cross. Left click and drag down the number of rows required.

There are many new features provided in Microsoft Office 2010, one of them is a selection of advanced image editing tools.

If you select a picture in an Office document such as Word or PowerPoint, the Picture Tools tab will light up and the context sensitive picture format menu will appear.
 

The Background removal tool removes the background from the photo.

 
The Corrections button will allow you to adjust the relative lightness of a picture (brightness), the difference between the darkest and lightest areas of a picture (contrast), and the blurriness of the picture. These are also referred to as colour corrections.  You can bring out detail in over or under-exposed pictures by brightening the picture or change the definition of the borders between light and dark by increasing or decreasing contrast.

 
The Color button will allow you to adjust the colour intensity (saturation) and colour tone (temperature) of a picture, re-colour it, or change the transparency of one of its colours. You can apply multiple colour effects to your picture.

 
The Artistic effects button allows you to apply artistic effects to a picture or a picture fill to make the picture look more like a sketch, drawing, or painting. A picture fill is a shape or other object with a picture applied to "fill it".  You can apply only one artistic effect at a time to a picture, so applying a different artistic effect will remove the previously applied artistic effect.

 
Previously tools such as these were only available with sophisticated bitmap editing products such as Photoshop or Paint Shop Pro.

Here are some of my favourite apps and services that I use on a daily basis. Best of all they don't cost a penny! Why not give them a go and let us know what you think, or let us know about any of your favourite apps in the comments below!

Dropbox

Todo.ly

I've tried many task list applications and services, but this is my favourite by far. You can create multiple categories (projects) and sub-categories. You can then simply click and drag tasks to order them within each project, or within other tasks. You can set set completion dates and print your lists.

Website : http://todo.ly/

Klok

Klok is an Adobe Air desktop application with two versions, free and pro (£10). Create clients, projects and tasks; then simply click and drag your current task onto a box to start the work timer. You can see a colour coded graphical display of how you've spent your time and create timesheets for print or download as an excel file. The pro version also lets you import meetings from Google Calendar and has automated backups.

Website : http://www.getklok.com/

Xmarks

LastPass

Feedly

280Daily

A refreshingly anti-social web app! 280Daily is a private and personal online journal. You're restricted to 280 characters, so it doesn't take long to write and you can set a friendly email reminder so you don't forget. It's accessible from any desktop or mobile web browser, you can upload photos to include with your entries, export entries to PDF or even have them printed and bound in a book!

Website : http://280daily.com/

Tip 01 : How to line up text without creating a new bullet

Want to align a paragraph with the bulleted list items above?

In order to create an aligned paragraph instead of another bullet item, press Shift and Enter at the end of the bulleted or numbered list.

Tip 02 : Insert bullet list keyboard shortcut

To insert a new bullet list using your keyboard, simply type an asterisk and hit the spacebar

Tip 03 : Insert numbered list keyboard shortcut

To create a new numbered list using your keyboard, simply type a number, a full stop and a space, followed by your first list item. Each time you subsequently press return, the ordered list will generate a new item number.

We hope you found these tips helpful. If there are any others that you'd like to share, please let us know and we'll include them in a future hints and tips article!