Excel Tutorial

Data Validation in excel

Easy way for grading and remarks - VLOOKUP formula and Conditional formatting

How to format cells in excel

How to capitalize the first letter of the sentence.

How to automatically fill series

Checklist in excel #

How to add a pie graph in excel

Count male and female

How to add a checkbox in excel

shortcut keys in excel

Autogenerate number in excel

How to use if formula in excel

easy count attendance sheet

how to easily add progress bar

easy payroll

how to use Conditional formatting and if formula with check box

Conditional formatting and IF function in excel

How tonsolve perimeter

Wondering how to use UPPER, Proper and lower formulas? must watch this for easier excel use.

Happy New Year!!

TEXT TO COLUMN WITH EXISTING DELIMITER

Delimiter- use to split data in a column such as comma, space, semicolon etc

The power of text to column

So, what is text to column? basically it’s the opposite of CONCATENATE where we merge different column or cell in one column/cell.

TEXT TO COLUMN is use to split data from one cell to different columns.

CONCATENATE formula

VLOOKUP formula

How to use SUM and AutoSum