How to apply the same formula to multiple cells in Excel

For excel, nothing saves time than the use of formulas. As a matter of fact, this is the bread and butter of this Microsoft Office application. However, crafting a useful…

Comments Off on How to apply the same formula to multiple cells in Excel

How to sort alphabetically in excel with Multiple columns

Excel is one of the most useful Microsoft Office applications and yet one of the most complicated to use especially for people with little knowledge about the same. This tutorial…

Comments Off on How to sort alphabetically in excel with Multiple columns

Excel extract text from string between characters

Microsoft has been in use for a long time to create grids of texts. It is essentially a spreadsheet program which is the reason why it's so successful in creating…

Comments Off on Excel extract text from string between characters

Apply formula to the entire column without dragging

Excel is helping people and businesses solve some of the hardest tasks. This Microsoft application also makes it very easy and simple for anybody to compute some problems that would…

Comments Off on Apply formula to the entire column without dragging

How to auto fill numbers in excel without dragging

If you can use excel the right way, I don't see any need to reach out for your calculator to do the math. Excel just needs some simple formulas and…

Comments Off on How to auto fill numbers in excel without dragging

How to Split cell diagonally and fill half color in Excel

Excel actually is one of my favorite spreadsheets due to its great formatting features. One can format any content that is housed in the worksheet including cells. You can also…

Comments Off on How to Split cell diagonally and fill half color in Excel

Excel Formula To Generate Unique Sequential Numbers

Excel takes the lead when it comes to automation operations on cells. I personally love Excel due to its robustness in offering various functionalities to the user. Users can, therefore,…

Comments Off on Excel Formula To Generate Unique Sequential Numbers

Dynamic Row Numbering In Excel

Over recent years, thirst for data manipulation tools has dramatically increased. This is because as time goes by, more data and especially numeric data is channeled into digital devices like…

Comments Off on Dynamic Row Numbering In Excel

How to Insert Multiple Rows In Excel With Formula

Excel comes with much excellent inbuilt functionality that leads to automation of activities. This is actually one of the advantages of spreadsheets. Inserting many multiple rows at once in excel…

Comments Off on How to Insert Multiple Rows In Excel With Formula

How to Remove Duplicates in Excel Using Vlookup

Excel is an electronic tool that offers ease in managing numeric data. This large data contains collections of columns that essentially add up to make up rows. The data can…

Comments Off on How to Remove Duplicates in Excel Using Vlookup