Monthly Archives: March 2010

How Not To Get Duped When Buying HDMI Cable

by on
3
Pro Tip: Never buy a cable wrapped in Gold. Weblog MintLife has an awesome infographic proving why getting an expensive gold plated HDMI cable is unnecessary. To put it in a nutshell, the quality of $10 and $250 HDMI cable are same. So why are companies like Mint selling expensive HDMI cables? To dupe people and earn higher profit margins on each sale. Read More

How To Change Default Screenshot Image Format [Mac OS X]

by on
Leave a comment
We at AddictiveTips pay special attention to the quality of our screenshots, and ensure that they are clearly visible and of reasonably large size, while keeping the file size acceptably small. Format of the screenshot plays a vital part in determining this. While it is possible to change the format of any image file using third-party tools, it can be time consuming to execute this. Read More

How To Easily Lock A Mac Screen

by on
4
One of the most used features of Windows systems is the ability to lock the desktop. Simply hitting Windows + L Key makes sure that no one invades your privacy and prevents unauthorized use. Mac offers a similar feature through password-protected screensavers, much like Windows, but it can be tedious to manage those. Luckily, a very simple free solution is available. Read More

Find Max & Min Values In Excel 2010

by on
5
Through simple Excel 2010 functions you can easily find out the maximum and minimum value in the spreadsheet. The MAX and MIN functions immediately returns the maximum and minimum values for the specified range. But sometimes there is a need of including logical values along with numeric values to find out max and min value, then MAXA and MINA functions are very helpful. The syntax of theses functions are same and takes only one argument which either be number or location of data range. In this post we will using a simple example to demonstrate the core usage of these functions. Read More

Excel Database Functions: DAVERAGE and DSUM

by on
Leave a comment
Excel 2010 enables user to create database table for performing database functions and applying formulas. Excel 2010 inherited different database functions which lets one tweak data from the specified database, you just need to choose the primary field, and apply a certain condition for pulling out specified content from database. THE DAVERAGE and DSUM functions are used to find out the average and sum of the database values as specified in criteria. Read More

Outlook 2010: Test Email Auto Configuration

by on
8
Outlook 2010 contains some features which are difficult to use or comprehend by novices and that's why they are concealed by the Outlook Dev - team. In this post we will explore two new functions provided by Outlook 2010, which is not very apparent: Connection Status and Test E-mail AutoConfiguration are for viewing the connection status and testing email protocol and server configuration settings, respectively. The Connection Status is a feature that verifies the current status of connection with mail account servers, informing users about the issues they may be encountering while syncing the mail folders. The Test E-mail AutoConfiguration, on the other hand, conduct a number of tests to check whether the mail accounts are properly configured or not. While you don't have to test the configuration frequently, it may help you in situations where Outlook fails to sync the mail folders and goes offline without throwing any exceptions. The connection status and test email auto-configuration are basically developed to test connection with MS Exchange Server. However, you can use them with both POP3 and IMAP mail accounts. Read More

System Performance In Windows 7 Taskbar

by on
1

Most System Performance monitoring tools work from system tray. Windows 7 has an awesome taskbar which can help certain users display basic visual information on it. Windows 7 Taskbar Monitor is a small portable tool that does exactly this. According to the developer, it is inspired by iStat Pro for Mac OS X.

Read More

Extract Multiple Addresses From A vCard File

by on
2
The Mac Address Book offers storage of contact information in the all-popular vCard format. Consider having multiple addresses/contact information within one vCard file for a particular contact, and you wanted to separate all of these out in individual files. vCard Splitter does exactly that for you. Read More

Add & Embed Excel Spreadsheet In Word 2010 Document

by on
6
Sometime there is a dire need of adding functions and formulas on data values present in Word document, for this you don't need to open Excel spreadsheet exclusively for formulating data values, you can also insert Excel spreadsheet in Word document. By following a simple procedure you can create spreadsheet which includes all the inherent features, functions and tools provided in Excel 2010. Read More

Send Outlook 2010 Calendar via Email

by on
Leave a comment
Unlike its antecedents, Outlook 2010 provides a very simple way to send calendar to the recipients via email. Through this feature you can send your weekly, monthly or even yearly appointments, events, and meetings schedule to the desired email addresses. This feature could be very useful especially when you need to give out complete schedule to concerned people. Read More

Excel 2010: Categorizing Numeric & Text Data

by on
Leave a comment
Excel 2010 provides a list of functions that lets you categorize the value types in the spreadsheet. You can use a wide range of built-in function or create custom formulas to categorize your data set into different group to perform further complex operations. Using ISTEXT, ISNUMBER and ISNONTEXT functions, you can easily make categories of data types (text or numeric), and perform more operations over two logical values TRUE or FALSE, as these functions yield TRUE or FALSE against the specified values. These functions take a single argument, which can either be the location of cell where data is residing or direct values. The above mentioned function help users identify the type of data from a large data set. For instance, if you want to apply some formulas on only numeric values in a data set, use ISNUMBER function to quickly check the cell location of all numeric values, and then apply the required formulas or functions over them. In this post, we will categorize numeric and text data of a simple data set. Read More

Share Excel 2010 Workbook With Windows 7 Homegroup

by on
3
Excel 2010 provides an extremely useful feature that enables users on network to share and access spreadsheet. Through worksheet sharing, you can take input from other users as well, and let them do analysis and point-out any mistakes you might have done. Excel 2010 enables user to share and access spreadsheets in very convenient way, you just need to enable sharing for the Excel file or place it in network location and other users can view and make changes to it simultaneously while you are working on the spreadsheet. Apart from simple sharing, it also lets you apply required constraints and rules over the spreadsheet. Read More

Excel 2010: DCOUNT Function

by on
1
Excel provides a very simple way to pull out data from databases to perform desired functions over it. It also provides list of functions which can be used exclusively for databases, you just need to create a database or simple table and let Excel know to consider it as one complete database, define some criteria to pull out specified entries. Excel DCOUNT function lets you to count the occurrence of specified data if the criteria is met. Read More

Untethered Jailbreak iPhone 3GS OS 3.1.3 Via Userland Exploit

by on
2
Got a third-gen iPhone 3GS on iOS 3.1.3 and can't wait to jailbreak it? We've got a treat for you! Yesterday, famous iPhone hacker Comex uploaded a video on YouTube showing an untethered jailbreak of a 3rd generation iPod Touch running OS 3.1.3. Not only does the video meet all the guidelines of a good jailbreak video as set by the iPhone Dev Team, but it also got the approval of MuscleNerd as being legitimate. Check out the video after the break. Read More

Get Free Voice-Based GPS Navigation On iPhone 3G & 3GS

by on
1
Free voice-based turn-by-turn navigation solution has been a hallmark for Android devices, with the wonderful Google Maps software. Nokia also followed suit, announcing a similar offer for its smartphones. Now iPhone users can also jump on the bandwagon with the latest release of AOL’s MapQuest 4 Mobile. Yes, the software now offers basic voice guidance and off-route assistance warnings. Read More