Excel Basics

How to Change Excel Sheet from Right to Left (4 Suitable Ways)

This article illustrates how to change the Excel sheet direction from right to left. The Excel sheet direction is from left to right by default. You ...

How to Change Positive Numbers to Negative in Excel (6 Ways)

When working with Excel, you may face situations where you will need to change positive numbers to negative. The main objective of this article is to ...

Excel Conditional Formatting Icon Sets Based on Percentage

When working with big amounts of data, it is often important to format the data in Excel in specific ways to improve readability. If you are curious ...

How to Mirror Text in Excel (5 Easy Ways)

Looking for ways to learn how to mirror text in Excel? Sometimes, we want to mirror the letters in a text in an Excel cell or text box. Here, you ...

Excel Conditional Formatting: Add Custom Icon Sets (2 Ways)

Icons in conditional formatting help to understand the data at a glance. There are several icon sets in Excel. But in some cases, the icon sets may ...

How to Mirror Chart in Excel (2 Suitable Examples)

If you are looking for some special tricks to learn how to mirror chart in Excel, you've come to the right place. This article will discuss two ...

How to Flip Excel Sheet from Left to Right (4 Easy Ways)

In an Excel sheet, the dataset usually shows from left to right. However, sometimes, the direction of the sheet is shown from right to left. This ...

How to Zoom in Excel Graph (With Easy Steps)

While working with Microsoft Excel, we insert graphs to make it possible to visualize data collections. We zoom an Excel graph to see it up close. ...

How to Remove Drawing Tools in Excel (3 Easy Methods)

In this tutorial, I am going to show you 3 easy methods to remove drawing tools in Excel. A lot of times when you copy any data from other sources, ...

How to Automatically Hide Rows with Zero Values in Excel

In this article, we will learn to automatically hide rows with zero values in Excel. In Microsoft Excel, we store different types of data and use ...

Create a Table in Excel Based on Cell Value (4 Easy Methods)

If you want to create a table in Excel based on cell value, you have come to the right place. In the following article, we will demonstrate to you 4 ...

How to Add Brackets to Negative Numbers in Excel (3 Easy Ways)

It is a common case while working in Excel to get negative values in the calculation. By default, Excel will put a negative sign before such values. ...

How to Create a Table Without Data in Excel (2 Easy Methods)

To represent data in a very clean and concise manner there is no better alternative than creating a table. And to create a table, Microsoft Excel is ...

How to Mirror Table in Excel (4 Easy Methods)

While working with Microsoft Excel, sometimes we need to mirror a table for the convenience of our work. Mirroring a table in Excel is an easy task. ...

How to Mirror Data in Excel (3 Easy Ways)

Sometimes, we need to put the same data in different columns or rows for calculation and visualization purposes. In this regard, it is quicker and ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo