2024-02-04T05:01:22.685Z
nova-2
2-general-nova
2024-01-09.29447
30089e05-99d1-4376-b32e-c263170674af
79e48d7d-8943-46a8-ae2e-3053ea2758c8
f9adbd2311e82d04a19763a254e191686c709cad873a4152f857a77fb74711ef
67875a7f-c9c4-48a0-aa55-5bdb8a91c34a
deprecated
It is August 23, 2023, and you're watching the Code Report.
Most developers will never admit it, but that game changing new app they're building probably could have just been an Excel spreadsheet.
Excel, which came out in 1985, could be the single most important piece of software for our modern service based economy.
Working with Excel formulas at my dead end white collar job is actually where I got my first taste of programming.
I used formulas to figure out that I would never be able to own a house unless I got a higher paying job, but you can't do real programming with Excel.
It is possible to hook it up with Visual Basic, but that's just way too Microsoft Apti.
Luckily, as of yesterday, Microsoft Excel will now support Python, a feature developed in collaboration with the creator of Python, Widov Van Rossum, which is totally awesome.
Here's how it'll In Excel, you have access to this new py formula, which can run Python code against the data in your spreadsheet.
Like, for example, if you want to your data into a Pandas data frame, you can now accomplish that by simply highlighting your data and running the corresponding Python code.
Another huge benefit is the ability to use Python data as packages, like seaborn and matplotlib.
More importantly though, it allows developers to write their own custom functions that can wrangle and clean real world datasets, which can be fed to the hungry AIs.
In fact, you could even do machine learning directly in your spreadsheet with tools like scikit learn.
That's pretty cool, but don't expect to train deep learning models with tools like PyTorch and TensorFlow, and that brings us to the one major caveat.
To industry transformation, The key to success is Your Python code does not run locally, but instead runs in Microsoft's Azure cloud.
This will, of course, keep you safe from the dangers of spreadsheets and also from the hell that is managing your Python versions locally.
They teamed up with Anaconda to create a standard run time for running Python and Excel in Azure.
However, being able to run Python locally offline, is far more privacy friendly and would be faster in most situations.
The only problem is that Microsoft then wouldn't have a product to sell you.
You could switch to Linux and run Libre our office, which has support for macros in both JavaScript and Python, and has had those features forever, but good luck convincing your boss that's a good idea.
It's just too free and to open source.
Python and Excel is going to be a game changer for the boring ass corporate world.
For the last few years, I've been using Google Sheets with Apps Script, which is one of the most under rated tools out there.
It's the same basic idea as Excel and Python, but with JavaScript.
I use it for a variety of business related needs, like it helps me automate the shipping of t shirts and stickers to Fireship Pro members, and it can even be used to create custom menus and dialogues.
However, Python is a far more powerful language when it comes to data analysis.
What that means as that virtually every white collar worker will now be able to go generate some Python code with ChatGPT, copy and paste it into Excel, and solve the vast majority of common problems out there.
Microsoft will be the one running and hosting this code.
They already have the most powerful AI models and those models will only grow bigger and stronger over time.
Nobody's even close to Microsoft right now in the AI race, and that's a result of their developer friendly strategy, which can be broken down in 3 steps.
1st, they embrace the developer community.
Developers, developers, Developers, developers, developers, developers.
Then extend developers with awesome new features and tools.
Then I seem to have forgotten what the third step is, but this has been in CodeReport, thanks for watching, and I will see you in the next one.

Speaker 0: It is August 23, 2023, and you're watching the Code Report. Most developers will never admit it, but that game changing new app they're building probably could have just been an Excel spreadsheet. Excel, which came out in 1985, could be the single most important piece of software for our modern service based economy. Working with Excel formulas at my dead end white collar job is actually where I got my first taste of programming. I used formulas to figure out that I would never be able to own a house unless I got a higher paying job, but you can't do real programming with Excel.

It is possible to hook it up with Visual Basic, but that's just way too Microsoft Apti. Luckily, as of yesterday, Microsoft Excel will now support Python, a feature developed in collaboration with the creator of Python, Widov Van Rossum, which is totally awesome. Here's how it'll In Excel, you have access to this new py formula, which can run Python code against the data in your spreadsheet. Like, for example, if you want to your data into a Pandas data frame, you can now accomplish that by simply highlighting your data and running the corresponding Python code. Another huge benefit is the ability to use Python data as packages, like seaborn and matplotlib.

More importantly though, it allows developers to write their own custom functions that can wrangle and clean real world datasets, which can be fed to the hungry AIs. In fact, you could even do machine learning directly in your spreadsheet with tools like scikit learn. That's pretty cool, but don't expect to train deep learning models with tools like PyTorch and TensorFlow, and that brings us to the one major caveat. To industry transformation, The key to success is Your Python code does not run locally, but instead runs in Microsoft's Azure cloud. This will, of course, keep you safe from the dangers of spreadsheets and also from the hell that is managing your Python versions locally.

They teamed up with Anaconda to create a standard run time for running Python and Excel in Azure. However, being able to run Python locally offline, is far more privacy friendly and would be faster in most situations. The only problem is that Microsoft then wouldn't have a product to sell you. You could switch to Linux and run Libre our office, which has support for macros in both JavaScript and Python, and has had those features forever, but good luck convincing your boss that's a good idea. It's just too free and to open source.

Python and Excel is going to be a game changer for the boring ass corporate world. For the last few years, I've been using Google Sheets with Apps Script, which is one of the most under rated tools out there. It's the same basic idea as Excel and Python, but with JavaScript. I use it for a variety of business related needs, like it helps me automate the shipping of t shirts and stickers to Fireship Pro members, and it can even be used to create custom menus and dialogues. However, Python is a far more powerful language when it comes to data analysis.

What that means as that virtually every white collar worker will now be able to go generate some Python code with ChatGPT, copy and paste it into Excel, and solve the vast majority of common problems out there. Microsoft will be the one running and hosting this code. They already have the most powerful AI models and those models will only grow bigger and stronger over time. Nobody's even close to Microsoft right now in the AI race, and that's a result of their developer friendly strategy, which can be broken down in 3 steps. 1st, they embrace the developer community.

Developers, developers, Developers, developers, developers, developers. Then extend developers with awesome new features and tools. Then I seem to have forgotten what the third step is, but this has been in CodeReport, thanks for watching, and I will see you in the next one.
It is August 23, 2023, and you're watching the Code Report. Most developers will never admit it, but that game changing new app they're building probably could have just been an Excel spreadsheet. Excel, which came out in 1985, could be the single most important piece of software for our modern service based economy.
software development
software
microsoft
video gaming
Working with Excel formulas at my dead end white collar job is actually where I got my first taste of programming. I used formulas to figure out that I would never be able to own a house unless I got a higher paying job, but you can't do real programming with Excel.
It is possible to hook it up with Visual Basic, but that's just way too Microsoft Apti. Luckily, as of yesterday, Microsoft Excel will now support Python, a feature developed in collaboration with the creator of Python, Widov Van Rossum, which is totally awesome. Here's how it'll In Excel, you have access to this new py formula, which can run Python code against the data in your spreadsheet. Like, for example, if you want to your data into a Pandas data frame, you can now accomplish that by simply highlighting your data and running the corresponding Python code. Another huge benefit is the ability to use Python data as packages, like seaborn and matplotlib. More importantly though, it allows developers to write their own custom functions that can wrangle and clean real world datasets, which can be fed to the hungry AIs. In fact, you could even do machine learning directly in your spreadsheet with tools like scikit learn. That's pretty cool, but don't expect to train deep learning models with tools like PyTorch and TensorFlow, and that brings us to the one major caveat. To industry transformation, The key to success is Your Python code does not run locally, but instead runs in Microsoft's Azure cloud. This will, of course, keep you safe from the dangers of spreadsheets and also from the hell that is managing your Python versions locally. They teamed up with Anaconda to create a standard run time for running Python and Excel in Azure. However, being able to run Python locally offline, is far more privacy friendly and would be faster in most situations. The only problem is that Microsoft then wouldn't have a product to sell you. You could switch to Linux and run Libre our office, which has support for macros in both JavaScript and Python, and has had those features forever, but good luck convincing your boss that's a good idea.
machine learning
deep learning
neural networks
artificial intelligence
microsoft
software development
data
software
It's just too free and to open source. Python and Excel is going to be a game changer for the boring ass corporate world. For the last few years, I've been using Google Sheets with Apps Script, which is one of the most under rated tools out there.
It's the same basic idea as Excel and Python, but with JavaScript. I use it for a variety of business related needs, like it helps me automate the shipping of t shirts and stickers to Fireship Pro members, and it can even be used to create custom menus and dialogues. However, Python is a far more powerful language when it comes to data analysis. What that means as that virtually every white collar worker will now be able to go generate some Python code with ChatGPT, copy and paste it into Excel, and solve the vast majority of common problems out there. Microsoft will be the one running and hosting this code. They already have the most powerful AI models and those models will only grow bigger and stronger over time. Nobody's even close to Microsoft right now in the AI race, and that's a result of their developer friendly strategy, which can be broken down in 3 steps. 1st, they embrace the developer community. Developers, developers, Developers, developers, developers, developers. Then extend developers with awesome new features and tools. Then I seem to have forgotten what the third step is, but this has been in CodeReport, thanks for watching, and I will see you in the next one.
microsoft
ibm
software development
computer science
software
computers
programming
business
It is August 23, 2023, and you're watching the Code Report. Most developers will never admit it, but that game changing new app they're building probably could have just been an Excel spreadsheet. Excel, which came out in 1985, could be the single most important piece of software for our modern service based economy. Working with Excel formulas at my dead end white collar job is actually where I got my first taste of programming. I used formulas to figure out that I would never be able to own a house unless I got a higher paying job, but you can't do real programming with Excel. It is possible to hook it up with Visual Basic, but that's just way too Microsoft Apti. Luckily, as of yesterday, Microsoft Excel will now support Python, a feature developed in collaboration with the creator of Python, Widov Van Rossum, which is totally awesome. Here's how it'll In Excel, you have access to this new py formula, which can run Python code against the data in your spreadsheet. Like, for example, if you want to your data into a Pandas data frame, you can now accomplish that by simply highlighting your data and running the corresponding Python code. Another huge benefit is the ability to use Python data as packages, like seaborn and matplotlib. More importantly though, it allows developers to write their own custom functions that can wrangle and clean real world datasets, which can be fed to the hungry AIs. In fact, you could even do machine learning directly in your spreadsheet with tools like scikit learn. That's pretty cool, but don't expect to train deep learning models with tools like PyTorch and TensorFlow, and that brings us to the one major caveat. To industry transformation, The key to success is Your Python code does not run locally, but instead runs in Microsoft's Azure cloud. This will, of course, keep you safe from the dangers of spreadsheets and also from the hell that is managing your Python versions locally. They teamed up with Anaconda to create a standard run time for running Python and Excel in Azure. However, being able to run Python locally offline, is far more privacy friendly and would be faster in most situations. The only problem is that Microsoft then wouldn't have a product to sell you. You could switch to Linux and run Libre our office, which has support for macros in both JavaScript and Python, and has had those features forever, but good luck convincing your boss that's a good idea. It's just too free and to open source. Python and Excel is going to be a game changer for the boring ass corporate world. For the last few years, I've been using Google Sheets with Apps Script, which is one of the most under rated tools out there. It's the same basic idea as Excel and Python, but with JavaScript. I use it for a variety of business related needs, like it helps me automate the shipping of t shirts and stickers to Fireship Pro members, and it can even be used to create custom menus and dialogues. However, Python is a far more powerful language when it comes to data analysis. What that means as that virtually every white collar worker will now be able to go generate some Python code with ChatGPT, copy and paste it into Excel, and solve the vast majority of common problems out there. Microsoft will be the one running and hosting this code. They already have the most powerful AI models and those models will only grow bigger and stronger over time. Nobody's even close to Microsoft right now in the AI race, and that's a result of their developer friendly strategy, which can be broken down in 3 steps. 1st, they embrace the developer community. Developers, developers, Developers, developers, developers, developers. Then extend developers with awesome new features and tools. Then I seem to have forgotten what the third step is, but this has been in CodeReport, thanks for watching, and I will see you in the next one.
It
it
is
is
August
august
23,
23
2023,
2023
and
and
you're
you're
watching
watching
the
the
Code
code
Report.
report
Most
most
developers
developers
will
will
never
never
admit
admit
it,
it
but
but
that
that
game
game
changing
changing
new
new
app
app
they're
they're
building
building
probably
probably
could
could
have
have
just
just
been
been
an
an
Excel
excel
spreadsheet.
spreadsheet
Excel,
excel
which
which
came
came
out
out
in
in
1985,
1985
could
could
be
be
the
the
single
single
most
most
important
important
piece
piece
of
of
software
software
for
for
our
our
modern
modern
service
service
based
based
economy.
economy
Working
working
with
with
Excel
excel
formulas
formulas
at
at
my
my
dead
dead
end
end
white
white
collar
collar
job
job
is
is
actually
actually
where
where
I
i
got
got
my
my
first
first
taste
taste
of
of
programming.
programming
I
i
used
used
formulas
formulas
to
to
figure
figure
out
out
that
that
I
i
would
would
never
never
be
be
able
able
to
to
own
own
a
a
house
house
unless
unless
I
i
got
got
a
a
higher
higher
paying
paying
job,
job
but
but
you
you
can't
can't
do
do
real
real
programming
programming
with
with
Excel.
excel
It
it
is
is
possible
possible
to
to
hook
hook
it
it
up
up
with
with
Visual
visual
Basic,
basic
but
but
that's
that's
just
just
way
way
too
too
Microsoft
microsoft
Apti.
apti
Luckily,
luckily
as
as
of
of
yesterday,
yesterday
Microsoft
microsoft
Excel
excel
will
will
now
now
support
support
Python,
python
a
a
feature
feature
developed
developed
in
in
collaboration
collaboration
with
with
the
the
creator
creator
of
of
Python,
python
Widov
widov
Van
van
Rossum,
rossum
which
which
is
is
totally
totally
awesome.
awesome
Here's
here's
how
how
it'll
it'll
In
in
Excel,
excel
you
you
have
have
access
access
to
to
this
this
new
new
py
py
formula,
formula
which
which
can
can
run
run
Python
python
code
code
against
against
the
the
data
data
in
in
your
your
spreadsheet.
spreadsheet
Like,
like
for
for
example,
example
if
if
you
you
want
want
to
to
your
your
data
data
into
into
a
a
Pandas
pandas
data
data
frame,
frame
you
you
can
can
now
now
accomplish
accomplish
that
that
by
by
simply
simply
highlighting
highlighting
your
your
data
data
and
and
running
running
the
the
corresponding
corresponding
Python
python
code.
code
Another
another
huge
huge
benefit
benefit
is
is
the
the
ability
ability
to
to
use
use
Python
python
data
data
as
as
packages,
packages
like
like
seaborn
seaborn
and
and
matplotlib.
matplotlib
More
more
importantly
importantly
though,
though
it
it
allows
allows
developers
developers
to
to
write
write
their
their
own
own
custom
custom
functions
functions
that
that
can
can
wrangle
wrangle
and
and
clean
clean
real
real
world
world
datasets,
datasets
which
which
can
can
be
be
fed
fed
to
to
the
the
hungry
hungry
AIs.
ais
In
in
fact,
fact
you
you
could
could
even
even
do
do
machine
machine
learning
learning
directly
directly
in
in
your
your
spreadsheet
spreadsheet
with
with
tools
tools
like
like
scikit
scikit
learn.
learn
That's
that's
pretty
pretty
cool,
cool
but
but
don't
don't
expect
expect
to
to
train
train
deep
deep
learning
learning
models
models
with
with
tools
tools
like
like
PyTorch
pytorch
and
and
TensorFlow,
tensorflow
and
and
that
that
brings
brings
us
us
to
to
the
the
one
one
major
major
caveat.
caveat
To
to
industry
industry
transformation,
transformation
The
the
key
key
to
to
success
success
is
is
Your
your
Python
python
code
code
does
does
not
not
run
run
locally,
locally
but
but
instead
instead
runs
runs
in
in
Microsoft's
microsoft's
Azure
azure
cloud.
cloud
This
this
will,
will
of
of
course,
course
keep
keep
you
you
safe
safe
from
from
the
the
dangers
dangers
of
of
spreadsheets
spreadsheets
and
and
also
also
from
from
the
the
hell
hell
that
that
is
is
managing
managing
your
your
Python
python
versions
versions
locally.
locally
They
they
teamed
teamed
up
up
with
with
Anaconda
anaconda
to
to
create
create
a
a
standard
standard
run
run
time
time
for
for
running
running
Python
python
and
and
Excel
excel
in
in
Azure.
azure
However,
however
being
being
able
able
to
to
run
run
Python
python
locally
locally
offline,
offline
is
is
far
far
more
more
privacy
privacy
friendly
friendly
and
and
would
would
be
be
faster
faster
in
in
most
most
situations.
situations
The
the
only
only
problem
problem
is
is
that
that
Microsoft
microsoft
then
then
wouldn't
wouldn't
have
have
a
a
product
product
to
to
sell
sell
you.
you
You
you
could
could
switch
switch
to
to
Linux
linux
and
and
run
run
Libre
libre
our
our
office,
office
which
which
has
has
support
support
for
for
macros
macros
in
in
both
both
JavaScript
javascript
and
and
Python,
python
and
and
has
has
had
had
those
those
features
features
forever,
forever
but
but
good
good
luck
luck
convincing
convincing
your
your
boss
boss
that's
that's
a
a
good
good
idea.
idea
It's
it's
just
just
too
too
free
free
and
and
to
to
open
open
source.
source
Python
python
and
and
Excel
excel
is
is
going
going
to
to
be
be
a
a
game
game
changer
changer
for
for
the
the
boring
boring
ass
ass
corporate
corporate
world.
world
For
for
the
the
last
last
few
few
years,
years
I've
i've
been
been
using
using
Google
google
Sheets
sheets
with
with
Apps
apps
Script,
script
which
which
is
is
one
one
of
of
the
the
most
most
under
under
rated
rated
tools
tools
out
out
there.
there
It's
it's
the
the
same
same
basic
basic
idea
idea
as
as
Excel
excel
and
and
Python,
python
but
but
with
with
JavaScript.
javascript
I
i
use
use
it
it
for
for
a
a
variety
variety
of
of
business
business
related
related
needs,
needs
like
like
it
it
helps
helps
me
me
automate
automate
the
the
shipping
shipping
of
of
t
t
shirts
shirts
and
and
stickers
stickers
to
to
Fireship
fireship
Pro
pro
members,
members
and
and
it
it
can
can
even
even
be
be
used
used
to
to
create
create
custom
custom
menus
menus
and
and
dialogues.
dialogues
However,
however
Python
python
is
is
a
a
far
far
more
more
powerful
powerful
language
language
when
when
it
it
comes
comes
to
to
data
data
analysis.
analysis
What
what
that
that
means
means
as
as
that
that
virtually
virtually
every
every
white
white
collar
collar
worker
worker
will
will
now
now
be
be
able
able
to
to
go
go
generate
generate
some
some
Python
python
code
code
with
with
ChatGPT,
chatgpt
copy
copy
and
and
paste
paste
it
it
into
into
Excel,
excel
and
and
solve
solve
the
the
vast
vast
majority
majority
of
of
common
common
problems
problems
out
out
there.
there
Microsoft
microsoft
will
will
be
be
the
the
one
one
running
running
and
and
hosting
hosting
this
this
code.
code
They
they
already
already
have
have
the
the
most
most
powerful
powerful
AI
ai
models
models
and
and
those
those
models
models
will
will
only
only
grow
grow
bigger
bigger
and
and
stronger
stronger
over
over
time.
time
Nobody's
nobody's
even
even
close
close
to
to
Microsoft
microsoft
right
right
now
now
in
in
the
the
AI
ai
race,
race
and
and
that's
that's
a
a
result
result
of
of
their
their
developer
developer
friendly
friendly
strategy,
strategy
which
which
can
can
be
be
broken
broken
down
down
in
in
3
3
steps.
steps
1st,
1st
they
they
embrace
embrace
the
the
developer
developer
community.
community
Developers,
developers
developers,
developers
Developers,
developers
developers,
developers
developers,
developers
developers.
developers
Then
then
extend
extend
developers
developers
with
with
awesome
awesome
new
new
features
features
and
and
tools.
tools
Then
then
I
i
seem
seem
to
to
have
have
forgotten
forgotten
what
what
the
the
third
third
step
step
is,
is
but
but
this
this
has
has
been
been
in
in
CodeReport,
codereport
thanks
thanks
for
for
watching,
watching
and
and
I
i
will
will
see
see
you
you
in
in
the
the
next
next
one.
one
success
The transcript discusses the benefits of using Python and Excel for coding, including the ability to use it locally and the potential for privacy concerns. The speakers also mention the importance of working with APIs and the potential for machine learning to be used in Python. They also discuss the benefits of working with developers and the potential for growth in AI models.
Microsoft Excel just got Python
Microsoft Excel just added support for Python, allowing developers to code and run custom functions directly inside a spreadsheet. Let's take a first look at how Python support will work in Excel. 

#python #ai #thecodereport 

💬 Chat with Me on Discord

https://discord.gg/fireship

🔗 Resources

Python Excel Announcement https://techcommunity.microsoft.com/t5/microsoft-365-blog/introducing-python-in-excel-the-best-of-both-worlds-for-data/ba-p/3905482
Anaconda Excel https://www.anaconda.com/excel
Python in 100 Seconds https://youtu.be/x7X9w_GIm1s

📚 Chapters

🔥 Get More Content - Upgrade to PRO

Upgrade at https://fireship.io/pro
Use code YT25 for 25% off PRO access 

🎨 My Editor Settings

- Atom One Dark 
- vscode-icons
- Fira Code Font

🔖 Topics Covered

- Run Python locally in Excel
- Python excel overview
- How to get access to Python in excel
- Alternatives to Excel
- Microsoft's AI business strategy