Все публикации

0:02:58

Calculate fortnight payment using PMT function in Excel

0:02:26

Find the sum of only unhidden rows in Excel

0:01:42

Add +4 to all numeric values of a column in Excel

0:01:25

Reach an specific bottom cell in Excel in one go

0:02:59

An example on =stockhistory function of Excel

0:01:47

Draw double line border in Excel

0:01:19

Combine two lists into one in Excel using TOCOL function

0:01:31

Using dynamic reference jump every third cell in Excel using formula

0:02:44

Mark duplicates between two data sets in Excel

0:01:34

Check if a cell value is present in a given range of cells in Excel

0:02:15

Search ? in Excel with this tip

0:01:29

Separate data of a column with multiple vertical lines into a single cell in Excel

0:01:24

Remove last name from a list of names in Excel

0:02:42

Find location of a letter in the cell range in Excel using formula

0:01:44

Highlight all values in a column which are not present in another column in Excel

0:01:06

Hide only text values in a given array in Excel

0:01:52

Calculate accumulated paid leaves of an employee in Excel if he gets a paid leave after every 5 days

0:01:59

Find whether a cell contains only number not text in Excel

0:01:35

Get the hyperlink with literal text in Excel

0:01:50

Count cells with specific colors from a column in Excel

0:02:23

Create date range in Excel

0:01:12

Make list of unique items from an array of items in Excel

0:02:14

Extract the first word from a text string in Excel

0:02:34

Find sum & average of sales for dates from a specific month in Excel