PIVOT EDU UNIT BLOGS

Conditional Formatting

How to Use Conditional Formatting in MS Excel? Conditional formatting is used to change the appearance of cells in a range based on your specified conditions. The browser version of Excel provides a number of built-in conditions and appearances: Conditional Formatting Example Here, the Speed values of each Pokémon

Read More »

How To Use Lookup And Reference Formula In MS Excel?

What is VLOOKUP? VLOOKUP means Vertical Lookup.It searches for a value in the first column of a table and returns related data from another column. Step 1: Click the cell where you want the answer Example: Click cell E2 Step 2: Type the formula =VLOOKUP (102, A2:C4, 3,)

Read More »

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

Read More »