Sandeep Agarwal

Edit Plus is without doubt one of the most feature-rich text editors. In fact, its capabilities run beyond a text editing tool. Hence, it is widely used in the industry, especially by programmers. Image via Flickr.As a programmer myself, I must

Formatting a document definitely increases its readability and visibility. I am sure you highlight pieces of text by applying different types of formatting. Now, let me ask you a question. How often do you need to apply bold, italics, and underline f

Back in my schooling days, the thought of writing page numbers on a Word document used to ring alarms in my head. That is because I did not know about the Insert Page Number feature. Yes, it’s hard to believe that I used to do it manually.

Image by Kyrien via shutterstock.We’ve all bumped into Windows Safe Mode either accidentally or by necessity. We have also experienced how Windows loads with minimal functionality when in safe mode. The idea behind such a setup is to allow the

Image by Phil Whitehouse via Flickr.You will agree that an Excel sheet can run up to thousands of rows and columns. You will also agree that when you are working on one such worksheet, you might have to navigate into deep rows and columns. This takes

A few years back, collaborating on documents was not as easy as it is today. People had to exchange documents over email messages, maintain multiple local copies, track changes and maybe even resort to a version history table in the document itself.

Image via Flickr.What’s the first thing that strikes your mind when somebody talks about sorting? I’m sure ascending and descending are two words that ring a bell. Or maybe it’s the ever illustrious Sorting Hat from Harry Potter. Original Image

In order to use MS Excel formulas properly we need to have clarity about the different types of cell references. We’ve already discussed some of them. But today, we will discuss the concept of names, which make it easier to build, use, and understa

I always wanted to learn the art of typing any character from a given font set. Take for example, ¤. But, how do I do it, was the question? Now, have a quick glance at your keyboard.

I used to hate working with MS Excel sheets because it required a lot of patience. The constant switching between the mouse and the keyboard is just not fun. For working with data I needed the keyboard and for navigation I needed the mouse.

What’s your first choice of media player? Also, what are the reasons that make it a favorite? If you were to ask me, I would say VLC Media Player and KMPlayer. They are known for their ability to play almost all available media formats. I use

Microsoft Excel is huge in terms of its underlying features and functions. So are the keyboard shortcuts in it. The list can go on and on. What we will do is limit our scope and concentrate only on Function Keys today.

Have you ever left your computer on, only realizing later that you wouldn’t be able to get back at it until a few hours? Well, I must admit that I have this foolish habit. And hence, it became very import for me to find a way to switch off my compu

Microsoft Excel is all about working with data. Its interface consists of the ribbon, taskbar and the worksheet. The worksheet is the working area for your data and has cells that are separated by gridlines. Now, moving around the worksheet from

Microsoft Excel stores dates as sequential serial numbers and not in the format that we see. By default, 1st January 1900 is serial number 1. So, 10th May 2014 becomes 41769. Storing dates as serial numbers makes it easier for the tool to perform dat

Unless you are a pro at managing and organizing meetings and appointments, they can quickly get overwhelming and tire you out. Besides, it also helps if you are quick in scheduling one when needed. Outlook’s desktop client as a to

Gridlines are faint lines that act like cell dividers in MS Excel. They distinguish cells from each other and make data in them more legible. By default the gridlines are active on Excel. But depending on the kind of a data a worksheet contains, it m

What’s the secret of a good presentation or a good presenter? Usually, a good presentation is low on words and high on pictures (could be animations, tables and charts too). It also depends on how well the presenter is able to put his poi

MS Excel formulas is what drives the ultimate power of the tool. And, in order to master the use of formulas you need to understand what cell references are.

If you work for a financial organization you would know and understand the importance of reporting. You would also know that it’s not just the data in the files that’s important but also data about the files.