Excel Tutorial

Excel Tutorial Online: Learn from basic to advanced

Microsoft Excel comes with various tools and functions that help you to gather, analyze, and visualize data. This will enable… Read More

4 years ago

Enable Excel Developer Tab 2020 to Ribbon [Windows, Mac]

Developer tab is located on the ribbon just after View tab. In some version of Excel, you will not find… Read More

4 years ago

How to Add or Remove Excel Add-Ins [Plugins]

The Excel Add-Ins works similarly as the plugin with only a few changes is seen. The Add-Ins is an important… Read More

4 years ago

Freeze Panes in Excel [COLUMNS & LOCK ROWS]

Freeze panes in excel: If you have a large data set, then you need to freeze rows and columns so… Read More

4 years ago

Excel Split Cell – Half, Rows, Cells, Diagonally – [Mac, Windows]

When you receive data from any database or you have copied data set from the internet then there may be… Read More

4 years ago

Regression Analysis in Excel [Linear Regression]

Whenever we want to estimate the relationship between variables then we think of using regression analysis. There are different types… Read More

4 years ago

Pareto Chart in Excel: Steps to create (Drive more customers)

If you are hotelier or you have any other business then this excel chart is very useful for you. For… Read More

4 years ago

How to Make Histogram in Excel (Windows, Mac)

An Excel histogram is a bar chart that organizes data points in the user-specified ranges. Here we have provided the… Read More

4 years ago

Excel Count, CountA, CountBlank, CountIf, CountIfs functions

The COUNT function will count the total number of cells containing the total number of cells within the list of… Read More

4 years ago

Excel Logical Test Using Multiple If Statements [OR/AND]

To test certain conditions, people use If statement. The If() function is used to perform logical tests and to evaluate… Read More

4 years ago