Advanced Excel Archives - Page 58 of 62

How to Change Orientation of Worksheet to Landscape in Excel

Aug 1, 2024

Method 1 - Applying Landscape Command to Change Orientation of Excel Worksheet Steps: Go to the Page Layout tab. From the Page Setup group, ...

How to Change Orientation of Worksheet to Landscape in Excel

How to Remove Leading Zeros in Excel: 8 Easy Methods

Jul 6, 2024

Method 1 - Converting Text to Number to Remove Leading Zeros in Excel Steps: Arrange a dataset like the below image. Select the ...

How to Remove Leading Zeros in Excel: 8 Easy Methods

How to Merge Excel Worksheets Without Copying and Pasting?

Jun 14, 2024

In this article, we will demonstrate three ways to merge Excel worksheets without copying and pasting. In the first method, we combine data from ...

How to Merge Excel Worksheets Without Copying and Pasting?

How to Make Excel Spreadsheet Bigger When Printing (7 Ways)

Jun 14, 2024

You cannot make your Microsoft Excel spreadsheet bigger (unless you want to change the page size). But in this article, we will show some tips and ...

How to Make Excel Spreadsheet Bigger When Printing (7 Ways)

How to Highlight Every Other Row in Excel (3 Easy Methods)

Nov 11, 2025

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

How to Highlight Every Other Row in Excel (3 Easy Methods)

How to Delete Blank Rows in Excel (6 Ways)

Nov 19, 2025

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 Delete Blank Rows in Excel (6 Ways)

How to Multiply in Excel (8 Methods)

Jul 1, 2024

We have a dataset of product Names, unit prices, and Quantities. We will learn to multiply this information from the dataset to calculate the Total ...

How to Reduce Excel File Size (11 Suitable Methods)

Jun 18, 2024

Larger file sizes can cause slower performance and trouble when sharing files. There can be multiple reasons behind this larger file size, and ...

How to Reduce Excel File Size (11 Suitable Methods)

How to Lock and Unlock Cells in Excel Using VBA

May 14, 2024

To demonstrate how to lock and unlock cells in Excel, we’ll use the following dataset containing Salesman, Product, and Net Sales in the range ...

How to Lock and Unlock Cells in Excel Using VBA

How to Compare Two Columns or Lists in Excel (4 Suitable Ways)

Jul 26, 2024

Method 1 - Compare Two Columns Using Equal Operator Steps: Add a new column on the right side to show the matching status. Enter the ...

How to Compare Two Columns or Lists in Excel (4 Suitable Ways)

Intro to Relational Database Management System (RDBMS) Concepts!

Nov 11, 2025

Before we dive into creating databases and data-centric applications in Access, it is prudent to go over some basic database and relational database ...

Intro to Relational Database Management System (RDBMS) Concepts!

Top 10 Advantages of MS Access Over Other DBMS

Nov 11, 2025

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

Top 10 Advantages of MS Access Over Other DBMS

Microsoft Excel Security Tips: Secure Workbook & Worksheet

Jul 15, 2024

Tip 1 - Protecting Worksheet Only for Microsoft Excel Security Go to the Review tab >> Protect group >> Protect Sheet. The ...

Microsoft Excel Security Tips: Secure Workbook & Worksheet

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

Aug 2, 2024

Sparklines are tiny mini-charts that are contained wholly within worksheet cells. Sparklines were introduced in Excel 2010. They allow users to ...

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

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

Nov 11, 2025

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