Skip to content 
How to Convert Inches to MM, CM, or Feet in Excel? If you work with measurement data and need to convert the data from one length measurement unit to another, you can operate some inbuilt formulas in excel to do that. For example, you may need to convert data in centimeters/millimeters to inches or feet. […]
How to Convert Inches to MM, CM, or Feet in Excel? Read More »
How to Highlight Weekend Dates in Excel? When working with dates in MS Excel, you may sometimes need to highlight only specific days of the week. For a sample, you may have a list of dates where you want to highlight all the weekend dates. It can quickly be done using Conditional Formatting with a
How to Highlight Weekend Dates in Excel? Read More »
Most Excel users prefer to type the formula directly within the cell when writing formulas in Excel. However, when working with large complex formulas, typing or editing the procedure in the cell becomes a bit hard. In such cases, usually do this in the formula bar. A formula bar is a bar below the ribbon
How to Hide or Show Formula Bar in Excel Read More »
How to Fix #VALUE Error in MS Excel? When you’re working formulas in Excel, you will often encounter the #VALUE error. While the error is rather generic and doesn’t tell you what the problem is, in most cases, this happens when you give a formula a data type that is not desired (explained with
How to Fix #VALUE Error in MS Excel? Read More »
One area that often troubles MS Excel users is working with dates. This is mainly because dates can be formatted in many different ways in Excel. So while you may see two dates in Excel and believe those are the same, there is a possibility that these might be different values in the back
How to Compare Dates in MS Excel (Greater Than Less Than, Mismatches) Read More »
Copying and Paste a cell or a range of cells is one of the numerous common tasks users do in Excel. A correct understanding of how to copy-paste multiple cells (that are adjacent or non-adjacent) would help you be a lot more efficient while working with Microsoft Excel. This tutorial will show you distinct
Copy and Paste Multiples Cells in Excel (Adjacent & Non-Adjacent) Read More »
Excel is not only a wonderful tool for data entry and data analysis but likewise great at making charts, flow charts, simple diagrams, etc. It’s quite simple in Excel to insert a line then customize and position it. You’ll be surprised how multiple options you get when you need to draw a line in Excel.
How to Insert Or Draw a Line in Excel Straight Line, Arrows, Connectors Read More »
Excel can be quite useful when you’re working dates. It has powerful built-in formulas that allow you to do calculations based on dates. One common strategy for performing calculations with dates would be to find out how many years or months or dates have elapsed between two given dates. It could especially be useful to calculate
How to Calculate Years of Service in Ms Excel (Easy Formulas) Read More »
I was a math nerd in school, and the sections about probability and permutation/combination were among my choices. I remember spending a lot of time calculating factorials as a part of the possible calculations. But if you’re using Excel and somehow get into a condition where you need to calculate factorial, you don’t need to
How to Do Factorial (!) in Excel FACT function Read More »
3 WAYS TO FIX EXCEL CAN NOT OPEN THE FILE Book1.XLSX’ BECAUSE THE FILE FORMAT, OR FILE EXTENSION IS NOT VALID ERROR Sometimes Excel files don’t open properly or don’t open at all, which can cause a lot of stress and terror. No one likes to lose important information or create another document from scratch,