Excel Basics

How to Rotate Text in an Excel Chart (2 Methods)

If you are searching for some special tricks to rotate text, you are in the perfect place. In Microsoft Excel, there are numerous ways to rotate text ...

How to Write Phone Number in Excel (Every Possible Way)

Excel sometimes fails to differentiate between phone numbers and regular numbers, and as a result, it may display phone numbers in inappropriate ...

How to Show Value Instead of Formula in Excel (7 Methods)

While dealing with MS Excel in daily life, we sometimes prefer sending a file to another person letting him view the result only. So in this article, ...

How to Format Phone Number with Dashes in Excel (2 Ways)

As different parts of a phone number bear different meanings, such as country codes and area codes, using dashes can separate the sections and make ...

How to Format Phone Number with Country Code in Excel (4 Methods)

In our everyday routines, we often need to store phone numbers for various purposes, such as keeping track of business contacts, maintaining a ...

How to Put Parentheses for Negative Numbers in Excel

Placing parentheses for negative numbers is a common exercise popularly used by accountants to increase readability. Nowadays, it is also displayed ...

How to Remove Parentheses from Phone Numbers in Excel

This article provides some basic ideas on how to remove parentheses from phone numbers in Excel. Suppose you want to save some phone numbers of some ...

Excel Formula to Change Phone Number Format

Even though Excel is a great tool for storing various types of data, it cannot automatically recognize phone numbers and does not format them ...

How to Apply Number Format in Millions with Comma in Excel (5 Methods)

In this article, we will learn to apply the number format in millions with the comma in Excel. Often, we need to use large numbers in our Excel ...

How to Change Excel Column Name from Number to Alphabet (2 Ways)

The column names in Excel remain in alphabetical order by default. But it can be set to numerical order too. So if you somehow get that the column ...

How to Hide Formula in Excel without Protecting Sheet (2 Methods)

This tutorial will explain how to hide the formula in Excel without protecting the sheet. While working in Microsoft Excel we might need to share our ...

Excel Custom Number Format – Millions with One Decimal (6 Ways)

If you are looking for some of the easiest ways of custom number format for millions with one decimal place in Excel, then you are in the right ...

How to Remove Currency Symbol in Excel (6 Ways)

Excel automatically includes a Dollar symbol for the cells formatted as currency. We will show you how to remove the currency sign from the cells. We ...

[Solved!] Names Not in Name Manager in Excel (2 Solutions)

In terms of working with Excel, sometimes we can not find Excel Names in Name Manager. Let me go through some basic definitions before going through ...

How to Use Dynamic Named Range in Excel Chart (Step by Step)

This article illustrates how to use the dynamic named range feature in an Excel chart. Without the feature, we have to readjust the source data of a ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo