VLOOKUP is one of the most used Excel functions. It helps to look up data in the same worksheet, different worksheet, or different workbook book easily. Most people are used to looking up values from the same Workbook but not separate Workbook. For this reason, I will guide you on how to VLOOKUP between two […]
How to VLOOKUP between two Excel Files Read More »
Do you have data full of duplicate values that you wish to clean? It can be annoying to have repeated values in your worksheet. Luckily, Excel has inbuilt features to handle just that. You can take advantage of these features to remove duplicates in Excel easily. In this guide, I will show you different methods
How to Find and Remove Duplicates in Excel: Simple Guide Read More »
Deleting subsequent rows is very easy as you just highlight, right-click then select delete. The challenge comes in when you want to delete every other row. It can take ages to highlight and delete every other row manually. However, there are a few ways you can achieve this efficiently. In this tutorial, I will show
How to Delete Every Other Row in Excel: Easy Guide Read More »
Footnotes are helpful when it comes to providing extra and important details. Although Excel is not a word editing software, you can still add footnotes. This can be helpful, especially if you have data and charts that need a little extra explaining. In this tutorial, I will show you how to add a footnote in
How to add a footnote in Excel: 4 Easy Methods Read More »
There are so many scenarios in which you need to remove the last digit in Excel. If you are dealing with less data, then it can be easy to remove the data manually. But if you have a huge chunk of data, it can take ages to get rid of the last digit. In this
How to Remove Last Digit in Excel: 5 Simple Ways Read More »
One of the most popular questions I always come across is how to move a table in Excel. There are many ways you do that, depending on what you want to achieve. For example, you can move a table with or without formatting. Additionally, you can choose to move it with or without the formula.
How to Move a Table in Excel: Easy Guide Read More »
Excel is highly useful when working with formulas, functions, and complex calculations. But editing content, especially text, can be a daunting task. Excel is not optimized for editing text, unlike Microsoft Word, Google Docs, or other text editing programs. For this reason, if you want to present your data cleaner, you have to play around
How to split text in Excel: 6 Easy Ways Read More »
Inventory management is among the most tedious work. Luckily, you can integrate barcodes to help track and manage your inventory. Tracking products manually is time-consuming and may cost you extra money to hire labor. Excel is the best office tool to store and manage inventory. Combining these two technologies make the whole process seamless and
How to Create Barcodes in Excel: Easy Guide Read More »
QR code is a 2D barcode that can be interpreted by mobile phones or scanners. Since they were introduced, QR codes have become integral to file sharing and linking physical objects. Once you scan a QR code, you will be directed to an app, website, audio, video, or text file. Creating a QR code is
How to Generate a QR code in Excel: 5 Easy Ways Read More »
It can be tedious to combine data manually in Excel. Luckily, you can save time and energy by taking advantage of formulas and VBA to combine cells in Excel. In this tutorial, I will guide you step by step on how to do it. How to combine two cells without space Combining two cells without
How to combine cells in Excel: Easy Guide Read More »
