Advanced Excel Archives - Page 3 of 8

How to Merge Excel Worksheets without Copying & Pasting

Sep 15, 2021 Advanced Excel 1

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

Sep 15, 2021 Advanced Excel 5

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)

Sep 27, 2021 Advanced Excel 1

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]

Oct 7, 2021 Advanced Excel

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)

Sep 13, 2021 Advanced Excel 4

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)

Oct 19, 2021 Advanced Excel 1

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

Oct 14, 2021 Advanced Excel 6

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

Sep 13, 2021 Advanced 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)

Sep 13, 2021 Advanced Excel 2

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

Sep 28, 2021 Advanced Excel 2

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)

Jun 8, 2021 Advanced Excel 6

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

Jun 8, 2021 Advanced 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

Oct 17, 2021 Advanced Excel 4

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!

Apr 25, 2021 Advanced Excel 2

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

Jun 13, 2021 Advanced Excel

Microsoft Office Access is a database management system (DBMS) provided by Microsoft as part of its Office Professional or Business suite, that ...