Advanced Excel

How to Merge Excel Worksheets without Copying & Pasting

In this article, we will be familiarized with the topic which is "Merge Excel worksheets without Copying & Pasting". The problem that occurs ...

How to Merge Two Cells in Excel without Losing Any Data

In this article, I will show you several tricks that you can use to merge two cells in Excel without losing data. Using Excel’s Merge & Center ...

How to Make Excel Spreadsheet Bigger when Printing (Easy steps)

Printing in an efficient way creates a lot of positive impacts on the mother environment and your office balance sheet. So, I always inspire people ...

Excel conditional formatting based on another cell text [5 ways]

In this article, we will be familiarized with an interesting topic which is "Excel Conditional Formatting Based on Another Cell Text". Excel ...

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

Excel has many features that can perform different tasks. Besides performing different statistical, financial analyses we can solve equations in ...

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

How to Convert Text to Numbers in Excel

In this article, I tried to sum up some of the processes on how to convert text to numbers in Excel. In many cases when you import data from an ...

How to Highlight Every Other Row in Excel

In this article, we will see how to highlight every other row in Excel. Some available techniques are applying conditional formatting, using ...

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

How to Multiply in Excel: Columns, Cells, Rows, & Numbers

Multiplying numbers in excel is very easy. But while multiplying multiple cells, columns and rows, you often face difficulties. Knowing different ...

Reduce Large Excel File Size by 40-60% (12 Proven Methods)

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

How to Lock & Unlock Certain/Specific Cells to Protect them 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 ...

How to Compare Two Columns or Lists in Excel

While doing different tasks in Excel we often come across a situation where the matching and differences of two or multiple columns are required. ...

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

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

ExcelDemy
Logo