How to Use Analyze Data in Excel (and Why It Sometimes Gets It Wrong)

Grab Your Free Workbook Now! 📥

Follow step-by-step and boost your learning.

It’s practical, easy, and totally free. Get started today!

🔔 SUBSCRIBE if you’d like more tips and tutorials like this

We respect your privacy. Unsubscribe at any time.

Want to clear out data without ruining your entire spreadsheet? In this quick tutorial, learn how to use the Go To Special feature in Excel to instantly select and delete multiple numbers at once, while keeping your text labels and formulas completely safe. Perfect for beginners looking to speed up their workflow!

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🎓 FREE Excel Course ▶️ https://bit.ly/mellonfree1
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

💻 OFFICIAL WEBSITE http://www.mellontraining.com

🎓 BEST-SELLING COURSES (Join 70,000+ Professionals):
📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash
📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax
📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm
📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi
📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba
📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts
📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips
📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth
📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm

My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/

👨‍🏫 About Me:
Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator.
For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery.
On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs.
📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace.
📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies.
📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place.

SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME

🔽 CONNECT WITH ME
• LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos
• Twitter: https://x.com/mellontraining
• Facebook: https://www.facebook.com/mellontraining

📊 Excel Your Skills: www.mellontraining.com

🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍

Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl

YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnhQQ2xsQlB3TUdV

Delete Thousands of Numbers Instantly in Excel! #excel #shorts

Andreas Exadaktylos May 23, 2026 18:09

⬇️ Download the COMPLETE TEMPLATE: https://mellontraining.com/fix-charts/
🎓 Go deeper: Excel Charts & Data Visualisation 👉 https://mellontraining.com/go/charts
Your Excel chart titles are silently lying to your audience — and you probably don't even notice it. In this video, I'll show you 2 methods to make chart titles that update AUTOMATICALLY, so your dashboards always tell the truth.

✅ What you'll learn:
→ How to link a chart title directly to a cell (Method 1 — beginner-friendly)
→ How to build a fully dynamic title using formulas that calculate growth %, year changes, and more (Method 2 — dashboard-level pro move)
→ The exact formula bar trick that most Excel users never discover
→ How to use the & operator and INT function to build clean, professional titles

This is the difference between a static report and a self-maintaining dashboard that impresses every time data changes.

⏱ TIMESTAMPS:
00:00 – Why your chart titles are outdated (and why it matters)
01:05 – Method 1: Link chart title to a static cell
01:45 – Method 2: Dynamic title with live formulas

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🎓 Excel Charts, Infographics & Data Visualisation
Master 50+ dynamic charts. Turn plain data into charts people understand.
👉 https://mellontraining.com/go/charts
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🎓 Free Excel course 👉 https://mellontraining.com/go/free

💬 Question about this one? Drop it in the comments — I read every single one.

👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've
helped people go from "what is Excel?" to real-world mastery — 70,000+
students and counting.

🔔 Subscribe: https://mellontraining.com/go/subscribe
🌐 Website: https://mellontraining.com
💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos
📘 Facebook: https://www.facebook.com/mellontraining

#Excel #ExcelCharts #ExcelDashboard #MicrosoftExcel #ExcelTutorial

YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjVhZDlDc1RFUEhV

Your Excel Charts Are Wrong | Here's Why & How to Fix It

Andreas Exadaktylos May 9, 2026 16:21

Need a better way to organize your project tasks? Meet the FILTER function. 🧠
In this Short, we build a dynamic Task Priority Organizer that sorts itself. No macros, no VBA, just one simple formula.

Breakdown:
1️⃣ Select your task list.
2️⃣ Lock your ranges with F4.
3️⃣ Match to your priority header.
4️⃣ Drag and done! 💥

Formula used in video: =FILTER($B$10:$B$34, $C$10:$C$34=B2, "None")

Subscribe for daily tips to level up your spreadsheet game! 💻

🌐 Official Website: http://www.mellontraining.com

🎓 BEST-SELLING COURSES (Join 70,000+ Professionals):
📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash
📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax
📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm
📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi
📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba
📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts
📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips
📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth
📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm

My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/

👨‍🏫 About Me:
Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator.
For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery.
On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs.
📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace.
📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies.
📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place.

SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME

🔽 CONNECT WITH ME
• LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos
• Twitter: https://x.com/mellontraining
• Facebook: https://www.facebook.com/mellontraining

📊 Excel Your Skills: www.mellontraining.com

🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍

Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl

#ExcelFilter #DataVisualization #OfficeHacks #Excel365 #TaskManagement

YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmFrWXVtNGJBZkxN

Master the Excel FILTER Function in 30 Seconds 📊 #Excel

Andreas Exadaktylos April 27, 2026 16:53

🎓 This is Lesson 1 of the full course 👉 https://mellontraining.com/go/finmodel

Most people have never actually done the maths on their own finances. In this
video I'll show you exactly how to build a personal budget in Excel from a
completely blank file. No templates, no downloads, no experience required.

By the end of 10 minutes you'll have a working spreadsheet that calculates your
taxes, totals your expenses, and tells you exactly where you stand —
automatically.

💡 WHAT YOU'LL LEARN
→ How to format numbers as currency, and the accounting format for statements
→ Cell referencing, and why you should never retype a number
→ The SUM function, and FORMULATEXT for auditing your own formulas
→ Merge & Center and Cell Styles for headers that look deliberate
→ Why Excel beats a calculator, paper or Word every single time

🎯 WHO THIS IS FOR
Total beginners, students, first-jobbers, anyone who's ever wondered where
their money actually goes — and anyone about to start a serious Excel path.

💻 WORKS ON PC AND MAC
Every formula and feature shown works identically on both.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🎓 Excel Financial Modeling & Business Analysis Masterclass
This video is Lesson 1. The full course is 155 lessons and 15.5 hours, and
inside it you'll build:

✅ A full 3-statement financial model (P&L, Cash Flow, Balance Sheet)
✅ A Discounted Cash Flow (DCF) valuation model
✅ A 13-week Cash Flow Forecast (milestone project)
✅ An interactive Financial KPI Dashboard
✅ Project Costing and Activity-Based Costing models

Plus a free bonus PDF: 200+ Excel shortcuts for PC and Mac.

👉 https://mellontraining.com/go/finmodel
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

⏱ TIMESTAMPS
0:00 The maths nobody actually does
0:33 Build the income section
2:10 Formulas: tax, cell referencing and net income
4:45 Expenses, SUM, and your net savings number
6:55 Make it presentable — then change one number

💬 Drop a comment with your net savings number — I read every one.

👨‍🏫 I'm Andreas, a Microsoft-certified Excel instructor. For 25 years I've
helped people go from "what is Excel?" to real-world mastery — 70,000+
students and counting.

🔔 Subscribe: https://mellontraining.com/go/subscribe
🌐 Website: https://mellontraining.com
💼 LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos
📘 Facebook: https://www.facebook.com/mellontraining

#Excel #ExcelTutorial #PersonalBudget #PersonalFinance #ExcelForBeginners

YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnVkejJfN0lMYV8w

Build a Budget in Excel in 10 Minutes — and See If You're Actually Broke

Andreas Exadaktylos April 19, 2026 16:13

The fastest way to clear your data without losing your hard work. 📈
If you manage monthly reports, you need the Constants shortcut. It identifies raw numbers and ignores your formulas, so you can wipe the sheet clean and start fresh instantly.

📊 Want to go deeper? My Excel Dashboard & Data Analysis Masterclass teaches you how to THINK like a Data Analyst — not just use shortcuts:
👉 https://bit.ly/mellondash

🌐 Official Website: http://www.mellontraining.com

🎓 BEST-SELLING COURSES (Join 70,000+ Professionals):
📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash
📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax
📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm
📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi
📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba
📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts
📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips
📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth
📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm

My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/

👨‍🏫 About Me:
Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator.
For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery.
On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs.
📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace.
📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies.
📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place.

SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME

🔽 CONNECT WITH ME
• LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos
• Twitter: https://x.com/mellontraining
• Facebook: https://www.facebook.com/mellontraining

📊 Excel Your Skills: www.mellontraining.com

🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍

Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl

#workhacks #corporate #exceltricks #dataanalyst #efficiency

YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjlGc0RGaVEyd1Nr

The Excel Button You’ve NEVER Used 🤫 #exceltips

Andreas Exadaktylos April 17, 2026 14:00

Stop scrolling through endless rows of data! 🛑 In this video, I show you how to create a professional, interactive Sales Tracker using a Scroll Bar and the OFFSET formula. Perfect for dashboards!

🌐 Official Website: http://www.mellontraining.com

🎓 BEST-SELLING COURSES (Join 70,000+ Professionals):
📖Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/mellondash
📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/mellondax
📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/mellonfm
📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/mellonbi
📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/mellonvba
📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/melloncharts
📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/mellontips
📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/mellonpyth
📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/mellongm

My UDEMY Courses ▶️ https://www.udemy.com/user/andrewex/

👨‍🏫 About Me:
Hi, I’m Andreas, a Microsoft Excel instructor and online learning creator.
For over 20 years I’ve been helping students go from “What is Excel?” to real-world mastery.
On this channel you’ll find Excel tutorials and step-by-step lessons taken from my Excel full course and Excel course beginner to advanced programs.
📚My lessons cover Excel for beginners and advance excel skills in one clear path, so you can grow at your own pace.
📚Think of these videos as your personal excel tutoring sessions: practical examples, clear explanations, and lots of excel ideas you can apply at work or in your studies.
📚If you’ve ever wondered how to use Excel to analyze data, build reports, or speed up your daily tasks with advanced Excel techniques, you’re in the right place.

SUBSCRIBE and join me on this journey—let’s unlock the full power of Microsoft Excel together! 🔔https://bit.ly/3HHWQME

🔽 CONNECT WITH ME
• LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos
• Twitter: https://x.com/mellontraining
• Facebook: https://www.facebook.com/mellontraining

📊 Excel Your Skills: www.mellontraining.com

🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍

Get vidIQ to grow your channel faster! 🚀 https://vidiq.com/AndreasExadaktyl

#excel #exceltips #microsoftexcel #productivity #excelhacks #dashboard #officetips #learnexcel

YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLk1zWkRFMndYX04w

STOP scrolling manually in Excel! 🛑

Andreas Exadaktylos April 3, 2026 17:04

Load More... Subscribe

Watch: Analyze Data in 8 minutes

Prefer reading? The same steps are written out below the video.

Step-by-step

Analyze Data is Excel’s AI assistant: it suggests charts and PivotTables and answers questions typed in plain English. The example uses a wholesale customers data set (Channel, Region and annual spending in Fresh, Milk, Grocery, Frozen, Detergents_Paper and Delicassen) and shows both a good answer and a wrong one, and how to fix the data so the answers are right.

1. Open Analyze Data

Click inside the table and go to Home > Analyze Data. A pane opens with suggested insights: PivotTables, bar charts, scatter plots, doughnuts and histograms.

2. Judge the suggestions

Not all of them make sense. One scatter plot treats region numbers as quantities on the X-axis. A better pick is the PivotChart of Delicassen by Channel and Region: click Insert PivotChart to add it to a new sheet.

3. Ask a question

In Ask a question about your data, type What are the total Grocery sales for Region 3? It answers correctly and you can click Insert PivotTable.

4. See where it goes wrong

Ask What are total sales by Region? and it returns Sum of Region, which is nonsense. The cause is the data layout: sales are spread across six columns, and there’s no single Sales column for Excel to add up.

5. Reshape the data with Power Query

Click inside the data and go to Data > From Table/Range. In Power Query, select the Channel column, hold Ctrl and select Region, then right-click and choose Unpivot Other Columns. Rename Attribute to Department and Value to Sales, then Close & Load.

6. Ask again

Click inside the new table, open Analyze Data and ask What are total sales by region? This time you get a proper Sales by Region chart. Good data structure in, good answers out.

Go further

My Excel Power Query, Power Pivot, DAX & Power 3D Map course shows how to shape any data so tools like this give the right answers.