Posts

Showing posts with the label Excel tutor

Vlookup Formula in excel

Image
VLOOKUP is a popular function in spreadsheet software like Microsoft Excel  and Google Sheets that allows you to search for a value in a specified column of a table and retrieve a corresponding value from another column in that same row. Here's a step-by-step guide on how to use VLOOKUP Function in Excel #Training =VLOOKUP(lookup_value, table_range, column_index, [range_lookup])

Office Productivity Hack

 Change any values like 1200%,1300%,1400%  etc. In 0.12 , 0.13,0.14 This is one of the essential part in Excel when we calculate a % in spreadsheet value you can see like above but the fact is we want to see the resul like out put. In this series we gave how quickly you can resolve this issue