Advanced Excel

Using Table Nomenclature in Excel & Referring to Tables in VBA!

We have already covered how to format Excel Tables extensively in a previous tutorial. We are now going to look at using Table Nomenclature or ...

How to Print An Excel Sheet on One Page

This is a question that is often asked (How to Print Excel Sheet on One Page), namely how to fit the contents of one’s spreadsheet on one page when ...

How to Make Excel Tables Look Good (8 Effective Tips)

Editor's Note: "How to make Excel tables look good/professional?" - this is a general question by a new user of Excel. I asked Taryn to make a ...

How to Modify Theme Color, Font, & Effects & Create Custom Excel Theme

Excel has themes, which have different default colors, auto shape effects, SmartArt effects, and fonts. When utilizing themes one can quickly change ...

The Different Ways of Counting in Excel

There is a total of five functions used for counting, predominantly in Excel. These are namely the COUNT Function, the COUNTA Function, the COUNTIF ...

Creating Email Addresses from a Single Column with Flash Fill, TEXT Formulas & Commentator’s Text Formula Suggestions

Using Flash Fill This is a question that is often asked namely, how to extract data from one column into another format or more than one column. ...

Navigating Excel Table: Selecting Parts of a Table and Moving a Table

In this post, we shall discuss how you can navigate within a table, how you can select different parts of a table, and how you can move a table from ...

How to Insert or Delete Rows and Columns from Excel Table

In this post, we shall learn how you can add new rows or columns to a table and how you can delete existing rows or columns from a table. You can ...

How to Remove Duplicate Rows in Excel Table

This post will deal with imposters! No, I mean table duplicate entries. We will be able to manage them, remove them, tame them according to our ...

How to Use Sort and Filter with Excel Table

In this post, we will discuss how you can sort and filter the data of a table. The following table contains the data of a real estate company. ...

How to Use Slicers to Filter a Table in Excel 2013

In this post today, we will be discussing the Slicer Feature in Excel. It is also possible to filter a table using the Slicer feature. This ...

How to Use Wildcards in Excel?

In this article, we shall see how to use wildcards in Excel. Wildcard characters such as the asterisk "*", question mark "?" and the tilde "~" can ...

How to Find Unique Values in Excel & Detect Duplicates

In this article, we are going to analyze how to find unique values in Excel. Duplication of values in Excel can occur in a single column or across ...

Text to Columns in Excel (Split Column, Text, Date, …)

Excel's Text to Columns Wizard is a very important feature with many uses. In this article, I will teach you some useful uses of Text to Columns in ...

Date & Time in Excel – How to Enter Them in Worksheet Cells Effectively?

Date System in Excel An Excel date is simply a serial number. The earliest date that Excel can understand is January 1, 1900. This date has ...

ExcelDemy
Logo