Basic Excel Course Urdu/Hindi - Class 4

In this class we are going to learn following concepts of MS Excel

Lookup & Reference: Learn all about Excel's lookup & reference functions, such as VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE.

Logical: Learn how to use Excel's logical functions, such as IF, AND, OR and NOT.

Sort: You can sort your Excel data on one column or multiple columns. You can sort in ascending or descending order.

Filter: Filter your Excel data if you only want to display records that meet certain criteria.

Conditional Formatting: Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.

Charts: A simple Excel chart can say more than a sheet full of numbers. As you'll see, creating charts is very easy.

Pivot Tables: Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.
Web design
Be the first to comment