Vue IT Training
Vue IT Training
  • Видео 162
  • Просмотров 69 403
Speed up your Excel scrolling with the navigation pane!!
Do you spend ages scrolling around #spreadsheeds?
Are you constantly flicking between the sheets?
Do you wonder if there is a quicker way to navigate in #excel ?
In this video I will show you how the navigation pane works, and how it can speed up your use of of spreadsheets and make it easier to find things.
#spreadsheet #exceltips #exceltricks #spreadsheetmagic #spreadsheetsolutions #exceltipsandtricks #excel365
Просмотров: 135

Видео

How to save a Powerpoint Template?
Просмотров 4019 часов назад
Do you spend ages opening and editing your templates in Powerpoint to remove blank slides? Did you know you can save a template into the DESIGN gallery where you can access it easily? This video will show you how to save your Powerpoint as a template and retain all the formats, and background designs. #presentationsoftware #powerpointslide #powerpoint #powerpointpresentation #presentationskills...
SAVE TIME IN POWERPOINT BY USING THE SELECTION PANE
Просмотров 18День назад
Do you spend ages trying to select objects in #Powerpoint? Or working out which objects you are animating on a #powerpointslide ? Or chasing objects around the screens because you can't select them? Then you need the SELECTION PANE!!!! Watch this video and find out how it works #presentationsoftware #powerpointpresentation #presentationskills #presentation #presentationtools
How to move columns around in an Excel Table #excel365 #exceltable #excelpivot
Просмотров 2,4 тыс.Месяц назад
It can be so frustrating trying to move columns around in an Excel Table. Watch my video to nail this technique and move columns like a pro. It will save you so much time. #exceltips #spreadsheet #spreadsheets #spreadsheettutorial #exceltutorials
Refresh data we pulled from a web site - PART 2
Просмотров 412 месяца назад
In the first video, we looked at how you can grab data from the web and bring that in to Excel! Now to test that, and see if it updates when the web page is updated! #exceltips #excel365 #data #web #olympics #exceldatamanipulation
How to grab data from a web page (using the Olympics Medal Table as an example!!!)
Просмотров 2912 месяца назад
Do you need to get data from a web page? Did you know that you can do this through #powerquery in #excel! Have a look at our short video to find out how, and get set up for the #Olympics!
How to link to other slides in your Powerpoint Presentation
Просмотров 582 месяца назад
How create a summary slide in #powerpoint that links to other slides.
Useful Shortcuts Microsoft Word
Просмотров 312 месяца назад
Speed up your formatting of documents with my useful everyday formatting shortcuts in Microsoft Word! Want to know more? Check out our online course vueittraining.co.uk/online-courses/mastering-ms-word/ #shortcuts #shortcutsforstudents #msword #documents #file #page #formatting
Why does the font in #microsoft #word keep defaulting to Times New Roman?
Просмотров 1032 месяца назад
How annoying is it when your font in your document changes back to Times New Roman? Have a look at our video and find how how you can solve this #styles problem for GOOD!!!! Check out our online course for more on Mastering Microsoft Word vueittraining.co.uk/online-courses/mastering-ms-word/ #msword #documents #systemsandprocesses #tableofcontent #styles
How to create a reference row for #vlookup so you know the column number!
Просмотров 263 месяца назад
One of the issues with Vlookups is that you need to know the number of the column that you want to return. But then you start the formula, and forget to count the columns! Then have to go back and start again. This video suggests using a reference row to help with this. If you want to know more, come along to our Vlookups Excel Surgery on 1 July 2024. vueittraining.co.uk/online-courses/excel-su...
How to make Data Validation dynamic by using a Xlookup Formula
Просмотров 3463 месяца назад
If you use Data Validation in #excel you can use an xlookup to pick up data for another column. Its a really easy way of making your data more dynamic. IF you want to know more about Xlookups, come along to our monthly online surgery on 1st August. Here is the booking link vueittraining.co.uk/online-courses/excel-surgery-1-august-1-pm-to-2-pm-online-live-training-session/ #exceltips #excel365 #...
A data validation can be dynamic with the help of a #vlookup!
Просмотров 1173 месяца назад
In #excel, when you change the drop down on the Data Validation, the vlookup will change the contents of the related column. In this video we use the following tools: Tables Data Validation Vlookup. Our July Surgery is looking a Vlookups - click here to book vueittraining.co.uk/online-courses/excel-surgery-1-july-1-pm-to-2-pm-online-live-training-session/
How to move your meeting responses to a folder in Outlook
Просмотров 9134 месяца назад
How to automatically Move Meeting Responses into a Folder, and get rid of them from your Inbox. On our Making your Inbox Smarter Course, we use Rules to automatically move messages. This rule moves meeting acceptances and declines from your Inbox into a subfolder to avoid cluttering up your Inbox. #outlook #outlookbusiness #outlook2023 #email #inbox #inboxzero #message #messages
Are you using #Ifs in #Excel? This video explains how they work!
Просмотров 184 месяца назад
Using #ifs in Excel? Here is a short video that explain the newer IFs function. If you want to know more come along to our online June Surgery vueittraining.co.uk/online-courses/excel-surgery-3-june-1-pm-to-2-pm-online-live-training-session/ #exceltips #excel365 #exceltipsandtricks #excelformula #excelfunctions #excelformulas #iffunction
Where does the data come from for my vlookup? How to find out #excel365 #vlookup #vlookupformula
Просмотров 1484 месяца назад
When you are using a file that someone else has set up, it is often difficult to find the source of the #vlookup ! This video shows you how to view behind the scenes with #formula auditing and see #linkedfiles. We are looking at vlookups on our August Excel Surgery. Book here vueittraining.co.uk/online-courses/excel-surgery-1-august-1-pm-to-2-pm-online-live-training-session/
How we went from data to pivot table to graph in Excel
Просмотров 765 месяцев назад
How we went from data to pivot table to graph in Excel
Speed up your work using dictation in Outlook and Word
Просмотров 685 месяцев назад
Speed up your work using dictation in Outlook and Word
Changing cell colour depending on the date in #excel365
Просмотров 775 месяцев назад
Changing cell colour depending on the date in #excel365
How to colour the whole row not just the cell with conditional formatting in Excel
Просмотров 1,5 тыс.5 месяцев назад
How to colour the whole row not just the cell with conditional formatting in Excel
How to get your Data Validation list to updated when it is on another sheet! #exceltips #excel365
Просмотров 8846 месяцев назад
How to get your Data Validation list to updated when it is on another sheet! #exceltips #excel365
How to transform your Equipment spreadsheet using Power Query, Xlookup and tables!
Просмотров 686 месяцев назад
How to transform your Equipment spreadsheet using Power Query, Xlookup and tables!
Find and Replace non printing characters in Microsoft Word
Просмотров 1186 месяцев назад
Find and Replace non printing characters in Microsoft Word
Conditional Formatting in Excel - its great when its working properly!
Просмотров 986 месяцев назад
Conditional Formatting in Excel - its great when its working properly!
Are you forever searching for the cells used in a formula? This video will save you hours!
Просмотров 646 месяцев назад
Are you forever searching for the cells used in a formula? This video will save you hours!
Auto-number in Microsoft Word
Просмотров 1,2 тыс.7 месяцев назад
Auto-number in Microsoft Word
An introduction to Pivot Tables in Excel
Просмотров 518 месяцев назад
An introduction to Pivot Tables in Excel
Are Windows Notifications driving you up the wall?
Просмотров 278 месяцев назад
Are Windows Notifications driving you up the wall?
Insert one document into another - MS Word
Просмотров 6938 месяцев назад
Insert one document into another - MS Word
Save time on your reports and assignments - use this #Word - #powerpoint hack!!!
Просмотров 439 месяцев назад
Save time on your reports and assignments - use this #Word - #powerpoint hack!!!
CHANGE CASE in a Word Document #msword #mswordtutorial
Просмотров 259 месяцев назад
CHANGE CASE in a Word Document #msword #mswordtutorial

Комментарии

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

    Thanks, would have never found the Form stuff on my own. One Question: is there a way to exclude non-empty meeting responses? Sometimes people actually write something there, so I would like to be aware of it and keep it in my inbox. But I could only find exceptions with specific words.

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

    You are awesome! Saved me a lot of time at work!! Thank you!

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

    Thank you so much.. great.. appreciate very much😘

  • @angelarawstorne3939
    @angelarawstorne3939 7 дней назад

    hi there, is it possible to have the template, i have liked, subscribed and joined your mailing list. thx

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

    Helped a lot, just so straight forward and helpful. Thanks and Appreciation for the help.

  • @McGinty.
    @McGinty. 12 дней назад

    Thank you, worked in IT for 9 years and always bugged me how my inbox was spammed by meeting responses, but no longer!

  • @spuneet156
    @spuneet156 12 дней назад

    Thanks I forgot it for a while

  • @grahamwalkden551
    @grahamwalkden551 22 дня назад

    How do I get your template

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

    The problem with this "fix" is that all of this text is NOT headings and should not be styled as such. When doing a Table of Contents - all these headings are going to create a mess.

    • @vueittraining
      @vueittraining 24 дня назад

      There are 9 heading levels. So the lower heading levels containing the longer paragraphs can be excluded from the table of contents. So the table of contents can show only heading levels 1. Obviously it is not a perfect work around but it is the best I found. Would be interested in hearing of other methods

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

    REALLY annoying video...presenter ...OMG

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

    Consider CHANING the COLOR of your CURSOR to YELLOW. Easier to follow along with you. Under SETTINGS...MOUSE

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

    Excellent help, thank you.

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

    Worthless video

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

    Thank you so much mam. This thing was driving me crazy.

  • @bawa_jani
    @bawa_jani 2 месяца назад

    This function not availabe on earlier excel version !!!

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

      Unfortunately it is only available for Excel 365.

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

      @@vueittraining Thank you.. Nice informative video...

  • @Xo.francy
    @Xo.francy 2 месяца назад

    Very useful, thank you!

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

      Glad to found it useful. Meeting responses can just bung up the inbox !

  • @sup2069
    @sup2069 2 месяца назад

    Wow thank you, did not know this existed!

    • @vueittraining
      @vueittraining 2 месяца назад

      There are all these hidden gems in Excel. Glad it was useful!

  • @conradblume4274
    @conradblume4274 2 месяца назад

    Very good tutorial, thank you for posting!!

  • @jenniferbeyer2106
    @jenniferbeyer2106 2 месяца назад

    could I get the template?

  • @awesh1986
    @awesh1986 2 месяца назад

    You helped me solve a huge problem. Thanks a lot.

  • @news1676
    @news1676 2 месяца назад

    Hello mam You are making amazing videos I noticed your RUclips channel and you're doing great! I have seen all your videos and your content qualities are excellent but still it is not delivering the right audience due to SEO problems. Focusing on your SEO to get a big fanbase would be best. I have some ideas on how to boost your audience and engagement. Would you like to talk about it for a while? Let's talk and I'll share my strategies with you.

  • @thegovernor287
    @thegovernor287 2 месяца назад

    Thank you that has just saved me a lot of time.

  • @jwcorcoran9838
    @jwcorcoran9838 3 месяца назад

    Great video, thank you so much!

  • @Birendutube
    @Birendutube 3 месяца назад

    thanks helpful

  • @luzoFinds
    @luzoFinds 3 месяца назад

    LOVE IT THANKS!

  • @retiefjoubert55
    @retiefjoubert55 3 месяца назад

    Have the scenario where the entire reference to a list changes depending on another prior input, so second level of dependent lists. Example, there is a first Named Range Product_type, with say Fruit or Vegetables. The Fruit_list has Apples and Oranges listed and Vegetables_List has Potatoes and Pumpkin listed. So the user selects Product_type > Fruit, and secondly from Fruit_list selects Apples. All Good. BUT. When the first level data option changes, to Vegetables, the selected value of Apples stays there, and the user has to re-open the updated dropdown list to select say Potatoes. Can this be fixed?

    • @vueittraining
      @vueittraining 3 месяца назад

      Unfortunately, Data Validation is used to change the value in that one cells. I would use a vlookup (or xlookup) in the second column to return the value of a connected cell. I will see if I can do another video on it.

  • @charliegerson7570
    @charliegerson7570 4 месяца назад

    Please, how do you create a functional Radio button or Check boxes in Mail Merge? Mine always becomes a .png (image file) and does not work when I output the mails.

    • @vueittraining
      @vueittraining 4 месяца назад

      I don’t think this is possible . Maybe create a Microsoft form and put the form link in the mail merge file.

    • @charliegerson7570
      @charliegerson7570 4 месяца назад

      @@vueittraining Thanks for your response. Will try your suggestion. Very appreciative of your assistance.

  • @charliegerson7570
    @charliegerson7570 4 месяца назад

    Wonderful. Powerful great tip. Sincere thanks.

  • @markv00
    @markv00 4 месяца назад

    I'm by no means an expert in excel, but I watched a video recently from an excel MVP, and I think the new item added to the list from another sheet could be triggered by you sorting the list prior to going to check if it's in the list. I could be totally wrong, and my apologies if so. I thought I remembered that other video saying any "triggering" event, like resorting, refreshing, and such would cause the list to refresh. I'm curious if not sorting after adding the new item to the table on a separate sheet would show up in the data validation drop down on sheet 2. I may see if I can work that out. Just a thought. Good Day!

    • @vueittraining
      @vueittraining 4 месяца назад

      Thank you . I will give this a try and do a follow up video 😀

  • @loree657
    @loree657 4 месяца назад

    Very helpful! Thank you!

  • @johnstaunton29
    @johnstaunton29 4 месяца назад

    Super helpful thank you !

  • @malcolmmaclaurin700
    @malcolmmaclaurin700 4 месяца назад

    Very informative - thank you - however like everyone else how do I receive the template. 😀

  • @lornafromlondon6106
    @lornafromlondon6106 4 месяца назад

    Argh.... I watched a few of these vids. Yours was helpful and finally got the job done. Thank you. Could have save myself an hour if I'd seen this earlier😂

    • @vueittraining
      @vueittraining 4 месяца назад

      Glad it finally solved the problem !

  • @viorelioanmaerean2608
    @viorelioanmaerean2608 5 месяцев назад

    Thank You ! It' s perfect !

  • @sabryyoussef151
    @sabryyoussef151 5 месяцев назад

    Very straight and helpful, thank you my dear Appreciate ur help ❤

  • @dexterbarrett2085
    @dexterbarrett2085 5 месяцев назад

    *Promosm*

  • @ajikkar
    @ajikkar 5 месяцев назад

    Can you please suggest a way to insert date in subject line which will change according to system date while doing email mail merge from word

    • @vueittraining
      @vueittraining 5 месяцев назад

      This can be done via Power Automate. It can be tricky to set up though .

    • @ajikkar
      @ajikkar 5 месяцев назад

      @@vueittraining Appreciate your prompt response

  • @TanyaYacapiloveyou14344
    @TanyaYacapiloveyou14344 5 месяцев назад

    I have liked and subscribed. Can I have a copy of this template? It will be very useful for monitoring my electric consumption.

  • @-hearts_zad8764
    @-hearts_zad8764 5 месяцев назад

    Thx from the heart

  • @kebincui
    @kebincui 6 месяцев назад

    Excellent 👍

  • @gsk3288
    @gsk3288 6 месяцев назад

    very useful, thanks a lot

  • @KellyLarm
    @KellyLarm 6 месяцев назад

    Thank you! Just the tip I was looking for!

  • @mouffoukhoussem5068
    @mouffoukhoussem5068 6 месяцев назад

    Thank you so much, this tip helped me so much.

  • @AcaciaTrust
    @AcaciaTrust 7 месяцев назад

    Good Morning. Thank you for this great tool. I have subscribed and am wondering how I can access the free template? In Thanks.

  • @ollie_htt1693
    @ollie_htt1693 7 месяцев назад

    Thank you!

  • @JulieMcleish
    @JulieMcleish 8 месяцев назад

    This has been a great help, thank you

  • @stevesusanneearl2359
    @stevesusanneearl2359 8 месяцев назад

    Thank you 🙏 really helpful

  • @stevesusanneearl2359
    @stevesusanneearl2359 8 месяцев назад

    Thank you 🙏

  • @Phantom-R-E-D
    @Phantom-R-E-D 8 месяцев назад

    Thank you very much! Very clear and concise instructions.

  • @seagoddess9937
    @seagoddess9937 8 месяцев назад

    This... didn't even answer the question of the video??? You just told us how to make them into jpegs. That is so useless