Yearly Archives: 2010

Make Outlook 2010 Update Send/Receive Process Before Exit

by on
1
Outlook 2010 Send/Receive is responsible for checking new mail items and other updates in all the included mail accounts, if you need to always run this process before exiting Outlook, you can easily set it up in this way. To make Outlook always perform Send/Receive update on exiting, head over to Send/Receive tab, and from Send/Receive Groups options, click Define Send/Receive Groups. Read More

Outlook 2010: Search For Calendar Items

by on
Leave a comment
Outlook 2010 provides real time search for calendars’ items; tasks, events, meeting schedule, etc. If you’re overwhelmed with lot of events, schedules, tasks etc in Outlook 2010 calendar. It is a bit hard to find manually the one for which you’re looking for. Since Outlook 2010 has real-time search capability, you can search for the specific event/task instantly. Read More

Merge Spreadsheets Using Data Consolidation In Excel 2010

by on
11
We usually maintain the data in multiple worksheets to check the data for each instance and to view them individually but it would be great to merge all the data from different worksheets in Excel spreadsheet to analyze it. Consolidate feature in Excel 2010, lets you to pull-each record from the worksheet in to one master worksheet, which adds-up all data from spreadsheets. Through Consolidation, you can summarize data from multiple sheets into one designated master sheet. By assembling data in to single master sheet, you can modify, or aggregate it under one window. Read More

Excel 2010: Using SUMPRODUCT Function

by on
6
Excel SUMPRODUCT is one of the most used function. Because of it's versatility, it can be used in numerous ways. This function can handle array in a simple way, giving novices an option to use array without comprehending the structure of it. It can manipulate up to 25-30 arrays, requires list of array as argument; =SUMPRODUCT(array1, array2….). So you just need to specify range of array in your worksheet. Primarily it is used for adding and then multiply the values stored in array. This post will be putting some light on how to use this function in your spreadsheet. Read More

Excel 2010: Checking Logical & Syntax Errors

by on
Leave a comment
While getting your head down on a huge spreadsheet which contain maze of values, data, text, etc, then it is quite possible that you missed out logical & syntax errors. As logical errors can not be identified by Excel compiler, you need to write some formulas which can point out any blank space, negative value, or even #NA! and #DIV/0! errors. Thanks to Excel built-in functions which can easily get rid of these anomalies in the spreadsheet. This post will cover how to use Excel built-in functions to identify errors. Read More

Word 2010: Insert Tables & Formulas

by on
33
Word 2010 provides a great feature of using tables along with document content to complement and summarize it in a better way, but sometimes in tables we also need to write the formula for evaluation of values. Although it does not support a huge range of formulas, we can use basic formulas that will be sufficient for most users. This post elaborates how to create and apply new design over the table and how to get required results through formula with simple illustrations. Read More

Excel 2010: Password Protect Spreadsheet

by on
18
The two mostly used protection levels in Excel are Worksheet Protection and Workbook Protection. Sometimes these two terms mean the same but actually differs from each other. From Worksheet protection you can have a total control of spreadsheet or datasheet, by protecting each element your worksheet encompass. In this level of protection you can prevent users from modifying data, cells, formula, name ranges, etc. Read More

Add Math Equations With Word 2010 Equation Editor

by on
19
When writing a document which primarily covers mathematical signs and equations then using Word 2010 built-in Equation feature would be of great help. In Word 2010, you can insert Equation from the built-in list instantly. Handling equation that you have written by yourself would be a bit tedious task to get by, but through this feature of Word you can manipulate them by performing simple actions and clicks. In this post we will explain how easy it is to use Equations in Word. Read More

Comparative Histogram In Excel 2010

by on
3
Charts are one of the most eminent feature  in Excel but sometimes you need to use them in a different way. We will try to make a Comparative Histogram out of the table data which is quite unique from the rest of the charts. In this type of Histogram, we compare two sets, or groups of data using horizontal bars, so our main emphasize will be on horizontal bars in the chart. If you will ever need to make a chart out of your spreadsheet which contains two sets of data, then this post would come helpful. Read More

22 Free Windows 7 Apps That You Should Know About

by on
32
Microsoft’s Windows 7 brought with it a revolution in the way the Windows operating environment worked, behaved, looked and felt. Though loaded with a host of useful features, many third-party apps out there can actually make life much easier for any average Joe. Hence, we present a collection of 22 freeware for Windows 7. Hang on tight and enjoy the ride. Read More

Insert Checkboxes In Excel 2010

by on
32
Excel provides very useful Form Controls which enable users to create a control & operate several things simultaneously. You can add Buttons, checkboxes, Labels, Combo-box, Scroll list etc. The real usage of form controls can be attained when you are dealing with colossal datasheet, and you need to invoke several functions and actions in desired order. These controls also abet you, when the data cells interconnect with each other. In this post we will be using Checkbox form control in a scenario where more than two ranges are related with each other. Read More

Word 2010: Adding Dictionary For Common Words

by on
1
Like previous Word versions, Word 2010 also includes a powerful dictionary to detect misspelled words, and suggest you to choose alternatives, etc., but one major downside of this feature is that it always points-out when you have written names and special terminologies in the document. Although you can add them in the default Word dictionary, but it would be better if you could make your own dictionary that contains special terms, phrases, and names that you frequently use while writing. Word 2010 also provides users with an option to add another dictionary. In what follows, we will explain how you can add your custom dictionary in Word 2010, so that it stops showing the red squiggly line underneath the unknown words. Read More

Compare Word 2010 Documents For Changes After Recovery

by on
1
Word 2010 provides you an excellent feature to compare documents, it happen sometimes that while writing documents, the system stops responding or crashes due to some reason. Though Word has an Auto Save option to recover it back, but then it would be bemusing for you to compare both documents manually. By using Compare Document feature you can automate the process to cope up with this problem of comparing both versions. It would be also useful when you need to compare two versions of document for viewing detailed changes. Read More

Find Length of Characters In Excel 2010

by on
2
With simple formula, you can find out the length of characters in text, sentence and in the table data instantly. Through Excel LEN function, you can check the length of characters your datasheet contains. LEN is a simple function, which requires only one argument to be provided with. This post will be putting some light over it. Read More

Manage & Sync Google Calendar Events And Contacts From Desktop

by on
Leave a comment
There are not many stable desktop applications that can sync with Google Calendar, you can use Live Calendar Gadget to get the results but only to be disappointed that it does not support 2 way syncing. Azotix Active Organizer is the first complete windows desktop application of it’s kind we have come across, that can create, edit, and remove events from Google Calendar. Read More

How To Remove Ads From Cydia In iPhone/iPod Touch

by on
20
For iPhone/iPod users, advertisements can become a real problem when using Cydia. While the package installer itself isn't the fastest one around, it gets even slowed down much more due to the ads mostly sponsored by Google or Fastclick. Although most users are not aware of it, it is relatively easy to get rid of these annoying ads in Cydia once and for all. Read More

Windows 7 Setup Customization With Win Integrator

by on
9
Microsoft’s Windows 7 operating system comes with a lot of features and programs that may be useful to some (that’s why Microsoft put them there in the first place), but to most average users, these features will only serve to consumer unnecessary hard disk space. Unfortunately, Windows itself does not provide any option for their removal. Win Integrator is a free utility that allows a user to perform a customized installation of the Windows 7 and choose what to install and what not. Read More