Latest Blog Posts

How to Make FOR Loop in Excel Using Formula (3 Examples)

Example 1 - Applying Combined Functions to Make a FOR Loop in Excel Here's an overview of the problem we'll solve with a for loop. Steps: ...

Data Analysis in Excel – Learn 10 Common Statistical Terms

Want to analyze business or any data in Excel? You have to master some common statistical ways. Excel is just a tool, how sharply you can use ...

Essential Excel Skills That Will Make You an Excel Expert: 28 Skills

Method 1 - Converting to PDF If you want to prevent other people from changing your data, convert your spreadsheet to PDF and send it out. ...

102 Useful Excel Formulas Cheat Sheet PDF (Free Download Sheet)

In this Excel Formulas Tutorial, we'll share 102+ Excel formulas as a cheat sheet in a free PDF. You can download the PDF and print it to revise when ...

How to Hide the Same Rows Across Multiple Excel Worksheets

The sample dataset has three sheets and contains sales data of different regions. Macro 1 - Hiding All the Same Rows Across Multiple Excel ...

Excel Solver Guide (Easy and Step by Step)

This article contains a list of articles that explains this topic step wise. Follow the steps given in these articles systematically to solve complex ...

Learn Excel Macros & VBA Programming (Free Tutorial & 50++ Examples)

Learn all about VBA macros and practice the examples to make yourself more productive and break the limitations of Excel. Consider the below overview ...

How to Use Microsoft Excel for Beginners (25 Common Tasks)

This article is intended for beginner users of Excel. We will discuss the basics of how to use Microsoft Excel and describe how to do 25 of the most ...

Excel Alternating Row Color with Conditional Formatting [Video]

In this video tutorial Excel Alternating Row Color using Conditional Formatting, you will learn three topics: Highlight alternating rows, ...

Conditional Formatting with Formula in Excel (21 Examples)

How to Use Formula with Excel Conditional Formatting In the following image, we have a very simple dataset. With Excel conditional formatting with ...

How to Do Conditional Formatting in Excel (Ultimate Guide)

⏷What Is Conditional Formatting in Excel? ⏷Where Is Conditional Formatting Located in Excel? ⏷Apply Different Types of Conditional Formatting      ...

How to Make a Graph or Chart in Excel

This is a complete tutorial on How to Make or Plot a Graph or Chart in Excel. To make a complex chart like the Gantt Chart, you have to know the ...

How to Create a Gantt Chart in Excel – 9 Steps

In a Gantt chart he Horizontal Axis (Value Axis) represents the total time span of the project. Each Bar in the Gantt Chart represents the duration ...

How to Make a Pie Chart in Excel [Video Tutorial]

Then you want to make a Pie Chart in Excel. But do you know: Pie Chart is the worst chart in the world! These are not my words. Read this article by ...

Change the color of text and background of cells – An Excel Font and Fill Color Complete Guide

Overview on Excel Font and Fill Color Change Hello, here I am present to give you a complete guide on how you can work with Excel font color and ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo