Splitting a column using Flash Fill in Excel

Splitting a column using Flash Fill in Excel MS Excel has introduced a new feature in 2023 called Flash Fill. It helps in splitting a column using Flash Fill when a pattern is identified. It works similar to Auto Fill but with a slight difference. Advantages of using Flash Fill Flash Fill helps in splitting…

Read More

Excel Conditional Formatting Practice Questions

Excel Conditional Formatting Practice Questions In the previous blog, we practiced some basic questions on MS Excel formatting and filtering. In this blog, we will look at Excel conditional formatting practice questions. if you want to practice more Excel questions, visit Excel Basics to Advanced Practice Questions. Ques 1. Using the data set given in…

Read More

MS Excel Practice Questions

MS Excel Practice Questions In this series of blogs, we will post MS Excel Practice Questions. These questions will be helpful for the candidates who have attended our MS Excel training as well as others who wish to learn and practice. This first section covers the overview of MS Excel and contains basic concepts, in…

Read More

Why MS Excel is important for an IT novice

Why MS Excel is important for an IT novice MS Excel was introduced to the world some 30 years back but it is still relevant in the business community and day-to-day life. Today we will understand why MS Excel is important for an IT novice. MS-Excel is a must for someone starting a career in…

Read More