Advanced Excel

How to Animate Text in Excel (2 Methods)

Method 1 - Scrolling Text Animation Open the Visual Basic Window by pressing Alt+F11. Insert a new module by going to Insert and clicking ...

How to Create Data Visualisation in Excel (7 Practical Examples)

Excel spreadsheet is extensively used for data analysis. Also Excel provides many inbuilt features for insightful data visualisation. In this ...

How to Create a Tooltip in an Excel Chart (Easy Steps)

What is a Tooltip? Tooltip is a message or note that appears when the mouse pointer rests on an icon or any graphical interface. In Microsoft Excel, ...

How to Create a Full Outer Join in Excel – 2 Examples

Example 1 - Create a Full Outer Join for Matched Values in Excel There are 2 sample tables. They showcase a Sales Report and Product Data. To ...

How to Create Digital Clock in Excel ( 2 Easy Methods)

Method 1 - Build Digital Clock Through Excel VBA and TEXT Function Steps: Go to Insert > Illustrations > Shapes. The Shapes menu ...

How to Generate Automatic Email Alerts in Excel (2 Easy Ways)

We will use the following dataset that includes emails of various people, as well as the deadlines they must meet, then set up email alerts based on ...

How to Create Animated Bar Chart Race in Excel (with Easy Steps)

What is an Animated Bar Chart Race? A bar chart race is an effective graphic format to demonstrate a significant change in information over time, by ...

How to Close Queries and Connections Pane in Excel

Closing connections and query panes can be troublesome; we can do this by a simple process, or it can be done by other means. In this article, we ...

How to Find External Data Connections in Excel (5 Quick Tricks)

In this article, we will show how to find External Data Connections in Excel. External Data Connections are the reference to the data in another ...

How to Create a Workflow Management Template in Excel – 6 Steps

Step 1 - Prepare the Work Plan Timeline Enter the data Headlines. Enter the Project name and the tasks. Enter the names of the workers ...

How to Set Alarm Clock in Excel (3 Easy Methods)

In this article, I will show you how to set an alarm clock in Excel. While working in Excel, we may want to remind ourselves of something important ...

How to Perform the Left Join in Excel – 3 Methods

There are 2 datasets below. The first dataset contains Product ID and Name. The second one contains Product Name, salesperson's name, and value of ...

How to Create Dynamic Tooltip in Excel (with Easy Steps)

Step 1 - Use Formula to Fetch Data from Another Sheet In a new worksheet, create a data table with columns L No and Name. In the first column, ...

How to Add Cell Tooltip in Excel (3 Easy Methods)

Consider a worksheet where we have a list of grocery items. In this list, in one column, we have the item name. In another column, the price per unit ...

How to Perform an Outer Join in Excel – 2 Methods

Consider the List of Customer Orders containing the “Product ID”, “Customer”, and “Date”. Mind this List of Products and Sales with “Product ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo