Efren Nolasco, Author at Office Tutorial

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 … Read more

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. … Read more

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 … Read more

Sorting

Having a lot of data in your worksheet needs to be organized to make it easy to understand if someone reads it. Like making lists of employees, it is cleaner and more readable if it is … Read more

Lookup Functions

Lookup functions in Excel are divided into two, VLookup (Vertical Lookup) function which look for the value in the leftmost column of the range of cells you specify in table-array and the HLookup (Horizontal Lookup) function … Read more