Latest Blog Posts

How to Create an Equation from Data Points in Excel (2 Methods)

We have a dataset of a manufacturing company’s Total Production and Target Production month-wise. We will make a chart and create an equation from ...

How to Convert IST to EST in Excel (5 Easy Ways)

Let's consider a dataset of 6 IST times. Before starting the conversion, we have to calculate the time difference between those two time zones. ...

How to Find Confidence Interval in Excel for Two Samples

Are you a business analyst or a data science enthusiast? Do you work with a large amount of data? Then, you’ve come across a statistical term ...

How to Change Axis Scale in Excel (with Easy Steps)

The scale for a graph axis is crucial for maximizing data visualization because it can have a big impact on how an audience understands a message. ...

How to Scale Time on X Axis in Excel Chart (3 Quick Methods)

Generally, if you use a Line Chart, it works fine. Let’s have a look at the following picture. If we create a Scatter Chart based on this ...

How to Make a Lineweaver Burk Plot in Excel (with Easy Steps)

In biochemistry, the Michaelis-Menten Equation of enzyme kinetics results in a Lineweaver-Burk Plot, also known as a Double Reciprocal Plot. Here's ...

How to Convert Time to Hours in Excel (3 Methods)

Dataset Overview Let’s consider a dataset of a trader. Here, the dataset has the Product Arrival Time. As you can see, the dataset has two columns B ...

How to Plot Multiple Lines in a Graph in Excel – 3 Steps

This is the sample dataset: Step 1 - Plot a Chart using the Insert Tab Go to the Insert tab. Select Scatter. Choose a type of ...

How to Make First Derivative Graph on Excel (With Easy Steps)

We'll consider a simple dataset that contains the Price and the Demand columns. The Price will be in Dollars and the Demand will be in the number of ...

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

Return Expected Value If Date Is Between Two Dates in Excel

If you are looking for special tricks to return the expected value if the date is between two dates in Excel, you've come to the right place. There ...

How to Change Y Axis Scale in Excel (with Easy Steps)

While working in Microsoft Excel with the sales-related worksheets, sometimes we need to change the Y-axis scale for the convenience of our work. The ...

How to Solve Nonlinear Equations in Excel (with Easy Steps)

There are many ways to solve different types of equations in Excel. But to solve the nonlinear equations, we had to use the Solver Add-in of Excel. ...

How to Convert UTC to EST in Excel (3 Easy Ways)

In this article, we will learn to convert UTC to EST in Excel. UTC stands for Coordinated Universal Time. It was previously known as Greenwich Mean ...

How to Plot Graph in Excel with Multiple Y Axis (3 Handy Ways)

Consider the following dataset, which contains sales and salary information for several salespeople. We'll use it to demonstrate how to create an ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo