Learn Microsoft Excel Online Free
Sometimes we need to enter time into excel, and as we all know there are several formats to show the time. We often use 12-hour clock or 24-hour clock to show the time like 3:01:01PM or 15:01:01, one time displays in two different formats. So if we want to convert time format between them, how… read more »
We open an excel file and find there are merged cells obviously in it, and if we want to find out all of the merged cells, how can we do? In this article, there are two ways to find merged cells, you can use Find command, or use VBA code to find them out. First… read more »
Sometimes we want to find all zero value cells in worksheet and hide zero value to make the data to be checked easier. In this article, we will provide you some simple ways like changing format settings or by IF function to hide zero values. Prepare a table with some 0 value cells. At the… read more »
Sometimes when we entering a website into the cell, we may notice that it changes to hyperlink automatically after entering the website. Actually most time we just want to show it and don’t want user to click on it to connect the real website, how can we prevent this? This article will provide you some… read more »
Sometimes we want to concatenate words which are separated into different cells into one big column, how can we do? Now we will share you some small tips to concatenate words in Excel, and you can also add different separators between words if you like. Concatenate cells by CONCATENATE Function This function is very useful… read more »
We enter a list of numbers or products and there are some duplicates in the list, if we want to just do count for the unique values and exclude the duplicates, how can we do? Now you can follow the below steps to solve this question by formula quickly. Prepare a list of products and… read more »
Sometimes we will record some important information in our worksheet for example like product code, serial number or some personal information telephone number etc., so we want to hide these contents in Excel and make them invisible if others open the worksheet. This article will show you’re the quickly way to hide the contents in… read more »
We often use formulas to do calculate like sum, average for some data saved in worksheet. And most time we want to use the returned results directly for example copy it to another cell or worksheet. But we find that if we do a copy for a sum\average to another cell, we often get an… read more »
We often use Sum function to calculate the total amount of a column. If #N/A exists in the column, how can we ignore them and just calculate the numbers in the column. This article will show you the simple method to do count ignore the invalid #N/A. First prepare a list of number contains #N/A… read more »
Sometimes we need to add brackets into cells to enclose texts for some reasons. If we only add brackets for one single cell, it is very easy, but if there are a column of cells need to add brackets, how can we do? This article will show you three simple ways to add brackets by… read more »
