Excel Tutorial

This article will tell you how to import filtered excel rows from one excel file into a new excel workbook. And when the source excel rows data is changed, the data in new excel workbook will also be changed dynamically by refresh the connection. There are two method to achieve this, i will introduce them …

How To Import Filtered Excel Rows From One Excel File To Another Dynamically Read More »

This article will show you how to import data into excel workbook from local files, the local file format can be excel, csv, text, xml, html and pdf. It also show you how to export an excel workbook to those format files.

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

Table is very useful in excel worksheet. Use table can make your data more regular and manageable. You can sort data, filter data etc. This article will show you how to create a table in excel cells and how to make it beautiful.

Excel auto correct feature is very helpful when you input wrong text in excel cell. It can help you to correct some type mistakes. But for some time this feature is not needed so we should disable it. For example if you want to type text ehr in cell, then excel correct it to text …

How To Stop AutoCorrect In Excel Read More »

When you copy or input a url or an email address text into excel cell, it will add a hyperlink automatically. Sometimes this is useful, but for most times this is not useful at all. This article will tell you how to remove the hyperlink and how to disable auto hyperlinking in excel settings.

Microsoft excel provide filter function for you to find out required rows by customized condition in a very long excel worksheet. The filter feature include basic filter which provide simple condition filtering and advanced filter which provide complex condition filtering. This article will show you both 2 filter feature with example.

Excel provide an autorecover 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.

In this article i will tell you how to generate a column chart ( bar chart ) in excel based on multiple excel cell data. You can customize the column chart Chart Title, Axes, Axis Titles, Data Labels, Data Table, Legend, Trend Lines etc. You can also customize the chart style and column color and …

How To Quickly Generate Excel Column Chart Based On Cell Data Read More »

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

How To Create Error Message Pop-Up Alert When User Input Wrong Data In Excel Read More »