Search
Close this search box.

TUTORIALS

Our Videos

LATEST BLOGS & VIDEOS

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

How to Create an Actual vs Target Chart in Excel

Mellon Training November 19, 2024 8:00 pm

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

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

Mellon Training November 17, 2024 2:00 pm

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

How to Create Infographics with Excel Add-ins | People Graph & Bubbles

Mellon Training November 15, 2024 8:00 pm

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

5 WAYS to Generate Random Numbers in Excel 🔢

Mellon Training November 12, 2024 4:00 pm

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

Analyze Data in Excel for AI Powered Insights

Mellon Training November 10, 2024 2:00 pm

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

Create a Progress Doughnut Chart in Excel

Mellon Training November 7, 2024 6:00 pm

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

How to Create an Excel Animated Chart using VBA

Mellon Training November 4, 2024 3:13 pm

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

Clean up your Excel Reports using Power Query Column From Examples

Mellon Training November 3, 2024 7:00 pm

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

Excel Recommended Charts

Mellon Training October 30, 2024 4:34 pm

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

Create a Forecast Chart in Microsoft Excel 📈

Mellon Training October 27, 2024 6:00 pm

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

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

Mellon Training October 25, 2024 2:57 pm

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

Excel Fill Handle Tricks | STOP Manually Copying Formulas in Excel

Mellon Training October 17, 2024 3:01 pm

Excel CONCATENATE & TEXTJOIN Function https://www.youtube.com/watch?v=IdmfETWSgfw 👉 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 for ONLY $9.99👉 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

Excel ROWS & COLUMNS Function Tutorial

Mellon Training October 13, 2024 1:52 pm

Create an Excel Dashboard in SIMPLE STEPS https://www.youtube.com/watch?v=AIusUKOlyxQ In this Excel 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 for ONLY $9.99👉 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

Create an Excel Pivot Dashboard FROM SCRATCH (in 2024)

Mellon Training May 21, 2024 11:51 am

Create an Excel Pivot Dashboard FROM SCRATCH https://www.youtube.com/watch?v=nc9hIpIivIQ 👉 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 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔍 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 🎬 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

How to Create an Excel Dashboard in 5 Simple Steps

Mellon Training April 28, 2024 4:58 pm

Excel Tornado Chart | Two-Sided Bar Chart https://www.youtube.com/watch?v=NCNIMzyLa1Q 👉 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 🎓 Join 60,000+ professionals in our courses for ONLY $9.99👉 https://courses.mellontraining.com/ 🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME 🔍 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 🎬 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

6 QUICK Ways to Autofill Dates in Excel https://www.youtube.com/watch?v=oKXUj3eu24w 👉 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 and copy down data 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 for ONLY $9.99👉 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

How to Fill Blank Cells in Excel

Mellon Training April 8, 2024 12:00 pm

Two (2) Methods to Import Text Files in Excel 365 https://www.youtube.com/watch?v=xZyx3SwF55Q 👉 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 for ONLY $9.99👉 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

How to Combine Cells in Excel | Excel CONCATENATE & TEXTJOIN Function

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

Combine Excel INDEX & MATCH Functions https://www.youtube.com/watch?v=IYdwHa_-n8A 👉 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 for ONLY $9.99👉 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

Excel VLOOKUP to Calculate Payments

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

Create Excel Hyperlinks to Another Sheet FAST! https://www.youtube.com/watch?v=lRzep-tAqhY 👉 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 for ONLY $9.99👉 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

How to Create Dropdown Lists in Excel using INDIRECT Function

Mellon Training March 12, 2024 3:06 pm

Mastering the Top 10 Text Functions in Excel https://www.youtube.com/watch?v=oz_krI0zdto 👉 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 for ONLY $9.99👉 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

Excel Data Validation using AND, LEN & ISNUMBER Functions

Mellon Training March 6, 2024 1:35 pm

How to LOCK CELLS in Excel https://www.youtube.com/watch?v=KrMPKl0fciI 👉 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 for ONLY $9.99👉 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 use FLASH FILL In Excel ⚡

Mellon Training February 28, 2024 5:30 pm

Create a Milestone / Timeline Chart in Excel ⛳ https://www.youtube.com/watch?v=YifrFjPNGgw 👉 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 for ONLY $9.99👉 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 8:36
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLnJLSDFGRUJHYU9Z

Create a FLOATING BAR CHART In Excel

Mellon Training February 23, 2024 2:41 pm

Marge MANY Excel Workbooks to ONE with POWER QUERY https://www.youtube.com/watch?v=cRNWI9MAHWg 👉 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 for ONLY $9.99👉 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

Convert Birth Date to Age using Excel YEARFRAC Function & Power Query

Mellon Training February 20, 2024 1:27 pm

Color Tips and Layouts DESIGN TIPS for Excel Dashboards https://www.youtube.com/watch?v=XBIEfiBz9LI 👉 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 for ONLY $9.99👉 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

Trend-based Conditional Formatting in Excel | Color Scale & Data Bars

Mellon Training February 15, 2024 4:09 pm

How to Create an Excel Bullet Chart https://www.youtube.com/watch?v=n3UkHe04WmQ 👉 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 for ONLY $9.99👉 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

How to Create Advanced Pies and Doughnuts Charts in Excel

Mellon Training February 10, 2024 5:51 pm

CREATE CUSTOM VIEWS in Excel https://www.youtube.com/watch?v=4MMQ-cUaUak 👉 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 for ONLY $9.99👉 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

Excel VBA LOOPS | For Each & For Next Statements

Mellon Training February 5, 2024 5:07 pm

Create Excel Infographics | Tube Bar Chart https://www.youtube.com/watch?v=oYF49igjk9U 👉 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 🎓 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 🔔 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 🎬 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 #excelcharts #exceltutorial 11:21
YouTube Video VVV5S29fYUplZjQ4QnplZnp5ZDdqcnFnLi1pMUxZenVYRjg4

How to Create An Excel INTERACTIVE MAP CHART in 5 Steps🗺️

Mellon Training February 1, 2024 4:00 pm

Load More... Subscribe