ExcelSirJi | Premium And Advance Excel Training Tutorials

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?”

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…

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…

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

Data Analysis

How to use Goal Seek in Excel for 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

Data Visualization

How to create a Histogram chart in Excel

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.

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.

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

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…

Advanced Excel Techniques

How to Use Array Function 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

Advanced Excel Techniques

How to use Solver in Excel with examples

BySumit Shrimal

This tutorial shows how to add and find the Solver tool in different versions of Excel, from 2016 to 2003. It includes simple examples on how to use Excel Solver to solve linear programming problems and other types of challenges.

Excel Functions

How to use IFERROR Function in Excel

BySumit Shrimal

This tutorial explains how to use the IFERROR function in Excel to catch and handle errors. It shows you how to replace errors with a blank cell, a different value, or a custom message. You’ll also learn how to use IFERROR with functions like VLOOKUP and INDEX MATCH, and how it compares to other error-checking functions like IF ISERROR and IFNA

Excel Basics

Unprotect Excel Worksheet – 4 easy methods

ByAnshu Taneja

Want to learn how to unprotect Excel worksheet? Follow this simple guide to master this important skill in Excel. You can protect an Excel worksheet with or without a password. This helps keep your data…

Excel Basics

How to Convert Inches to Centimeters

BySumit Shrimal

In this tutorial, we’ll learn how to convert inches to Centimeters, and millimeters. A millimeters is one-tenth of a centimeter. You can easily do these conversions in Excel using formulas. Let’s see how it works.

Excel Functions

Offset Function in Excel

BySumit Shrimal

In this tutorial, we’re going to explore one of the most intriguing features in Excel: the OFFSET function.

So, what is the OFFSET function in Excel? Simply put, OFFSET gives you a reference to a range of cells that’s moved from a starting point by a certain number of rows and columns.

Excel Basics

Bullet Points in Excel – 4 Easy Ways

ByAnshu Taneja

Today, I’ll show you how to add bullet points in Excel with simple steps and clear images, so you can easily highlight key points in your Excel reports for better clarity and readability. Bullet points…

Data Analysis

How to calculate CAGR (Compound Annual Growth Rate) in Excel

BySumit Shrimal

The tutorial explains what the Compound Annual Growth Rate (CAGR) is and shows how to create a clear and easy-to-understand formula for calculating CAGR in Excel.

Excel Basics

How to Print Gridlines in Excel – 3 Easy and Quickiest Way

ByAnshu Taneja

If you want to print your Excel spreadsheets with gridlines, this guide is for you. Adding gridlines makes your data easier to read and gives your spreadsheet a clean, organized look. In this post, we’ll…

Excel Functions

Absolute Value in Excel – Simple steps with 4 examples

ByAnshu Taneja

What is Absolute Value in Excel? The absolute value of a number is its distance from zero on the number line, regardless of direction, so it’s always a non-negative number. The ABS function in Excel…

Excel Basics

How to Delete Blank Rows in Excel – 6 Easy Methods

ByAnshu Taneja

Blank rows in Excel can be a real hassle, making it harder to move around and work with your data. But don’t worry—there are plenty of easy ways to get rid of these unwanted rows….

Excel Basics

Strikethrough in Excel – 4 Easy Ways

ByAnshu Taneja

What is Strikethrough in Excel? Strikethrough in Excel is a feature that lets you draw a line through text. It’s like crossing something out, usually to show that it’s no longer needed or has been…