- 93
- 167 117
SMEOfficeSupport
Registrace 25. 10. 2011
Robin's Story - Blue Cross
Robin was found at just a few weeks old abandoned at the side of a road in Durham along with 6 other ponies and a donkey. He was too young to be away from his mum and wouldn’t have survived if the RSPCA hadn’t found him. It’s often the case that male ponies get abandoned due to being ‘useless’ as they can’t be used for breeding. The RSPCA transferred Robin over to the Blue Cross, where his rehabilitation was continued and the search for a forever home began. Robin was with the Blue Cross for over 250 days looking for a home, before starting a new life in Derbyshire with Megan.
Since then Robin has gone from strength to strength, growing in both height and personality. In what is coming up to his 2nd birthday (at an educated guess!), we are asking for donations so that we can celebrate the brilliant work that the Blue Cross does in finding ponies like Robin a forever home where they can thrive and enjoy a second chance at life.
Please donate here gofund.me/0b172ad8
Since then Robin has gone from strength to strength, growing in both height and personality. In what is coming up to his 2nd birthday (at an educated guess!), we are asking for donations so that we can celebrate the brilliant work that the Blue Cross does in finding ponies like Robin a forever home where they can thrive and enjoy a second chance at life.
Please donate here gofund.me/0b172ad8
zhlédnutí: 44
Video
Create a Simple Outlook Rule
zhlédnutí 45Před 2 lety
Part of the "Tame Your Inbox" using Outlook desktop training programme microsoft-office-training.thinkific.com/courses/tame-your-outlook-inbox
PowerPoint Design Ideas
zhlédnutí 55Před 3 lety
30 second tips and tricks for Microsoft Office PowerPoint Excel Word Outlook
Customer Testimonial - Microsoft Forms and Automed Excel Reporting
zhlédnutí 47Před 3 lety
For our client we created a bespoke solution so that staff could input their timesheets from any device i.e. mobile or laptop. The data would automatically populate an Excel database and updated reports for payroll and expenses.
Excel Nested IF Function with AND
zhlédnutí 71Před 4 lety
A nested function uses a function as one of the arguments. Excel allows you to nest up to 64 levels of functions. Users typically create nested functions as part of a conditional formula. This example demonstrates how using IF and AND function.
25 PowerPoint Tips 'n' Tricks Free Download
zhlédnutí 38Před 4 lety
What You Don't Know About PowerPoint. This 4 page document shares some of the features you may not know about. Download now. www.smeofficesupport.co.uk/25-powerpoint-tips-download
Create a Facebook Cover Video
zhlédnutí 78Před 4 lety
microsoft-office-training.thinkific.com/courses/ppt2vid The Power of PowerPoint This PowerPoint training is an innovative way to use the "Power of PowerPoint" to design and create engaging videos for marketing. The training videos focus on creating a Facebook video cover page. I’ve done all the legwork for you with regards to correct dimensions and length to upload to your Facebook business pag...
Camera, Lights, Action! Excel Camera Tool
zhlédnutí 26Před 4 lety
The Camera Tool in Excel is a very useful, yet hidden, feature. Basically, you specify a rectangular area in your workbook and the camera tool creates a mirror image of that area as a drawing object. You can move it or resize it. And whenever the contents of original rectangular area changes (charts, drawings or cell values) the mirror image changes too.
5 Methods to Select Multiple Objects in Word, Excel or PowerPoint
zhlédnutí 21KPřed 4 lety
Objects can include charts, images, slicers, text boxes, photos, call-outs, and more. This video demonstrated five ways to quickly select several shapes at once. Which option you choose might depend on whether you want to select just some of the shapes on your worksheet or all of them, or whether you are more comfortable with keyboard shortcuts versus using the ribbon menu.
Double Click Tricks in Excel
zhlédnutí 326Před 4 lety
How to use double click to: AutoFit Columns/Rows AutoFill Formula or Series Rename Sheet Tab Show/Hide Ribbon Format Painter Skip the OK button Edit Mode Navigation AutoFit Columns/Rows AutoFill Formula or Series Rename Sheet Tab Show/Hide Ribbon Format Painter Skip the OK button Edit Mode Navigation
Record and Use a Macro in Excel
zhlédnutí 15Před 5 lety
Everyone should know about recording and using macros. A little known feature to many users, rarely used, yet not overly complicated to learn. Users find their way around functions like SUM and the basic functions that count, average, and calculate your values. These functions are part of what make spreadsheets a powerful tool for crunching numbers and text. Macros, with their magic automation ...
Create a Keyboard Shortcut to Insert Your Logo
zhlédnutí 695Před 5 lety
Create a Keyboard Shortcut to Insert Your Logo
SME Office Support - Christmas Card 2018
zhlédnutí 9Před 5 lety
SME Office Support - Christmas Card 2018
Automate and track invoices using Excel - Workshop Derby 5th July 2018
zhlédnutí 109Před 6 lety
Automate and track invoices using Excel - Workshop Derby 5th July 2018
Showcase - Create a Facebook Cover Video using PowerPoint
zhlédnutí 199Před 6 lety
Showcase - Create a Facebook Cover Video using PowerPoint
Create Animated Video using the Power of PowerPoint
zhlédnutí 80Před 6 lety
Create Animated Video using the Power of PowerPoint
You have saved my life!! I work in a lab, and every time I prepare for analysis I have to fill up 13 forms, and the data goes to a certificate of analysis! I was looking through the CZcams jungle to find help and there you were!! Thank you, thank you, thank you!!!
Oh so glad it helped! 👍🏻👌🤓
Exactly what i was looking for. Thanks
I am a govt. employee. This thing really help me
In the absence of another suitable word, I just say: you are a pure genius!!
That’s lovely feedback ! Fanx 😎
Brilliant! Exactly what I was looking for.
Thank you for this great video video from other tubers show much harder way for repeated words.
Thank you so much ma'am. This is an amazing explanation. Have a great day ahead!
Fantastic workaround. WHY ISNT THIS IN MAC !@?
haha, I don't know but I can't use a MAC ! 🙂
Too too good
NICE,THANKS ALOT
Thanks
How do I stop repeat same word fill in every line? I type first line and rest repeats. I need to input diff info each line instead.
Hi, could you help me with a bit more detail so I understand what you're trying to achieve. Are you adding the same field code on each line?
@@SMEOfficeSupport can't, only by video, do you have contact? I'm screwed I can't finish resume,should fill the form today. I got ready document, I fill first line it repeats same content in the rest, how do I remove it?
@@JapanShopBrazil you should be able to right click and remove content control. Unless the document is password protected .... then you're screwed! 😕
@@SMEOfficeSupport no I almost finished editing, Ms word on Android, but can't fill the lines at the right cuz it autofill same thing in all lines, I want to remove that function
There is a publish date option in quick parts. I want to add two different date in that.. how to do it?? Bcs there r no option as publish date 1 & publish date 2.
Hi, don't think it can be done using the publish date option from document properties. Try using the Developer controls and Date Picker. Quick vid here. somup.com/c0X0oygaQE
I was looking for this and I found you... Thank you so much
Ah what an awesome tutorial! Thanks
not pro 🙃 so slow way
Thank you!
Thanks, that's great help to me
Thanx this is so helpful to me.
Very easy and its gonna change my ability to do so, thanks again
Thanks! Exactly what I was looking for! And very simple too 😊
Here's the full reference for the original video where David JP Phillips discusses these five design principles: czcams.com/video/Iwpi1Lm6dFo/video.html&ab_channel=TEDxTalks
Thank you for your comment. David is brilliant …. I learnt these design principals, and more, from David’s videos. I have referenced him in my comments. Thanks for posting the link.
What if the info has nothing to do with the categories listed?
nice...thank you for this sharing
This saves me so much time. thank you.
This is great, but I wish you credited the original creator and the project.
Hi Kelly Thanks for taking time to comment. I’d love to grant your wish but not sure exactly how. I was inspired by the brilliant JP. Philips and have credited him in the comments. I don’t understand what you mean by the project? I’m glad you thought the tips were great. Thank you.
I created this video in PowerPoint
@@SMEOfficeSupport I added the original TED talk, including the Supercar example, in a comment. Here's the full link that you may want to add in the show notes. czcams.com/video/Iwpi1Lm6dFo/video.html&ab_channel=TEDxTalks
ive done this years ago on a PC but using Microsoft 365 for Mac and dont see any of the features you are using? what do i need?
How do you add more document properties and change the name of it?
Can this be done on Mac?
Hi Kevin, sorry I don't use a Mac so would have to Google that! lol
Very very useful. Thank you so much.
Can you link several documents or files to auto populate in the same way? Or it only works on the same file?
Thank you it help me a lot, a cool and simple feature that no one knows
You’re welcome glad this helped. 😊
Thank you very much, good bless you 🙏🙏🙏
Therenne na huththo
Nice work Loved it.. You made my day man
Hello! This was very very helpful. Can you do the same with a drop-down list? Haven't found on here. So I have a drop down list with multiple options to choose from, but it does repear throughout the document. I want it to make it so I only have to choose once from that and it repeats everywhere where the same drop down box is available. Also, can you make the document properties list bigger by creating you own repeating text content controls? Thanks!
Hi, I've done a very quick vid. Hopefully you can follow: somup.com/c3ielnunCj
@@SMEOfficeSupport thank you so much!!
Is there a way to repeat the date in the subsequent headers so that it would update automatically when at a later day you change the date on the first page? Or does this have to be done manually? The template I'm using doesn't update the date automatically once I change the date on the first page.
If you use the document property for date (remember what it’s called) on your front page, you can copy paste that field in your header. That should update each time you update the front page. Sometimes you have to refresh the document. Or close and reopen. Hopefully it should work without having to do that.
Thank you so useful...just need to work out how to change the names on the document property options....some make no sense
Select the document property, you’ll need access to the developer tab (customise ribbon in options). in the developer tab you should have properties when you’ve selected the field. You can change the name there to something more relevant.
Hello Carol, if there was a heart button for your video, I would have pushed it 10 times! I was trying to read and find this feature for an hour! Then I saw your video and it is exactly what I was looking for!! Thank you!
Happy to help!!! X
Thanks for the good explanation 👍🏻👍🏻🙏🏻
oh. Thanks a lot. Love you <3
How to add the "document property" in quick part? Im form indonesia
Hi, you maybe have an older version of Word. If you can't find Document Property in Quick Parts. Try adding the command to your Quick Access Toolbar. Here's how somup.com/c3evDROVl5
@@SMEOfficeSupport Hi, thnks Carrol... for Your feedback, But, I mean, If we need additional "Field" of Document Property, so we need more than the default, Lest sample, If I need add "Web Address", "Date Created", or others "Field" so I can make more auto type template in the document form.
I have asked and asked my former colleges whom was kind of skilled in words etc. Have wanted this auto repete function for years. You did it. Now my header auto repete the text made in my table on the front sheet. Thank you a million🙂 The only thing now that wouldmake it more ideal is that i could change the "Document Property" names to match my actual subject. Like "clinet" or like Purcase no or like "document no" etc.
Hi, yes it can be done. If I've understood you correctly, copy this link into your browser to watch vid. :-) somup.com/c3eUlbTSsI
@@SMEOfficeSupport tysm that was very helpful <3
@@SMEOfficeSupport Sorry, this changes the label in the top left corner, but the original name is still visible when the field is empty! Is there a way to change this too?
@@SMEOfficeSupport Thank you for this video, the only thing is when you delete the name that you had shown, it still shows "Author" for the blank text, the label is changed but the word inside the brackets is not. Is there a way to change this too?
@@cortneyjane1 from the developer, tab choose Design Mode, then change the field content in the square brackets. When done Turn off Design Mode. X
Can this be automated and done with batches of documents or files too instead of just within one file?
I would look at MailMerge for that! You can place fields from a table in excel or Word that holds the variable information. Couple of clicks merges doc with data in fields.
@@SMEOfficeSupport interesting! Thank you very much for this I will check it out!
@@SMEOfficeSupport gosh though isnt that for email though???
@@Yapah.S.Da.K.O.S can be but also to create multiple documents. Create main doc Create table in word or excel that holds variable information i.e first, last, department In main document add variable fields I.e first, last, department Use mail merge wizard to create multiple docs I don’t have a video on this but this is a fairly good starting point support.microsoft.com/en-us/office/use-mail-merge-to-personalize-letters-d7686bb1-3077-4af3-926b-8c825e9505a3
This is exactly what I was looking for. Thank you!!
Glad it was helpful! :-)
I have been busting my butt the past day trying to figure out how to do this. Thank you for this video!!!
You’re welcome
Hi.. Thanks for the video.. I have a question, how to create more document property option? Can you explain how to use the field button?
thanks. if i need to save multiple records then what I shall do???
Hi, this method is for a documents where data is repeated throughout. You can reuse the document by saving as another file name and changing relevant data. If you have multiple records to merge into a word document you should use mail merge. Not sure if that answers your question? 🤓
Thank you for this awesome class!! I was able to create and populate auto populate field.
I have a problem in resolving an issue in word document. I am using a template and when I change a text in table, it automatically changes the header and appears the same word there. How can I stop auto update text in different pages or headings?