Advanced Excel Archives - Page 27 of 28

Excel Conditional Formatting Dates

Feb 22, 2022 Advanced Excel 1

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

Feb 22, 2022 Advanced Excel 1

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]

Feb 22, 2022 Advanced Excel 6

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]

Sep 9, 2021 Advanced Excel 1

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

Sep 9, 2021 Advanced Excel

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!

Sep 8, 2021 Advanced Excel

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

Jun 12, 2022 Advanced Excel 1

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

Sep 8, 2021 Advanced 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

Jun 7, 2021 Advanced 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

Mar 2, 2022 Advanced Excel

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

Apr 3, 2022 Advanced Excel

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

Mar 2, 2022 Advanced Excel

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

Mar 2, 2022 Advanced Excel

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

Jun 22, 2022 Advanced Excel

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

Jun 7, 2021 Advanced Excel

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