Advanced Excel

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

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 ...

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

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

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 ...

How to Make FOR LOOP in Excel Using Formulas?

Don't you want to use Excel VBA and want to make a FOR LOOP in Excel using Formulas? In this article, I've shown how you can make one using ...

Top 20 Advanced Essential Excel Skills You Need to Know

Whether you’re just starting out on your Excel journey or have been using it for a while, there are a few skills that you should know about Excel: ...

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, ...

Excel Conditional Formatting Dates

In this tutorial Excel Conditional Formatting Dates, you will learn how to use the Excel function WEEKDAY() to find out the weekdays from some dates. ...

Excel Conditional Formatting Based on Another Cell

In this tutorial: Excel Conditional Formatting Based on Another Cell, you will learn using two video tutorials how to format one or more cells based ...

Excel Conditional Formatting Formula

In this tutorial Excel Conditional Formatting Formulas, you will learn how to use Excel formulas to format cells conditionally. In this tutorial, ...

How to Use Conditional Formatting in Excel [Ultimate Guide]

This is a complete guide on How to Use/Do Conditional Formatting in Excel. You will also learn how to do and manage multiple conditional ...

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

You cannot create a Gantt chart in Excel in direct way. But don't worry, you can make an advanced level Gantt chart in Excel modifying the Stacked ...

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 ...

Monitor Cells with Excel Watch Window!

Sometimes we have a great deal of data in the workbook. Everything is important but most important is the last row of the data containing, say, the ...

How to Create Pivot Table Data Model in Excel 2013

So far, we have focused exclusively on pivot tables that are generated from a single table of data. The Data Model feature has brought additional ...

Exporting Data in Excel

We shall discuss in this section about exporting data in Excel. You can convert your Excel workbook in different formats like CSV, txt, PRN, and many ...

ExcelDemy
Logo