![Melissa Compton](/img/default-banner.jpg)
- 153
- 1 013 051
Melissa Compton
United States
Приєднався 21 гру 2020
Hello! I'm so excited you're here!
I'm here to help you be more efficient and productive with "how to" and productivity tutorials for all things Microsoft!
New tutorials uploaded Tuesday and Thursday!
My background: 25+ years experience in Business Analysis | Project Management | Software Testing | Lean Six Sigma Methodology and Business Management. I'm a Certified Lean Six Sigma Black Belt and Yoast SEO Master Certified.
Please subscribe to my channel, give a thumbs up to the videos you like and share the ones you love! Also, please leave a comment with feedback or suggestion for a future tutorials.
I love learning and growing and I'm grateful I get to do it with you! So, lets put on our thinking caps and get to learning!!!
I'm here to help you be more efficient and productive with "how to" and productivity tutorials for all things Microsoft!
New tutorials uploaded Tuesday and Thursday!
My background: 25+ years experience in Business Analysis | Project Management | Software Testing | Lean Six Sigma Methodology and Business Management. I'm a Certified Lean Six Sigma Black Belt and Yoast SEO Master Certified.
Please subscribe to my channel, give a thumbs up to the videos you like and share the ones you love! Also, please leave a comment with feedback or suggestion for a future tutorials.
I love learning and growing and I'm grateful I get to do it with you! So, lets put on our thinking caps and get to learning!!!
How to Find Unknown Data Needed to Make Goals in Excel - Goal Seek
Struggling to find the unknown data you need to achieve your goals in your business? In this tutorial, I'll walk you through the process of using Goal Seek in Excel to identify and calculate the missing data necessary for setting and reaching your objectives. Whether you're working on a financial plan, a sales target, data analysis, or any project that requires goal tracking, this Microsoft Excel tutorial has got you covered!
📺RELATED VIDEOS
Checkboxes - ua-cam.com/video/fk1QF60_Yxs/v-deo.html
Link Excel Data and Charts to PowerPoint - ua-cam.com/video/TBI7eJlFi3Y/v-deo.html
Pivot Table from Multiple Workbooks - ua-cam.com/video/M9DdrpsVUks/v-deo.html
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: melcompton.com
CONNECT WITH ME!
Official Website: 🌐 melcompton.com
Facebook: MelComTech
Instagram: melcomtech
Twitter: MelComTech
LinkedIn: www.linkedin.com/in/melissa-compton
Pinterest: www.pinterest.com/MelCTech
TikTok: www.tiktok.com/@melcomtech
🧰TOOLS AND DISCOUNTS
My Software:
✅ 🌐 Bluehost: melcompton.com/recommends/bluehost/
✅ 🖼️ Adobe: melcompton.com/recommends/adobe/
✅ 🎥Filmora: melcompton.com/recommends/wondershare-filmora/
✅ ✍️ RightBlogger: melcompton.com/recommends/rightblogger/
✅ 🔢 Microsoft Business: melcompton.com/recommends/microsoft-365-business/
✅ 🔗 Thirsty Affiliates: melcompton.com/recommends/thirsty-affiliates/
✅ 📽️ TubeBuddy: melcompton.com/recommends/tubebuddy/
✅ 🖼️ Canva Pro: melcompton.com/recommends/canva-pro/
✅ 🌐 Website Theme (Newspaper 12): melcompton.com/recommends/newspaper-theme/
✅ 📃 WP Forms: melcompton.com/recommends/wp-forms/
✅ 📧 WP Mail SMTP: melcompton.com/recommends/wp-mail-smtp/
My Gear:
✅ 💻 HP Victus 15L: amzn.to/42sCr6f
✅ 🖥️ Dell Monitors: amzn.to/3r0iwte
✅ 🖱️ Logitech Wireless Mouse and Keyboard: amzn.to/42sCr6f
✅ 🔊 Behringer: amzn.to/3MW32mu
✅ 🎧 Audio-Technical: Headset: amzn.to/2Np3Qpl
✅ 🎧 WC Wicked Cushions Replacement Earpads: amzn.to/3uoihuh
✅ 🎤 Elgato Wave Mic Arm Low Profile: amzn.to/3UFMJ25
✅ 🎙️ Audio Technical 2005 USB Mic: amzn.to/3UHFfM4
🔔 SUBSCRIBE ON UA-cam
youtube.com/@MelCompton
👏 SUPPORT MY CHANNEL
✅ Hit the THANKS button on any video
✅ Amazon affiliate links: amzn.to/3Nijfnd
This description contains affiliate links. These are tools I personally use and love. I may receive a small commission should you make a purchase using one of these links. This helps keep the tutorials and website posts coming and up to date. Thank you for your support!
#melissacompton #excel #tutorial
📺RELATED VIDEOS
Checkboxes - ua-cam.com/video/fk1QF60_Yxs/v-deo.html
Link Excel Data and Charts to PowerPoint - ua-cam.com/video/TBI7eJlFi3Y/v-deo.html
Pivot Table from Multiple Workbooks - ua-cam.com/video/M9DdrpsVUks/v-deo.html
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: melcompton.com
CONNECT WITH ME!
Official Website: 🌐 melcompton.com
Facebook: MelComTech
Instagram: melcomtech
Twitter: MelComTech
LinkedIn: www.linkedin.com/in/melissa-compton
Pinterest: www.pinterest.com/MelCTech
TikTok: www.tiktok.com/@melcomtech
🧰TOOLS AND DISCOUNTS
My Software:
✅ 🌐 Bluehost: melcompton.com/recommends/bluehost/
✅ 🖼️ Adobe: melcompton.com/recommends/adobe/
✅ 🎥Filmora: melcompton.com/recommends/wondershare-filmora/
✅ ✍️ RightBlogger: melcompton.com/recommends/rightblogger/
✅ 🔢 Microsoft Business: melcompton.com/recommends/microsoft-365-business/
✅ 🔗 Thirsty Affiliates: melcompton.com/recommends/thirsty-affiliates/
✅ 📽️ TubeBuddy: melcompton.com/recommends/tubebuddy/
✅ 🖼️ Canva Pro: melcompton.com/recommends/canva-pro/
✅ 🌐 Website Theme (Newspaper 12): melcompton.com/recommends/newspaper-theme/
✅ 📃 WP Forms: melcompton.com/recommends/wp-forms/
✅ 📧 WP Mail SMTP: melcompton.com/recommends/wp-mail-smtp/
My Gear:
✅ 💻 HP Victus 15L: amzn.to/42sCr6f
✅ 🖥️ Dell Monitors: amzn.to/3r0iwte
✅ 🖱️ Logitech Wireless Mouse and Keyboard: amzn.to/42sCr6f
✅ 🔊 Behringer: amzn.to/3MW32mu
✅ 🎧 Audio-Technical: Headset: amzn.to/2Np3Qpl
✅ 🎧 WC Wicked Cushions Replacement Earpads: amzn.to/3uoihuh
✅ 🎤 Elgato Wave Mic Arm Low Profile: amzn.to/3UFMJ25
✅ 🎙️ Audio Technical 2005 USB Mic: amzn.to/3UHFfM4
🔔 SUBSCRIBE ON UA-cam
youtube.com/@MelCompton
👏 SUPPORT MY CHANNEL
✅ Hit the THANKS button on any video
✅ Amazon affiliate links: amzn.to/3Nijfnd
This description contains affiliate links. These are tools I personally use and love. I may receive a small commission should you make a purchase using one of these links. This helps keep the tutorials and website posts coming and up to date. Thank you for your support!
#melissacompton #excel #tutorial
Переглядів: 86
Відео
Pull Live Data From Stock Market in Microsoft Excel
Переглядів 1,4 тис.21 день тому
Get ready to transform your stock market analysis with Microsoft Excel! In this tutorial, I’ll show you how to let Excel pull live stock data for you to analyze in Excel. Perfect for investors and data enthusiasts, this step-by-step guide makes it easy to keep up with market changes and make informed decisions. Whether you’re tracking your portfolio or just curious about trends, you’ll find Exc...
How to Boost Productivity with Excel's New Checkboxes
Переглядів 31121 день тому
Unlock the full potential of Excel with a new feature! In this tutorial, I'll show you how to boost productivity with Excel's new checkboxes for task management, data tracking, and more. Learn step-by-step how to streamline your workflow and make your Microsoft Excel spreadsheets more interactive. Whether you’re a beginner or a seasoned Excel user, this feature will change the way you handle yo...
How to Combine Multiple Columns or Rows into One List in Excel
Переглядів 1,8 тис.2 місяці тому
Struggling with scattered data? Merge it all into one list in Microsoft Excel. In this tutorial you will learn how to combine multiple columns or rows into one list in excel. 📺RELATED VIDEOS Link Excel Data and Charts to PowerPoint: ua-cam.com/video/TBI7eJlFi3Y/v-deo.html Filter Data with Slicers In Excel: ua-cam.com/video/x_ZYf6UNEoE/v-deo.html Create a Pivot Table in Excel: ua-cam.com/video/w...
How to Customized Tab with Favorite Tools in Microsoft Excel
Переглядів 1292 місяці тому
How to Customized Tab with Favorite Tools in Microsoft Excel. Do you find yourself using the same tools in Microsoft Excel repeatedly? Streamline your workflow by creating a customized tab with your favorite tools! 🌟 Learn how to set up your personalized tab so everything you need is quick and easy to find. Say goodbye to searching and hello to efficiency! You can also use this same process to ...
How to Navigate and Search Worksheets in Excel
Переглядів 1253 місяці тому
Navigating Excel worksheets can be like finding a needle in a haystack, right? Been there! In this tutorial you will learn how to navigate and search Worksheets in Excel. Start using the navigation menu and watch how it transforms your workflow. You’ll wonder how you ever managed without it. 🧩✨ 📺RELATED VIDEOS Link Excel Data and Charts to PowerPoint: ua-cam.com/video/TBI7eJlFi3Y/v-deo.html Fil...
How to Link Excel Data and Charts to PowerPoint
Переглядів 2833 місяці тому
Make data and charts in your PowerPoint presentation dynamic by connecting it to Excel. When you change your data in Excel your PowerPoint presentation data and charts will update! Chapters: 00:00 - Intro 00:50 - Setup 02:00 - Data to PowerPoint 04:26 - Create Chart in Excel 07:20 - Charts to PowerPoint 09:20 - PowerPoint to Excel 09:44 - Outro 📺RELATED VIDEOS Use Slicers to Filter Data in Exce...
How to Filter Data with Slicers in Microsoft Excel | EASY
Переглядів 1963 місяці тому
In this tutorial you will learn how to filter data with slicers in Microsoft Excel. Unlock the power of Excel with Slicers to enhance your data analysis! Discover how to efficiently use Slicers in tables and pivot tables in Microsoft Excel to filter and refine data, making your reports more dynamic and insightful. Perfect for anyone looking to streamline their Excel skills! 📺RELATED VIDEOS Crea...
How to Create a Pivot Table in Microsoft Excel from Start to Chart
Переглядів 2073 місяці тому
Unlock the power of your data with this easy tutorial on creating a pivot table in Microsoft Excel, from start to stunning charts! Whether you're a beginner or looking to brush up your skills, this video will walk you through each step with clear, easy-to-follow instructions. Discover how to organize vast amounts of data and transform it into meaningful, visual insights. Don’t miss out on maste...
Microsoft MVP Award
Переглядів 1114 місяці тому
Thank you so much for your help in getting the Microsoft MVP Award! It's all because of you! My Software: Bluehost: melcompton.com/recommends/bluehost/ Adobe: melcompton.com/recommends/adobe/ Filmora: melcompton.com/recommends/wondershare-filmora/ RightBlogger: melcompton.com/recommends/rightblogger/ Microsoft Business: melcompton.com/recommends/microsoft-365-business/ Thirsty Affiliates: melco...
How to Create a Pivot Table from Multiple Workbooks in Excel
Переглядів 2,2 тис.7 місяців тому
In this tutorial, I'll show you how to create a pivot table from multiple workbooks in Excel using Power Query. I'll guide you through the steps to efficiently combine data from different workbooks and create a dynamic pivot table for analysis. By utilizing the power of Power Query, you'll streamline the process and gain valuable insights from your data. Whether you're a beginner or an experien...
How to Create Barcodes in Microsoft Excel
Переглядів 5767 місяців тому
How to Create Barcodes in Microsoft Excel
How to Create Multiple Dependent Drop-Down Lists in Microsoft Excel
Переглядів 7929 місяців тому
How to Create Multiple Dependent Drop-Down Lists in Microsoft Excel
How to Create a Dynamic Organizational Chart in Microsoft Excel
Переглядів 15 тис.10 місяців тому
How to Create a Dynamic Organizational Chart in Microsoft Excel
How to Create a Blog Post Using the Article Writer in RightBlogger
Переглядів 12710 місяців тому
How to Create a Blog Post Using the Article Writer in RightBlogger
How to Fix Weird Characters on Your Website
Переглядів 51010 місяців тому
How to Fix Weird Characters on Your Website
How to Create a Real Estate Open House Flyer with Canva and RightBlogger
Переглядів 97510 місяців тому
How to Create a Real Estate Open House Flyer with Canva and RightBlogger
How to Create a Real Estate Listing in RightBlogger
Переглядів 6810 місяців тому
How to Create a Real Estate Listing in RightBlogger
How to Create an Online Business Startup Budget in Excel
Переглядів 70910 місяців тому
How to Create an Online Business Startup Budget in Excel
How to Create a Blog Post from a YouTube Video with RightBlogger
Переглядів 22811 місяців тому
How to Create a Blog Post from a UA-cam Video with RightBlogger
How to Create a Pivot Table in LibreOffice Calc
Переглядів 7 тис.Рік тому
How to Create a Pivot Table in LibreOffice Calc
AI: The Future of Making Jobs Easier and More Productive
Переглядів 102Рік тому
AI: The Future of Making Jobs Easier and More Productive
How to Extract Data from a Picture to Excel on PC, iPhone or iPad
Переглядів 21 тис.Рік тому
How to Extract Data from a Picture to Excel on PC, iPhone or iPad
How to Mail Merge in LibreOffice Writer
Переглядів 15 тис.Рік тому
How to Mail Merge in LibreOffice Writer
How to Create a Dynamic Annual Calendar in Microsoft Excel
Переглядів 25 тис.Рік тому
How to Create a Dynamic Annual Calendar in Microsoft Excel
How to Create a QR Code in LIbreOffice Impress, Writer, and Calc
Переглядів 4,9 тис.Рік тому
How to Create a QR Code in LIbreOffice Impress, Writer, and Calc
How to Remove Dots from a Table of Contents in Microsoft Word
Переглядів 22 тис.Рік тому
How to Remove Dots from a Table of Contents in Microsoft Word
How to Remove the Gray Background from a Table of Contents in LibreOffice Writer
Переглядів 9 тис.Рік тому
How to Remove the Gray Background from a Table of Contents in LibreOffice Writer
How to Import Multiple CSV Files into Separate Worksheets in the Same Workbook in Excel
Переглядів 29 тис.Рік тому
How to Import Multiple CSV Files into Separate Worksheets in the Same Workbook in Excel
How to Create a Fillable PDF Form with a Submit Button in LibreOffice Writer - NO CODING REQUIRED
Переглядів 30 тис.2 роки тому
How to Create a Fillable PDF Form with a Submit Button in LibreOffice Writer - NO CODING REQUIRED
Thank you! Finally, a video that gives the answer I was looking for, short and sweet. UA-cam, please gives this video more attention. Subscribed and liked.
Thank you!
Thank you❤
Thank you, you solved my problem 🎉
Thank You for this Tutorial. However, I do have few .txt files that have leading zero's in one of the cell. Those are getting trimmed in excel. So in the VB script is there any code we can add so that when macro imports the data from .txt to excel in text format (rather than general) so that leading zero's are preserved?
This was a wonderful video. I learned how to do it by watching it twice and I’ve been trying for hours to figure out how to do it.
Great
thank u so much, so easy and straight to the point
I have been watching some of your videos, and have learned quite a bit, wondering if you can tell me how to make a UI based excel sheet for certain types of forms. would like to collaborate with you on this task, so that i may explain my situation. I have seen this done before but individual refused to show me how this is done. This idea is intended for my business.
Melissa, Thanks. This was very helpful.
For anyone who needs to import CSV files with a delimiter other than comma, you need to do 2 things: 1) Make sure your file extensions are .txt rather than .csv (this is because of an odd behavior of the VBA function used to open files, see the answer to StackOverflow question 39890471) 2) In the macro code, replace the 2 lines "Set xTempWb = Workbooks.Open(xFilesToOpen(I))" with: Set xTempWb = Workbooks.Open(Filename:=xFilesToOpen(I), Format:=6, Delimiter:=";") This is for semi-colon delimited files, change the Delimiter parameter to your actual delimiter.
Thanks very much!
Great, very helpful
Excellent. Thanks
Thank you ❤ ur amazing. Hi from Egypt.
Hi, Melissa: Thanks for the video. It really helped. But after I followed the instructions, I ended with an error message when I hit the "Submit" button. Instead of seeing the e-mail, I got this error message: ActiveX component can't create object. Where did I do wrong? Please advise.
YOU'RE A LIFE SAVER! THANK YOU!!
This was incredible, and so easy to follow along with! Thank you for this!
♥️♥️
Outstanding, really made me re-think how to get information from participants in a trial.
Verr interesting. Mucho Danke.
qué es eso sprache my friend LOL
A calm, cool and fully prepared trainer with curated content. :)
The only issue I'm having is this completely disabled RGB in my case..
I know you might not see this but I was wondering if there was a way where, when I click the submit button, the form could take the entries and populate a running list on another sheet within the document?
Thank you so much for your help but now how do I sort the data?
Generally when all data is in one file the file becomes heavy. does the combine file also get heavy once data is imported?
Excel version please
mam not showing after export send mail for selection....pls help
Thank you
Hi Melissa thank you so much for this tutorial, you are so easy to understand. John from Australia.
thank you it's really helpful
It is much easier to use Chat GPT. Just paste the screenshot into Chat GPT and say "Can you generate a table of text based on the screenshot I pasted here?" Voila!
Great. What are the other options as a result of submit button rather than mail. Is there any option to upload the file to Omedrive..?
Thanks for this, how do I achieve same result in Google Sheets?
hi, do u have a way of alternate colors in a writer document :? thank u
If you import a PDF to make it a fillable form, The PDF opens in Draw. Do the same rules for making the PDF into a fillable form remain the same in Draw as they do in Writer?
thank you
Really helpful video. Very clear and not too roomy.
Very informative? Can i do same import from text files as well ?
Hi. Yes it should work the same way. :)
@@MelCompton When I navigate to the folder with my text files, there are no files to select. Any ideas why I am not seeing my files?
Absolutely amazing
Thanks a lot.
Ha! Well done! I'd never have guessed the 1,1,1,1 trick in a million years! Thanks!
It works for me, but the issue is that 5 minutes exactly my monitors wake back up without any input and nothing I've looked up will fix it.
This was a super helpful tutorial. Thank you Melissa. Any suggestions on how to add/track important dates in this annual dynamic calendar - based on a separate tab list (holidays, PTO, task names on due dates, etc). I'm not able to add in rows in between/under each week to bring in key notes on specific dates.
This was a super helpful tutorial. Thank you Melissa. Any suggestions on how to add/track important dates in this annual dynamic calendar - based on a separate tab list (holidays, PTO, task names on due dates, etc). I'm not able to add in rows in between/under each week to bring in key notes on specific dates.
Can I change the checkbox in the 'generate pdf' from X to a nicer looking 'vink'?
thanks
Thanks for the tutorial
Thanks
Thanks this saved me pulling out my remaining few hairs ! 🥰
Thank you