Prashant Pai

6.78K subscribers

1.7K videos

Hi, my name is Prashant Pai, and I am from India. The aim of this channel is to make viewers a super user of MS Office applications including Excel, Access a...

Latest Videos

Highlight the entire row in a table for today's entry in Excel

Color the cell with specific color when a specific word is entered in Excel

Highlight the entire row when an entry is made in Excel using Conditional Formatting

Extract Tuesday only dates between two dates in Excel using formula

Create dynamic QR codes in Excel

Create checklist progress chart in Excel using formula

Extract domain name and user name from email using formula in Excel

Find the row number of the item code from a table in Excel

An example on Wraprows and Textsplit function combined in Excel

Remove line breaks in Excel using formula

Find when a particular guest visited a specific city last time in Excel using Xlookup

Insert blank row after every existing row in a table in Excel

Find the least expensive item and second least expensive item from a list in Excel

Quickly insert headings after every 6 rows in Excel

Find latest entry of a value (Last match lookup) in an array or a table in Excel

Enclose negative numbers with brackets in Excel using Custom Formatting

Make Excel to segregate a column of data into group of 4 values with a blank row after that

Make Excel to repeat a word until every 4th row and leave a blank row after that

Find out missing invoices from master list to received list in Excel using Xlookup

Repeat a text with space in Excel

Apply single dynamic tax rate to an entire column in Excel

Highlight difference between entries of two columns in Excel using Go to Special

Remove the decimal portion of a number down to the nearest whole number in Excel

Prevent Excel from rounding 15 digit credit card numbers using custom formatting

Remove international currency symbols from values in Excel using Paste Special

Apply percentage decrease to an entire column in Excel using Paste Special

Apply percentage increase to an entire column in Excel

Convert text formatted currency to numbers in Excel using formula

Paste multiple cells into a single cell using formula in Excel

Split multi line cells into rows and columns in Excel using formula