Maximizing Connectivity & Productivity

Archive for June 2012

Word – Page Borders

Dressing up a page with a border is simple.  Apart from a borders decorative uses, a border can be useful too.  For ex. you can use this feature to create cut out borders for coupons. Go to Page Layout tab -> select Page Borders from Page Background […]

Read more

Excel – Formatting Comments

Yes, you can change the look of those yellow comments if you feel you have too.. Right click the cell, select Edit Comment, then select the fonts and alignments from their respective groups on the Home tab. Right click the comment’s border,select Format Coment to: Change the color, […]

Read more

Excel Comments to Cells

Comments to cells are a good way to document the purpose of the cell, or describe the formula etc. To add a comment you can: Right-click the cell and select Insert Comment Press Shift+F2 Choose Review-> Comments-> New Comment You can control the display of the comments […]

Read more

Excel 2007 – Calculation Issue

Check out this link for more details..

Read more

Access – Date picker not showing

The Access date picker is a little calendar that appears on the side of a date field when the date field is clicked on.   When clicked, this pops up to allow the selection of a date from the calendar. If the date picker does not display, the three main […]

Read more

Excel table advantages

So why use Excel tables?  Isn’t a spreadsheet just like a table?  Well, there are benefits to using an excel table.. First, here’s how to create one. Simply select your data and go to Home-> Styles-> Format As Table, pick the table style from the selection that […]

Read more

Create new stationery in Outlook 2010

Ever wanted to create your own stationery in Outlook?  Here are two methods: Method 1 Open up a new message and create your message the way you would like it to appear on every email.  Goto File -> SaveAs -> type %appdata%\microsoft\data in the dialog address bar and […]

Read more

Conditional formatting in Excel

Use this feature to highlight different aspects of data and make it more readable. Select the data containing the info to be highlighted.  Go to Home->Styles->Conditional Formatting->Highlight Cells Rules and then select which rule applies best. If you are adventurous, you can also create your own rules.  […]

Read more

Office over Libre

How Microsoft Office Tops LibreOffice: 11 Features By Datamation. However, the main strength of Office to  me, is the ability to integrate Excel, Access, Word, Outlook, Powerpoint using VBA.  This helps businesses streamline manual procedures using automation, and results in time and therefore cost savings.    

Read more

Slicer in Excel 2010

Use slicers to view (slice) a pivot table to make the pivot table summarization of data easier to read. In essence, a slicer will ‘slice’ the pivot table by selected categories, so that only data is viewed. To use: Click inside the pivot table -> the contextual […]

Read more
Page 1 of 212
Mississauga, ON, Canada 905.607.3500