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 ...

READ MORE +

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 ...

READ MORE +

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 ...

READ MORE +

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 ...

READ MORE +

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 ...

READ MORE +

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 ...

READ MORE +

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, ...

READ MORE +

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. ...

READ MORE +

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 ...

READ MORE +

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 ...

READ MORE +

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 ...

READ MORE +

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 ...

READ MORE +

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 ...

READ MORE +

Basic Conditional Formatting in Excel and Access

Conditional formatting allows one to visually highlight or visually emphasize certain values in one’s dataset, based on the fulfilment of a certain criteria. It can be time consuming to go through ...

READ MORE +

Changing Case using Worksheet Functions and Excel VBA

Excel provides the text worksheet functions, namely the Upper Function, the Lower Function and the Proper Function, which can change the case of a specified input text string. This text string could ...

READ MORE +