Hour,Minute & Second Formula in Excel

To extract Hours ,Minutes and seconds from given time these formulas are used.

How to Write Greater Than 15 digits in Excel

When we type number greater than 15 digits in excel it will convert digit after 15th number to zeros

Freeze Panes in Excel

It will freeze row or column when we scroll down excel sheet below or right top row or left column will remain fixed.

LEN formula in Excel

To check length of the word or to check how many letters or character in cell we can use len formula in excel

Remove duplicates in Excel

Sometimes data contains duplicate entries in a column. We can check it by selecting column click on Home->conditional formatting->highlight cell rules->Highlight Duplicate Values.

How to Merge Excel files using Access

Merging of excel file is common task one can merge excel files manually by copying one files content to other. But we can merge excel files easily with the help of Microsoft Access

Aggregate Function in Excel

Aggregate formula in excel used when cells in column contain value error or hidden rows

Count and Counta in Excel

Count formula in excel will count the numbers present in the cell of the selected data whereas counta formula will count the number of cells that contains data

Round function in Excel

To round the decimal numbers as many digits in excel we can use round formula in excel. example shown in below image. If second digit after the decimal is greater than or equal to 5 it will increase the first digit after decimal by one

How to create BAR chart in Excel

Bar chart represent the categorical data in bars or columns. It can be plotted horizontally and vertically. It can be used to compare values visually when there is few category.