Search
Close this search box.

TUTORIALS

Our Videos

LATEST BLOGS & VIDEOS

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Learn the essential Excel formulas for working with rows and columns. This tutorial covers everything from counting and summing cells to finding maximum and minimum values. Whether you're new to Excel or want to improve your skills, this video will provide you with valuable insights. 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:52
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLklNQzJIYmhnZ0NB

The #1 Excel Rows and Columns Functions Technique You Need to Know!

Mellon Training October 13, 2024 1:52 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ In this 60min Video Tutorial you are going to create a Beautiful Interactive Excel Pivot Dashboard FROM SCRATCH! ⬇️ Grab the workbook I use in the video here: https://bit.ly/4dQ2jjq 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 #exceldashboard 52:13
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLm5jOWhJcElpdklR

How to Create an Excel Pivot Dashboard FROM SCRATCH (in 2024)

Mellon Training May 21, 2024 11:51 am

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video we are going to create from scratch a FULL Excel Dashboard in 1 Hour (FREE DASHBOARD TEMPLATE INCLUDED) ⬇️ Grab the workbook I use in the video here: https://bit.ly/3w3VUjE 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 🔍 Key Moments in This Video: 00:00 Introduction 01:44 Dashboard Data 08:40 Starting Calculations 22:40 Calculations Part 2 32:28 Final Calculations 43:15 Creating the Dashboard 🎓 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 #exceldashboard 1:9:33
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkFJdXNVS09seXhR

EXCEL Mastery in 1 Hour? I Put This Dashboard Building Method to the Test

Mellon Training April 28, 2024 4:58 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video we are going to learn how we can use Excel's map charts to compare values across different geo-spatial regions. ⬇️ Grab the workbook I use in the video here: https://bit.ly/3xMjgdV 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 🔍 Key Moments in This Video: 00:00 Introduction 00:22 Select the Data for the Geospatial Map Chart 01:50 Modify the Excel Map Chart 04:35 Change the colors of the Geospatial Map Chart 05:42 Add a Slicer to the Excel Map Chart 🎓 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 9:00
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnJYUFE0b0U2eHFv

Create a Geospatial Map Chart in Excel in Just 10 Minutes

Mellon Training April 22, 2024 12:00 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Suppose you have and Excel Worksheet with Blank Cells in some Columns.If you want to sort or filter the list, you need to fill blank cells in Excel with value from above. In this video I will show you two (2) different techniques using a number of shortcuts and tricks, to restore labels initially, so you can filter or short the list , and also to hide them when we want to print out the information. ⬇️ Grab the workbook I use in the video here: https://bit.ly/4agGcAp 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 5:37
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjBROEJydHRJRHQw

5-Minute Excel Hack to Fill Blank Cells with Value from Above Like a Pro!

Mellon Training April 8, 2024 12:00 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Sometimes in Excel, you'll want to take two or more cells and combine them together. Let's take a look at 3 Different Ways on How to Combine Cells in Excel. ⬇️ Grab the workbook I use in the video here: https://bit.ly/49hsZ96 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 🔍 Key Moments in This Video: 00:00 The & (ampersand) Method 02:55 The CONCATENATE() Function Method 04:10 The TEXTJOIN() Function Method 🎓 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 #exceltutorial #excelonlinecourse #mellontraining 6:35
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLklkbWZFVFdTZ2Z3

Combine Cells in Excel in JUST 5 Minutes a Day

Mellon Training March 31, 2024 1:00 pm

Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🎓 ALL MY COURSES 50% OFF!! 🎁 COUPON CODE 👉 50offyoutube 🔔 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 #excel #shorts 0:28
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlBKMG1vekVFaldF

How to Create a Heat Map in 2 STEPS #excel #tutorial

Mellon Training March 28, 2024 1:04 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video we are going to create the VLOOKUP formula to calculate each row's pay, and then use a PIVOT TABLE to calculate how much each person should get. ⬇️ Grab the workbook I use in the video here: https://bit.ly/4a6eEhd 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 🔍 Key Moments in This Video: 00:00 Combine VLOOKUP and PIVOT TABLES to Calculate Payments 00:48 Calculate Pay for each Person 01:18 Create a Table 01:50 Calculate VLOOKUP Formula 02:50 Calculate Final Payment 03:10 Create a Pivot Table 🎓 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 4:22
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLi1jSXlhdHNENFVV

You Won't Believe How Easy Calculating Payments in Excel Can Be

Mellon Training March 26, 2024 3:28 pm

Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 👉 What You'll Learn: The Repeat action command button in Excel allows you to apply the most recent action to a different cell or cells without the need to perform it manually each time. 🎓 ALL MY COURSES 50% OFF!! 🎁 COUPON CODE 👉 50offyoutube 🔔 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 #excel #shorts 0:56
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnM3MllCYzZESk9B

How to repeat the LAST ACTION in Excel with Shortcut or REPEAT Command Button

Mellon Training March 21, 2024 5:09 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video we are going to create TWO Combined Excel Drop-Down Lists using Data Validation and Excel INDIRECT Function ⬇️ Grab the workbook I use in the video here: https://bit.ly/48OmpXr 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 4:21
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkNmQUdabHBuTVpn

INDIRECT Function Secrets to MASTER Excel Drop-Down Lists!

Mellon Training March 12, 2024 3:06 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video tutorial, I’ll show you how to combine a custom number format and data validation to force users to enter the correct number of numeric digits. We will also learn how to combine data validation with functions, like AND() , ISNUMBER() , and LEN() ⬇️ Grab the workbook I use in the video here: https://bit.ly/3T1jW6h 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 🔍 Key Moments in This Video: 00:00 Introduction 00:43 How to determine requirements in Excel 01:35 How to apply a Custom Format in Excel 04:05 Add Data Validation with Functions 🎓 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 8:52
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlB0UlhVQ2M0bGpv

MASTER Consistent Phone Number Format in 30 Minutes with Excel Custom Format!

Mellon Training March 6, 2024 1:35 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video, I’ll show you Six (6) Ways Excel Flash Fill can make your work easier by automatically anticipating your fill needs. ⬇️ Grab the workbook I use in the video here: https://bit.ly/48A0weg 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 🔍 Key Moments in This Video: 00:00 6 WAYS To Save Time Using FLASH FILL In Microsoft Excel ⚡ 01:08 How does Flash Fill work? 02:25 How to use Flash Fill to extract text? 03:09 How to use Flash Fill to combine text? 03:53 How to use Flash Fill to change case? 04:40 How to use Flash Fill to extract numbers or text? 05:55 How to use Flash Fill to extract and add? 🎓 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 7:25
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkNVMDU5bEJ6ZEVV

6 WAYS To Save Time Using FLASH FILL In Microsoft Excel ⚡

Mellon Training February 28, 2024 5:30 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video, I’ll show you to first, generate a low and high value for each entity. Then, we’ll represent those values in a floating bar chart. Along the way you’ll learn about the MIN IFS and MAX IFS functions. ⬇️ Grab the workbook I use in the video here: https://bit.ly/3wsxFeC 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 🔍 Key Moments in This Video: 00:00 How To Create A FLOATING BAR CHART In Excel 02:00 Calculate the MINIFS and MAXIFS Functions 04:20 Create the Floating Bar Chart 🎓 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 8:36
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnJLSDFGRUJHYU9Z

CREATE A FLOATING BAR CHART In Excel Like a Pro In Just 5 Minutes!

Mellon Training February 23, 2024 2:41 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video, I’ll show you how to use YEARFRAC at the sheet level and then how to use Excel Power Query to Convert and Calculate a Birth Date to an Age. ⬇️ Grab the workbook I use in the video here: https://bit.ly/3UHr9Ld 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 🔍 Key Moments in This Video: 00:00 2 WAYS To Convert A Birth Date To An Age | Power Query & YEARFRAC() 01:10 How to Calculate Age using YEARFRAC Excel Function 02:30 How to Calculate Age using Microsoft Excel Power Query 🎓 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 #excelfunctions 5:40
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkdYM041Vm91ei04

Power Query Expert Reveals Fastest Way to Convert Birth Date to Age

Mellon Training February 20, 2024 1:27 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Improve your Excel skills with these 3 expert tricks for custom trend-based conditional formatting. From highlighting trends for an Excel Dashboard to using color scales, these techniques will take your spreadsheet game to the next level! 🔥Trend-Based Color Scale Excel Conditional Formatting 🔥Trend-Based Data Bars Excel Conditional Formatting ⬇️ Grab the workbook I use in the video here: https://bit.ly/49DOnpx 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 🔍 Key Moments in This Video: 00:00 How to create Custom Conditional Formatting in Excel 00:28 Trend-Based Color Scale Excel Conditional Formatting 02:35 Trend-Based Data Bars Excel Conditional Formatting 🎓 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 6:39
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjlBbmxrV0NITFc0

Master Trend-based Conditional Formatting in Excel in Just 24 Hours

Mellon Training February 15, 2024 4:09 pm

Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video, we're going to look at how we can create some very creative visualizations using pie charts and doughnut charts. We are not going to create basic pie and donut charts. As you will see, by the end of this video, we will make some really impressive pies and donuts that you can use into reports and dashboards and wow your boss! ⬇️ Grab the Project Files I use in the video here: https://bit.ly/3STcwmt 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 🔍 Key Moments in This Video: 00:00 How to Create Advanced Pies and Donut Charts in Excel 00:38 Create a Pie Chart 02:55 Create a Donut Chart 06:50 Create a Tracker Chart in Excel 🎓 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 11:53
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkRXMEJ0VVJua0lr

Stop Making Ugly Charts! Learn Advanced Pies and Doughnuts in Excel

Mellon Training February 10, 2024 5:51 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ Get the Full VBA Course for ONLY $9.99🎓https://bit.ly/4bmAWvX 👉 What You'll Learn: In this video tutorial, I'm going to show you how to implement the for next loops, and also something new to you guys, which is the for each, which has its place and it's also quite useful. 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎁 Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD 🔍 Key Moments in This Video: 00:00 How To Use The For Each & For Next Statement In Excel VBA 00:55 Using the FOR...NEXT Loop 06:40 Reset the Values using a VBA Subroutine 09:50 Using the FOR EACH... NEXT Loop 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🎬 LINKS to related 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 #vba 15:23
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjJmTzlRd3NOc0lZ

Master EXCEL VBA with For Each and For Next Statements!

Mellon Training February 5, 2024 5:07 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ Excel Dashboard & Data Analysis Masterclass COURSE for ONLY $9.99 📊https://bit.ly/3uiC2s6 👉 What You'll Learn: In this video tutorial, we're going to introduce and create Macros for making visualizations both interactive and automated. By the end of this video, you are going to build some fantastic interactive features for our visualizations and our worksheets ready to use for dashboards and graphs ⬇️ Grab the workbook I use in the video here: https://bit.ly/4bnE6iX 🎁 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 🔍 Key Moments in This Video: 00:00 How to Make an Interactive Map in Excel 00:36 What is a Macro? 00:55 Create a List with Data Validation 02:00 Create a New Formatting Rule with Conditional Formatting 03:30 Record a Macro 07:05 Edit Macros with VBA 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🎬 LINKS to related videos: 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 11:21
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLi1pMUxZenVYRjg4

MIND-BLOWING Excel Secrets To Create An INTERACTIVE MAP CHART In Minutes

Mellon Training February 1, 2024 4:00 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this Video Tutorial I’ll show you how to build a Line Panel Chart that shows two or more similar sets of data, side-by-side. ⬇️ Grab the workbook I use in the video here: https://bit.ly/49aSsBA 🎁 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 related videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 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 8:52
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLlVXd21hNjJnVXZj

Create a POWERFUL Excel PANEL CHART in Minutes!

Mellon Training January 28, 2024 3:00 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video, we'll show you how to easily add text to a number automatically in Excel using Custom Format Cells Options. ⬇️ Grab the workbook I use in the video here: https://bit.ly/3Um6trW 🎁 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 🔍 Key Moments in This Video: 00:00 Add Text To A Number In An Excel Worksheet 00:25 Using Custom Number Cells Dialog Box 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🎬 LINKS to other YouTube Videos: Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88 Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc 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 1:52
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnpXNzJPMTNpLVRB

Add Text to Numbers in Seconds with This Custom Format Hack!

Mellon Training January 26, 2024 6:00 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: If you're tired of manually summing up Excel tables, then you need to watch this video! Learn a simple function hack that will help you sum up Excel tables in just one step. 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🎁 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 🎬 LINKS to related 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 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 👍 6:56
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkVtYlNmRlMybjZj

Use this FUNCTION HACK to Sum Excel Tables in ONE STEP

Mellon Training January 22, 2024 4:51 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Learn how Excel's Goal Seek feature can save you time and help you reach your desired results quickly and efficiently. Say goodbye to manually adjusting your spreadsheets - with Goal Seek, you can supercharge your data analysis and decision making. Watch this video to learn more! 🎁 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 related 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 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 4:57
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkZaOXBMTnZ2ekZF

Supercharge Your Spreadsheets with Excel's Goal Seek Feature

Mellon Training January 19, 2024 5:00 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Learn how to use the Excel SUMPRODUCT function with criteria to simplify your data analysis! This tutorial will explain everything you need to know about using SUMPRODUCT in Excel, with examples and step-by-step instructions. Master this powerful tool and save time on your spreadsheets! 🎁 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 related 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 #sumproduct 11:40
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLkYwWURUSUtSbzY0

Why Excel SUMPRODUCT is About to Change Your Spreadsheets Forever

Mellon Training January 14, 2024 3:00 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Learn how to create eye-catching Excel bar and donut charts that highlight and note important events. In this video, we'll show you 2 different techniques to make your data visually stand out and convey meaningful insights. Take your charts to the next level with these tips! 🎁 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 related 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 #excelchartstutorial 8:22
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnVscHk0Qjdnel9n

MASTER Excel Bar and Donut Charts in 2024 with These 2 Simple Tricks!

Mellon Training January 10, 2024 3:25 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video we are going to make a Dynamic Column Chart in Excel using Form Controls List Box. 🎁 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 related 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 #exceltutorial 7:17
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnlxbkx1VHQ1SDln

The SECRET to Dynamic Column Charts in Excel

Mellon Training January 6, 2024 5:00 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this comprehensive video, we will guide you through the process of creating and utilizing Pareto charts in Microsoft Excel. Pareto charts are powerful tools that allow you to analyze and prioritize data, enabling you to focus on the most significant factors. Whether you're a business professional, data analyst, or student, understanding how to create and interpret Pareto charts will greatly enhance your data analysis skills. Throughout this tutorial, we will cover everything you need to know to become an Excel Pareto chart expert. 🎁 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 related 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 3:17
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnhSUnMxZ1VuU0Y0

Mastering Excel Pareto Charts: A Step-by-Step Tutorial

Mellon Training January 4, 2024 2:00 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Which lookup function to use for financial modeling in Excel: https://youtu.be/MkJ1gwKpBP8 In this video we are going to use Excel EOMONTH() & EDATE FUNCTIONS to create a timing flag, which is a technique that we use quite commonly in financial models. 🎁 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 related 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 #financialmodeling 5:04
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLmpRZU51aXJURFBN

Best Excel Formula for Forecasting Project Costs in 2024!

Mellon Training January 1, 2024 4:00 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Split a Column into smaller Columns with Power Query: https://youtu.be/4je6zQo5-r0 In this Excel Tutorial we are going to use DAX to Clean up and Modify the Text in the Tables that you have imported into your data model. Excel DAX offers a wide range of functions that you can apply to standardize and cleanse text in tables. 🎁 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 related 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 #DAX 4:32
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjQ5dXB3RXZSQnh3

4 Simple DAX Tweaks to Supercharge Your Text Modification

Mellon Training December 27, 2023 3:28 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: In this video we are going to Split a Column into smaller pieces across two or more Columns, using 2 GREAT Excel Power Query Features: 🚀 Splitting Column by a Delimiter 🚀 Splitting Columns by Number of Characters 🎁 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 🔍 Key Moments in This Video: 00:00 Introduction 00:30 Splitting Column by a Delimiter 02:40 Splitting Columns by Number of Characters 🎓 Join 60,000+ professionals in our courses here 👉 https://courses.mellontraining.com 🎬 LINKS to related 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 3:52
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLjRqZTZ6UW81LXIw

Excel Power Query EXPERT Shares Column Splitting Hack

Mellon Training December 24, 2023 4:27 pm

🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 👉 What You'll Learn: Create Form Control Buttons to Change Charts: https://youtu.be/SWg3RWRK7OE In this Excel Tutorial we are going to move a Vertical Data Entry Form to a different Worksheet and turn it into Horizontal Data Set, using Excel Macros & VBA. 🎁 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 related 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 #vba 8:21
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLndQcFhVeDNkQmtj

The Excel Pro's Guide to Faster Data Entry

Mellon Training December 22, 2023 4:46 pm

Load More... Subscribe