ExcelDemy - Page 348 of 359 - Free Excel Tutorial & Online Courses

One and Two Ways (Variables) Sensitivity Analysis in Excel!

Apr 6, 2021 Data Analysis with Excel

Sensitivity analysis studies how different sources of uncertainty can affect the final output in a mathematical model. Recently one of my friends ...

Practice Excel Indirect Function with 3 Case Studies

Jun 7, 2021 Excel Formulas 3

Today I want to talk about one of the most important Excel functions - INDIRECT function. Before doing that, I need to give you a brief ...

How to Make a Control Chart with Excel VBA!

Jul 19, 2022 Excel Charts 4

In this article, I will show you How to Make a Control Chart with Excel VBA. Control charts are widely used to monitor process stability and control. ...

Excel Charts with Dynamic Title and Legend Labels

Jul 20, 2022 Excel Charts

Dynamism is everywhere! Then why not with Excel? Creating dynamic charts in Excel is possible in many ways. What I am going to cover in this ...

How different is VBA from other programming languages?

Apr 6, 2021 Macros & Excel VBA

THE EXCEL CONTRAPTION A beginner's journey into the world of Excel is always filled with many “OMG it can do that too ?!? Amazing!”. For what all ...

Reverse Pivot Tables – Unpivot Summary Data

Jun 12, 2022 Excel Pivot Table

Excel pivot tables are beautiful! Then why do you need to reverse your pivot tables or pivoted data? Because data generated by businesses are ...

How to Use INDEX Function in Excel (8 Examples)

Jul 3, 2022 Excel Functions 9

The INDEX Function is one of the top used 10 Excel functions. In this tutorial, you will get a complete idea of how the INDEX function works in Excel ...

Excel Advanced Filter [Multiple Columns & Criteria, Using Formula & with Wildcards]

Nov 4, 2021 Advanced Excel 7

I was performing keyword analysis for one of my new projects using SemRush.com, a competitive analysis tool. Actually, I was checking for how many ...

Separating Numbers from a Text – [A Formula Challenge for You]!

Apr 6, 2021 Excel Formulas 14

At Udemy, I run several courses on Excel and Data Analysis. In one of my free courses (Excel Formulas and Functions with Excel Formulas Cheat Sheet), ...

Stock return analysis using histograms & 4 skewness of histograms

Jun 12, 2022 Data Analysis with Excel 1

A histogram is a widely used way to summarize a large data set. Creating a histogram using Data Analysis ToolPak is very easy. This blog is aimed to ...

How to insert Equation in Excel using Equation Editor (Easy Guide)

Sep 7, 2021 Advanced Excel 8

If you do mathematics related report or assignment with Excel, you have to know how to use the Equation Editor. In this tutorial, we shall ...

Forecasting in Excel Using FORECAST Function & Auto Fill Handle Tool

Jun 30, 2022 Advanced Excel

This article is aimed to show you two forecasting methods that you can use to forecast in Excel. If you own or operate a business, this is a ...

Running Average: How to Calculate Using Excel’s Average(…) Function

Sep 9, 2021 Data Analysis with Excel 2

In this post, you will learn how to calculate the running average of a data set using Excel's Average(...) function. A business generates a huge ...

Use Scatter Chart in Excel to Find Relationships between Two Data Series

Jul 12, 2022 Data Analysis with Excel

In this post, you will learn how to find out the relationships between two or more data series using Scatter Chart in Excel. You know, business ...

How to Make a Histogram in Excel Using Data Analysis ToolPak

Mar 1, 2022 Data Analysis with Excel

This is a step by step guide on how to make a histogram in Excel using Data Analysis ToolPak. Charts and graphs help you to summarize your data ...

Latest Posts