About Sandeep Agarwal

Sandeep Agarwal is an engineer and a tech fanatic who has what seems to be an unending appetite for exploring all things tech. He loves to share his discoveries too and that's what keeps him going at Guiding Tech.

Sandeep on Google+

How to Use Row and Column Markers on Edit Plus

Highlighter

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. As a programmer myself, I must often look at source code, debugging log files, data files, and much more. And when I do that, […]

How to Create a Button in Excel or Word to Apply Multiple Formatting

Select-BIU

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 formatting (all at once) to text in your Word, PowerPoint, or Excel document? If […]

How to Use Field Codes in MS Word to Show Only Even or Odd Page Numbers

Page-Numbers

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. Time started giving me tougher requirements; like showing […]

A Guide to the MS Office Safe Mode and How It Helps

Safe-Featured

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 user to debug and fix issues in the machine that are stopping it from booting normally. Now, did you know […]

3 Ways to Jump to Cell A1 in MS Excel Real Quick

Change-Direction[1]

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 you away from the reference row and column i.e cell A1, where you might […]

How to Recover or Restore Older Versions of Files on OneDrive

New-Version

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. Then came the era of cloud services, enabling teams to work on single […]

How to Use a Custom List for Sorting Data in MS Excel

Sorting-Feature

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. Although those methods are tried and true (the Sorting Hat is never wrong), there are many other ways to […]

MS Excel Name Manager: How to Create, Use and Manage Names

Name-Tags

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 understand formulas. Names can be used to name MS Excel objects like […]

How to Easily Type Special Font Characters in Windows Using Excel

Character-Map-Scroll

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. Do you see ¤ character? You don’t, right? Actually you didn’t look properly, it is there. Open a […]

The Complete List of Navigation Shortcut Keys for Excel

Navigation-Compass

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. And that was far from productive. So I thought I should learn […]

How to Play YouTube Videos (and From Other Sites) in KMPlayer

Reel

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 either of these randomly but with two exceptions. I choose VLC […]

The Complete List of MS Excel Function Key (F1 to F12) Shortcuts

Function-Keys

MS 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. We will try and learn the actions associated with F1 through F12, standalone and […]

How to Shutdown Windows Computer Remotely Using Outlook

Remote-Control

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 computer even while I would […]

6 Cool Cell Selection Tips for Microsoft Excel Users

MS-Excel-Logo

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 one cell to the other or selecting one or more cells is not as easy […]