• About Us
  • Privacy Policy
  • Disclaimer
  • Contact Us
TechTrendFeed
  • Home
  • Tech News
  • Cybersecurity
  • Software
  • Gaming
  • Machine Learning
  • Smart Home & IoT
No Result
View All Result
  • Home
  • Tech News
  • Cybersecurity
  • Software
  • Gaming
  • Machine Learning
  • Smart Home & IoT
No Result
View All Result
TechTrendFeed
No Result
View All Result

Understanding Convolutional Neural Networks (CNNs) By way of Excel

Admin by Admin
November 18, 2025
Home Machine Learning
Share on FacebookShare on Twitter


as a black field. We all know that it learns from information, however the query is how it actually learns.

On this article, we are going to construct a tiny Convolutional Neural Community (CNN) straight in Excel to know, step-by-step, how a CNN truly works for pictures.

We’ll open this black field, and watch every step occur proper earlier than our eyes. We’ll perceive all of the calculations which can be the muse of what we name “deep studying”.

This text is in a collection of articles about implementing machine studying and deep studying algorithms in Excel. And you’ll find all of the Excel recordsdata on this Kofi hyperlink.

1. How Photos are Seen by Machines

1.1 Two Methods to Detect One thing in an Picture

After we attempt to detect an object in an image, like a cat, there are two important methods: the deterministic method and the machine studying method. Let’s see how these two approaches work for this instance of recognizing a cat in an image.

The deterministic approach means writing guidelines by hand.

For instance, we will say {that a} cat has a spherical face, two triangle ears, a physique, a tail, and many others. So the developer will do all of the work to outline the principles.

Then the pc runs all these guidelines, and provides a rating of similarity.

Deterministic method to detect a cat on an image — picture by creator

The machine studying method signifies that we don’t write guidelines by ourselves.

As an alternative, we give the pc many examples, photos with cats and photos with out cats. Then it learns by itself what makes a cat a cat.

Machine studying method to detect a cat on an image — picture by creator (cats are generated by AI)

That’s the place issues might turn into mysterious.

We often say that the machine will determine it out by itself, however the actual query is how.

Actually, we nonetheless have to inform the machines learn how to create these guidelines. And guidelines must be learnable. So the important thing level is: how can we outline the type of guidelines that shall be used?

To grasp learn how to outline guidelines, we first have to know what a picture is.

1.2 Understanding What an Picture Is

A cat is complicated type, however we will take a easy and clear instance: recognizing handwritten digits from the MNIST dataset.

First, what’s a picture?

A digital picture could be seen as a grid of pixels. Every pixel is a quantity that exhibits how shiny it’s, from 0 for white to 255 for black.

In Excel, we will characterize this grid with a desk the place every cell corresponds to at least one pixel.

MNIST Handwritten digits – picture from the MNIST dataset https://en.wikipedia.org/wiki/MNIST_database (CC BY-SA 3.0)

The unique dimension of the digits is 28 x 28. However to maintain issues easy, we are going to use a ten×10 desk. It’s sufficiently small for fast calculations however nonetheless massive sufficient to indicate the final form.

So we are going to scale back the dimension.

For instance, the handwritten quantity “1” could be represented by a ten×10 grid as beneath in Excel.

Picture is a grid of numbers — picture by creator

1.3 Earlier than Deep Studying: Basic Machine Studying for Photos

Earlier than utilizing CNNs or any deep studying technique, we will already acknowledge easy pictures with traditional machine studying algorithms reminiscent of logistic regression or resolution timber.

On this method, every pixel turns into one characteristic. For instance, a ten×10 picture has 100 pixels, so there are 100 options as enter.

The algorithm then learns to affiliate patterns of pixel values with labels reminiscent of “0”, “1”, or “2”.

Basic ML for picture recognition — picture by creator

Actually with this easy machine studying method, logistic regression can obtain fairly good outcomes with an accuracy round 90%.

This exhibits that traditional fashions are in a position to study helpful info from uncooked pixel values.

Nevertheless, they’ve a significant limitation. They deal with every pixel as an impartial worth, with out contemplating its neighbors. Consequently, they can’t perceive spatial relationships with the pixels.

So intuitively, we all know that the efficiency is not going to be good for complicated pictures. So this technique is just not scalable.

Now, in case you already understand how traditional machine studying works, you understand that there isn’t any magic. And in reality, you already know what to do: you must enhance the characteristic engineering step, you must remodel the options, as a way to get extra significant info from the pixels.

2. Constructing a CNN Step by Step in Excel

2.1 From complicated CNNs to a easy one in Excel

After we discuss Convolutional Neural Networks, we frequently see very deep and complicated architectures, like VGG-16. Many layers, 1000’s of parameters, and numerous operations, it appears very complicated, and say that it’s not possible to know precisely the way it works.

VGG16 structure — picture by creator

The primary concept behind the layers is: detecting patterns step-by-step.

With the instance of handwritten digits, let’s ask a query: what might be the best doable CNN structure?

First, for the hidden layers, earlier than doing all of the layers, let’s scale back the quantity. What number of? Let’s do one. That’s proper: just one.

As for the filters, what about their dimensions? In actual CNN layers, we often use 3×3 filters to detect small sample. However let’s start with massive ones.

How massive? 10×10!

Sure, why not?

This additionally signifies that you don’t have to slip the filter throughout the picture. This manner, we will straight evaluate the enter picture with the filter and see how properly they match.

This straightforward case is just not about efficiency, however about readability.
It can present how CNNs detect patterns step-by-step.

Now, we’ve got to outline the variety of filters. We’ll say 10, it’s the minimal. Why? As a result of there are 10 digits, so we’ve got to have a minimal of 10 filters. And we are going to see how they are often discovered within the subsequent part.

Within the picture beneath, you’ve the diagram of this easiest structure of a CNN neural community:

The best CNN structure – picture by creator

2.2 Coaching the Filters (or Designing Them Ourselves)

In an actual CNN, the filters aren’t written by hand. They’re discovered throughout coaching.

The neural community adjusts the values inside every filter to detect the patterns that greatest assist to acknowledge the pictures.

In our easy Excel instance, we is not going to practice the filters.

As an alternative, we are going to create them ourselves to know what they characterize.

Since we already know the shapes of handwritten digits, we will design filters that appear to be every digit.

For instance, we will draw a filter that matches the type of 0, one other for 1, and so forth.

An alternative choice is to take the typical picture of all examples for every digit and use that because the filter.

Every filter will then characterize the “common form” of a quantity.

That is the place the frontier between human and machine turns into seen once more. We will both let the machine uncover the filters, or we will use our personal information to construct them manually.

That’s proper: machines don’t outline the character of the operations. Machine studying researchers outline them. Machines are solely good to do loops, to search out the optimum values for these defines guidelines. And in easy circumstances, people are all the time higher than machines.

So, if there are solely 10 filters to outline, we all know that we will straight outline the ten digits. So we all know, intuitively, the character of those filters. However there are different choices, after all.

Now, to outline the numerical values of those filters, we will straight use our information. And we can also use the coaching dataset.

Under you possibly can see the ten filters created by averaging all the pictures of every handwritten digit. Each exhibits the standard sample that defines a quantity.

Common values as filters — picture by creator

2.3 How a CNN Detects Patterns

Now that we’ve got the filters, we’ve got to check the enter picture to those filters.

The central operation in a CNN is named cross-correlation. It’s the key mechanism that permits the pc to match patterns in a picture.

It really works in two easy steps:

  1. Multiply values/dot product: we take every pixel within the enter picture, and we are going to multiply it by the pixel in the identical place of the filter. Which means the filter “appears to be like” at every pixel of the picture and measures how related it’s to the sample saved within the filter. Sure, if the 2 values are massive, then the result’s massive.
  2. Add outcomes/sum: The merchandise of those multiplications are then added collectively to supply a single quantity. This quantity expresses how strongly the enter picture matches the filter.
Instance of Cross Correlation for one image – picture by creator

In our simplified structure, the filter has the identical measurement because the enter picture (10×10).

Due to this, the filter doesn’t want to maneuver throughout the picture.
As an alternative, the cross-correlation is utilized as soon as, evaluating the entire picture with the filter straight.

This quantity represents how properly the picture matches the sample contained in the filter.

If the filter appears to be like like the typical form of a handwritten “5”, a excessive worth signifies that the picture might be a “5”.

By repeating this operation with all filters, one per digit, we will see which sample provides the best match.

2.4 Constructing a Easy CNN in Excel

We will now create a small CNN from finish to finish to see how the complete course of works in observe.

  1. Enter: A ten×10 matrix represents the picture to categorise.
  2. Filters: We outline ten filters of measurement 10×10, every one representing the typical picture of a handwritten digit from 0 to 9. These filters act as sample detectors for every quantity.
  3. Cross correlation: Every filter is utilized to the enter picture, producing a single rating that measures how properly the picture matches that filter’s sample.
  4. Determination: The filter with the best rating provides the anticipated digit. In deep studying frameworks, this step is commonly dealt with by a Softmax perform, which converts all scores into possibilities.
    In our easy Excel model, taking the most rating is sufficient to decide which digit the picture more than likely represents.
Each 10×10 filter represents the average shape of a handwritten digit (0–9).
The input image is compared with all filters using cross-correlation.
The filter that produces the highest score — after normalization with Softmax — corresponds to the detected digit.
Cross-correlation of the enter digit with ten common digit filters. The best rating, normalized by Softmax, identifies the enter as “6.” – picture by creator

2.5 Convolution or Cross Correlation?

At this level, you would possibly surprise why we name it a Convolutional Neural Community when the operation we described is definitely cross-correlation.

The distinction is refined however easy:

  • Convolution means flipping the filter each horizontally and vertically earlier than sliding it over the picture.
  • Cross-correlation means making use of the filter straight, with out flipping.

For extra info, you possibly can learn this text:

For some historic motive, the time period Convolution stayed, whereas the operation that’s truly carried out in a CNN is cross-correlation.

As you possibly can see, in most deep-learning frameworks, reminiscent of PyTorch or TensorFlow, truly use cross-correlation when performing “convolutions”.

Cross correlation and convolution — picture by creator

Briefly:

CNNs are “convolutional” in title, however “cross-correlational” in observe.

3. Constructing Extra Complicated Architectures

3.1 Small filters to detect extra detailed patterns

Within the earlier instance, we used a single 10×10 filter to check the entire picture with one sample.

This was sufficient to know the precept of cross-correlation and the way a CNN detects similarity between a picture and a filter.

Now we will take one step additional.

As an alternative of 1 world filter, we are going to use a number of smaller filters, every of measurement 5×5. These filters will have a look at smaller areas of the picture, detecting native particulars as an alternative of your complete form.

Let’s take an instance with 4 5×5 filters utilized to a handwritten digit.

The enter picture could be lower into 4 smaller components of 5×5 pixels for every one.

We nonetheless can use the typical worth of all of the digits to start with. So every filter will give 4 values, as an alternative of 1.

Smaller filters in CNN for digits recognition – picture by creator

On the finish, we will apply a Softmax perform to get the ultimate prediction.

However on this easy case, it’s also doable simply to sum all of the values.

3.2 What if the digit is just not within the heart of the picture

In my earlier examples, I evaluate the filters to mounted areas of the picture. And one intuitive query that we will ask is what if the thing is just not centered. Sure, it may be at any place on a picture.

The answer is sadly very primary: you slide the filter throughout the picture.

Let’s take a easy instance once more: the dimension of the enter picture is 10×14. The peak is just not modified, and the width is 14.

So the filter remains to be 10 x 10, and it’ll slide horizontally throughout the picture. Then, we are going to get 5 cross-correlation.

We have no idea the place the picture is, however it’s not an issue as a result of we will simply get the max worth of the 5 the-cross correlations.

That is what we name max pooling layer.

Max pooling in a easy CNN – Picture by creator

3.3 Different Operations Utilized in CNNs

We attempt to clarify, why every element is helpful in a CNN.

A very powerful element is the cross-correlation between the enter and the filters. And we additionally clarify that small filters could be helpful, and the way max pooling handles objects that may be anyplace in a picture.

There are additionally different steps generally utilized in CNNs, reminiscent of utilizing a number of layers in a row or making use of non-linear activation capabilities.

These steps make the mannequin extra versatile, extra strong, and in a position to study richer patterns.

Why are they helpful precisely?

I’ll go away this query to you as an train.

Now that you simply perceive the core concept, strive to consider how every of those steps helps a CNN go additional, and you may strive to consider some concrete instance in Excel.

Conclusion

Simulating a CNN in Excel is a enjoyable and sensible technique to see how machines acknowledge pictures.

By working with small matrices and easy filters, we will perceive the primary steps of a CNN.

I hope this text gave you some meals for thought of what deep studying actually is. The distinction between machine studying and deep studying is just not solely about how deep the mannequin is, however about the way it works with representations of pictures and information.

Tags: CNNsConvolutionalExcelNetworksNeuralUnderstanding
Admin

Admin

Next Post
Google Colab is Coming to VS Code

Google Colab is Coming to VS Code

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Trending.

Discover Vibrant Spring 2025 Kitchen Decor Colours and Equipment – Chefio

Discover Vibrant Spring 2025 Kitchen Decor Colours and Equipment – Chefio

May 17, 2025
Safety Amplified: Audio’s Affect Speaks Volumes About Preventive Safety

Safety Amplified: Audio’s Affect Speaks Volumes About Preventive Safety

May 18, 2025
Flip Your Toilet Right into a Good Oasis

Flip Your Toilet Right into a Good Oasis

May 15, 2025
Reconeyez Launches New Web site | SDM Journal

Reconeyez Launches New Web site | SDM Journal

May 15, 2025
Apollo joins the Works With House Assistant Program

Apollo joins the Works With House Assistant Program

May 17, 2025

TechTrendFeed

Welcome to TechTrendFeed, your go-to source for the latest news and insights from the world of technology. Our mission is to bring you the most relevant and up-to-date information on everything tech-related, from machine learning and artificial intelligence to cybersecurity, gaming, and the exciting world of smart home technology and IoT.

Categories

  • Cybersecurity
  • Gaming
  • Machine Learning
  • Smart Home & IoT
  • Software
  • Tech News

Recent News

The toughest query to reply about AI-fueled delusions

The toughest query to reply about AI-fueled delusions

March 24, 2026
How Reco transforms safety alerts utilizing Amazon Bedrock

How Reco transforms safety alerts utilizing Amazon Bedrock

March 24, 2026
  • About Us
  • Privacy Policy
  • Disclaimer
  • Contact Us

© 2025 https://techtrendfeed.com/ - All Rights Reserved

No Result
View All Result
  • Home
  • Tech News
  • Cybersecurity
  • Software
  • Gaming
  • Machine Learning
  • Smart Home & IoT

© 2025 https://techtrendfeed.com/ - All Rights Reserved