How to count cells with specific text in Excel

If you want to count cells with specific text then the following methods will be very helpful. This can be applied when you want to count cells with full or…

Comments Off on How to count cells with specific text in Excel

How to match data in two Excel worksheets

Reading values in one tab are easy when it comes to excel. But looking up values in two different tabs is not easy for some people. However, there is a…

Comments Off on How to match data in two Excel worksheets

How to delete blank rows in Excel

Having blank rows of data is very annoying. They are very irritating since they make it difficult for you to navigate data around. However, you can easily remove the blank…

Comments Off on How to delete blank rows in Excel

Best excel password recovery software

Though there are many attempts to have the best excel recovery software on the web, here we only review the best. Many developers are trying to market their software by…

Comments Off on Best excel password recovery software

Best uses of Microsoft excel

Excel. Probabilities are, the utterance of the term alone brings the memory of extensive use of spreadsheets, incomprehensible macros, and not to mention periodic use of its features such as…

Comments Off on Best uses of Microsoft excel

Excel formula for units of production depreciation

In production, depreciation occurs whenever an asset losses its value due to heavy use. When considering the units of production, depreciation is not calculated based on the duration an asset…

Comments Off on Excel formula for units of production depreciation

Excel skills for the successful business professional

When any skilled business professional set off Microsoft Excel program, their graceful like movements can leave any onlooker awed and believe they are observing tricks in another form. However, if…

Comments Off on Excel skills for the successful business professional

Top 10 Excel keyboard shortcuts

The keyboard plays a vital role in the excel spreadsheet execution. Most people do not know that all the operations in excel can be managed by using a keyboard even…

Comments Off on Top 10 Excel keyboard shortcuts

Resolving Common Errors in Excel

Software errors are almost unavoidable. MS Excel is not an exception either since one is likely to encounter some errors during day to day use of this spreadsheet program. When…

Comments Off on Resolving Common Errors in Excel

How to calculate Percentage using excel formulas

1. Excel formula for percentage change Normally in mathematics, the percentage change is usually given by; %Change = (change/initial value) *100. The change is usually a difference between the two…

Comments Off on How to calculate Percentage using excel formulas