Advanced Excel Archives - Page 5 of 8

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

Jun 4, 2021 Advanced Excel

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

Sep 27, 2021 Advanced Excel

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)

Sep 8, 2021 Advanced Excel 2

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

Apr 8, 2021 Advanced Excel

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

Nov 14, 2021 Advanced 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

Apr 8, 2021 Advanced Excel 6

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

Apr 7, 2021 Advanced Excel

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

Jun 5, 2021 Advanced Excel 1

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

Sep 12, 2021 Advanced Excel

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

Apr 7, 2021 Advanced Excel

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

Sep 12, 2021 Advanced Excel

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?

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

Jun 5, 2021 Advanced Excel

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, …)

Jun 7, 2021 Advanced Excel

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?

Jun 5, 2021 Advanced Excel

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