The Folder Pane and the Peek feature provide quick and convenient ways to open your email, calendar, contacts, and tasks. One of the new features in Outlook 2013 is the ability to peek at the details of the other Outlook objects such as Calendar, Tasks and Email. This is great for those times when you […]
Because appearance means everything in modern day business, you’ll want to make sure that you dress right for the occasion. Outlook 2013’s new Calendar view will give you all the information you need to plan your day’s schedule or your next trip. The temperature defaults to Fahrenheit which can be changed easily. How to: File […]
A great way of preserving the look and feel of the original source document when sending to multiple devices, the PDF is a much loved office favourite. Compressing large file sizes into much reduced versions is one of the PDFs best features. However, up until recently, making changes to a PDF file in Word was […]
Social networking is an important part of modern day business. Microsoft have recognised this and redesigned Outlook around your favourite platforms, LinkedIn, Facebook and others. Get the updates that you want from the people that you trust, right on time. When you open an email in Outlook, the Outlook Social Connector is minimized as a […]
One of the most asked questions during our Excel 2010 Training Courses has to be the subject of calculating with dates. Excel stores dates (and times) as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day (e.g. 31/10/2011 10:00 is stored as 40847.42).This is called a serial date, or serial […]
Here’s a brief tip on how to instantly brighten up your Excel spreadsheet with very little effort. By changing the colours of the tabs, your Excel Worksheet will change from being dull and boring to exciting and colourful! It will also help in organization, being particularly useful when organizing all your Excel Worksheets relating to […]
Here’s how to view two Excel 2010 workbooks at the same time, side by side, a very useful tip when you want to compare data without having to go back and forth! 1) Open both Excel workbooks 2) Select Window then select Compare Side by Side with (Spreadsheet 2) 3) When you have finished, […]
When you have an Excel Worksheet with masses of data, it’s not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the […]
If you want to make your Excel Worksheet appear a little less dull, or maybe you want to draw attention to a certain section of text, why not try rotating the text. And here’s how you can do it.. – Select the cell with the text in you would like to rotate. – Click the […]
If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet. Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.
If you want to add a row to an Excel spreadsheet, these are the simple steps you should take: With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert. Follow exactly the same steps if you want to add a column […]
If you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide columns and rows. Hide a single column: 1) Right click on the column header of the column you want to hide (this is […]
One of the most asked questions during our Excel 2010 Training Courses in London has to be the subject of calculating times. One important issue is how time values are typed in Excel. This should always be as 9:00 AM or 10:30 PM. There must be a colon separating the hours:minutes and if you are […]
Ever closed an Excel workbook and clicked the “Don’t Save” option, then realised you should have saved it! Microsoft Excel 2010 now has a file recovery option for just such an occassion. This has proved invaluable in our Microsoft Excel Training Courses in London. Always check the AutoRecover time in the Excel options. To do […]