Posts tagged "Excel"

Learn how to unprotect Excel or remove worksheet password

This is a Step-by-step blog on how to unprotect excel spreadsheet without using any software. This includes changing file extension and manipulating its constituents to get an unprotected excel file. Almost ALL Excel users wish at some point or the other felt the need of some magic to “Unprotect Excel Sheet” password so that they […]

Learn how to use Countif function in Excel

Countif function will help you to know how many records of a certain type you have in your Excel spreadsheet. The Excel Countif function returns the number of cells within a supplied range, that satisfy a given criteria. When to use Countif Function? COUNTIF function can be used when you want to count the number of […]

Excel Versions: Evolution of Spreadsheets [Infographic]

Excel versions aka Spreadsheets have a come a long way over the years and plenty of companies today are attempting to build the best one. Spreadsheets have been used by accountants for hundreds of years. Computerised or electronic spreadsheets are of much more recent origin. Information Systems oral history and some published newspapers and magazines […]

9 Excel Error in Formula and How to correct it

Do you feel agitated when you are engrossed in setting up formulas in your EXCEL and suddenly you see jargon of excel error like #NAME, #REF appearing in your excel spreadsheet? [This post on Excel tips and tricks is just a 5 min read] Well, there are high chances that you may have committed the […]

Learn how to create a horizontal bar chart in Excel

Horizontal bar chart may look appealing, but to make it may be troublesome. This article shows a step by step process to make a percentage horizontal bar chart in Excel. Consider there are two tables i.e. Income and Expense Select the data with headers and Press Ctrl + T. Do it for both Income and […]

Excel basics guide for beginners

Learning Excel basics are just a start to what’s in store to solve a lot of our daily problem and save time. Microsoft Excel is very useful for a wide range of applications. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. But using it for the […]

Learn how to use SUMIF in Excel

The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet. You can try the SUMIF function to […]

Learn how to remove blank row or empty cell in Excel

How to remove blank row or cell in Excel? confused ? Data doesn’t always import or paste into Excel as nicely as you want. Sometimes, all the information is there, but extra blanks and spaces are carried along with the data cells. Think that if you work with a large data set in an Excel […]

7 formula error in Excel that make you look dumb

In this blog, I will try to help you to debug your excel formula. As soon as you will use excel formula, you will likely need to know how to correct the error in excel formula. First of all, we need to know how many types of error, we can get we are applying excel formula […]

Learn how to create sparklines in Excel

Imagine you have result sheet for your students over the last 5 years and want to create a chart in Excel, which takes time. In that case, you are thinking if only there were some small mini-charts in a single cell. Well here is the solution. Ever had a worksheet of data in Excel and […]