CONCATENATE and CONCAT in Excel - Dashboard Guide

Dashboard Mode - CONCATENATE and CONCAT

Dashboard Goal

Combine first and last names into full names to display complete customer names in one place.

Sample Data

First Name	Last Name	City
John	Doe	New York
Jane	Smith	Los Angeles
Emily	Jones	Chicago
Michael	Brown	Houston
Linda	Wilson	Phoenix

Dashboard Components

• Full Name with CONCATENATE: Shows full name by joining first and last names with a space.
  Formula example in cell D2: =CONCATENATE(A2," ",B2)
  Result for row 2: "John Doe"
• Full Name with CONCAT: Shows full name by joining first and last names with a space using CONCAT.
  Formula example in cell E2: =CONCAT(A2," ",B2)
  Result for row 2: "John Doe"
• Count of Customers: Counts total customers.
  Formula example in cell G2: =SUBTOTAL(103,A2:A6)
  Result: 5

Dashboard Layout

+----------------------+----------------------+------------------+
| Full Name (CONCATENATE) | Full Name (CONCAT)    | Count of Customers |
| (Column D)            | (Column E)            | (Cell G2)         |
+----------------------+----------------------+------------------+
| John Doe             | John Doe             | Total: 5          |
| Jane Smith           | Jane Smith           |                  |
| Emily Jones          | Emily Jones          |                  |
| Michael Brown        | Michael Brown        |                  |
| Linda Wilson         | Linda Wilson         |                  |
+----------------------+----------------------+------------------+

Interactivity

Adding a filter by City will update the full name lists to show only customers from the selected city. The count of customers will also update to reflect the filtered list.

Self Check

If you filter the City to show only "Chicago", which full names appear and what is the count of customers?

Answer: Only "Emily Jones" appears in both full name columns, and the count of customers updates to 1.

Key Result

Dashboard shows full customer names combined from first and last names using CONCATENATE and CONCAT, plus total customer count.