Yearly Archives: 2010

MusicBee – Full-Featured Free Music Manager

by on
2
Music managers, not exactly a "niche of software" that is badly represented. Large numbers of these, both commercial and free (open-source) have been around ever since the introduction of portable audio formats such as MP3. However, as it is the kind of software you'll use to great extent, it is particularly in this area where you will be most critical towards comfort of use and the availability of features and customizability. MusicBee is an attempt to provide one with a full-featured playing, tagging, organizing, ripping and synchronizing (e.g. iPod) manager. Lot of stuff to go in there, but hell, this manager manages. Read More

Canvas Add-on For OneNote 2007 and 2010

by on
2
Undoubtedly OneNote 2010 provide users an ultimate notetaking environment, but still you need to navigate through the sections and notebooks manually. Recently Microsoft Labs coined an add-on which gives fascinating and appealing experience of working on OneNote sections. Canvas for OneNote is an add-on which will revolutionize the way of notetaking by providing dynamic and broad canvas for navigating through sections and notebooks under one hood. Read More

Excel 2010: Basic Logical Functions

by on
2
Using logical functions provided by Excel 2010, we could apply and evaluate the specific rationale on the data. The most commonly used logical functions are AND, OR, and NOT. They take values as arguments to apply a simple logic over them and yield TRUE and FALSE result. The logical function helps users in situations where they want to categorize the value into groups, so that further complex functions can be easily performed. For example, if you want to check two different values that belong to different fields against a condition, you can use the logical function to check where the required condition is met. This may assist you in filtering out unwanted values and in focusing on only those values that you require. Additionally, Excel 2010 lets you use the multiple logical functions to check required conditions for the data set in one go. In what follows, we will demonstrate the usage of AND & OR logical functions. Read More

Word 2010 Bookmarks

by on
3
Bookmarking is an phenomena which enables you to mark-out important text or any other content. In Word 2010 you can easily add a bookmark for the important portion of the document, it could be heading, image, imported object, audio file, paragraph, etc. Read More

Excel 2010: SUBTOTAL Function

by on
1
Remembering all the functions that Excel 2010 provides is not possible, but you should know all basic functions, so that you can quickly apply them. Excel 2010 offers SUBTOTAL function that provides users with a list of functions that can be used by only entering their function number. It takes the function number of corresponding functions as an argument and location of cells to show you the subtotal of the selected data range. The SUBTOTAL function supports a total of 11 functions including AVERAGE, COUNT, MAX, MIN, SUM, VAR.S, VAR.P etc. This function prevents user from writing different subtotal functions over and over again in their spreadsheets to calculate the subtotal amount of the list. Just enter the corresponding number of the function, and it will show the required subtotal amount. In this post we will be using only four functions from the list to apply them over on the spreadsheet. Read More

Google Calendar Events Desktop Notifier

by on
2
Want a good desktop Google Calendar events reminder app? GMinder is the best so far. Being stable, it is a nifty little application which allow users to Add, Open, or Dismiss a new event without having to visit the website. The event notification alerts are fully customizable and so are the agenda. Read More

SecurStick – Encrypt USB stick data without administrator privileges

by on
1
Data encryption tools like TrueCrypt, BestCrypt or FreeOTFE are perfectly well suited for encryption of USB drives or putting encrypted container files on USB sticks. Unfortunately, this does not guarantee a safe and completely portable storage facility. The problem lies with the necessary evil of a driver that needs to be installed in order to mount the encrypted files (or partitions) on the system. If one does not have administrator privileges on the operating system, the only way to be able to use an encrypted volume is to ask an administrator to pre-install the software... on every single computer you might just want to use your encrypted data. Well, not anymore. Read More

Create Tables In Access 2010 Using SQL Commands

by on
10
MS Access provides a number of ways to create tables and queries. Using simple SQL commands, you can create tables, queries, forms, and reports. SQL stands for Structured Query Language that is being used extensively for creating, handling and manipulating RDBMS. Its syntax is very easy to comprehend, but becomes complex when you try to handle the colossal database. In this post we will define a simple query with SQL commands, which eventually creates a simple table. Read More

Excel Date & Time Converter

by on
Leave a comment
Writing dates and time values in spreadsheets are always very tedious because of standards to comply. Excel Date/Time Converter is very useful add-in which lets you convert values into date/time format instantly. It supports multi-languages, so you can also convert dates and time written in other eminent languages. Unlike others, It sports direct integration into Excel. Read More

Xps2Img Converts XPS Into Image

by on
8
Sometimes it is a dire need to share XPS format files with others, without thinking of XPS viewer or any concerned app being installed on the other end. Now xps2img allows you to change XPS files into different image formats. It is freeware application which is dead-simple to use, it runs on CLI IDE, but you can always create a batch file and run it from Windows environment. It encompass a lot of different attributes along with just conversion, you can also specify quality of image, compression level, pages to be converted, DPI, etc to convert image on your terms. Read More

OneNote 2010: Tagging Guide

by on
4
Tagging comes useful when you need to remember important content. When you are taking notes on daily basis, it becomes dire need to mark-out content that you would want to remember. Microsoft OneNote 2010 provides seamless tagging feature which enables you to mark-out important content out of your note sheets. It has a long list of intrinsic tag types which let users to tag an important text, image, video, audio, table etc instantly. You can also carve out new tag by modifying the existing one with desired text and image. Read More

Set / Change Time Zones In Outlook 2010

by on
1
If you travel a lot for meetings back & forth to places with different time zones, you might need to add/set time zones accordingly. Outlook 2010 offers an easy way to set the time zones, it offers the same build-in Windows time zone list to let you choose maximum of two time zones which can be swapped anytime. Read More

Monitor Website Content And Send Notification To Growl

by on
Leave a comment
Growl Site Monitor is a small open source tool that requests page content and verifies if it returns the correct content. If the content is not properly returned or an error occurs, users are instantly notified via Growl. The original intention behind this app is to use this with Prowl (iPhone application), so that you can get notifications on your iPhone. There are plenty of apps out there that can tell you when the website is down, but very rarely will you come across an app that can tell you if the content has changed on a specific page. This has two benefits; first that in a large publishing company you can find out which page content has been modified so you detect a problem, and second, that if you are following your favourite website, you can see if the new content has been added or not. Originally built for the purpose of checking content, it can also be used to check if the website is down or not. At the moment users can only add the website and the content name, along with the checking interval time via the XML file. Add the URL that you want to check between the <Uri> and </Uri> tags and type the content you want to check between the <RegularExpression> and </RegularExpression> tags. To give the content check a name, type the name in-between the quotation marks <ContentCheck Name="[name goes here]">. It is fairly easy to use once you get a grip on how to modify the XML file. Once the XML file is ready, save it and then launch the application. Click Browse and select the location of the Configuration file and choose it. Now click Check All Now button to begin checking the content on the website. As you can see in the first screenshot, one content check failed while the other succeeded. If you have Prowl installed on your iPhone, you will be instantly notified once regular expression does not match the content in the URL you provided. Download Growl Site Monitor

Excel 2010: Merge Cells (Concatenation)

by on
17
While working on spreadsheet you might want to merge cells values into single column or row, which are widely dispersed in the spreadsheet. With Excel CONCATENATE function you can easily merge columns, rows and data values. It takes location of cells or data values as argument. In this post we will be applying this function to merge only two columns. Read More

Excel 2010: Error Bars

by on
5
Data visualization tools always help the audience to understand the spreadsheet data in an interactive way but if you are able to show data variability in charts, along with other visualizations then it makes your charts more professional. With Excel 2010 Error Bars you can now show data variability and discrepancy in related data values. You can easily let Excel know the values and percentages on which Error Bars should be visible. Error Bars are great tool to aggrandize the chart showing X and Y bars, which eventually confine user to enter data values in specific range. It can be used with almost every type of chart but in this post we will be using it with Scatter and Trend lines chart. Read More

PowerPoint 2010: Video Compression

by on
Leave a comment
PowerPoint supports inclusion of almost all formats of media into presentations which give it more flamboyant look. When we need to insert a hefty video which will eventually take a lot of disk space and make working on PowerPoint a bit slow, then it would be better to marginalize the size of the video. With PowerPoint 2010 you don't need to use third-party media compression tool, it's inherent feature of media compression is very handy and easier to use. Most importantly it provides you with compression options which is best suited for your presentation. Read More

Excel 2010: Matrix Inverse Function (MINVERSE)

by on
3
Previously we have covered how to evaluate the determinant of matrix. Now we will be focusing on how to find out inverse of the matrix which mainly requires multiplication of determinant with matrix ad-joint. The old-school method for evaluating inverse is very tedious but with Excel MINVERSE function, we can evaluate it instantly. We just need to write or specify data range values in matrix as argument of the function. Read More