Excel Learning Guide for Beginners

How to Merge Text from Two Columns in Excel

Khawer Khan July 01, 2021

Today I am going to discuss about how we can merge text from two separate columns in excel. Merge Text from Two Separate Columns We type text in se…

Beginners

Khawer Khan May 06, 2021

Today I am going to discuss about how we are going to lock headings and how to use it in excel. Lock Headings As we all know that when we create d…

Beginners

Khawer Khan December 02, 2020

Today I am going to discuss about what is insert function and how to use it in excel. Insert Function Insert function is used to add rows, columns, …

Beginners

Khawer Khan December 01, 2020

Today I am going to show you simple formula that are used to change text case. Text Case Whenever we type text in worksheet we use right case, but s…

Beginners

Khawer Khan November 30, 2020

Here we are going to discuss about how we are going to remove duplicate content in excel. Removing Duplicate Content As I have mentioned in my previ…

Beginners

Khawer Khan November 30, 2020

Today I will start with duplicate contents that how we are going to check entries for duplication's. Duplicate Content If there are few entries …

Beginners

Khawer Khan November 27, 2020

Today I am going to teach you that how can we merge two separate cells. Merge Two Separate Cells In my previous post I have added headings for simpl…