Latest Blog Posts

How to Make a Daily Schedule in Excel: 6 Practical Examples

Method 1 - Make a Basic Daily Schedule This Excel daily schedule template is really simple but very good. With time slots, hobbies, and a to-do list ...

How to Spell a Number in Dirhams in Excel (2 Ways)

The following dataset contains a list of products and their sales values. We will try to enter the numbers in the Sales column as words with Dirhams ...

How to Find the Equation of a Trendline in Excel- 5 Steps

  What Is Trendline in Excel? A trendline is a linear or curved line in a graph or chart that defines the general pattern of the selected ...

Spell Number Not Working in Excel: Complete Guide

Method 1 - Solving Spell Number for US Currency Steps: Go to the Developer Tab and then select Visual Basic. The VBA editor will ...

How to Stop Excel from Auto Formatting Numbers (3 Easy Ways)

As can be observed in the animation below, by default Excel changes the format of numbers after they've been input. It can become tiresome having to ...

How to Apply Conditional Formatting to Dates 6 Months prior to Today – 3 Steps

The dataset show cases products and manufacturing dates. To highlight dates 6 months prior to today: Step 1 - Select the Range and Add ...

How to Convert Time to Minutes in Excel (5 Suitable Methods)

Here's a simple overview of converting time values to different formats. Method 1 - Convert Hours and Minutes in the HH:MM Format to Just ...

How to Keep Excel Chart Colors Consistent: 3 Simple Methods

Method 1 - Using Copy Paste Feature to Keep Excel Chart Colors Consistent Steps: Select the data range for the chart. Go to the Insert tab. ...

How to Stop Excel from Rounding 16 Digit Numbers (2 Easy Ways)

The Reasons Behind Excel Rounding Numbers Excel maintains IEEE 754 in storing numbers. Numbers containing digits up to 15 will be displayed as ...

How to Make an X Y Graph in Excel (With Easy Steps)

We will set up a dataset in columns B and C and then using the X-Y graph we will display, modify, and format our X and Y plots. Step 1 - Collect ...

How to Plot Michaelis Menten Graph in Excel (With Easy Steps)

In this article, we will plot a Michaelis Menten graph in Excel using the Michaelis Menten equation. Generally, this equation is used to analyze the ...

Why is Excel Changing My Numbers to Decimals? (2 Solutions)

Consider the following dataset where students' marks are entered in column C. While entering 62 in cell C5, it unexpectedly becomes 0.62. We have ...

How to Convert Time to Seconds in Excel (3 Easy Methods)

The following dataset contains 5 different times in a 12-hour time format. We’ll transform them into seconds. You can go through the below methods ...

How to Change the Series Color in an Excel Chart – 5 Quick Methods

The image below showcases a chart of Month-wise Items Sold. The first 7 months of the year and items sold were used to create a chart.   ...

How to Display the Equation of a Line in an Excel Graph (2 Easy Ways)

Here's the dataset we'll use to explore the methods. We made the line graph using the equation y = 2x + 3. Method 1 - Using Display ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo