This post will provide you with a basic idea about how to take print in excel properly. First, you have to select the area which you want to print as I have shown in the picture above. Then you have …
Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by WHO. Let’s check where are we in our lifeline by this sheet. Let’s take an input of the date of birth from the user. …
Press Ctrl+F to toggle the Find and Replace window>Replace Tab or go to Home Ribbon> Find & Select> Replace Here you will get the replacement feature of excel. In this post, I will discuss the 4 most useful ways of …
Lesson#50: 4 most useful way to use Find and Replace Read more »
If you know the use of the character “&” then it can replace the function CONCATENATE. You can join one or more numbers or texts using “&” between them to convert them into a single text. Place “&” and other …
Lesson#45: “&” can replace the function CONCATENATE Read more »
This post has tips for those who need to work in excel regularly in office work, study, and other areas. We should keep in mind that working by not using a mouse, just using a keyboard increase our working speed. …
Lesson#23: Work fast in Excel using keyboard shortcuts Read more »
You are having a table full of data and you want to convert columns to rows or vice versa. Excel has a feature that is TRANSPOSE which allows pasting rows as columns and columns as rows. For Example, I have …
Lesson#10: Rotate table data from rows to column and vice versa by TRANSPOSE Read more »
OK friends. This is going to be my first lesson. The ABCD of Excel starts here. We will learn how to make basic operations in Excel. How to add, subtract, multiply and divide two numbers. This picture now shows how …
Why Excel? Microsoft Excel is a very powerful software developed by Microsoft Inc. It’s a spreadsheet software where we can make any type of data calculation, chart, or graph preparation. It is very much useful and widely used in offices …