Dave Langer
@daveondata.bsky.social
I help you build the skills
To unleash the power of AI
Technologies like Copilot in Excel
👇
https://daveondata.com/newsletter
To unleash the power of AI
Technologies like Copilot in Excel
👇
https://daveondata.com/newsletter
Pinned
Dave Langer
@daveondata.bsky.social
· Apr 28
Vibe Analytics with Copilot in Excel - Day 2
Copilot in Excel does an excellent job of using column names to understand the nature of your data.
So I decided to test Copilot in Excel using column names like:
Column1
Column2
Column3
Here's what happened...
Copilot in Excel does an excellent job of using column names to understand the nature of your data.
So I decided to test Copilot in Excel using column names like:
Column1
Column2
Column3
Here's what happened...
Vibe Analytics with Copilot in Excel - Day 2
Copilot in Excel does an excellent job of using column names to understand the nature of your data.
So I decided to test Copilot in Excel using column names like:
Column1
Column2
Column3
Here's what happened...
Copilot in Excel does an excellent job of using column names to understand the nature of your data.
So I decided to test Copilot in Excel using column names like:
Column1
Column2
Column3
Here's what happened...
April 28, 2025 at 4:57 PM
Vibe Analytics with Copilot in Excel - Day 2
Copilot in Excel does an excellent job of using column names to understand the nature of your data.
So I decided to test Copilot in Excel using column names like:
Column1
Column2
Column3
Here's what happened...
Copilot in Excel does an excellent job of using column names to understand the nature of your data.
So I decided to test Copilot in Excel using column names like:
Column1
Column2
Column3
Here's what happened...
Want to differentiate yourself at work with Excel skills?
Leaders aren't excited about this in 2025:
- Using PivotTables
- Knowing many functions
You know what they're excited about:
AI
And that means Copilot in Excel.
Here are 4 ways to build skills to impress your leaders:
Leaders aren't excited about this in 2025:
- Using PivotTables
- Knowing many functions
You know what they're excited about:
AI
And that means Copilot in Excel.
Here are 4 ways to build skills to impress your leaders:
April 27, 2025 at 4:43 PM
Want to differentiate yourself at work with Excel skills?
Leaders aren't excited about this in 2025:
- Using PivotTables
- Knowing many functions
You know what they're excited about:
AI
And that means Copilot in Excel.
Here are 4 ways to build skills to impress your leaders:
Leaders aren't excited about this in 2025:
- Using PivotTables
- Knowing many functions
You know what they're excited about:
AI
And that means Copilot in Excel.
Here are 4 ways to build skills to impress your leaders:
Want to predict customer churn?
Don't overcomplicate it.
Use logistic regression.
It's powerful, interpretable, and works great with real business data.
Start with Python in Excel.
Don't overcomplicate it.
Use logistic regression.
It's powerful, interpretable, and works great with real business data.
Start with Python in Excel.
April 26, 2025 at 11:48 PM
Want to predict customer churn?
Don't overcomplicate it.
Use logistic regression.
It's powerful, interpretable, and works great with real business data.
Start with Python in Excel.
Don't overcomplicate it.
Use logistic regression.
It's powerful, interpretable, and works great with real business data.
Start with Python in Excel.
Is your company rolling out Copilot in Excel?
Here's the mistake your executives are probably making:
To make the most out of AI in Microsoft Excel, you need to know 2 things:
1 - Python
2 - DIY data science
Copilot in Excel relies heavily on Python.
👇
Here's the mistake your executives are probably making:
To make the most out of AI in Microsoft Excel, you need to know 2 things:
1 - Python
2 - DIY data science
Copilot in Excel relies heavily on Python.
👇
April 26, 2025 at 3:56 PM
Is your company rolling out Copilot in Excel?
Here's the mistake your executives are probably making:
To make the most out of AI in Microsoft Excel, you need to know 2 things:
1 - Python
2 - DIY data science
Copilot in Excel relies heavily on Python.
👇
Here's the mistake your executives are probably making:
To make the most out of AI in Microsoft Excel, you need to know 2 things:
1 - Python
2 - DIY data science
Copilot in Excel relies heavily on Python.
👇
Excel → Power Query → Python → Machine Learning
That's the real progression for DIY data science.
You don't jump to neural networks.
You grow step by step.
From formulas to forecasts.
That's the real progression for DIY data science.
You don't jump to neural networks.
You grow step by step.
From formulas to forecasts.
April 25, 2025 at 9:10 PM
Excel → Power Query → Python → Machine Learning
That's the real progression for DIY data science.
You don't jump to neural networks.
You grow step by step.
From formulas to forecasts.
That's the real progression for DIY data science.
You don't jump to neural networks.
You grow step by step.
From formulas to forecasts.
8,587 professionals will receive a new machine learning tutorial tomorrow:
ML with Python in Excel.
It will be the first in a series of tutorials showing how Microsoft Excel is the platform for DIY data science.
Want in?
Click the link in my profile to get started.
ML with Python in Excel.
It will be the first in a series of tutorials showing how Microsoft Excel is the platform for DIY data science.
Want in?
Click the link in my profile to get started.
April 25, 2025 at 1:44 PM
8,587 professionals will receive a new machine learning tutorial tomorrow:
ML with Python in Excel.
It will be the first in a series of tutorials showing how Microsoft Excel is the platform for DIY data science.
Want in?
Click the link in my profile to get started.
ML with Python in Excel.
It will be the first in a series of tutorials showing how Microsoft Excel is the platform for DIY data science.
Want in?
Click the link in my profile to get started.
The Copilot AI inside Excel can write Python code for you.
That's the future Microsoft envisions.
Here's what Microsoft won't tell your executives.
If you can't prompt it well, you're playing with 🔥.
Learn enough Python to guide the AI...
And leave 99% of Excel users in your dust.
That's the future Microsoft envisions.
Here's what Microsoft won't tell your executives.
If you can't prompt it well, you're playing with 🔥.
Learn enough Python to guide the AI...
And leave 99% of Excel users in your dust.
April 24, 2025 at 9:31 PM
The Copilot AI inside Excel can write Python code for you.
That's the future Microsoft envisions.
Here's what Microsoft won't tell your executives.
If you can't prompt it well, you're playing with 🔥.
Learn enough Python to guide the AI...
And leave 99% of Excel users in your dust.
That's the future Microsoft envisions.
Here's what Microsoft won't tell your executives.
If you can't prompt it well, you're playing with 🔥.
Learn enough Python to guide the AI...
And leave 99% of Excel users in your dust.
Want to join the top 1% of Excel users in the age of AI?
Here’s the biggest mistake you can make in 2025:
Ignoring Python in Excel.
Here's why:
Here’s the biggest mistake you can make in 2025:
Ignoring Python in Excel.
Here's why:
April 24, 2025 at 2:18 PM
Want to join the top 1% of Excel users in the age of AI?
Here’s the biggest mistake you can make in 2025:
Ignoring Python in Excel.
Here's why:
Here’s the biggest mistake you can make in 2025:
Ignoring Python in Excel.
Here's why:
Need to join 3 tables?
Formulas = pain
SQL = elegant
Learn JOIN, GROUP BY, CASE WHEN
Drop the SQL into Power Query.
Your Excel workflow will never be the same.
Formulas = pain
SQL = elegant
Learn JOIN, GROUP BY, CASE WHEN
Drop the SQL into Power Query.
Your Excel workflow will never be the same.
April 23, 2025 at 10:33 PM
Need to join 3 tables?
Formulas = pain
SQL = elegant
Learn JOIN, GROUP BY, CASE WHEN
Drop the SQL into Power Query.
Your Excel workflow will never be the same.
Formulas = pain
SQL = elegant
Learn JOIN, GROUP BY, CASE WHEN
Drop the SQL into Power Query.
Your Excel workflow will never be the same.
In 2025, Microsoft Excel power users will be using Python in Excel.
Here are 5 reasons why (with business scenarios):
Here are 5 reasons why (with business scenarios):
April 23, 2025 at 1:48 PM
In 2025, Microsoft Excel power users will be using Python in Excel.
Here are 5 reasons why (with business scenarios):
Here are 5 reasons why (with business scenarios):
Your PivotTable won't find customer segments.
Cluster analysis will.
Tools like k-means help you group customers by many behaviors.
So many behaviors it makes PivotTables cry.
Try it with Python in Excel.
It's like discovering new tribes in your data.
Cluster analysis will.
Tools like k-means help you group customers by many behaviors.
So many behaviors it makes PivotTables cry.
Try it with Python in Excel.
It's like discovering new tribes in your data.
April 22, 2025 at 10:56 PM
Your PivotTable won't find customer segments.
Cluster analysis will.
Tools like k-means help you group customers by many behaviors.
So many behaviors it makes PivotTables cry.
Try it with Python in Excel.
It's like discovering new tribes in your data.
Cluster analysis will.
Tools like k-means help you group customers by many behaviors.
So many behaviors it makes PivotTables cry.
Try it with Python in Excel.
It's like discovering new tribes in your data.
Most Excel users don’t realize it yet...
But Python in Excel is the biggest upgrade to the tool in 30+ years.
Here’s why it changes everything for people who live in spreadsheets:
But Python in Excel is the biggest upgrade to the tool in 30+ years.
Here’s why it changes everything for people who live in spreadsheets:
April 22, 2025 at 2:16 PM
Most Excel users don’t realize it yet...
But Python in Excel is the biggest upgrade to the tool in 30+ years.
Here’s why it changes everything for people who live in spreadsheets:
But Python in Excel is the biggest upgrade to the tool in 30+ years.
Here’s why it changes everything for people who live in spreadsheets:
Reporting tells you what happened.
Analysis tells you why.
Prediction tells you what's next.
Most professionals stop at the first one.
Want more impact?
Learn the other two.
Analysis tells you why.
Prediction tells you what's next.
Most professionals stop at the first one.
Want more impact?
Learn the other two.
April 21, 2025 at 11:14 PM
Reporting tells you what happened.
Analysis tells you why.
Prediction tells you what's next.
Most professionals stop at the first one.
Want more impact?
Learn the other two.
Analysis tells you why.
Prediction tells you what's next.
Most professionals stop at the first one.
Want more impact?
Learn the other two.
Most Excel pros ignore the most powerful tool in the app.
It’s not formulas.
It’s not macros.
It’s Power Query.
Here’s why Power Query is your secret weapon for doing real analytics in Excel:
It’s not formulas.
It’s not macros.
It’s Power Query.
Here’s why Power Query is your secret weapon for doing real analytics in Excel:
April 21, 2025 at 1:48 PM
Most Excel pros ignore the most powerful tool in the app.
It’s not formulas.
It’s not macros.
It’s Power Query.
Here’s why Power Query is your secret weapon for doing real analytics in Excel:
It’s not formulas.
It’s not macros.
It’s Power Query.
Here’s why Power Query is your secret weapon for doing real analytics in Excel:
Excel formulas are great.
But SQL lets you:
- Query millions of rows
- Filter like a data whisperer
- Prep data BEFORE it hits Excel
SQL + Excel == next-level spreadsheets.
And now with Python in Excel?
It's a must-learn.
But SQL lets you:
- Query millions of rows
- Filter like a data whisperer
- Prep data BEFORE it hits Excel
SQL + Excel == next-level spreadsheets.
And now with Python in Excel?
It's a must-learn.
April 20, 2025 at 11:45 PM
Excel formulas are great.
But SQL lets you:
- Query millions of rows
- Filter like a data whisperer
- Prep data BEFORE it hits Excel
SQL + Excel == next-level spreadsheets.
And now with Python in Excel?
It's a must-learn.
But SQL lets you:
- Query millions of rows
- Filter like a data whisperer
- Prep data BEFORE it hits Excel
SQL + Excel == next-level spreadsheets.
And now with Python in Excel?
It's a must-learn.
Most ML advice is built for future data scientists.
But what if you just want to solve real business problems?
Here’s the 5-step path I teach working professionals:
But what if you just want to solve real business problems?
Here’s the 5-step path I teach working professionals:
April 20, 2025 at 3:03 PM
Most ML advice is built for future data scientists.
But what if you just want to solve real business problems?
Here’s the 5-step path I teach working professionals:
But what if you just want to solve real business problems?
Here’s the 5-step path I teach working professionals:
Most real-world machine learning isn't Gen AI or neural nets.
It’s this:
- Profile your data
- Engineer useful features
- Use decision trees
ML isn’t magic.
It’s just pattern-finding + good inputs.
Start with intuition.
Scale with trees.
It’s this:
- Profile your data
- Engineer useful features
- Use decision trees
ML isn’t magic.
It’s just pattern-finding + good inputs.
Start with intuition.
Scale with trees.
April 19, 2025 at 10:07 PM
Most real-world machine learning isn't Gen AI or neural nets.
It’s this:
- Profile your data
- Engineer useful features
- Use decision trees
ML isn’t magic.
It’s just pattern-finding + good inputs.
Start with intuition.
Scale with trees.
It’s this:
- Profile your data
- Engineer useful features
- Use decision trees
ML isn’t magic.
It’s just pattern-finding + good inputs.
Start with intuition.
Scale with trees.
Excel isn’t just formulas anymore.
It’s a full-blown data stack.
But most users are stuck in 2007.
Here’s how you become a modern Excel power user in 2025:
It’s a full-blown data stack.
But most users are stuck in 2007.
Here’s how you become a modern Excel power user in 2025:
April 19, 2025 at 4:31 PM
Excel isn’t just formulas anymore.
It’s a full-blown data stack.
But most users are stuck in 2007.
Here’s how you become a modern Excel power user in 2025:
It’s a full-blown data stack.
But most users are stuck in 2007.
Here’s how you become a modern Excel power user in 2025:
I've been using SQL for 25 years.
I've been doing analytics for 13 years.
Here are 6 hard-won lessons I've learned when using SQL for DIY data science:
I've been doing analytics for 13 years.
Here are 6 hard-won lessons I've learned when using SQL for DIY data science:
April 18, 2025 at 4:17 PM
I've been using SQL for 25 years.
I've been doing analytics for 13 years.
Here are 6 hard-won lessons I've learned when using SQL for DIY data science:
I've been doing analytics for 13 years.
Here are 6 hard-won lessons I've learned when using SQL for DIY data science:
Microsoft Excel → Python
PivotTable to count items by category?
In Python:
table.groupby('category').size()
Boom!
Instant PivotTable in one line.
PivotTable to count items by category?
In Python:
table.groupby('category').size()
Boom!
Instant PivotTable in one line.
April 17, 2025 at 10:17 PM
Microsoft Excel → Python
PivotTable to count items by category?
In Python:
table.groupby('category').size()
Boom!
Instant PivotTable in one line.
PivotTable to count items by category?
In Python:
table.groupby('category').size()
Boom!
Instant PivotTable in one line.
Don't focus so much on the "Python" aspect of Python in Excel.
A better way to look at it is this:
Microsoft Excel is now the ultimate choose-your-own-adventure analytics tool.
Building data analysis skills with Excel is like visiting various stops on a wandering journey...
A better way to look at it is this:
Microsoft Excel is now the ultimate choose-your-own-adventure analytics tool.
Building data analysis skills with Excel is like visiting various stops on a wandering journey...
April 17, 2025 at 2:36 PM
Don't focus so much on the "Python" aspect of Python in Excel.
A better way to look at it is this:
Microsoft Excel is now the ultimate choose-your-own-adventure analytics tool.
Building data analysis skills with Excel is like visiting various stops on a wandering journey...
A better way to look at it is this:
Microsoft Excel is now the ultimate choose-your-own-adventure analytics tool.
Building data analysis skills with Excel is like visiting various stops on a wandering journey...
Microsoft Excel → SQL
Need to remove duplicates in Excel?
You'd use Data -> Remove Duplicates.
In SQL:
SELECT DISTINCT customer_id
FROM transactions
DISTINCT shows you unique values.
No clicks needed.
**AND**
You've automated it for reproducibility.
Need to remove duplicates in Excel?
You'd use Data -> Remove Duplicates.
In SQL:
SELECT DISTINCT customer_id
FROM transactions
DISTINCT shows you unique values.
No clicks needed.
**AND**
You've automated it for reproducibility.
April 16, 2025 at 10:10 PM
Microsoft Excel → SQL
Need to remove duplicates in Excel?
You'd use Data -> Remove Duplicates.
In SQL:
SELECT DISTINCT customer_id
FROM transactions
DISTINCT shows you unique values.
No clicks needed.
**AND**
You've automated it for reproducibility.
Need to remove duplicates in Excel?
You'd use Data -> Remove Duplicates.
In SQL:
SELECT DISTINCT customer_id
FROM transactions
DISTINCT shows you unique values.
No clicks needed.
**AND**
You've automated it for reproducibility.
With the release of Python in Excel, there's more reason than ever to learn Power Query.
While you can wrangle data using Python formulas, here are good reasons to prefer Power Query to Python.
If you're a "Pythonista," this opening might anger you.
Please read on before 🔥 me...
While you can wrangle data using Python formulas, here are good reasons to prefer Power Query to Python.
If you're a "Pythonista," this opening might anger you.
Please read on before 🔥 me...
April 16, 2025 at 3:20 PM
With the release of Python in Excel, there's more reason than ever to learn Power Query.
While you can wrangle data using Python formulas, here are good reasons to prefer Power Query to Python.
If you're a "Pythonista," this opening might anger you.
Please read on before 🔥 me...
While you can wrangle data using Python formulas, here are good reasons to prefer Power Query to Python.
If you're a "Pythonista," this opening might anger you.
Please read on before 🔥 me...
With Python and Copilot in Excel, learning SQL is more valuable than ever for Microsoft Excel users.
Here's the "why" in two words:
Power
Flexibility
First, let's talk about Python in Excel.
Here's the "why" in two words:
Power
Flexibility
First, let's talk about Python in Excel.
April 15, 2025 at 2:27 PM
With Python and Copilot in Excel, learning SQL is more valuable than ever for Microsoft Excel users.
Here's the "why" in two words:
Power
Flexibility
First, let's talk about Python in Excel.
Here's the "why" in two words:
Power
Flexibility
First, let's talk about Python in Excel.
Microsoft Excel → Python
Need a new "level" column on a table with logic like:
=IF(C2 > 1000, "High", "Low")
In Python:
table['level'] = np.where(table['sales'] > 1000, 'High', 'Low')
Your Excel knowledge can unlock the power of Python.
Need a new "level" column on a table with logic like:
=IF(C2 > 1000, "High", "Low")
In Python:
table['level'] = np.where(table['sales'] > 1000, 'High', 'Low')
Your Excel knowledge can unlock the power of Python.
April 15, 2025 at 12:02 AM
Microsoft Excel → Python
Need a new "level" column on a table with logic like:
=IF(C2 > 1000, "High", "Low")
In Python:
table['level'] = np.where(table['sales'] > 1000, 'High', 'Low')
Your Excel knowledge can unlock the power of Python.
Need a new "level" column on a table with logic like:
=IF(C2 > 1000, "High", "Low")
In Python:
table['level'] = np.where(table['sales'] > 1000, 'High', 'Low')
Your Excel knowledge can unlock the power of Python.