Excel Tutorial

In this article, I will show you how to retrieve data from a web page and import the data into an excel worksheet. With this function, you can prepare excel data very efficiently.

Microsoft Excel provides a filter function for you to find out required rows by the customized condition in a very long excel worksheet. The filter feature includes a basic filter that provides simple condition filtering and an advanced filter that provides complex condition filtering. This article will show you both the 2 filter features with

Excel provides an auto recover unsaved workbook feature for you to recover the unsaved excel workbook. This feature is very useful. It can save you a lot of time when you exit Excel without saving the workbook changes. This article will tell you how to use it.

Sometimes you may want to verify user input data type or value in excel cell. And excel just provide such a feature for you to customize the cell data validation process. You can define which data type and what data values are valid for one or multiple excel cells. If the data is not valid,

In this article, I will show you how to make an excel cell expand it’s width and height to fit the input text width or height automatically.

There are three ways to adjust excel worksheet row height and column width as below. I will tell you how to do it one by one with an example in this article. Adjust it by hand. Adjust it by ribbon menu item. Adjust it by popup menu item.

My excel display language is Chinese by default, but for some reason, I need to change the excel display language to English. This article will tell you how to change the excel display and editing language, and after that, you will find the whole office software display and editing language has all been changed as

Sometimes you need to know which bit-version dose your installed Microsoft office software is, then you can download and install additional software such as office language package according to your current office software bit version. In this article, I will tell you how to check whether your installed office software is a 32-bit or 64-bit