Entries by Vivekananda Sinha

Most Common Interview Questions

When it comes to the Interview Process, research and preparation for the interview can often times determine your chances of making it to the next step. One of the best ways to get ready for a job interview is to practice your responses to any and all interview questions – even the downright weird. To […]

Filling Gaps in a Range

When you import data, you can sometimes end up with a worksheet that looks something like the one shown in the figure. This type of report formatting is common. As you can see, an entry in column A applies to several rows of data. If you sort this type of list, the missing data messes things up, and […]

Using SmartArt to create a bulleted list

We can use SmartArt to create a bulleted list in Excel. Choose Insert➜Illustrations➜SmartArt, and choose the diagram style from the dialog box. The below figure shows a “Vertical Bullet List” SmartArt diagram. This object is free-floating and can easily be moved and resized. The example shown here uses minimal formatting, but you have lots of control over the […]

Why Base SAS Training can get your Career into Orbit

Those contemplating Base SAS training, should not thinking and start acting! Business intelligence has provided businesses an opportunity to leverage streams of data. From this data organizations conclude on a variety of statistics. It could be the average inventory fulfilment ratio to customer purchasing patterns to geographical acceptance of a service. In the next several […]

Top Reasons to take SAS Training

The rise of Business Analytics has created a demand for candidates haven undergone SAS Training. SAS is a renowned data analytics tool used worldwide. There is a demand for SAS programmers, analysts, consultants, and modellers. The domain of data science is becoming huge as digital information increases. The following information discusses some of the challenges […]

Useful Keyboard Shortcuts

Windows Common Shortcuts  CTRL+C (Copy) CTRL+X (Cut) CTRL+V (Paste) CTRL+Z (Undo) DELETE (Delete) SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin) CTRL while dragging an item (Copy the selected item) CTRL+SHIFT while dragging an item (Create a shortcut to the selected item) F2 key (Rename the selected item) CTRL+RIGHT […]

Join multiple text quickly

We sometime comes with the challenge to join multiple text in Excel. The first thing that comes into our mind is to use the CONCATENATE Function. The major challenge in using this function that we cannot select a continuous Range such as CONCATENATE(A1:A10). To get the result we need to specify all the cells individually. To do […]

DATEDIF function

DATEDIF calculates the difference between two dates and expresses the result in terms of months, days, or years. The DATEDIF function, which isn’t documented in the Excel Help system, is one of the little Excel mysteries. Although the Excel 2000 Help system has an entry for DATEDIF, the function is not documented in earlier or later versions. The […]

Exclusive Run commands

Most wanted Windows RUN (DOS) Commands Finally collected in iLearn: Accessibility Controls = access.cpl Add Hardware Wizard = hdwwiz.cpl Add/Remove Programs = appwiz.cpl Administrative Tools = control admintools Automatic Updates = wuaucpl.cpl Bluetooth Transfer Wizard = fsquirt Calculator = calc Certificate Manager = certmgr.msc Character Map = charmap Check Disk Utility = chkdsk Clipboard Viewer […]

Count Unique records in a Range

In some situations, you may need to count unique records in a range. The below figure shows an example. Column A has a list of cities, and the goal is to count the number of unique cities in the list. The formula in cell C3 returns 7, which is the number of unique cities. To […]