Excel Learning Guide for Beginners
Recent posts
View all
Beginners
How to Merge Text from Two Columns in Excel
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…
Read more
Beginners
How to Lock Headings in Excel
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…
Read more
Beginners
How to Use Insert Function in Excel
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, …
Read more
Beginners
Lesson 8: How to Change Text Case in Excel
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…
Read more
Beginners
Lesson 7: How to Remove Duplicate Content in Excel
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…
Read more
Beginners
Lesson 6: How to Check Duplicate Content in Excel
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 …
Read more
Beginners
Lesson 5: How to Merge Cells in Excel
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…
Read more