Advanced Excel

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

Data clean-up techniques in Excel

Cleaning-up data in Excel covers many areas. We have covered almost every angle. Here are the links: Data clean-up techniques in Excel: Removing ...

Data clean-up techniques in Excel: Fixing trailing minus signs

Sometimes it may happen that your imported data will show as the following screenshot: Some data have minus signs at the end, trailing minus ...

Data clean-up techniques in Excel: Adding text to cells

Sometimes you may need to add text to a cell, one solution is to use a new column and use formulas. To gain a clear grasp on this topic, you have ...

Data clean-up techniques in Excel: Replacing or removing text in cells

Solution 1: Using Find and Replace Dialog box. Sometimes it is necessary to replace or remove some characters from a column of data. For example, ...

Data clean-up techniques in Excel: Filling blank cells

Sometimes you will end up with a worksheet that will look something like the one shown in the following Figure. Filling Blank Cells in Excel. ...

Data clean-up techniques in Excel: Changing vertical data to horizontal data

Sometimes after importing a file in your Excel file, the following type of data layout may generate. See the following image. Vertical data. We ...

Data clean-up techniques in Excel: Matching text in a list

You may have some data and you want to check this data against another available list. Download this file to work with us in the following ...

ExcelDemy
Logo