Excel Tricks with Tejraj

One of my friend asked me to provide dynamic way of converting binary numbers in to hexadecimal numbers. Though there is already a function available in excel BIN2HEX() but my friend requested me to provide some customization in it. I tried my level best and provided him a solution. We will learn to create same format through this blog post. YouTube Video: Just follow below easy steps and create your own template to convert binary numbers into hexadecimal numbers. 1. Under Developer tab click on Insert command ( Click here if developer tab is not visible on your ribbon ). 2. Click on Toggle button from the available buttons. 3. Draw a shape and you will see “Toggle Button” get appear on your screen. 4. Click on this toggle button and you will see “Format” tab will appear on your Ribbon . Under this tab adjust the height and width as below: Height: 1cm Widht: 1.65 cm 5. Toggle button will now look as shown in below image. 6. Right Click on the resized Toggle Button and click on “Proper...

This blog post is in continuation to our series of posts on “Conditional Formatting”. In this blog post we will see how to highlight Bottom 10 Items in Excel? But, before proceeding on this topic, first we should know where we can find “Conditional Formatting” option in Excel. We can find “Conditional Formatting” in “Home” tab and under Home Tab go to “Styles” group. We can find many sub categories under “Conditional Formatting”. But the one which we will focus in this blog post is to highlight “Bottom 10” Items. Below image will help you to find the exact option to highlight “Bottom 10 Items”. Now you are familiar with the option where we can find the option to highlight “Bottom 10” Items. To explain this topic in very simple way, I have created a dummy data of 20 students and marks obtained by them in subjects Maths, English & Science. Also we have used SUM function to calculate the total marks obtained by each student. Now we will see how we can highlight “Bottom 10” Items in co...

This blog post is in continuation to our series of posts on “Conditional Formatting”. In this blog post we will see how to highlight Top 10 Items in Excel?  But, before proceeding on this topic, first we should know where we can find “Conditional Formatting” option in Excel. We can find “Conditional Formatting” in “Home” tab and under Home Tab go to “Styles” group. We can find many sub categories under “Conditional Formatting”. But the one which we will focus in this blog post is to highlight “Top 10 Items ” . Below image will help you to find the exact option to highlight “Top 10 Items ” . Now you are familiar with the option where we can find the option to highlight “Top 10 Items ” . To explain this topic in very simple way, I have created a dummy data of 20 students and marks obtained by them in subjects Maths, English & Science. Also we have used SUM function to calculate the total marks obtained by each student. Now we will see how we can highlight “Top 10 Items ”  i...

There are many occasions when we want to clear unwanted things while working in excel. In this blog post we will learn about “Clear” command in excel which will help us to clear the unwanted things in excel sheet. We can find this command in “Home” tab under “Editing” group as shown in below image. “Clear” command is divided in 06 categories: 1. Clear Formats 2. Clear Comments 3. Clear Hyperlink 4. Remover Hyperlink 5. Clear Content 6. Clear All Let’s learn about this in detail… We have created dummy data to explain all these categories as shown in below image. Let us understand this dummy data first. This data is well formatted with header row highlighted with dark blue color with bold font having white font color. All the other rows are having light blue color with blank font color. Also we have applied “All Borders” to our entire data. (To learn more about types of borders Click Here). We have inserted two comments in our data in “Experience in Years” column for employees “CCC and “...