Advanced Excel

How to Restrict Data Entry in Excel Cell (2 Simple Methods)

The following dataset contains the names of students in a column. We’ll restrict the data entry in the Project Code column. Method 1 - Using ...

How to Send Email Automatically When Condition Met in Excel

Method 1 - Use VBA Macro to Send Email Automatically Based on a Cell Value We have the following dataset of some customer details of a super shop. ...

[Solved]: Share Workbook Not Showing in Excel (with Easy Steps)

Share Workbook is a feature that enables you to share your file with multiple users. If you are using the latest version of Microsoft Excel you might ...

How to Send Email from Excel List (2 Effective Ways)

For this tutorial, we've used a data set with some people's names, as well as their emails and registration numbers, as you can see in the image ...

How to Send an Editable Excel Spreadsheet by Email (3 Methods)

Below is the dataset that represents the quarterly sales of some stationery products. Method 1 - Use the Share Option to Send an Editable ...

Automatically Send Emails from Excel Based on Cell Content (2 Methods)

The sample dataset below contains the information of several sales representatives of Armani Group. The name of the sales representatives, their ...

How to Create Student Database in Excel (With Easy Steps)

Step 1 - Enter Data Headers Our database contains some Student ID as Std ID, Student Name as Std Name, total Marks, Percentage of those marks, ...

How to Create a Timeline Chart in Excel (3 Simple Ways)

Timeline Charts are charts or graphs that depict the chronological execution of partial events of a much bigger event. We have tasks of a ...

How to Create a Project Timeline in Excel (3 Simple Methods)

We will use the following dataset, which contains Milestones and metrics of the Effort of a project. Method 1 - Use the SmartArt Graphics ...

Create a Timeline in Excel with Milestones (With Easy Steps)

Consider the following dataset. It contains the 7 fundamental steps of a scientific study. We want to create a timeline in Excel using the steps as ...

How to Create a Timeline with Dates in Excel (4 Easy Ways)

  Watch Video – Create a Timeline with Dates in Excel The dataset below contains information about a company's projects. It ...

How to Make Inventory Aging Report in Excel (Step by Step Guidelines)

  Step 1 - Creating the Basic Outlines In the following figure, you can see the basic report for inventory aging and we have created this ...

How to Send Multiple Emails from Excel Spreadsheet (2 Easy Methods)

We’ll use a sample dataset as an example. The dataset represents the Salesman and their Email addresses. We’ll send an email to everyone. ...

How to Automatically Send Email from Excel Based on Date

In the dataset, we have some email addresses (all of them are dummy addresses except one). We're using a real address to demonstrate how the methods ...

How to Send Automatic Email from Excel to Outlook (4 Methods)

We have Employee Restructured Salary data in Excel, and we want to send automatic emails using Outlook. Opening Microsoft Visual Basic and ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo