Similar Topics

Web Technologies32.1K+ articles

DSA20.4K+ articles

Python19.6K+ articles

Experiences15.8K+ articles

Interview Experiences14.5K+ articles

School Learning11.1K+ articles

JavaScript9.9K+ articles

Java9.4K+ articles

Misc7.7K+ articles

Mathematics5.7K+ articles

Excel-macros

11 posts

How to Configure Macros in Excel

Last Updated: 20 March 2026

Excel Macros are a feature that allow users to automate repetitive tasks by recording a sequence of actions and running them whenever needed. A macro captures the steps pe...read more

article_image

Absolute References in Excel Macros

Last Updated: 20 March 2026

Absolute References in Excel Macros are fixed cell references used in Excel VBA that always point to the same specific cells, regardless of the active cell or where the ma...read more

article_image

Relative References in Excel Macros

Last Updated: 20 March 2026

In Excel, the way of recording actions within a macro that is relative to the cell or range that the macro starts from is known as a relative reference. When you start rec...read more

article_image

How to Enable & Run a Macro in Excel? 6 Ways

Last Updated: 02 September 2025

We can record a macro in Excel or write from scratch in VB Editor. Excel provides different options to run a macro. Even while executing an Excel macro is a straightforwar...read more

article_image

How to Extract Text Only from Alphanumeric String in Excel?

Last Updated: 06 December 2023

In the vast landscape of Excel spreadsheets, managing data efficiently is crucial for streamlined analysis and reporting. Often, one encounters the challenge of dealing wi...read more

article_image

Excel-functions

How to Password Protect Your Excel Macro?

Last Updated: 20 March 2026

Protecting Excel Macros with a Password is a security feature in Microsoft Excel VBA that allows users to restrict access to the VBA project containing macros. By applying...read more

article_image

Paired Sample T-Test in Excel

Last Updated: 13 October 2021

Excel is one of the most powerful and influential software developed by Microsoft, it has enormous useful features which make it the first choice of many companies. Today ...read more

article_image

How to Extract Text before @ Sign from an Email Address in Excel?

Last Updated: 21 August 2021

You got a dataset and you want to extract the name part of the email address. This task can be done with a text to column and formula that uses the LEFT and FIND functions...read more

article_image

How to Create a Heat Map in Excel?

Last Updated: 30 July 2021

Heatmaps are basically used to calculate the intensity of an event. It helps us in easily understanding and interpreting any complex dataset and make deductions from it. I...read more

How to Calculate the Midrange in Excel?

Last Updated: 30 July 2021

MS Excel is a spreadsheet developed by the company Microsoft. Excel provides various kinds of functions and we can insert the data in form of rows and columns and perform ...read more

Excel-functions

Excel Personal Macro Workbook

Last Updated: 20 March 2026

Personal Macro Workbook in Excel is a special hidden workbook (PERSONAL.XLSB) that automatically opens whenever Microsoft Excel starts. It allows users to store macros in ...read more

article_image