All resources related to TABLES for Excel and Google Sheets.

Excel table styles

Excel has several built-in table styles that help us format a range of cells to be visually appealing and easy to understand. We can choose from a wide variety of table styles and even customize the created table to suit our preferences. We can also convert our table into a...

Get column index in Excel Table

Excel allows us to get the column number from the Excel Table using MATCH function. The MATCH function logic is the same as for the regular cell ranges. The only difference is coming from the lookup array referencing in the Excel Table. This step by step tutorial will assist all...

Two-way Lookup using VLOOKUP in a Table

While working with Excel, we normally have to work with more than one table. Organizing and completing data in Excel can be done using the VLOOKUP and MATCH functions. This step by step tutorial will assist all levels of Excel users in retrieving data from one table to another by...

How to do Dynamic Reference of Table Name

With the INDIRECT function in combination with functions like SUM and AVERAGE, we can do dynamic reference of table name to perform different calculations. This tutorial will walk through the steps to dynamically reference a set of data in other functions. Figure 1: Total Sales for the Three Cities Setting up the...

Basic inventory formula example

Excel allows a user to create a basic inventory formula example, by using the SUMIF function. This step by step tutorial will assist all levels of Excel users in creating a basic inventory formula example. Figure 1. The result of the SUMIF function Syntax of the SUMIF Formula The generic...

How to Count Table Columns in Excel

Excel allows a user to count table columns, using the COLUMNS function. This step by step tutorial will assist all levels of Excel users in counting table columns. Figure 1. The result of the formula Syntax of the Formula The generic formula is: =COLUMNS(array) The parameter of the COLUMNS function...