How to Import Stock Prices into Excel from Google Finance (3 Methods)

We’ll use the data from NASDAQ for the Microsoft Corporation (MSFT) to demonstrate how to import stock prices. Here's how our final table will look ...

How to Keep Track of Inventory in Excel (With Easy Steps)

What Is Inventory Tracking? Inventory tracking involves monitoring and managing a company’s inventory levels, movements, and status. The primary ...

How to Make a Sales Tracker in Excel (Download Free Template)

In this article, we will go through the different stages of making a dynamic sales tracker and its report. At the bottom is a free downloadable ...

How to Keep Track of Customer Payments in Excel (With Easy Steps)

  Step 1: Headline Entry for Customer Payments in Excel Open an Excel spreadsheet. Type all the necessary Headline info for the payment ...

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 ...

Excel Files are Not Opening in Separate Windows – 4 Solutions

Solution 1 - Opening Separate Windows using the Taskbar Go to the Windows Search Bar and enter Excel. Click Pin to taskbar. Open an ...

How to Unlock Grayed out Menus in Excel (5 Effective Ways)

Reasons for Menus to Be Grayed Out Working on a cell / Editing a cell. Password-protected spreadsheet. Workbooks are safeguarded. ...

How to Find a Significant Difference Between Two Numbers in Excel (2 Methods)

Method 1 - Using the ‘Data Analysis’ Tool    Step 1: Download and Install the Data Analysis ToolPak Go to the top left corner of Excel ...

Send Email from Excel VBA without Outlook: 4 Suitable Examples

Method 1 - Sending Single Email from Gmail Account Using Excel VBA  Steps: Go to Developer >> Visual Basic  The VBA window will ...

How to Protect Formulas in Excel (Easy Steps)

Dataset Overview Suppose you have a dataset containing sales data, and you’ve used formulas to calculate revenues. Step 1 - Unlock All ...

How to Set Decimal Places in Excel with Formula (5 Ways)

Suppose we have a dataset that contains values with five decimal places, but we want to only display two decimal places. In this article, we ...

Round Time to the Nearest 5 Minutes in Excel – 4 Methods

The dataset contains a column with time. To round the time to the nearest 5 minutes: Method 1 - Using the ROUND Function STEPS: Set ...

How to Create a Matrix Chart in Excel (2 Methods)

In the dataset below, we have records of the selling prices, cost prices, and profits of a company's products. Watch Video – Create a ...

How to Track Multiple Projects in Excel (Download Free Template)

Step 1 - Collecting Data in Excel from Multiple Projects Organize the data by dividing your project into smaller tasks, and scheduling them into ...

How to Create a Training Matrix in Excel (3 Easy Methods)

To demonstrate our methods for creating a training Matrix in Excel, we’ll use the following dataset with 3 columns: “Employee”, “Topic”, and “Date”. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo