Advanced Excel

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

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

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

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 fulfillment of certain ...

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

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

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

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

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

ExcelDemy
Logo