DOWNLOAD THE EXCEL FILE

How to Calculate Mean, Median & Mode Values in Excel

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.

⬇️ Download the workbook: https://bit.ly/3CE380Q In this video, I'll show you a simple trick to create a clickable Table of Contents that lets you instantly navigate between worksheets—no more searching, no more hassle! 🎓 Join 60,000+ professionals in our courses 👉 https://courses.mellontraining.com/ 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel #exceltips 6:54
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLi13Nks5d1QySVhn

How to Link Every Worksheet to a Master Sheet in Excel

Andreas Exadaktylos 71 minutes ago

⬇️ Download the workbook: https://bit.ly/40RwfqQ In this Excel Tutorial I'm going to show you how to create a professional and automated work schedule in Microsoft Excel! Whether you're a beginner just starting out or an experienced user looking to streamline your process, this video has something for you. Stick around until the end for some advanced formatting tricks that will take your schedule to the next level! 🎓 Join 60,000+ professionals in our courses 👉 https://courses.mellontraining.com/ ⌚ TIMESTAMPS 00:00 INTRODUCTION 00:34 SETTING UP THE CALENDAR 01:12 ADJUSTING COLUMN WIDTH 01:34 ADDING WEEKDAYS 01:55 EMPLOYEE NAMES AND MERGING CELLS 02:56 ADDING BORDERS 03:11 ENTERING WORK HOURS 03:56 AUTOMATING END TIME CALCULATION 04:44 COPYING WORK HOURS 05:01 ADDING DAYS OFF 05:53 FORMATTING FOR CLARITY 07:11 CALCULATING NUMBER OF EMPLOYEES PER DAY 08:13 CALCULATING TOTAL WORK HOURS 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel 12:48
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjJ3NkZfaFZadnlz

How to Create a Simple Work Schedule in Excel

Andreas Exadaktylos January 31, 2025 3:30 pm

Want to keep your Excel sheets clean and organized? In this quick tutorial, I’ll show you how to create dynamic borders that appear only when data is entered. No more unnecessary clutter—just a smarter way to format your spreadsheets! 🚀 💡 What You’ll Learn: ✅ How to use Conditional Formatting for borders ✅ The perfect formula to make borders dynamic ✅ A quick trick to instantly improve your Excel workflow! 📌 Don’t forget to Like & Subscribe for more Excel hacks! 🔥 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel #shorts 0:37
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlFLVUNlUkNYcnhV

How to Create Dynamic Borders in Excel #shorts #excel

Andreas Exadaktylos January 30, 2025 6:00 pm

⬇️ Download the workbook: https://bit.ly/3Eirj5k In today’s video, we’re diving into Advanced Conditional Formatting with Formula-Based Rules. Conditional formatting in Excel is a game-changer. It automatically applies colors, icons, or bold fonts to data based on specific conditions. While Excel offers built-in rules, formula-based conditional formatting takes customization to the next level. 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ ⌚ TIMESTAMPS 00:00 Introduction 00:37 Creating a Formula-Based Conditional Formatting Rule 01:33 1. Highlight Rows Based on a Condition 02:18 2. Highlight Duplicates Sales Entries 04:04 3. Color Every Other Row (Zebra Striping) 05:02 4. Highlight Past Dates 07:09 5. Highlight Top 10% Sales Values 08:46 6. Combining Multiple Conditions 09:42 Managing Conditional Formatting Rules 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel 11:10
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlJ5SjhvUzlGOHZV

Advanced Conditional Formatting in Excel using Formula-Based Rules

Andreas Exadaktylos January 24, 2025 3:00 pm

⬇️ Download the workbook: https://bit.ly/4hhzmgW In today’s video, we’re diving deep into one of the most effective tools for visualizing complex data in Excel—the Mekko Chart. This powerful chart is also known as a Marimekko Chart, and it helps you visualize the relationship between two categorical variables. Whether you're analyzing market share or comparing multiple segments across different categories, the Mekko Chart will give you a visual representation that's easy to interpret and incredibly insightful. A Mekko Chart, sometimes called a Marimekko Chart, is a type of stacked bar chart, but with variable-width bars. The width of each bar corresponds to the size or proportion of a specific segment, and the height of each segment reflects the value of that category. This makes it a powerful tool for analyzing both the size of categories and their relative contributions. The chart allows you to compare the percentage share of different segments within a specific category, making it particularly useful in market analysis, business segmentation, and even financial forecasting. The Mekko Chart is a visual powerhouse that combines the best aspects of both bar and pie charts, making it easier to spot trends and patterns in your data. 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ ⌚ TIMESTAMPS 00:00 Introduction 01:09 Preparing Your Data 01:54 Creating the Helper Table 06:52 Find the Midpoint values of each market 08:03 Add Label Marker and Label 10:11 Insert the Chart 12:35 Format Horizontal and Vertical Axes 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel #mekkochart 18:58
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnhHTFFELThXelFB

How to Make a Mekko (Marimekko) Chart in Excel

Andreas Exadaktylos January 17, 2025 4:01 pm

⬇️ Download the workbook: https://bit.ly/3Wl8BR0 Learn how to create a visually stunning progress chart in Excel in just a few minutes! This step-by-step tutorial guides you through building a dynamic donut chart to track task progress effectively. From calculating percentages to formatting slices, adding progress indicators, and customizing visuals, you'll master all the techniques to make your data shine. Perfect for project tracking or reporting! Don’t forget to like, share, and subscribe for more Excel tips. 🎉 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ ⌚ TIMESTAMPS 00:00 Introduction 00:27 Calculate the Percentage 00:52 Insert a Donut Chart 01:18 Format the Chart 03:45 Add progress indicators 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel 6:53
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjV3VlBZM1B2Nnhz

Track your Tasks in Excel effectively with Half Progress Doughnut Chart

Andreas Exadaktylos January 14, 2025 7:00 pm

⬇️ Download the workbook: https://bit.ly/4j0Mvgk In this video tutorial, I'm going to show you 4 different ways to insert or embed PDF file inside Microsoft Excel. 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel 6:30
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjJZc0RPclFuemJv

4 WAYS to Insert PDF into Excel

Andreas Exadaktylos January 3, 2025 7:00 pm

⬇️ Download the workbook: https://bit.ly/3ZKuYA4 Learn how to create a dynamic Excel dashboard using Power Pivot! In this tutorial, we’ll walk you through setting up data models, creating relationships, and building powerful visualizations to analyze your data like a pro. 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel #powerpivot 28:48
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjROZFpBZEVkTU84

Create an Excel Dashboard with Power Pivot (+ Free Dashboard Template)

Andreas Exadaktylos December 27, 2024 2:00 pm

⬇️ Download the workbook: https://bit.ly/3DpOhr0 Microsoft Excel is an important tool for data analysis. It helps companies accurately assess situations and make better business decisions. In this Excel Tutorial you will learn some of the foundational concepts, such as Mean, Median and Mode Values. 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel 7:08
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlk0QjFrcHBMV3hv

Calculate Median and Mode in Excel

Andreas Exadaktylos December 20, 2024 1:30 pm

This is the EASIEST step-by-step walkthrough of how to create a personal budget on Excel. 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel 20:42
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnBaaC1YaVNwUXVz

Step by Step on How to Make a Simple Budget on Excel

Andreas Exadaktylos December 17, 2024 5:22 pm

⬇️ Download the workbook: https://bit.ly/3DhCfQs When working with large datasets in Excel, you may often want to lock certain rows or columns so that you can view their contents while scrolling to another area of the worksheet. In this video, we fix that by freezing rows and columns in Excel using only two steps! 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel 5:14
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmc0VjVvTDQtR1Fz

Freeze MULTIPLE Rows and Columns in Excel

Andreas Exadaktylos December 14, 2024 7:39 am

⬇️ Download the file: https://bit.ly/3Zr9k3D In this video tutorial I’ll show you how to import a word document with data into an excel worksheet using the new excel 365 version but without opening power query editor or Get & Transform” tools. Microsoft quietly replaced the comfortable Text Import Wizard from Excel and replaced it with the “Get & Transform” tools. In this Excel Tutorial I will show you how you can easily restore the “Text Import Wizard” , enabling the secret option: LEGACY WIZARDS. 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel #exceltutorial 4:23
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLklqbkdOc1Q4VlJn

Convert Word Document into Excel 365 | Text Legacy SECRET OPTION

Andreas Exadaktylos December 10, 2024 9:58 am

⬇️ Grab the workbook I use in the video here: https://bit.ly/3ZDfnmW 👉 What You'll Learn: In this lesson we're going to learn how to find and calculate Simple and Compound interest rates in Excel. You are going to learn the two main types of Interest: 1) Simple Interest 2) Compound Interest Then we will learn how to calculate both interest rates using 2 ways and formulas in Excel. 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🔔 SUBSCRIBE if you'd like more tips and tutorials like this: https://bit.ly/3HHWQME 🔍 Key Moments in This Video: 00:00 Types of Interest 02:52 Simple Interest 05:40 Calculate Simple Interest in Excel 08:05 Compound Interest 11:00 Way 1 to Calculate Compound Interest in Excel 12:00 Way 2 to Calculate Compound Interest in Excel 12:52 Compound vs Simple Interest 14:45 Rule of 72 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you're short of time, please click the 👍 #excel #interestrates 16:47
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnVQV2t2UlJ3eFlv

THE EASY WAY to Calculate Compound Interest in Excel

Andreas Exadaktylos December 6, 2024 9:30 pm

⬇️ Download the workbook: https://bit.ly/3ZBqr44 Learn how to create stunning interactive map charts in Excel using geographic data! In this step-by-step tutorial, we’ll show you how to visualize data geographically, customize map styles, and make your charts dynamic and engaging. Perfect for business reports, data analysis, or presentations. No advanced Excel skills required! 👉 What you’ll learn: Setting up geographic data in Excel Creating and customizing map charts Adding interactivity for better insights 🎯 Don’t forget to like, subscribe, and comment below with your thoughts or questions! 🎓 Join 60,000+ professionals in our courses 👉 https://courses.mellontraining.com/ 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • 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 👍 #excel 4:02
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlQ2NFNGdEpiVi00

How to make Interactive Map Charts in Excel

Andreas Exadaktylos December 3, 2024 3:10 pm

👉 What You'll Learn: Python in Excel allows us to write Python code directly inside of an Excel workbook, leveraging the power of Python for data analysis and visualization without the hassle of moving our data between different sets of tools. In this video we are going to look at this exciting and powerful new feature of Excel! 🔍 Key Moments in This Video: 00:00 What is Python in Excel 365? 00:32 Install Python in Excel 01:30 Python buttons in Excel Ribbon 02:50 How to enable Python in an Excel cell? 03:50 Python Examples inside Excel 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🔔 SUBSCRIBE if you'd like more tips and tutorials like this: https://bit.ly/3HHWQME 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you're short of time, please click the 👍 🎓 BEST-SELLING COURSES 📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK 📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB 📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq 📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm 📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw 📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr 📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8 📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy 📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔽 CONNECT WITH ME • Official website: http://www.mellontraining.com • LinkedIn: https://gr.linkedin.com/in/andreasexadaktylos • Twitter: https://x.com/mellontraining • Facebook: https://www.facebook.com/mellontraining #excel #python 9:34
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmJCTFpzWnpLYW1Z

Automate Excel LIKE A PRO with Python | Python in Excel

Andreas Exadaktylos December 1, 2024 3:00 pm

⬇️ Grab the workbook I use in the video here: https://bit.ly/3CUpTgF In this step-by-step tutorial, learn how you can use Office Scripts in Microsoft Excel and how they can help you to Automate Tasks in Excel Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🎁 SPECIAL OFFER $9.99 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🔍 Key Moments in This Video: 00:00 What are Office Scripts? 00:28 How to Record Actions to create a Script 03:25 Test your Script 🔔 SUBSCRIBE if you'd like more tips and tutorials like this: https://bit.ly/3HHWQME 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you're short of time, please click the 👍 #excel #excelcharts 5:02
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLk1MZnNEalVFWUNJ

Automate Tasks in Excel with Office Scripts | NO VBA

Andreas Exadaktylos November 26, 2024 6:00 pm

⬇️ Grab the workbook I use in the video here: https://bit.ly/4eJbrW3 In this tutorial, you will learn how to create a stacked area chart in Excel. Stacked area charts are used to visualize how different categories contribute to a total over time. They are often used to track sales data, website traffic, or other data that changes over time. Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🎁 SPECIAL OFFER $9.99 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🔍 Key Moments in This Video: 00:00 What are Area Charts in Excel? 00:23 How to Create a Simple Area Chart? 00:45 How to Create a Stacked Area Chart? 02:15 How to Create a 100% Stacked Area Chart? 06:25 Choose the Right Colors for your Area Chart 🔔 SUBSCRIBE if you'd like more tips and tutorials like this: https://bit.ly/3HHWQME 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you're short of time, please click the 👍 #excel #excelcharts 10:30
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjdPSjBLekNueURF

Create the BEST Stacked Area Chart in Excel with Ease!

Andreas Exadaktylos November 24, 2024 10:00 am

In the world of spreadsheet software, Excel has long reigned as the go-to tool for crunching numbers and analyzing data. But what of you had a smart assistant helping you navigate Excel's vast capabilities, giving you expert advice and quick insights. That's the idea behind Copilot - the newest and most innovative feature of Excel. Copilot in Excel uses artificial intelligence (AI) to change the way we interact with spreadsheets. So, let’s start learning this amazing tool! ⬇️ Grab the workbook I use in the video here: https://bit.ly/3ZiEc7C Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🎁 SPECIAL OFFER $9.99 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🔍 Key Moments in This Video: 00:00 What is Copilot? 00:35 How Copilot help us in Excel? 01:30 How to access Copilot for Excel? 02:05 How to find Copilot in Excel Ribbon? 02:45 Prerequisites for using Excel Copilot 05:55 Use Copilot to Calculate Formulas 08:45 Use Copilot to Create Charts 🔔 SUBSCRIBE if you'd like more tips and tutorials like this: https://bit.ly/3HHWQME 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you're short of time, please click the 👍 #excel #copilot 11:44
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlpzT0RCMXBPbTF3

Using Copilot in Excel to Save You HOURS of Work⚒️

Andreas Exadaktylos November 22, 2024 8:00 pm

⬇️ Grab the workbook I use in the video here: https://bit.ly/3CBQTSg If your work involves reporting the actual and target data, you may find it useful to present the actual values versus the target values in a chart in Excel. For example, you can show the actual sales values versus the target sales values, or the satisfaction rating achieved versus the target rating. In this Excel Tutorial you will learn 2 Actual vs Target Charts: 1. The first chart that we'll create uses a contrast in the Actual and Target bars to show whether the target has been met or not. 2. The second chart uses marker lines to show the target value. The actual values are shown as columns bars. Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🎁 SPECIAL OFFER $9.99 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🔍 Key Moments in This Video: 00:00 Two (2) different Actual vs Target Charts 01:18 1st Actual vs Target Chart 03:18 2nd Actual vs Target Chart 🔔 SUBSCRIBE if you'd like more tips and tutorials like this: https://bit.ly/3HHWQME 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you're short of time, please click the 👍 #excel #excelcharts 5:57
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjFhajFNcXE0ZGI0

How to Create an Actual vs Target Chart in Excel

Andreas Exadaktylos November 19, 2024 8:00 pm

⬇️ Grab the workbook I use in the video here: https://bit.ly/4hTBgFK A frequency table is a very simple but very helpful tool when you're trying to get to know your data set. It allows you to put your data points into buckets. For example, with exam scores, it allows you to see how many students scored between 90 and a hundred, how many scored between 80 and 89, and so on and so forth. This table will then help us create a bar chart or histogram that represents the same distribution in graphical form. In this video, we'll focus on a few different ways you can create a frequency table in Excel. Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🎁 SPECIAL OFFER $9.99 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🔍 Key Moments in This Video: 00:00 Introduction 00:12 What is a Frequency Table? 00:58 Preparing the Data 02:25 Using FREQUENCY() Function 05:00 Using COUNTIFS() Function 🔔 SUBSCRIBE if you'd like more tips and tutorials like this: https://bit.ly/3HHWQME 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you're short of time, please click the 👍 #excel #excelfunctions 9:51
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkhHN0g1RFctXzln

How to Create a Frequency Distribution Table in Excel | FREQUENCY Function

Andreas Exadaktylos November 17, 2024 2:00 pm

⬇️ Grab the workbook I use in the video here: https://bit.ly/3YLHT4s Today, we’ll learn how to use Excel add-ins to enhance data visualization and engage the audience. These content add-ins are part of Microsoft Excel and can enhance what we're already looking at Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🔍 Key Moments in This Video: 00:00 What is Excel Add-ins? 00:22 Preparing your Data (Create a Pivot Table) 02:30 How to Create a Peaople Graph 06:00 3rd WAY: How to Create Bubbles Infographic 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 #excel #excelcharts 8:13
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlgyaWJZUGQ4cmFF

How to Make People Graph & Bubbles Chart with Excel Add-ins

Andreas Exadaktylos November 15, 2024 8:00 pm

⬇️ Grab the workbook I use in the video here: https://bit.ly/3YYQphy 👉 What You'll Learn: Today, we’ll learn 5 different ways to generate random numbers in Excel. Using these random number generators, you can actually create your own datasets 🔢. 1️⃣RAND() Function 2️⃣RANDBETWEEN() Function 3️⃣Combine RAND and RANDBETWEEN Formulas 4️⃣Using DATA ANALYSIS Button | Analysis Toolpak 5️⃣RANDARRAY() Function Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🔍 Key Moments in This Video: 00:00 Random Numbers Generator 00:20 1st WAY: RAND() Function 02:17 2nd WAY: RANDBETWEEN() Function 04:20 3rd WAY: Combine RAND and RANDBETWEEN Formulas 06:31 4th WAY: Using DATA ANALYSIS Button | Analysis Toolpak 09:04 5th WAY: RANDARRAY() Function 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 #excel #exceltips 11:28
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlhZRnZibnp3X3pV

5 WAYS to Generate Random Numbers in Excel 🔢

Andreas Exadaktylos November 12, 2024 4:00 pm

How to Create an Excel Animated Chart using VBA https://www.youtube.com/watch?v=QWV6_4mnC7Y 👉 What You'll Learn: Today, I'll introduce you to the Analyze Data feature, which really elevates the game. It delves deeper with AI to unearth trends, patterns, and insights within your data. We are going to learn how to use this AI feature to make your data analysis simpler, faster and more intuitive. ⬇️ Grab the workbook I use in the video here: https://bit.ly/4feHIpg Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔍 Key Moments in This Video: 00:00 Where is this Analyze Data button? 00:24 Differences between Analyze Data, Recommended Charts & Recommended Pivots 01:03 Analyzing your Source Data 02:31 Ask a question about your Data 03:52 Pitfalls of Analyze Data Feature 05:30 Reconfigure the Data using Power Query 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 #excel #dataanalysis 7:59
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLk1vTEtwd1JIVzhn

Analyze Data in Excel for AI Powered Insights

Andreas Exadaktylos November 10, 2024 2:00 pm

Make a Dynamic Column Chart in Excel | List Box https://www.youtube.com/watch?v=yqnLuTt5H9g 👉 What You'll Learn: In this Excel Video Tutorial, we're going to learn how to Create a Progress Doughnut Chart. A Progress Donut Chart displays the percentage completion towards a goal 🎯. We use these charts when we want to display the progress or the percentage completion of a single metric. So they're great for measuring goals and targets. ⬇️ Grab the workbook I use in the video here: https://bit.ly/3AASwic Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 🔍 Key Moments in This Video: 00:00 Why & When we use a Progress Doughnut Chart? 00:34 Preparing the Source Data of the Worksheet 01:30 Use this MAX Function PRO TIP! 02:23 Create a Donut Chart 03:20 Create the Percentage Completion of the Chart 05:25 Apply Conditional Formatting using IF & AND Formulas 13:03 Create Multiple Charts 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 #excel #excelcharts 13:26
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLm5HNGxlc3pqNDdv

Create a Progress Doughnut Chart in Excel

Andreas Exadaktylos November 7, 2024 6:00 pm

⬇️ Grab the workbook I use in the video here: https://bit.ly/3NUAVoC 👉 What You'll Learn: Today’s Video is about Animated Charts in Excel and how a simple VBA code can help us to achieve this kind of chart. If this sounds complicated to you, don’t worry, we will go step by step. We use VBA to control the animation. Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD Join 60,000+ professionals in our courses 👉 https://courses.mellontraining.com/ 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🔍 Key Moments in This Video: 00:00 How to Create an Excel Animated Chart using VBA 00:23 Preparing the Source Data of the Worksheet 00:48 Explanation of the IF Formula 02:15 The steps to Create the Chart 02:35 How to create a Clustered Column Chart 04:20 Write the VBA Code for the Animation 07:15 Final Steps 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 #excel #excelvba 8:35
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlFXVjZfNG1uQzdZ

How to Create an Excel Animated Chart using VBA

Andreas Exadaktylos November 4, 2024 3:13 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Today, we’ll learn how to create a column from an example. With this feature you can clean up your reports and make them informative and digestible. It’s one of my favorite features inside the Power Query editor. ⬇️ Grab the workbook I use in the video here: https://bit.ly/3Cic23r Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 #excel #powerquery 5:24
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkxBWnFsei1Kanpn

Clean up your Excel Reports using Power Query Column From Examples

Andreas Exadaktylos November 3, 2024 7:00 pm

Excel Pareto Chart https://www.youtube.com/watch?v=xRRs1gUnSF4 👉 What You'll Learn: Ever find yourself staring at a blank screen, unsure of how to visualize your data? This is where Recommended Charts can be a lifeline. It offers customized suggestions, helping you kickstart the visualization process. ⬇️ Grab the workbook I use in the video here: https://bit.ly/48wXZmL Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 #excel #excelcharts 3:33
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjBkMS1hQk1GTFR3

Excel Recommended Charts

Andreas Exadaktylos October 30, 2024 4:34 pm

⬇️ Grab the workbook I use in the video here: https://bit.ly/3NIrIiY 👉 What You'll Learn: Today, we’ll learn how to predict things like future sales, inventory requirements, or consumer trends using Excel forecast sheet. Excel offers several methods for creating forecasts, but Forecast Sheet stands out as the most powerful and user-friendly option. When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 #excel #excelcharts 5:12
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLk9GTXAzNWhxa1Nn

Create a Forecast Chart in Microsoft Excel 📈

Andreas Exadaktylos October 27, 2024 6:00 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Want to turn images that have table data into data that you can edit in Excel? With the Data from Picture feature, it's a snap. Today we’ll learn how to use the OCR, an AI powered technology that can scan images like the printout in our example, and convert them into editable digital data. ⬇️ Grab the workbook I use in the video here: https://bit.ly/3YBshkR Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 #excel #exceltips 4:53
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkpRbEFVNTMybzJj

Turn ANY Image into Editable Excel Data in SECONDS with AI Technology!

Andreas Exadaktylos October 25, 2024 2:57 pm

Excel Flash Fill Tutorial https://www.youtube.com/watch?v=CU059lBzdEU 👉 What You'll Learn: It's not uncommon in Excel that when you work with formulas, you often need to copy a formula down a column. Using copy and paste techniques is going to take forever. So what do we do? Double-click the lower right-hand corner. That's referred to as the fill handle. And as you drag over this, that thicker plus turns into a thin plus. Just double-click and there it is! We're all set. So, a real time saver, double-clicking to copy a formula down a cell. 🎁 Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎬 LINKS to other videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64 2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4 📊 Excel Your Skills: www.mellontraining.com 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 #excel #exceltricks 2:39
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLm4xS2xhWVgxTHNv

Excel Fill Handle Tricks | STOP Manually Copying Formulas in Excel

Andreas Exadaktylos October 17, 2024 3:01 pm

Load More... Subscribe
Mellon Training
Facebook-f Youtube

No matter your profession, stop wasting precious hours crunching numbers.

Get the Excel training that builds an unbeatable resume and warp drives your career.

QUICK LINKS