FLOOR.PRECISE Function In Excel 2010

In this post we will be covering new FLOOR function, which produces results with utter precision. Through FLOOR.PRECISE function you can evaluate  accurate floor values. The syntax of FLOOR.PRECISE function is exactly same as FLOOR function, requires two arguments to be passed for final evaluation. Read More

Compare Two Presentations In PowerPoint 2010

PowerPoint 2010 includes Compare feature, which enables you to compare two different versions of a presentation. Through Compare feature, you can view changes in presentation versions in a very interactive way. Adding more, it also allows you to insert changes and merge revisions on the fly. Read More

Hyperlinks In Word 2010

Hyperlinks provide a simple way of referring data or element that is to be followed. Using the hyperlinks in Word 2010, you can easily refer your document's audience to specific heading, file, page, website link etc.. Unlike other word processors, MS Word provides users with a wide range of features to easily create and manage hyperlinks. It supports almost all types of hyperlinks that users frequently use in the document. Apart from creating hyperlinks to bookmarks, you can easily choose the headings within the document that you want to link to; if shows a list of headings present in your document to let you select to create the hyperlink for. In what follows, we will explain how you can create and manage hyperlinks in Word 2010. Read More

Add Calculator In Excel 2010

Excel includes list of function and formulas but for applying them you need to abide by certain syntax, thus even for simple calculation you need to write formula and function with respective syntax, but what about simple calculations? In this post we will adding Calculator in Excel 2010, so you can easily launch it right from it's window. Read More

TimeSheet: Free Time Management Software

If you have ever wondered about how productive you have been, or how much of your time has been consumed by a particular task on your system, TimeSheet can help. It is an application that allows a user to automatically record the time spent on particular projects or tasks, and present it in an easily understandable report. Read More

Track Changes In Shared Files With FileTrack

Everyone at some point has used a shared file. Perhaps an application used by two different people, or a document that needs to be co-edited. In real world, shared usage of files is far more abundant. Take the example of a shared Microsoft Excel workbook. While Excel does provide a notification feature if a shared document is being modified but multiple people at the same time, the data corruption chance is always there when data is over-written, associate with a huge pain. Read More

Organize And Improve Work In Windows With SysPad

SysPad is a useful utility that enables you to take notes, launch applications and folders, organize network links, manage folders and much more right from the convenience of your system tray. This tiny utility simplifies day to day tasks especially in a business network setting where multiple folders are used on a regular basis. Read More

Create Backup Of Access 2010 Database

Creating backup of databases is the most important thing and must not be overlooked. Access 2010 offers a simple and easy way of creating backup of database you’re working on. To begin, open the Access 2010 database and close down all table fields. Now on File menu, click Save & Publish. Read More

Hide / Unhide Table’s Field In Access 2010

Access 2010 lets user easily hide and unhide table’s fields. This will come useful in situation when you want to see two non-contiguously placed fields side-by-side. For hiding the table’s field, select the field by clicking field title, now navigate to Home tab and from Records group, under More options, click Hide Fields. Read More

Access 2010: Quickly Set Form Control Padding

Setting Forms in required shape is no less than a laborious work, as you have to adjust each element at the position you want. Access 2010 offers 3 types of padding control to set the padding in Narrow, Medium, and Wide layout. To begin setting up Form Controls, open form in Layout View and select form by pressing Ctrl+A on keyboard. Navigate to Form Layout Tools Arrange tab, and from Control Padding options, Choose a desired padding option. Read More

Access 2010: Save Form In PDF Format

Unlike previous versions, Access 2010 offers a direct way to publish reports and forms in widely used document publishing format – PDF. Once you’ve done creating your forms in Access 2010, you can export the form into PDF and XPS format. For converting form and to save in PDF format, open the database Form and head over to External Data, and click PDF or XPS button. Read More

Access 2010: Change Alternate Row Color

Unlike Excel 2010, which doesn’t offer a direct way to format alternate rows, Access 2010 provides an easy way to format alternate rows to better visibility. To change alternate row color, open the desired database table, and head over Home tab, under Text Formatting group, from Alternate Row Color drop-down list, select a desired one. Read More