I think the discrete Fourier transform (DFT) is typically the easiest to use as a base of explanation:
A DFT is a linear transform that operates on a time domain signal. After the transform, the signal is in “the frequency domain”, i.e the signal has now been broken down into a vector/signal which contains information about what sinusoids are contained in the signal, and how strong they are. That’s pretty much it, but I’ll continue on to be more thorough.
So let’s say I have a time domain signal that has a 200Hz size wave and some noise: assuming my sampling rate is sufficient, after I do my DFT, I’ll easy be able to see the sine wave as a peak in the frequency domain, whereas the noise won’t really “add up” to much in the frequency domain.
Of course it’s important to mention that once you do a DFT, there is also an inverse DFT operation that “unapplies” the transform; doing this returns you to the time domain and gives you your original signal back.
For a continuous Fourier transform, the idea is essentially the same, except it is just expanded to calculus rather than discrete mathematics/linear algebra
EDIT:
Okay, we'll try to make this even simpler using some pictures via MATLAB. I've added a good amount of words to explain in detail, but there is almost zero math in the text; hopefully that will be sufficient for you.
We'll start off by showing two signals: one is a sinusoid (with a frequency of 50Hz, that is it oscillates 50 times per second. If you need more information than that, please consult a high school text book), the other is that same sinusoid, but with noise added.
Since you asked what noise was, you can think of noise as random numbers added into the signal which "corrupts" the signal, i.e. it is no longer a pure sinusoid. A plot of such signals in the time domain looks like this:

On the top plot, we can see that there is clearly a sinusoid present. In the bottom plot, it pretty much just looks like a bunch of random numbers. A DFT essentially breaks a signal down into sinusoidal components. It does this by "looking" for the each sinusoid in the signal (it's a bit more complicated than that, but since you wanted limited to no math we'll skip it).
So now that we know that a DFT can "look" for signals, we take the DFT of our two signals, and plot the results to find the following figure:

In the top plot, we have the DFT of our pure sinusoid. Recalling that I assigned it a frequency of 50Hz, we would expect there to be a peak at 50Hz, and indeed there is. You may notice there's a negative frequency component. There is more mathematics required to explain that which involves unit circles, which you said in your original question that you "don't care about", so we'll just leave that be.
Now, on the bottom plot, we have the DFT of the sinusoid plus our random noise. We can see that those two peaks are still there at -50Hz and +50Hz. When we just looked at the time domain signal, it looked like "nothing" was there, just a bunch of random numbers. Through using the DFT, we were able to show that there is actually a sinusoid buried in that noise, and we were able to identify it easily in the frequency domain. This is a very basic motivation for how/why one might want to use a DFT.
Naturally, the inverse DFT (IDFT) does this operation in reverse, i.e. it maps a signal in the frequency domain to the time domain. Knowing that, it's easy to see that if we take the DFT of a signal, perform no other operations, and then eventually take the IDFT of the output, we are given back the signal we started with. This is because the DFT is what is called a linear transform. If you'd like to learn more about that, you'll have to learn more about linear algebra.
This is just one application of the DFT, there is a myriad of other applications, and it is a VERY important subject/tool in signal processing. The Wikipedia article for the DFT has a list of a wide range of applications. If you're interested in learning more, I'd start there.
If someone else would like to provide details for the continuous time Fourier Transform, please do! I think you'll find its more or less going to be the same, but a bit more mathematical in its explanation.
For completeness, here's the MATLAB code for the figures I've shown:
f = 50; % sinusoid frequency
fs = 500; % sample rate
t = linspace(0,1,fs); % create a time vector
% create a sinusoid
x = sin(2*pi*f*t);
% create a noise signal
n = 1.5*randn(size(x));
% add in the noise to the signal x
xn = x+n;
% create a frequency vector that we'll use to label the plot
f = linspace(-fs/2, fs/2, numel(t));
% create a some plots
figure(1);
subplot(2,1,1);
plot(t,x);
xlabel('Time (s)'); ylabel('Magnitude');
title('Pure Sinusoid (No Noise)');
subplot(2,1,2);
plot(t,xn);
xlabel('Time (s)'); ylabel('Magnitude');
title('Sinusoid Buried in Noise');
figure(2);
subplot(2,1,1);
plot(f,20*log10(abs(fftshift(fft(x)))))
xlabel('Frequency'); ylabel('Magnitude (dB)');
xlim([-250,250]); ylim([0 60]);
title('DFT of Pure Sinusoid');
subplot(2,1,2);
plot(f,20*log10(abs(fftshift(fft(xn)))))
xlabel('Frequency'); ylabel('Magnitude (dB)');
xlim([-250,250]); ylim([0 60]);
title('DFT of Sinusoid Buried in Noise');