How To Plot X Vs Y Data Points In Excel

In this article, we will learn How To Plot X Vs Y Data Points In Excel. Scenario: Excel to plot XY graph, also known as scatter chart or X...

How to use Histograms plots in Excel

In this article, we will learn How to use Histograms plots in Excel. Scenario: A histogram is a common data analysis tool in the busines...

All about Drop down list in Excel

In this article, we will learn All about Drop down list in Excel. Scenario: Data Validation is the tool that is used to restrict the ent...

How and why to hard code values in Excel

In this article, we will learn How and why to hardcode values in Excel. Scenario: What is hard coding in Excel. Hard coding is a way of prov...

Shortcut to jump to last cell and first cell in Excel

In this article, we will learn the Shortcut to jump to the last cell and first cell in Excel. Scenario: Generally, when working with large d...

How to rename sheets and format sheet tabs in Excel

In this article, we will learn How to rename sheets and format sheet tabs in Excel. Scenario: Introduction to Excel basics, Here we are goin...

How to Increment A Value By Row or Column in Excel

If you want to increment a value or a calculation in Excel with rows and columns as they are copied in other cells, you will need to use the ROW f...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.