If you have so many Excel Worksheets & you want to combine their data. Then you can do it using with consolidate feature easily. Excel can automatically summarize or consolidate your data from multiple worksheets into one. So In this video, you will know how to use the data consolidate Read more…
If your excel cell is not scrolling, that means Scroll Lock is on. In this video, you will learn to remove/unlock/disable/turn off scroll lock in excel. So watch this video till the end for the complete solution.
If you want your Excel data more accurate then you can create a Drop-Down List in Excel. (Using Data Validation). In this video, you will learn to make two types of drop-down lists in excel, so Watch this video till the end.
Flash Fill is one of the best tools of MS-Excel. It automatically fills your data when it senses a pattern. You just need to enter a sample text, you want as output. Flash Fill will show you a preview of the data. Just check the list, if it’s ok then Read more…
Sometimes we have large amounts of data in Excel and we need to Filter data by related words or text. In MS-Excel we used to “Sort & Filter data” option at a basic level like Sort A to Z or Sort Z to A. But “Sort & Filter data” option Read more…
If you are usually work in MS-Excel and don’t know about VLOOKUP formula then you should know about it, which is one of the most important functions of Excel to find data in a table or range. The most important thing is that VLOOKUP formula also works between two sheets Read more…
If you have such type of MS-Excel file which data have so many Unwanted/ blank/extra space before and after text. That is also called leading, trailing and non-breaking spaces. Then in this video, you will know to remove extra whitespace from entire column at once.
Sometimes we have an Excel Sheet, which has a large number of mobile contacts. And we want to save them on android mobile. If we will save them manually, then this task is very time-consuming. After watching this video, you will know how to save Excel contacts to mobile phone Read more…
Sometimes we need to calculate difference between two dates in Excel. It’s purpose can be age calculations or anything else. If you will search on the internet, you won’t find single combine formula to get years, months & days between dates (Ex: 14 years, 2 months, 28 days. ). In this Read more…
Sometimes we need to convert vertical data into horizontal in MS-Excel quickly. But due to unawareness, we start converting all the data manually. And this process can be very time-consuming. You will be glad to know that, MS-Excel has an important feature, that is called the “Transpose”, which can help Read more…
Sometimes we need to split one column into multiple columns in excel. But due to unawareness of some advance feature of MS-Excel, we start to separate column/cells manually. In this video, we are sharing two different examples, so you can understand the “text to columns” feature in a better way. Read more…
We always face a problem using the VBA macro code, that it only works in the Open Excel workbook. Because when we open a new excel file, our saved macro code not showing there. If you want the macro code permanently stored in Excel, as part of the programme. So that Read more…
Everyone wants to save paper at the time of printout. As a result, we always try to take print both sided using the odd-even feature, either it’s an MS-Word document or pdf file. But unfortunately, MS-Excel doesn’t have this important feature. So In this video, we are going to share Read more…
MS-Excel doesn’t come with a built-in watermark feature. If you want to insert watermark in Excel then In this video, you will know how to insert/add watermark in MS-Excel. So follow all video steps & learn new thing.
If you have lots of contacts in Excel file then now you can convert it directly in “.vcf file”. After watching this video you will not need Google Contacts or any other online converter to convert your .csv file to .vcf file. Now follow all the video steps carefully to get the complete Read more…
Sometimes we have a large no mobile contacts in excel sheet which we want to save in our android mobile. If we will save them in our mobile one by one, it will take a lot’s of time.In this video, you will learn to save contacts in your phone directly Read more…
If you want to print your Excel workbook, you have to set the document to print that page, especially if you have a large number of data in your sheet. Here you will find everything in this video, Which you need to prepare your workbook for printing in Minimum Page. Read more…
Sometimes at the time of work in MS-Excel, we make some common mistakes like duplicate entries. If we try to remove duplicate data manually, It can be a hard & time-consuming task. In this video, we are going to share the best way to find or highlight duplicate values automatically. So that you can Read more…
Many times we are in need to convert the numbers into words. This is a typical requirement for writing cheques or for any other reason. Microsoft Excel does not have any standard function for this requirement. For the solutions, here we made some different “Excel Add-ins” which convert figures into Read more…
Every time we need to change the desired matter or text in Lowercase, Uppercase, Proper case letters in Excel. Unfortunately, MS-Excel doesn’t have important change case feature like MS-Word. In this video, you will learn to enable Change case feature without formula. Just need to use macro code (VBA-Visual Basic Read more…