Learn Excel | Premium And Advance Excel Training Tutorials

Data Analysis
Linear regression analysis in Excel
BySumit Shrimal
The tutorial teaches you the basics of regression analysis and shows a few ways to do linear regression in Excel.
Imagine this: you have a lot of data and need to predict next year’s sales for your company. You’ve found many factors that could affect the sales, maybe even hundreds. But how do you know which ones really matter? You can use regression analysis in Excel. It will help answer this and other questions, like: Which factors are important and which ones don’t matter? How connected are these factors? And how confident can you be in your predictions?”
Read More Linear regression analysis in Excel
Excel Basics
Excel Cell Reference – 3 simple ways
ByAnshu Taneja
What is Excel Cell Reference? Excel Cell references are the names of cells. A cell reference has a letter and a number. The letter comes from the column (A, B, C…) and the number comes…
Read More Excel Cell Reference – 3 simple ways
Excel Basics
Unhide Cells in Excel – 5 Easy Methods
ByAnshu Taneja
Unhide Cells in Excel means you’ve probably hidden a row, column, or worksheet before to focus on important data. But what if you need to see those hidden parts again? Don’t worry—Excel makes it easy…
Read More Unhide Cells in Excel – 5 Easy Methods
Excel Functions
How to use Transpose Function in excel
BySumit Shrimal
This tutorial explains how the TRANSPOSE function works and shows you the right way to use it to switch data in Excel.
Everyone has different preferences, even for work habits. Some people like to arrange data in vertical columns, while others prefer horizontal rows. If you ever need to switch the direction of your data quickly, the TRANSPOSE function can help
Read More How to use Transpose Function in excel
Data Analysis
How to use Goal Seek in Excel for Powerful What-If analysis
BySumit Shrimal
This tutorial shows how to use Goal Seek in Excel 365 – 2010 to get the result you want by changing an input value.
What-If Analysis is one of Excel’s most powerful but least understood features. Simply put, it lets you try out different scenarios and see possible outcomes. In other words, it helps you see how changes affect your data without actually changing the real data. In this tutorial, we’ll focus on one of Excel’s What-If Analysis tools—Goal Seek
Read More How to use Goal Seek in Excel for Powerful What-If analysis
Data Visualization
How to create a Histogram chart in Excel: A Step-by-Step Guide with Examples
BySumit Shrimal
This guide shows three easy ways to make a histogram in Excel: using the built-in Histogram tool, formulas, or a PivotTable. Even though making charts is usually simple, histograms can be tricky. But in newer versions of Excel, it’s easy to create one in just a few steps. Let’s explore each method in detail.
Read More How to create a Histogram chart in Excel: A Step-by-Step Guide with Examples
Excel Basics
How to Insert DEGREE Symbol in Excel
BySumit Shrimal
You need to know how to insert and use the degree symbol in a cell.
Let me explain why this is important. Yesterday, I was working with temperature data, and it was crucial to use the degree symbol to indicate Celsius and Fahrenheit.
Read More How to Insert DEGREE Symbol in Excel
Excel Functions
ROMAN Function In Excel
BySumit Shrimal
The ROMAN function in Excel converts numbers into Roman numerals. It’s useful when you need to display numbers in the Roman numeral format, such as for dates, titles, or other specific purposes. The function allows you to choose how “traditional” or simplified the Roman numeral should be. To use the ROMAN function, you just need to enter the number you want to convert, and Excel will do the rest
Read More ROMAN Function In Excel
Excel Basics
Show Formulas in Excel – 5 Easy Methods
ByAnshu Taneja
In this post, you’ll learn how to Show formulas in Excel spreadsheets. Usually, when you create a formula in Excel, it shows the result in the cell. But sometimes, you might want to see the…
Read More Show Formulas in Excel – 5 Easy Methods
Excel Functions
How to Use Array Functions in Excel
BySumit Shrimal
In this tutorial, you’ll learn what an Excel array formula is, how to enter it properly, and how to use array constants and array functions.
Array formulas are a very powerful tool in Excel, allowing you to do multiple calculations with a single formula. One array formula can replace many regular formulas. However, most users—around 90%—have never used them because they seem intimidating to learn.
Array formulas are known to be one of the trickiest Excel features to understand. The goal of this tutorial is to make learning them as easy and simple as possible
Read More How to Use Array Functions in Excel