- Видео 152
- Просмотров 1 186 342
Melissa Compton
США
Добавлен 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!!!
Stop Losing Track of Active Cells in Excel with Focus Cell (NO VBA)
No more losing track of where you are in big Excel spreadsheets! In this tutorial, I’ll show you how to use the new focus cell feature that automatically highlights the row and column of your active cell.
Watch now and let me know what you think in the comments!
📺RELATED VIDEOS
Dynamic Data Entry Form in Excel: ruclips.net/video/6ciUWlidWro/видео.html
Combine or Split Text in Excel: ruclips.net/video/nc9d0hj89p4/видео.html
Navigate and Search Worksheets in Excel: ruclips.net/video/23WakL8UCRQ/видео.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: facebook....
Watch now and let me know what you think in the comments!
📺RELATED VIDEOS
Dynamic Data Entry Form in Excel: ruclips.net/video/6ciUWlidWro/видео.html
Combine or Split Text in Excel: ruclips.net/video/nc9d0hj89p4/видео.html
Navigate and Search Worksheets in Excel: ruclips.net/video/23WakL8UCRQ/видео.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: facebook....
Просмотров: 153
Видео
Create a Dynamic Data Entry Form in Excel Using Current Column Headers
Просмотров 8463 месяца назад
Are you tired of manually creating data entry forms every time your Excel column headers change? 🚫 It can be frustrating to keep updating your forms to match your data. In this Excel tutorial, I'll show you how to create a dynamic data entry form in Excel that automatically adapts to your current column headers, making data entry easier and more efficient. 📺RELATED VIDEOS 🔗 COMBINE OR SPLIT TEX...
How to EASILY Combine or Separate Data in Excel (With Only 2 Functions!) | Step by Step Tutorial
Просмотров 1054 месяца назад
Join (Combine) or Split Text in Cells in Microsoft Excel Do you ever need to combine data like names, and addresses, or any other data? Ever need to split the data from one cell to multiple? This tutorial covers all the steps you need. I will show you how to effortlessly combine data from multiple cells into one or split text from a single cell into multiple cells in Microsoft Excel. Whether yo...
How to Find Unknown Data Needed to Make Goals in Excel - Goal Seek
Просмотров 1284 месяца назад
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 Exc...
Pull Live Data From Stock Market in Microsoft Excel
Просмотров 3,3 тыс.5 месяцев назад
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
Просмотров 3855 месяцев назад
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
Просмотров 6 тыс.6 месяцев назад
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: ruclips.net/video/TBI7eJlFi3Y/видео.html Filter Data with Slicers In Excel: ruclips.net/video/x_ZYf6UNEoE/видео.html Create a Pivot Table in Excel: ruclips.net/vide...
How to Customized Tab with Favorite Tools in Microsoft Excel
Просмотров 1596 месяцев назад
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
Просмотров 1567 месяцев назад
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: ruclips.net/video/TBI7eJlFi3Y/видео.html Fi...
How to Link Excel Data and Charts to PowerPoint
Просмотров 6177 месяцев назад
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
Просмотров 2667 месяцев назад
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
Просмотров 4008 месяцев назад
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
Просмотров 1278 месяцев назад
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...
Create a Pivot Table from Multiple Workbooks with Power Query | IN DEPTH EXCEL TUTORIAL
Просмотров 4 тыс.11 месяцев назад
Create a Pivot Table from Multiple Workbooks with Power Query | IN DEPTH EXCEL TUTORIAL
How to Create Barcodes in Microsoft Excel
Просмотров 81011 месяцев назад
How to Create Barcodes in Microsoft Excel
How to Create Multiple Dependent Drop-Down Lists in Microsoft Excel
Просмотров 947Год назад
How to Create Multiple Dependent Drop-Down Lists in Microsoft Excel
How to Create a Dynamic Organizational Chart in Microsoft Excel
Просмотров 21 тыс.Год назад
How to Create a Dynamic Organizational Chart in Microsoft Excel
How to Create a Blog Post Using the Article Writer in RightBlogger
Просмотров 139Год назад
How to Create a Blog Post Using the Article Writer in RightBlogger
How to Fix Weird Characters on Your Website
Просмотров 615Год назад
How to Fix Weird Characters on Your Website
How to Create a Real Estate Open House Flyer with Canva and RightBlogger
Просмотров 1,3 тыс.Год назад
How to Create a Real Estate Open House Flyer with Canva and RightBlogger
How to Create a Real Estate Listing in RightBlogger
Просмотров 73Год назад
How to Create a Real Estate Listing in RightBlogger
How to Create an Online Business Startup Budget in Excel
Просмотров 947Год назад
How to Create an Online Business Startup Budget in Excel
How to Create a Pivot Table in LibreOffice Calc
Просмотров 9 тыс.Год назад
How to Create a Pivot Table in LibreOffice Calc
How to Extract Data from a Picture to Excel on PC, iPhone or iPad
Просмотров 22 тыс.2 года назад
How to Extract Data from a Picture to Excel on PC, iPhone or iPad
How to Mail Merge in LibreOffice Writer
Просмотров 19 тыс.2 года назад
How to Mail Merge in LibreOffice Writer
How to Create a Dynamic Annual Calendar in Microsoft Excel
Просмотров 32 тыс.2 года назад
How to Create a Dynamic Annual Calendar in Microsoft Excel
How to Create a QR Code in LIbreOffice Impress, Writer, and Calc
Просмотров 6 тыс.2 года назад
How to Create a QR Code in LIbreOffice Impress, Writer, and Calc
How to Remove Dots from a Table of Contents in Microsoft Word
Просмотров 26 тыс.2 года назад
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
Просмотров 10 тыс.2 года назад
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
Просмотров 33 тыс.2 года назад
How to Import Multiple CSV Files into Separate Worksheets in the Same Workbook in Excel
Hi Melissa thanks for this very informative video and tool , after using the tool some of my dates on import have been changed to US format is there anyway of a line of code that can be added to stop the format changing.
Thanks it's simple and clever at the same time; I felt stupid after watching it like how didn't I think of that XD
I don’t have options? What do I do
Are you using outlook desktop in a pc?
@ think I figured it out, thanks
I am building an order form for a business I work for. Can I do this and have it submitted to a separate workbook for data/inventory tracking?
THANK YOU for the wonderful concise how-to video! It saved my A!@#$ss since I no longer pay Microsoft for their software. 😁
I thought I knew how to create a table of contents until I hit a problem. I had the exact same problem you showed a resolution to as to why am I heading 2 and 3 was not showing.. thank you for this video..
You're awesome. How do I insert dates (birth dates) in a form?
This is perfect!! I only make labels like twice a year but this was my first time using Libre Office. Great step by step explination!!! ❤
Hi, I really like your tutorial, but I'm stuck... After double clicking the submit button, where the private sub & end sub page pop up. What information goes on that page. You said to click control and v or paste, but nothing comes up for me.
The VBA script is in a pinned comment.
This clip may be 3 years old but it is still helping people like me. Thank you.
Melissa, I received a spreadsheet from a third party, and I can't execute the "sum" function in LibreOffice Calc. The result is zero, or it gives an error. How do I solve this? Thank you in advance.
Thank you! Thank you! I had spent almost two hours attempting to determine why nothing was showing in my table on contents. Your explanation of why this might happen was perfect! Now I can sleep tonight!!!
im sorry why cant i use fn+f4 as my shortcut key? im using msi laptop edit: i even try your ctrl+shift+alt+m but it also didnt work, double click on the shortcut work thou with a black cmd prompt show up before it work
Do I need to be connected to the internet for it to send ?
Yep, you have to outlook open
Nice Video thank you. I got the filled template with data.fdf format when submitted and it is editable after submitted also, can you advise me how can I solve these issue please?
This was super clear, easy to follow step by step. I'm subscribing, and I'm making a shortcut on my browser to your channel. I'm so glad I found your info!!
Wow! Thanks! That was super helpful.
can i have libreoffice form transparent box
Good
I dont have the choice to use templates and its pissing me off so much
Great video and explanation of when to use. Is it possible to protect a custom view so others can't view them if you share the workbook? Preferably, not delete the views. Thanks
I'm trying to download a font named ''Roseritta'' , but it doesn't have that type of file ( I'm talking about OpenType font file ) . It only has a Read me file and another one that I cannot open. What do I do?
Thank you so much. would I also save the template now that I have my address labels saved?
Thank you for making this video. I'm a bit frustrated though as you didn't include how to change the email body text that gets generated when the submit button is pressed. Does anyone know how this is done?
Fantastic, thank you!
Great brief for mail-merge ... great first-stop, beach landing...
Ma'am Melissa Compton youre a look alike of the Doctor in Radius inside Meralco compound who was assigned there as company/ clinic doctor while I was a reliever clinic nurse in there prior to my duty in Meralco Clinic.
very helpful if you do it all in one shot, however it seems difficult to edit eg if you change the database name do you have to start from scratch?
Great job, beautiful information, I liked it much more 🎉🎉🎉
is there any way to apply this system wide? to make it default
Thanks
We all agree! Thank you! I make Christmas labels once a year but the software changes and the procedure steps sometimes change. I spent hours getting labels this time. I just didn't seem to follow instructions very well (I'm getting older (83). I finally discovered your tutorial. It's excellent. I did discover that one should not make the Calc column names too long. It can cause issues when you specify the field-names for fields you move to the label file. One of my fields would not merge, apparently because the field name was too large. If a field name overflows a line and/or wraps to the next line, it might not be merged in the actual label template. 5160 labels can be almost to small for some address/name combinations. Adjustments larger than a couple characters can make things even worse. I'll look for some labels that are a bit larger when I run out of the Avery 5160 labels and I'll use shorter fieldnames like yours.
Thank you! It will help me a lot.
Thanks. Your script works like a charm.
Thank you for this tutorial.
I followed your great step-by-step guide. When I create the New document, the labels are blank. I then followed you guide to "automate" the process. The New document is still blank. I can't figure out what I'm doing wrong. Any suggestions?
THANK YOU
Thank you, Thank you, Thank you!! I had been stuggling to make the labels, but with this brilliant step by step guide I found it so easy to follow,even me with limited tech knowledge. Many thanks Melissa
but in outlook browser? can not find this. I want it to be by default 30 seconds delay. is it possible?
Thanks a million Melissa!
Question, I created a form, exported it as a pdf. However, when I open it, I can edit text anywhere on the form. I can also resize the cells of a table. Any idea what is happening?
Thanks for the video I was able to follow it step by step. You explained the steps in detail
Hi the only issue I have is that when I am dragging and dropping First Name etc it goes all over the place i have to undo and redo
Well done Thanks Is it possible to add calculated field in this pivot tables 🤔
Pretty cool 😎
Awesome, thank you! Just what I needed.
Where did u got the code?
I wrote it. It’s in the description and/or comments
I needed to import ptr files rather than CSV files so I went into the macro and changed csv to ptr, this allowed me to select the ptr files however when the new workbook was launched it was empty, any advice?
why explain in less than a minute when you can explain in 12.49. you are THE WORST teacher. you care more about viewer time than to actually deliver content that matters. trash like you ought to be replaced by ai.
Thank you Melissa, so many people are overcomplicating this! Followed