Excel Archive

Pivot Tables

Pivot Table is a tool used to summarize and reorganize selected rows and columns of data in a spreadsheet or database table to obtain the desired output without changing the spreadsheet. To make it easier to understand the use of …

Tables

To make it easier for your excel data to analyze it is recommended that you add it on a table. The table allows you to analyze your data easily, and you will learn here how to insert, filter, and sort a …

Microsoft Excel Charts

Using charts to present the complicated numbers on your table can be more efficient and presentable, and you can create charts or graphs using Microsoft excel chart based on the data on your table with a few clicks. Let me show you how …

Conditional Formatting

Conditional Formatting is used to highlight cells with certain value that meet the condition set. There are several condition rules that you can use to format your worksheet like highlight cells rules, Top/Bottom Rules, etc. For example, when making class …

Filtering

Filtering is used to make easier to focus on specific information on the large table of data. The records that will be displayed when filtered is the one who meets a certain criteria. The data that aren’t meeting the criteria will be …