HTML
CSS
Bootstrap
JavaScript
C#
SQL
Salesforce Admin
Excel Training
Study Material
Hlookup Function
HLOOKUP stands for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row.
What is Pivot Table in Excel
A pivot table in Excel is a powerful tool for data analysis and summarization. It allows you to rearrange and summarize selected columns and rows of data into a more meaningful and manageable format.
The primary features and uses of pivot tables include:
a- Data Summarization
b- Dynamic Reporting
c- Filtering and Sorting
d- Calculations and Formulas
e- Data Exploration
Course Video
YouTube Reference :