TUTORIALS

Our Videos

LATEST BLOGS & VIDEOS

⬇️ Download the workbook: https://bit.ly/4ikQrH6 Struggling to split text in Excel? Learn how to use the TEXTSPLIT function like a pro! In this video, I break down 8 easy and powerful ways to use Excel's TEXTSPLIT function to instantly separate words, clean up messy data, and boost your productivity. Whether you're splitting text across columns, rows, using multiple delimiters, or handling empty values and case sensitivity, this step-by-step tutorial has you covered. Even if you don’t have Excel 365, I share alternative methods that work like a charm. No more tedious manual editsβ€”just quick, clean data organization! πŸ’»βœ¨ Don't forget to LIKE, SUBSCRIBE, and drop a comment with the next Excel tip you want to see! πŸŽ“ 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 11:40
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkd6aE9remxOb3NZ

8 WAYS to use TEXTSPLIT Function: Separate Words in Excel EASILY!

Andreas Exadaktylos April 18, 2025 4:52 pm

πŸ”₯Take our 10-hour VBA & Macros Course: https://bit.ly/4bmAWvX ⬇️ Download the Complete Excel Form: https://bit.ly/4idzjTA Learn how to create a fully automated data entry form in Microsoft Excelβ€”perfect for collecting and organizing employee information with ease! This 4-step tutorial covers formatting, drop-downs, radio buttons, formulas, macros, and data protection. Boost your productivity with this practical Excel project! πŸŽ“ Join 70,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 #vba 18:56
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkVTTUtISXZGYmw4

How to Create a Fully Automated Data Entry Form in Excel (in 4 STEPS)

Andreas Exadaktylos April 10, 2025 4:00 pm

⬇️ Download the workbook: https://bit.ly/4hTqKNF Are you still using control F to search through massive Excel datasets? In this video, I’m going to show you a cool and efficient alternative that will not only make your life easier but also make your boss think you're an Excel wizard. We’re adding a dynamic search bar to an Excel worksheet that instantly filters and displays matching data. This step-by-step tutorial will help you add a sleek, functional search box to your worksheet that will impress your boss and boost your productivity. πŸ’Ό βœ… Great for large datasets βœ… Easy to follow βœ… No VBA required πŸŽ“ Join 70,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 #SearchBar #ExcelProductivity #ExcelTutorial #spreadsheethacks 6:56
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLllmLWVPRGV5REVj

How to Create a Search Bar in Excel: Find Anything in Seconds!

Andreas Exadaktylos March 28, 2025 4:58 pm

⬇️ Download the workbook: https://bit.ly/4hLLZB5 Tired of messy spreadsheets and repetitive data entry? In this video, I’ll walk you through how to create dependent dropdown lists in Excel β€” where one dropdown changes based on the selection in another! Whether you're tracking income and expenses, organizing categories, or just want to make your Excel sheets smarter and more dynamic, this tutorial has you covered. πŸ“‹ What You’ll Learn: πŸš€How to structure your data for dropdowns πŸš€Turning lists into Excel tables πŸš€Creating the primary dropdown (e.g. Income or Expenses) πŸš€Making the second dropdown update automatically πŸš€Using the INDIRECT function (don't worry, it’s easier than it sounds!) πŸš€How to easily update or expand your lists πŸ’‘ No complex formulas. No coding. Just easy, practical Excel magic! πŸŽ“ 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 #DropdownList #ExcelTutorial #ExcelTips #DataValidation #ExcelBeginner #Productivity 8:20
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlNHUEdZZWV5TXlZ

How to Create Multiple Dependent Drop-Down Lists in Excel (using INDIRECT Function)

Andreas Exadaktylos March 25, 2025 2:45 pm

⬇️ Download the workbook: https://bit.ly/43Uki5y In today's Excel tutorial, we'll create a dynamic, fully automated calendar that instantly updates as you select any month and year. No advanced formulas neededβ€”just clear, step-by-step guidance to help you build a useful, customizable calendar in minutes. Learn how to: βœ… Create interactive dropdown menus βœ… Format your calendar beautifully βœ… Use simple Excel functions to automate date entries βœ… Automatically highlight today's date and holidays πŸŽ“ 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 #DynamicCalendar #exceltutorial 18:10
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkpxem95enNnelBr

How to Create a Fully Dynamic Calendar in Excel: Holidays & Today's Date INCLUDED!

Andreas Exadaktylos March 19, 2025 3:32 pm

⬇️ Download the workbook: https://bit.ly/3Rehd8N Struggling with time calculations in Excel? In this tutorial, I'll show you how to add and subtract time, handle time formatting, and use the TIME function for precise calculations. Whether you're managing a payroll timesheet, tracking work hours, or scheduling tasks, this step-by-step guide will make Excel’s time functions easy to understand. πŸ“Œ What You’ll Learn: βœ” How Excel stores and formats time βœ” Adding and subtracting time correctly βœ” Fixing time calculations over 24 hours βœ” Using the TIME function to adjust time values βœ” Real-world payroll timesheet example πŸŽ“ 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 10:18
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjNzU0k4SVR2aHVz

How to Add or Subtract Time in Excel Like a Pro!

Andreas Exadaktylos March 14, 2025 2:30 pm

⬇️ Download the workbook: https://bit.ly/41LE3uz Have you ever wanted to create barcodes in Excel but weren’t sure where to start? Maybe you’re managing inventory, making product labels, or just curious about how barcodes work. Well, you’re in the right place! By the time we’re done, you’ll be able to generate barcodes that can be scanned with any barcode scanner, and it’s surprisingly easyβ€”no special software needed! In this tutorial, we’re going to break things down step by step: β€’ First, we’ll talk about how barcodes work in Excel. β€’ Then, we’ll format our data properly, so the barcode appears correctly. β€’ After that, we’ll write a simple formula to generate barcodes. β€’ Next, we’ll apply the correct font so that Excel turns our codes into barcodes. β€’ Finally, we’ll check how to install the barcode font if you don’t have it already. By the end, you’ll have everything you need to start creating barcodes in Excel easily and efficiently. No magic, no codingβ€”just Excel and a little know-how! ⬇️Download the Font: https://www.1001freefonts.com/idautomation.com-code-39-barcode-font-free-version.font πŸŽ“ 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:31
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmVuWVJfMHJlb0FB

The Easiest Way to Make Barcodes in Excel (No Extra Software Needed!)πŸ“¦

Andreas Exadaktylos March 7, 2025 3:28 pm

⬇️ Download the workbook: https://bit.ly/3ESwp8L Imagine saying goodbye to tedious data cleaning forever – and letting AI do the heavy lifting in Excel! Today, I’m going to show you how to use ChatGPT to supercharge your spreadsheet work. If you want to standardize data, generate dummy information, and even run complex analyses with just a few clicks, stick around! In this video, we’ll explore how you can use ChatGPT to clean up data, create formulas, and even analyze text. πŸŽ“ 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 #chatgpt 21:17
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlAxWnhTelpQTmxj

7 WAYS to use ChatGPT with Excel: How ChatGPT Automates Data Cleaning, Analysis & More

Andreas Exadaktylos February 28, 2025 1:43 pm

⬇️ Download the csv file: https://bit.ly/4kckXFf Have you ever wondered where all the McDonald's locations are around the world? What if I told you that you could map them allβ€”right inside Excel? Yeah, that’s right! Today, we’re diving into an awesome data visualization trick using Excel’s 3D Maps feature. You’ll be able to plot, customize, and explore thousands of McDonald's locations in just a few clicks! So, grab your fries, hit that like button, and let’s get mapping! πŸŽ“ 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 6:31
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmpRWUNHVzVPbE5v

How to 3D Map Geographic Data in ExcelπŸŸπŸ”

Andreas Exadaktylos February 25, 2025 3:18 pm

⬇️ Download the workbook: https://bit.ly/3Xe27Ut In today’s video, I'm going to show you how to create an eye-catching bar chart in Excelβ€”with a cool reference line that puts your data into context. We'll compare the average temperature of the top 20 world's major economic countries, also known as G20, for year 2022, and we will add a world average line that cuts across the chart. πŸŽ“ Join 70,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 8:40
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLm9WbW5STXNyOHFn

How To Create a Bar Chart with Reference Line in Excel

Andreas Exadaktylos February 21, 2025 3:01 pm

⬇️ Download the workbook: https://bit.ly/42XljcQ Struggling to visualize uncertainty or forecast trends in Excel? A fan chart is the perfect solution! In this video, I’ll show you a quick and easy way to create one from scratchβ€”no advanced skills needed! A fan chart or uncertainty chart is a way to display historical data and predict future values. For example, they are often used to indicate inflation or exchange rate predictions but can display any data with an uncertain future value. Say you are a financial analyst working for a multi-asset brokerage company. One of your tasks is to show how you expect stocks to evolve over the next five years. You've looked at the historical count and assessed three scenariosβ€”the base case, the best case, and the worst case. One way to present your analysis is through a Fan Chart, as shown here. So how can we create a fan chart in Excel? They look similar to line charts, but the future values fan out to represent possible future values. πŸŽ“ Join 60,000+ professionals in our courses for ONLY $9.99πŸ‘‰ https://www.udemy.com/user/andrewex/ πŸŽ“ 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 20:19
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlRfSzFsMFN2U3VB

How to Make an Excel Fan Chart: Visualize Uncertainty & Forecast Trends

Andreas Exadaktylos February 14, 2025 3:00 pm

If you're using the SUM function in Excel, STOP right nowβ€”you might be making a critical mistake! 🚨 Today, I’m going to show you why the SUBTOTAL function is far superior and how it can save you from costly errors. Whether you're an Excel beginner or an advanced user, this tip will change the way you work with data forever. So, stick around to see the difference in action! 🎯 Why Should You Stop Using SUM? Most Excel users rely on the SUM function to add up values. But what if I told you that in some cases, SUM gives you incorrect results? That’s rightβ€”when you're working with filtered data, SUM doesn't always show the right total! πŸŽ“ 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 #shorts 2:10
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLks3VkNOQWlUa3Zr

Stop using SUM in Excel: Switch to SUBTOTAL #excel

Andreas Exadaktylos February 8, 2025 3:00 pm

⬇️ 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! Here is the Formula that returns a list of all worksheet names in the workbook: =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"") This formula extracts the name of the active worksheet in an Excel workbook. Get workbook one is an Excel 4.0 macro function that gives the full reference of the active sheet. And this one finds the position of the closing bracket in the text. πŸŽ“ Join 60,000+ professionals in our courses for ONLY $9.99πŸ‘‰ https://www.udemy.com/user/andrewex/ πŸŽ“ 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 February 5, 2025 4:55 pm

⬇️ 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://www.udemy.com/user/andrewex/ ⌚ 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://www.udemy.com/user/andrewex/ ⌚ 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://www.udemy.com/user/andrewex/ ⌚ 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://www.udemy.com/user/andrewex/ ⌚ 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

Make a Progress Chart in Excel: 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://www.udemy.com/user/andrewex/ πŸŽ“ 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 πŸ‘‰ https://www.udemy.com/user/andrewex/ πŸŽ“ 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://www.udemy.com/user/andrewex/ πŸŽ“ 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 Mean, Median and Mode in Excel (for Data Analysis)

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://www.udemy.com/user/andrewex/ πŸŽ“ 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://www.udemy.com/user/andrewex/ πŸŽ“ 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://www.udemy.com/user/andrewex/ πŸŽ“ 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://www.udemy.com/user/andrewex/ πŸ”” 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

How to Calculate Compound Interest Rate 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://www.udemy.com/user/andrewex/ πŸŽ“ 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://www.udemy.com/user/andrewex/ πŸ”” 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://www.udemy.com/user/andrewex/ πŸ” 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 πŸŽ“ 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 πŸ”” 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://www.udemy.com/user/andrewex/ πŸŽ“ 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 πŸ” 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://www.udemy.com/user/andrewex/ πŸ” 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 πŸŽ“ 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 πŸ”” 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

Load More... Subscribe