Advanced Excel Archives - Page 4 of 8

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

Top Excel Security Tips: Features for securing worksheets and workbooks

Apr 25, 2021 Advanced Excel

We have already covered worksheet level protection and workbook level protection extensively in a previous tutorial. We are now going to cover ...

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

Apr 25, 2021 Advanced Excel

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

Basic Conditional Formatting in Excel and Access

Oct 9, 2020 Advanced Excel

Conditional formatting allows one to visually highlight or visually emphasize certain values in one’s dataset, based on the fulfillment of certain ...

Exchange (Copy, Import, Export) Data Between Excel and Access

Apr 8, 2021 Advanced Excel

Excel usage is widespread and Excel is often the go-to Office application for data entry, analysis, and manipulation. Microsoft Access provides ...

Excel Protection Explained: Worksheet vs. Workbook Level Protection

Sep 12, 2021 Advanced Excel 2

It is often necessary to protect either the sensitive information in one’s actual worksheet or the workbook structure, from being edited. Excel ...

3D Referencing & External Reference in Excel

Sep 12, 2021 Advanced Excel

Creating 3D referencing in Excel within a formula involves referring to the same cell or the same range of cells, on different worksheets. Each of ...

How to Compare Two Columns in Excel For Finding Differences

Oct 24, 2021 Advanced Excel 4

This is an interesting situation that often comes up. Namely, sometimes one needs to differentiate data into two different columns. There are so many ...