Entries by Vivekananda Sinha

Reversing Row order in Excel

In many cases we face challenges in reversing row order in Excel.  There are two simple approaches for doing this. One is to add an extra column with serial numbers and then sort on that column in descending order. This works perfect for small amount of data. For big data it is best to use Microsoft Power […]

Microsoft Excel Version History

Microsoft Excel is the largest used Reporting and Data Analysis application now a days. Its important to know the Microsoft Excel version history since the version 1. The table below lists the various versions of Excel for Windows.

Business Intelligence

Wikipedia defines Business Intelligence (BI), the set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis purposes. There are other definitions of Business Intelligence that are used in the Corporates, few of them are: Business Intelligence refers to skills, processes, technologies, applications and practices used to […]

VLOOKUP using Approximate Match

In a lot of cases, we use VLOOKUP to find exact matches, based on some kind of unique id. But there are many situations where we can perform VLOOKUP using Approximate Match. A classic case is using VLOOKUP to find a Grade for the students where marks are provided. Suppose we are provided with Test scores […]

Excel Error and Related Information

While working with Microsoft Excel, we come with various type of error. This Article will guide you through the different error in excel with example and fix for each of these error. #DIV/0! This error comes when something is divided with 0. Example: A Cell with the Formula =15/0 would return in this error. Fix: Do […]

Working with Excel Table

An important but often underutilized feature in Excel is tables. This tip describes when to use a table and also lists the advantages and disadvantages. Understanding what a Table is: A table is a rectangular range of structured data. Each row in the table corresponds to a single entity. For example, a row can contain information about […]

Generating a List of File Names

This tip describes how to retrieve a list of file names in a folder and display them in a worksheet.This technique uses an Excel 4 XLM macro function in a named formula. It’s useful because it’s a relatively simple way of getting a list of file names into a worksheet – something that normally requires a complex […]

Send Outlook Mail from Excel VBA

This article features code that you can use to send outlook mail from Excel by using the Microsoft Outlook object model. The below code can be used to send an Outlook mail directly from Excel. Sub SendOutlookEmail() Dim OutlookApp As Object Dim OutlookMail As Object Set OutlookApp = CreateObject(“Outlook.Application”) Set OutlookMail = OutlookApp.CreateItem(0) On Error Resume Next […]

Resume Writing Tips

Know the purpose of your Resume Some people write a resume as if the purpose of the document was to land a job. As a result they end up with a really long and boring piece that makes them look like desperate job hunters. The objective of your resume is to land an interview, and […]

What 4 Common Interview Questions Really Mean

Acing the interview isn’t just about having the perfect canned speeches. Yes, you need to show off your experience, talents, and personality—but before answering each question, you also have to figure out what the interviewer is actually asking you. Those seemingly innocuous questions, like “tell me about yourself” and “where do you see yourself in a […]