How to calculate the number of Leap Years between two dates in Excel
Keeping data on the number of leap years in a list is important for companies, government offices, and event organizers. If you need to check […]
Tag: Excel
How to count the number of Yes or No entries in Excel
In a list, you might need to count the number of Yes and No entries. This article discusses how to count the number of “Yes” […]
How to apply Data Validation to Cells in Microsoft Excel
When multiple data variables are accommodated in a project, the time and spatial grids of those variables must be identical. As such, you must control […]
How to insert a Dynamic Chart in Excel spreadsheet
If you need to display a dynamic chart in a spreadsheet, you can convert the data to the table and insert the chart afterward. It […]
How to use the TRUNC function in Microsoft Excel
We all have done some basic maths where we used to shorten a number with a lot of decimal digit. If Truncate and Round of […]
How to Group Worksheets in Excel
When working with an Excel file, you may have to apply the same formula or insert the corresponding columns to all the sheets. Grouping feature […]
How to increase the number of Recent files in Word, Excel, PowerPoint
If you open Microsoft Office apps such as Word, Excel, or PowerPoint, it greets with a screen containing some templates and recent entries. In case […]
How to use Insert Data from Picture feature in Excel
You can capture an image of a printed data table and import its information into Microsoft Excel via Insert Data from Picture feature in the […]
How to Embed an Excel Sheet on your Blog
When it comes to saving time, everybody has their way of performing tasks. Take the example of our social lives, we share things on every […]
Excel: Out of Memory, Not enough System Resources to Display Completely
When using Office 365 Excel application, you may receive an error that would point to “Out of Memory, Not enough System Resources to Display Completely” […]
How to split Text to Columns in Excel and Google Sheets
If a cell contains some text separated by comma or any other mark, and you want to split them into multiple columns, you should follow […]
How to extract domain names from URLs in Microsoft Excel
Sometimes you might need to collect the domain names for some reason from a long list of webpage URLs. This post will show you how […]
How to display the Current Date and Time in Excel and Google Sheets
If you need to display the current date and time in Excel or Google Sheets spreadsheet, you can do it quickly. There is more than […]
How to make a smooth curved graph in Excel and Google Sheets
Adding a graph in a spreadsheet is no big deal as long as you know the process. However, do you know that you can make […]
How to create a drop-down list in Excel and Google Sheets
If you are creating an interactive spreadsheet, you may need a drop-down list so that users can choose between options. For that, you can follow […]
How to print selected cells in Microsoft Excel or Google Sheets
Even if you have a big spreadsheet, sometimes, you may want to print only selected cells in Google Sheets or Microsoft Excel. There are some […]
How to print the Background Picture in Excel
If you use the traditional method to add a background image to your spreadsheet; Excel won’t print the image. If you need to print an […]
How to count blank or empty cells in Excel and Google Sheets
Microsoft Excel and Google Sheets support countless functions so that users can perform various jobs. There are some functions called COUNTBLANK, COUNTIF, SUMPRODUCT, etc. that […]
How to split one single long column into multiple columns in Excel
If your data in Microsoft Excel is poorly structured and accommodated in a single column, you can split it into multiple columns. This post offers […]
How to add Zero in front of number in Excel and Google Sheets
If you are trying to write a number in Excel or Google Sheets that starts with zero (0), you may not do that due to […]
