Latest Blog Posts

How to Add a Secondary Axis in an Excel Pivot Chart (with Easy Steps)

  Suppose you have a PivotTable that includes the Sum of Sales and the Sum of Profit. You can create a PivotChart with the Pivot ...

How to Stop Excel from Changing Numbers to Scientific Notation (7 Methods)

Dataset Overview Looking at the Sales Data in cells B4:D14, where we have the Customer Name, Invoice Number, and Sales in USD. The Invoice Number, ...

How to Make a Class Schedule on Excel: Step-by-Step Procedures

Method 1 - Inserting Class Times Go to cell C4 and type “PERIODS”. Select all the cells from C4 to K4. Navigate to the Home tab and click ...

How to Add and Subtract Columns in Excel (5 Easy Methods)

While working on Excel we may need to add or subtract among the column data. In order to do that Excel has many built-in functions as well as many ...

How to Edit AutoComplete in Excel (4 Easy Methods)

Excel has some auto features that save a lot of time and give more speed while we are typing or inputting data. AutoComplete is one of them and we ...

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 Remove Comma from Currency in Excel (6 Handy Tricks)

Does comma in numbers in an Excel worksheet bother you? Do you want to clean up your data by removing the comma from the number describing currency? ...

Convert Military Time to Standard Time in Excel (2 Suitable Ways)

If you are searching for a solution or some special tricks to converting military time to standard time in Excel then you have landed in the right ...

[Fixed!] Excel Changing Dates to Random Numbers (3 Solutions)

Sometimes, when we input dates or do some operation with the dates, they change into random numbers. As a result, we cannot see the original dates. ...

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 Stop Autocorrect in Excel for Dates (3 Quick Ways)

Excel has extraordinary autocorrect features. When you type some data in Excel cells, it auto-corrects the data type sometimes which might create ...

[Solved!] Long Numbers Are Displayed Incorrectly in Excel

Working with long numbers (more than 11 digits) can be a problem in Excel. There are some auto formatting options in the program to keep the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo