Advanced Excel

How to Make a Blank Calendar in Excel (Download Free Template)

If you are searching for quick steps or some special tricks to make a blank calendar in Excel, then you have landed in the right place. There are ...

How to Display References Dialog Box in Excel

This tutorial will demonstrate how to display the references dialog box in Excel. When you are dealing with lots of VBA codes in a different ...

How to Create a Weekly Calendar in Excel (3 Methods)

Method 1 - Creating it Manually List all the days of the week along with their corresponding dates in an Excel sheet. Include the initial ...

How to Create a Monthly Calendar in Excel (3 Effective Ways)

In this article, I will show you 3 effective ways to create a monthly calendar in Excel. Excel is a great tool to automate several calculations and ...

How to Filter by Color Using Conditional Formatting in Excel (3 Steps)

We have the Marks of a school's 10th-grade students, and we want to filter the Total Marks based on 2 criteria. They are as follows. Total > ...

How to Make a Calendar in Excel Without Template (2 Examples)

This tutorial will demonstrate how to make a calendar in Excel without a template. In our day-to-day life, we all use a deadline for certain work or ...

How to Create Button Without Macro in Excel (3 Easy Ways)

  We will use two different datasets from different sheets. The first sheet contains Product Info. The second one contains Sales Info. ...

Create a Yearly Calendar in Excel: 4 Methods

Method 1 - Create a Primary Outline Create an outline of the calendar by dividing the Months across 3 columns and 4 rows. Enter the 7 days ...

How to Combine Two Tables Using Power Query in Excel

To show the process, we have two datasets. One denotes the sales information, and the other is the region of sellers. In the sales information ...

How to Remove Email Link in Excel (7 Quick Ways)

Whenever you enter an email address in a worksheet, then Excel automatically turns the email address into a link. If you are looking for a way to ...

How to Delete Hidden Link in Excel (5 Easy Ways)

While working with Excel, you may want to remove unwanted links from your spreadsheet. Now, in this article, we’ll show 5 effective ways how to ...

How to Auto Refresh Excel File Without Opening (2 Easy Ways)

Method 1 - Using VBA Macro to Auto-Refresh a Specific Excel File Without Opening The Countdown Excel file has TODAY() and NOW() functions for ...

How to Highlight Text in Text Box in Excel (3 Handy Ways)

If you are looking for ways to highlight text in the Excel text box, then you are in the right place. So, let’s get started with the main article to ...

How to Highlight Entire Row in Excel with Conditional Formatting

In this article, we will learn how to highlight entire row in Excel with conditional formatting. In Excel, conditional formatting helps users to ...

How to Apply Different Types of Conditional Formatting in Excel – 5 Examples

Consider the following dataset. Example 1 - Highlight Cells Rules 1.1 The Cell Value Is Greater Than a specified Value Step 1: Select ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo