Melissa Compton
Melissa Compton
  • Видео 152
  • Просмотров 1 186 342
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....
Просмотров: 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

Комментарии

  • @andyshelton7757
    @andyshelton7757 13 часов назад

    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.

  • @reza4b
    @reza4b День назад

    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

  • @kingofthecosmos3253
    @kingofthecosmos3253 2 дня назад

    I don’t have options? What do I do

  • @ThomasWirth-q2o
    @ThomasWirth-q2o 2 дня назад

    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?

  • @stevetech1949
    @stevetech1949 2 дня назад

    THANK YOU for the wonderful concise how-to video! It saved my A!@#$ss since I no longer pay Microsoft for their software. 😁

  • @jmdsouza
    @jmdsouza 6 дней назад

    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..

  • @conharr2511
    @conharr2511 8 дней назад

    You're awesome. How do I insert dates (birth dates) in a form?

  • @ms.LauraRodriguez
    @ms.LauraRodriguez 9 дней назад

    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!!! ❤

  • @nicoleshelton8103
    @nicoleshelton8103 10 дней назад

    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.

    • @MelCompton
      @MelCompton 10 дней назад

      The VBA script is in a pinned comment.

  • @DSeisun1
    @DSeisun1 11 дней назад

    This clip may be 3 years old but it is still helping people like me. Thank you.

  • @MarceloAntonioNeriMoreira
    @MarceloAntonioNeriMoreira 15 дней назад

    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.

  • @brianriley6634
    @brianriley6634 17 дней назад

    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!!!

  • @daisum1237
    @daisum1237 17 дней назад

    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

  • @wahdafuq2346
    @wahdafuq2346 20 дней назад

    Do I need to be connected to the internet for it to send ?

    • @MattHillier
      @MattHillier 10 часов назад

      Yep, you have to outlook open

  • @GezahegnWubalem
    @GezahegnWubalem 20 дней назад

    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?

  • @TheRealBronweN
    @TheRealBronweN 21 день назад

    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!!

  • @Ghostoad
    @Ghostoad 21 день назад

    Wow! Thanks! That was super helpful.

  • @Sawaru
    @Sawaru 23 дня назад

    can i have libreoffice form transparent box

  • @nguyenvantuan2548
    @nguyenvantuan2548 25 дней назад

    Good

  • @nawyx60
    @nawyx60 26 дней назад

    I dont have the choice to use templates and its pissing me off so much

  • @denisekobrin9338
    @denisekobrin9338 28 дней назад

    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

  • @sofija12
    @sofija12 29 дней назад

    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?

  • @annettekerry
    @annettekerry Месяц назад

    Thank you so much. would I also save the template now that I have my address labels saved?

  • @liefschneider3123
    @liefschneider3123 Месяц назад

    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?

  • @RedMei126
    @RedMei126 Месяц назад

    Fantastic, thank you!

  • @timhancock8344
    @timhancock8344 Месяц назад

    Great brief for mail-merge ... great first-stop, beach landing...

  • @francishubertovasquez2139
    @francishubertovasquez2139 Месяц назад

    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.

  • @jons6013
    @jons6013 Месяц назад

    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?

  • @vrathod4437
    @vrathod4437 Месяц назад

    Great job, beautiful information, I liked it much more 🎉🎉🎉

  • @ugxrorke3190
    @ugxrorke3190 Месяц назад

    is there any way to apply this system wide? to make it default

  • @ibraheemopeyemioladebo8916
    @ibraheemopeyemioladebo8916 Месяц назад

    Thanks

  • @wes4139
    @wes4139 Месяц назад

    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.

  • @TonyMontanaAPBT
    @TonyMontanaAPBT Месяц назад

    Thank you! It will help me a lot.

  • @AmarReddy-marpadga
    @AmarReddy-marpadga Месяц назад

    Thanks. Your script works like a charm.

  • @GianniRaimondi-u9c
    @GianniRaimondi-u9c Месяц назад

    Thank you for this tutorial.

  • @258house
    @258house Месяц назад

    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?

  • @isgodreal1337
    @isgodreal1337 Месяц назад

    THANK YOU

  • @IanGill-e7c
    @IanGill-e7c Месяц назад

    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

  • @ValmisFilm
    @ValmisFilm Месяц назад

    but in outlook browser? can not find this. I want it to be by default 30 seconds delay. is it possible?

  • @brunabraz5853
    @brunabraz5853 Месяц назад

    Thanks a million Melissa!

  • @iandavidharwin
    @iandavidharwin Месяц назад

    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?

  • @sharleneblake2944
    @sharleneblake2944 Месяц назад

    Thanks for the video I was able to follow it step by step. You explained the steps in detail

  • @sharleneblake2944
    @sharleneblake2944 Месяц назад

    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

  • @sizomabu1036
    @sizomabu1036 Месяц назад

    Well done Thanks Is it possible to add calculated field in this pivot tables 🤔

  • @abdulnayeemnooshhabeham1707
    @abdulnayeemnooshhabeham1707 Месяц назад

    Pretty cool 😎

  • @joshuajones6113
    @joshuajones6113 Месяц назад

    Awesome, thank you! Just what I needed.

  • @NasimSaed
    @NasimSaed Месяц назад

    Where did u got the code?

    • @MelCompton
      @MelCompton Месяц назад

      I wrote it. It’s in the description and/or comments

  • @lucyhoughton4458
    @lucyhoughton4458 Месяц назад

    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?

  • @marmeladovsvid
    @marmeladovsvid Месяц назад

    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.

  • @Lily-cl6zk
    @Lily-cl6zk Месяц назад

    Thank you Melissa, so many people are overcomplicating this! Followed