- Видео 162
- Просмотров 69 403
Vue IT Training
Великобритания
Добавлен 24 фев 2016
Saving you time with #excel #word, #Teams, #powerpoint, #outlook365 #outlook and #microsoft365!
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
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!
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
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.
You are awesome! Saved me a lot of time at work!! Thank you!
Thank you so much.. great.. appreciate very much😘
hi there, is it possible to have the template, i have liked, subscribed and joined your mailing list. thx
Helped a lot, just so straight forward and helpful. Thanks and Appreciation for the help.
Thank you, worked in IT for 9 years and always bugged me how my inbox was spammed by meeting responses, but no longer!
Thanks I forgot it for a while
I do that as well 🤣🤣
How do I get your template
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.
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
REALLY annoying video...presenter ...OMG
Consider CHANING the COLOR of your CURSOR to YELLOW. Easier to follow along with you. Under SETTINGS...MOUSE
Excellent help, thank you.
Glad it was useful!
Worthless video
Thank you so much mam. This thing was driving me crazy.
This function not availabe on earlier excel version !!!
Unfortunately it is only available for Excel 365.
@@vueittraining Thank you.. Nice informative video...
Very useful, thank you!
Glad to found it useful. Meeting responses can just bung up the inbox !
Wow thank you, did not know this existed!
There are all these hidden gems in Excel. Glad it was useful!
Very good tutorial, thank you for posting!!
Glad you found it helpful!
could I get the template?
You helped me solve a huge problem. Thanks a lot.
Glad it was useful!
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.
Thank you that has just saved me a lot of time.
I’m glad it helped .
Great video, thank you so much!
Glad it was helpful!
thanks helpful
Glad it was useful!
LOVE IT THANKS!
Glad you like it! 😍
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?
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.
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.
I don’t think this is possible . Maybe create a Microsoft form and put the form link in the mail merge file.
@@vueittraining Thanks for your response. Will try your suggestion. Very appreciative of your assistance.
Wonderful. Powerful great tip. Sincere thanks.
Glad it was helpful!
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!
Thank you . I will give this a try and do a follow up video 😀
Very helpful! Thank you!
Glad it was useful 😀
Super helpful thank you !
Glad it was useful!
Very informative - thank you - however like everyone else how do I receive the template. 😀
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😂
Glad it finally solved the problem !
Thank You ! It' s perfect !
😀😀😀😀
Very straight and helpful, thank you my dear Appreciate ur help ❤
Glad you found it useful.
*Promosm*
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
This can be done via Power Automate. It can be tricky to set up though .
@@vueittraining Appreciate your prompt response
I have liked and subscribed. Can I have a copy of this template? It will be very useful for monitoring my electric consumption.
Thx from the heart
Glad it was helpful 😀
Excellent 👍
Thank you!
very useful, thanks a lot
Glad it was helpful!
Thank you! Just the tip I was looking for!
Glad it was useful!
Thank you so much, this tip helped me so much.
So glad it was useful!
Good Morning. Thank you for this great tool. I have subscribed and am wondering how I can access the free template? In Thanks.
Thank you!
Glad it was helpful
This has been a great help, thank you
Glad it helped!
Thank you 🙏 really helpful
Glad it was helpful!
Thank you 🙏
Glad you found it useful
Thank you very much! Very clear and concise instructions.
Glad it was useful 😃
This... didn't even answer the question of the video??? You just told us how to make them into jpegs. That is so useless