Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Create a Networking Catalogue in Excel (with Easy Steps)

Networking equipment such as switches, routers, wireless, etc is well-known in the technology industry. To promote the product, companies may often require to make a catalogue. So, in this article, we are going to discuss how to create a networking catalogue in Excel.


Download Practice Workbook

You can download and practice the dataset that we have used to prepare this article.


3 Steps to Create a Networking Catalogue in Excel

Let’s assume we have a dataset, namely Networking Catalogue for ABC Limited”. Here the dataset has five columns with eight rows. We will recreate the images as attached below.

How to Create a Networking Catalogue in Excel

Here, we have used the Microsoft Excel 365 version; you may use any other version according to your convenience.


Step 01: Give a Suitable Title to the Catalogue

First thing first, we will start our process by creating an appropriate title for our catalogue. Here we have chosen “Networking Catalogue of ABC Limited” as our catalogue title. Though you can choose anything which seems appropriate to you.

  • After writing the title name, select the adequate range of cells (B2:F2 for instance) to accommodate your title.
  • Then click on Merge & Center feature and Select the Bold option (B) from Font Ribbon.
  • Select the appropriate Font (Calibri in our case) and then increase the Font Size to 13. Next, make your title in the Bottom & Center alignment as in the image depicted below. It is worth mentioning that, those are subjective values, you may use any of the combinations on the basis of our work type or maintain a specific guideline if your work has any.

Give a Suitable Title to the Catalogue


Step 02: Create a Basic Outline

In Microsoft Excel, you can create an outline to segment and present your data more effectively. So we will now create a basic outline prior to entering our networking catalogue data. For your better understanding, we have added a GIF to demonstrate the process. Anyway, you can create your own outline according to your preference.

Give a Suitable Title to the Catalogue

Step 03: Write the Product Information

Apart from marketing and advertising the product, a networking catalogue also helps its user to track the record of the product. For example, a seller wants to know how many networking items he has in his product inventory. Using a catalogue surely benefits him if he wants to avoid random searching in his warehouse. Thus it will increase work efficiency and ensure the best utilization of available resources. To avail of these opportunities, you have to list all of your product-related information in the created table. So now we will write the product information in our Excel sheet.

  • See the image attached below. Here we list the product name and use Wrap Text to avoid the overlapping of the text on nearby cells.

Give a Suitable Title to the Catalogue

  • Then write the product id of the equipment as shown below.

  • To write the product type of our networking catalouge, we will now incorporate a drop-down list within the column.
  • First, select D5:D11 in which we would like to create a drop-down list.

  • Subsequently, a dialog box will appear. Now select Settings tab > choose List from the drop-down options of Allow.
  • Then click on the Upwards arrow.

  • Thus an additional Data Validation box will pop up.
  • Now type your list of data in this box. Switch, Router, Wireless, Server, IP Phone, Accessories for instance.

  • Afterward, press OK.

  • Now, to list your product type column, click on the down arrow icon and select the respective product type name in the corresponding row.

  • After inputting our data, see the output below.

  • So far so good. Now, we will type the corresponding price of the equipment. See the attachment given below.
  • Now to add a Dollar sign ($), click on the down-head arrow from the Number.

excel networking catalogue

  • Select the Currency option afterward.

excel networking catalogue

  • See the output as given below.

excel networking catalogue

  • You still lag behind to add the images of our networking catalogue.
  • After selecting the intended cell, go to Insert > Pictures > This device.

  • Find the picture from your storage and click on Insert simultaneously.

excel networking catalogue

  • See the output as given below.

excel networking catalogue

  • Follow the same process to attach the rest of the image as shown below.

Read More: How to Create Product Catalogue in Excel (With Easy Steps)


Things to Remember

  • Keep in mind while attaching the image in your excel sheet, unlike the text data the attached image won’t embed within the specific cell. Thus you may need to move it to the appropriate position to fit the image within the specific row.

Practice Section

We have provided a Practice section on the right side of each sheet so you can practice yourself. Please make sure to do it yourself.

Do it yourself


Conclusion

In this article, we have discussed how to create a networking catalogue in Excel. We think it is necessary knowledge to promote your product to your customers. However, If you have any queries, feel free to comment below and we will get back to you soon. Also, you may follow our website, ExcelDemy, a one-stop Excel solution provider to explore more.


Related Articles

Mohammad Shah Miran

Mohammad Shah Miran

Miran is a highly motivated individual with a strong educational background in engineering. He is interested in technology and passionate about creating engaging and informative content. After graduation, Miran decided to pursue a career in content development and has been working in the field for some time. Miran is dedicated to staying current with the latest trends and technologies and is eager to continue learning and growing as a professional.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo