SMEOfficeSupport
SMEOfficeSupport
  • 93
  • 167 117
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
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
30 Second Excel Tips
zhlédnutí 42Před 2 lety
30 Second Excel Tips
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 Development - CRM
zhlédnutí 59Před 3 lety
Excel Development - CRM
Vivianne Kayne Photographer
zhlédnutí 17Před 3 lety
Vivianne Kayne Photographer
Christmas 2020
zhlédnutí 32Před 3 lety
Christmas 2020
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 ...
How to Avoid Death by PowerPoint
zhlédnutí 9KPřed 5 lety
How to Avoid Death by PowerPoint
Create a Keyboard Shortcut to Insert Your Logo
zhlédnutí 695Před 5 lety
Create a Keyboard Shortcut to Insert Your Logo
MS Word - Type Once, Repeat Many
zhlédnutí 94KPřed 5 lety
MS Word - Type Once, Repeat Many
SME Office Support - Christmas Card 2018
zhlédnutí 9Před 5 lety
SME Office Support - Christmas Card 2018
Excel worksheet emailed as pdf
zhlédnutí 68Před 6 lety
Excel worksheet emailed as pdf
Microsoft Office - Did You Know
zhlédnutí 25Před 6 lety
Microsoft Office - Did You Know
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
SHOW 'N' TELL
zhlédnutí 56Před 6 lety
SHOW 'N' TELL
SHOW OFF
zhlédnutí 41Před 6 lety
SHOW OFF
Showcase - Create a Facebook Cover Video using PowerPoint
zhlédnutí 199Před 6 lety
Showcase - Create a Facebook Cover Video using PowerPoint
SHOWTIME
zhlédnutí 37Před 6 lety
SHOWTIME
Created in PowerPoint
zhlédnutí 4Před 6 lety
Created in PowerPoint
SHOWTIME
zhlédnutí 92Před 6 lety
SHOWTIME
Create Animated Video using the Power of PowerPoint
zhlédnutí 80Před 6 lety
Create Animated Video using the Power of PowerPoint
Working with Images
zhlédnutí 43Před 6 lety
Working with Images

Komentáře

  • @nmgr30
    @nmgr30 Před 27 dny

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

  • @shradhyeshrestha298
    @shradhyeshrestha298 Před měsícem

    Exactly what i was looking for. Thanks

  • @meraz69
    @meraz69 Před 2 měsíci

    I am a govt. employee. This thing really help me

  • @user-jn6jm4bb6f
    @user-jn6jm4bb6f Před 2 měsíci

    In the absence of another suitable word, I just say: you are a pure genius!!

  • @KrisgarEntertainment
    @KrisgarEntertainment Před 2 měsíci

    Brilliant! Exactly what I was looking for.

  • @borisglusica3026
    @borisglusica3026 Před 3 měsíci

    Thank you for this great video video from other tubers show much harder way for repeated words.

  • @imdeb
    @imdeb Před 4 měsíci

    Thank you so much ma'am. This is an amazing explanation. Have a great day ahead!

  • @johnherbert3081
    @johnherbert3081 Před 4 měsíci

    Fantastic workaround. WHY ISNT THIS IN MAC !@?

  • @mnmistry
    @mnmistry Před 4 měsíci

    Too too good

  • @mrinmoydas1275
    @mrinmoydas1275 Před 7 měsíci

    NICE,THANKS ALOT

  • @user-dx7sk5qr8v
    @user-dx7sk5qr8v Před 7 měsíci

    Thanks

  • @JapanShopBrazil
    @JapanShopBrazil Před 9 měsíci

    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.

    • @SMEOfficeSupport
      @SMEOfficeSupport Před 9 měsíci

      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?

    • @JapanShopBrazil
      @JapanShopBrazil Před 9 měsíci

      @@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?

    • @SMEOfficeSupport
      @SMEOfficeSupport Před 9 měsíci

      @@JapanShopBrazil you should be able to right click and remove content control. Unless the document is password protected .... then you're screwed! 😕

    • @JapanShopBrazil
      @JapanShopBrazil Před 9 měsíci

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

  • @DailyVlogConstruction
    @DailyVlogConstruction Před 9 měsíci

    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.

    • @SMEOfficeSupport
      @SMEOfficeSupport Před 9 měsíci

      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

  • @DailyVlogConstruction
    @DailyVlogConstruction Před 9 měsíci

    I was looking for this and I found you... Thank you so much

  • @simonforster4776
    @simonforster4776 Před 10 měsíci

    Ah what an awesome tutorial! Thanks

  • @gigamada
    @gigamada Před 11 měsíci

    not pro 🙃 so slow way

  • @akmaldurrani4616
    @akmaldurrani4616 Před rokem

    Thank you!

  • @Salah.abusoul143
    @Salah.abusoul143 Před rokem

    Thanks, that's great help to me

  • @gauravgurg
    @gauravgurg Před rokem

    Thanx this is so helpful to me.

  • @circumferenceallemployeeso6006

    Very easy and its gonna change my ability to do so, thanks again

  • @L0dG
    @L0dG Před rokem

    Thanks! Exactly what I was looking for! And very simple too 😊

  • @gritprogram
    @gritprogram Před rokem

    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

    • @SMEOfficeSupport
      @SMEOfficeSupport Před rokem

      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.

  • @DeeDee-oi1xz
    @DeeDee-oi1xz Před rokem

    What if the info has nothing to do with the categories listed?

  • @CideeTV
    @CideeTV Před rokem

    nice...thank you for this sharing

  • @franmcdonald4702
    @franmcdonald4702 Před rokem

    This saves me so much time. thank you.

  • @kellyriley5280
    @kellyriley5280 Před rokem

    This is great, but I wish you credited the original creator and the project.

    • @SMEOfficeSupport
      @SMEOfficeSupport Před rokem

      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.

    • @SMEOfficeSupport
      @SMEOfficeSupport Před rokem

      I created this video in PowerPoint

    • @gritprogram
      @gritprogram Před rokem

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

  • @sarahaguirre866
    @sarahaguirre866 Před rokem

    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?

  • @alanfate4853
    @alanfate4853 Před rokem

    How do you add more document properties and change the name of it?

  • @Kevin-ci6mq
    @Kevin-ci6mq Před rokem

    Can this be done on Mac?

    • @SMEOfficeSupport
      @SMEOfficeSupport Před rokem

      Hi Kevin, sorry I don't use a Mac so would have to Google that! lol

  • @AjayKumar-gg4ds
    @AjayKumar-gg4ds Před rokem

    Very very useful. Thank you so much.

  • @jamescornejo6543
    @jamescornejo6543 Před rokem

    Can you link several documents or files to auto populate in the same way? Or it only works on the same file?

  • @farshadrostami7403
    @farshadrostami7403 Před rokem

    Thank you it help me a lot, a cool and simple feature that no one knows

  • @ahmedalkhafage4711
    @ahmedalkhafage4711 Před 2 lety

    Thank you very much, good bless you 🙏🙏🙏

  • @Beye1M
    @Beye1M Před 2 lety

    Therenne na huththo

  • @9502689129
    @9502689129 Před 2 lety

    Nice work Loved it.. You made my day man

  • @kristofkolosnagy9152
    @kristofkolosnagy9152 Před 2 lety

    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!

    • @SMEOfficeSupport
      @SMEOfficeSupport Před 2 lety

      Hi, I've done a very quick vid. Hopefully you can follow: somup.com/c3ielnunCj

    • @bonniedo2158
      @bonniedo2158 Před 2 lety

      @@SMEOfficeSupport thank you so much!!

  • @lilianafhartwig
    @lilianafhartwig Před 2 lety

    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.

    • @SMEOfficeSupport
      @SMEOfficeSupport Před 2 lety

      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.

  • @cannonjohn2618
    @cannonjohn2618 Před 2 lety

    Thank you so useful...just need to work out how to change the names on the document property options....some make no sense

    • @SMEOfficeSupport
      @SMEOfficeSupport Před 2 lety

      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.

  • @pjandjennystevens2799

    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!

  • @logeshwaran9146
    @logeshwaran9146 Před 2 lety

    Thanks for the good explanation 👍🏻👍🏻🙏🏻

  • @giabaobdsgenz
    @giabaobdsgenz Před 2 lety

    oh. Thanks a lot. Love you <3

  • @duwi.rahardi1
    @duwi.rahardi1 Před 2 lety

    How to add the "document property" in quick part? Im form indonesia

    • @SMEOfficeSupport
      @SMEOfficeSupport Před 2 lety

      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

    • @duwi.rahardi1
      @duwi.rahardi1 Před 2 lety

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

  • @JanManger1
    @JanManger1 Před 2 lety

    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.

    • @SMEOfficeSupport
      @SMEOfficeSupport Před 2 lety

      Hi, yes it can be done. If I've understood you correctly, copy this link into your browser to watch vid. :-) somup.com/c3eUlbTSsI

    • @idirrahem7026
      @idirrahem7026 Před 2 lety

      @@SMEOfficeSupport tysm that was very helpful <3

    • @theneat88
      @theneat88 Před rokem

      @@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?

    • @cortneyjane1
      @cortneyjane1 Před rokem

      @@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?

    • @SMEOfficeSupport
      @SMEOfficeSupport Před rokem

      @@cortneyjane1 from the developer, tab choose Design Mode, then change the field content in the square brackets. When done Turn off Design Mode. X

  • @Yapah.S.Da.K.O.S
    @Yapah.S.Da.K.O.S Před 2 lety

    Can this be automated and done with batches of documents or files too instead of just within one file?

    • @SMEOfficeSupport
      @SMEOfficeSupport Před 2 lety

      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.

    • @Yapah.S.Da.K.O.S
      @Yapah.S.Da.K.O.S Před 2 lety

      @@SMEOfficeSupport interesting! Thank you very much for this I will check it out!

    • @Yapah.S.Da.K.O.S
      @Yapah.S.Da.K.O.S Před 2 lety

      @@SMEOfficeSupport gosh though isnt that for email though???

    • @SMEOfficeSupport
      @SMEOfficeSupport Před 2 lety

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

  • @adamkwiatek318
    @adamkwiatek318 Před 2 lety

    This is exactly what I was looking for. Thank you!!

  • @MindHunger
    @MindHunger Před 2 lety

    I have been busting my butt the past day trying to figure out how to do this. Thank you for this video!!!

  • @mohdirwanshah5694
    @mohdirwanshah5694 Před 2 lety

    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?

  • @awan4777
    @awan4777 Před 2 lety

    thanks. if i need to save multiple records then what I shall do???

    • @SMEOfficeSupport
      @SMEOfficeSupport Před 2 lety

      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? 🤓

  • @ivettecarmen869
    @ivettecarmen869 Před 2 lety

    Thank you for this awesome class!! I was able to create and populate auto populate field.

  • @Moon3pell
    @Moon3pell Před 2 lety

    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?