## Solving equations in Excel (polynomial, cubic, quadratic, & linear)

Excel has many features which can perform different tasks. Beside performing different statistical, financial analysis we can solve equations in Excel. In this article, we will analyze a popular ...

## How to Compare Two Columns in Excel Using VLOOKUP

There are a lot of ways to compare two lists or columns in Excel. In this article, I am going to compare two columns in excel using VLOOKUP. In one of my previous articles, I discussed How to Compare ...

## How to Split Cells in Excel (The Ultimate Guide)

If you want to extract the information from one cell into two or multiple cells splitting the cell is required. Splitting cells also provide better sorting and filtering of an existing table. In ...

## Calculate The Number of Days/Weeks/Months/Years between Two Dates in Excel

There might be a lot of reasons that you need to calculate the number of days between two dates in excel or number of weeks, months and years between two dates in Excel. If you have been given a task ...

## How to Use Compound Interest Formula in Excel

Compound interest is the interest that's calculated both on the initial principal of a deposit or loan and on all previously accumulated interest.In this article, we are going to learn the compound ...

## How to Delete Blank Rows in Excel (6 Ways)

While working with a big spreadsheet you often insert blank rows intentionally to read and understand it properly. Although inserting blank rows are liked by the majority of people, for some people ...

## How to Reduce Large Excel File Size (12 Smart Ways)

Handling a large file is important as it takes a huge amount of time to transfer. A large file takes too much time to open. Any kind of change in a large file takes a long time to update. So, ...

## How to Lock and Unlock Certain/Specific Cells in Excel

Locking cells, columns, and rows in excel give you the freedom to protect your data. After protecting a worksheet, by default, each and every cell are locked. It means that they can not be edited. ...

## Most Useful & Advanced Excel Functions List

Excel has a wide variety of functions that you can utilize to accomplish a myriad of tasks. We have put a list of tutorials together on the functions that you absolutely have to know and what’s even ...

## Intro to Relational Database Management System (RDBMS) Concepts!

Before we dive into creating databases and data-centric applications in Access, it is prudent to go over some basic database and relational database management system concepts. Since this is the ...

## Top 10 Advantages of MS Access Over Other DBMS

Microsoft Office Access is a database management system (DBMS) provided by Microsoft as part of its Office Professional or Business suite, that allows one to create and administrate databases. In ...

## Top Excel Security Tips: Features for securing worksheets and workbooks

We have already covered worksheet level protection and workbook level protection extensively in a previous tutorial. We are now going to cover securing your Excel files using a password and ...

## How to Use Sparklines in Excel [With a Snail Farming Example]

Sparklines are tiny mini-charts that are contained wholly within worksheet cells. Sparklines were introduced in 2010 and later versions of Excel. Sparklines allow for visualization of data and one ...