BInterest

How to Add Sparklines (Single Cell Graph / Graph within Cell) in Excel 2010 ? One of the Most important & innovative Addition in the Microsoft Excel 2010 is Sparklines. What are Sparklines ? Sparklines are tiny Graphs with in Single Cell of Excel, which helps the viewers of the Excel report to quickly explore [...]

How to Integrate Twitter with Microsoft Excel with & without Excel Add-ins same as something like Twitter Client for Microsoft Excel in Office ? Integrating Twitter (Most used Micro blogging tools today over internet) with Microsoft Office’s Excel (Most used Office product worldwide in Office) would be a killer combination for all the twitter users [...]

How to auto rename excel worksheet tabs to specific cell via VBA code or macro ? There is not official way / ribbon button / function to auto rename all the tabs in excel workbook as per contain of specified cell within that sheet. Renaming the tabs of the excel workbook is must for the [...]

How many times, you need to enter or are willing to enter current time & date in the excel sheet but could not do so. The Answer is many times., One of the reader of this blog, was in need of the ways to enter current Date & Time into the Excel Sheet, he was [...]

If you were in search of the Text language Translator, that means you have not yet used office application at their extended limits for sure. Why I am saying like this ? Because the Excel 2007 / 2010 can be used as the language Translator for Text Paragraphs. Translating Text into different languages worldwide is [...]

There is no option available within Excel to compare two excel sheets for a change. What if you have created a huge worksheet which have huge database along with the formulas. And you send the same to your client for a review, and same file after few days comes back with some minor changes. How [...]

Rather then editing huge excel tables within power point presentation, there is a better way to say your excel sheets embedding into the PowerPoint presentation as a separate Excel sheet and then edit them. Best way to embed the Table into the Presentation (.ppt or .pptx) is via Excel Sheets, Just copy your table from Excel sheet into the Presentation.
But [...]

Most of the extensive users of Excel application, open too many excel files in their day’s work, and most of the times it is the same file several times which you need to open for a reference or for a regular updates. In Office 2007, when you click on Office button on top left, My [...]

Printing Better Print Out of your Excel Sheet is what makes your presentation of the data looks proper and free of errors and clutters. This Excel Tip provides you the way to print better with Gridlines & Headlings of Excel. A printout of data can be more useful if you print gridlines and column and row [...]

One of the most awaited Microsoft product after the launch of Windows 7, on 22nd Oct, 2009 is Microsoft Office 2010 which promises to be one of the best of its kind. Some of the major areas of improvement incorporated in the Microsoft Office 2010 includes Extended File Extensions, Improved User interface & redefine the [...]

H in the Hlookup function stands for the Horizontal. i.e. row wise lookup function in excel. It searches the value in the rows of table and returns the value in the same column in an table from the row you have specified during the lookup function syntax. More simpler way to understand the same would [...]

The Only Tab, which is not displayed by default, to all the users of the Excel 2007 in the New Ribbon is the Developer Tab, which is useful for all the users who intend to work with Macro’s and VBA Codes or even insert some blocks or drop down menus to build a Dashboards. Before [...]

In Excel 2007, VLOOKUP Function search for a value in the 1st column of the table in study and returns the corresponding value in the same row from another column in table in study in the Vertical Direction. VLOOKUP FUNCTION can be used when you are in need of the searching the specific value for [...]

We all felt in love with the newer Excel Version (2007), due to its looks and increased capability but what was really frustrating was finding the Excel 2003 Menu Functions in the Excel 2007 Ribbons. It took nearly 2 to 3 Weeks for me to find all of them and get use to the same. [...]

As by profession, being a Market Research Analyst, came across a interesting Data Mining technique, called as Market Basket Analysis. It is nothing but a type of If – then Data Mining Technique, in simple world, “Modeling technique based upon the school of thought that if you buy a certain group of items, [...]