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…
Sometimes we want certain pages in a different orientation from our MS Word document. So In this video, we learn to change the portrait to landscape orientation of one page only.
Always, before printing anything we need to first do Page Setup in MS Word (like Page Size, Page Orientation, Page Margin and Line Spacing, etc). Using the Page Layout Tab you can do this. In this video you will know to Page Setup using the Page Layout Tab step by 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…
Microsoft PowerPoint is a powerful tool to create presentations with all its elements (like narration, animation, pointer movements, timings, and so on). Sometimes we need to convert PowerPoint presentations in video format. Because video file is easy to share on Youtube, WhatsApp, Facebook, Twitter, Instagram. Fortunately, PowerPoint (2010 & upper 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 need to compare two MS-Word documents to know about difference. If we have a very long document, then it may be a tedious job to compare. But, Microsoft Word provides a very powerful feature for document comparison. After using this compare feature… We are able to see all Read more…
Sometimes we need to check, is there any duplicate paragraph or repeat sentences in our MS-Word document. If we start finding the duplicacy & removing them manually, which takes a lot of time. Because we could have a long document which may consume our time and efforts. But unfortunately, MS-Word Read more…
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…
Sometimes we need to remove/Replace/reformat so many words, which are enclosed with brackets. If we remove these bracket with content manually, it will take a lot’s of time. Because we could have a very long document & many more like this. Follow these Steps as shown in Video to remove/change 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…
Sometimes, we need to copy matter or text from the Google Chrome to MS-Word. Then we face some issue related to the watermark which is covered by the white color background. We do all type of experiments to remove white background like font color & Text highlight color, but we Read more…