How to freeze two columns on Excel

In excel sheets we freeze columns, rows, or cells to make them visible all through the entire excel sheet even when we scroll from top to bottom. Excel sheets provide…

Comments Off on How to freeze two columns on Excel

How to write two lines in one cell in Excel

Writing content on text editors does not only involve writing to finish the task but also to check on some of the writing requirements that include, spacing, font, grammar, wording,…

Comments Off on How to write two lines in one cell in Excel

How to remove the first four characters on Excel

When writing content on various text editors, making and doing errors is usually inevitable. We happen to make errors in all aspects of life. Errors to some extend prove we…

Comments Off on How to remove the first four characters on Excel

How to remove the last 4 characters on Excel

When we are dealing with excel sheets, we may feed in data with errors or we may happen to make slight errors and which can ruin the validity of our…

Comments Off on How to remove the last 4 characters on Excel

How to freeze the top 4 rows in Excel

Globally, people have grown to use excel sheets in their day to day activities to perform general and specific functions. Excel sheets provide users with numerous capabilities and functionalities. People…

Comments Off on How to freeze the top 4 rows in Excel

How to calculate the 95 percentile

The handling of data requires numerous manipulations to be done to particular data. You need to find the mean, mode, median, standard deviation, maximum, minimum, and also the percentile of…

Comments Off on How to calculate the 95 percentile

Excel how to copy the first five characters

Each time we are writing content on pieces of paper, books, and emails and a word document, we mainly aim at speed and accuracy. The very main reason that makes…

Comments Off on Excel how to copy the first five characters

Excel how to subtract 6 months from a date in excel

Excel sheets nearly store all types and sorts of data that we happen to interact within our day to day life activities. In excel sheets you can record time, date,…

Comments Off on Excel how to subtract 6 months from a date in excel

How to sum every seven rows in Excel

When we are dealing with huge amounts of data in excel sheets, it is good we break the huge data down to small chunks that can be easily manipulated and…

Comments Off on How to sum every seven rows in Excel

How to rotate data 90 degrees in Excel

Each time you create data in any of the files and tools that can hold data; you always have the free will to manipulate or shape your data the way…

Comments Off on How to rotate data 90 degrees in Excel