Excel at the Office
Excel at the Office
  • 69
  • 175 749
How to Delay Screenshot with Snipping Tool in Windows
Did you know, the Snipping Tool (aka 'Snip and Sketch') in Windows has a DELAY function? Few people do, but it's a big help, handy for when you want to postpone the targeted screen snip for a few seconds.
For example if you want it to wait until you're in presentation mode before taking your screenshot, or if you want a screengrab of a particular bit of a video. Whatever it is, this gives you time to get the the bit you want to screenshot.
____________________________
Chapters
0:00 - Intro & why helpful
0:55 - How to delay snip
1:46 - Save & close
_________________
I hope you've found this helpful. See my other videos or blogs with more tips to excel at the office:
excelattheoffice.com/blog
Please support my work...
Buy Coffee:
eato.blog/buy-coffee
Quirky and unique t-shirts:
eato.teemill.com
Kind Regards,
Adrian
Переглядів: 56

Відео

Easily Compress Video File Size, Keeping HD Quality!
Переглядів 101Місяць тому
Are your MP4, MOV, or WMV video files too big to handle? Want an easy way to shrink them by up to 90% in size, without noticeable quality loss? Can't find a solution or want the cost and steep learning curve of video editing software? Then this is for you! UA-cam's advanced video compression technology is something you can use too! Upload your video in any format, let the UA-cam sausage machine...
"You've Been Hacked, Pervert" - Run Through of 'Pegasus' Email Scam (Don't Worry)
Переглядів 1,6 тис.Місяць тому
Hopefully this email was cleaned into your junk folder. But if you've received such an email with the subject "You've Been Hacked" (or Haked!), don't worry. In this video I run through the phishing email scam which begins "Hello Pervert". Chapters 0:00 - How to spot scam emails 2:20 - About 'Pegasus', scams 4:50 - Read through of email & tips 13:00 - Online security care & close I hope you've f...
Unique and Fun T-Shirts for Men and Women
Переглядів 232 місяці тому
Here's an overview of a new option to support my work. In essence, you get a fab new t-shirt with a unique design, and I'll receive a couple of £ from the sale. I'm open to design ideas, so let me know what you'd like! In this video I run through the website, how it works, and some of the designs. I'll be adding more designs over time. Here's a link to those quirky and unique t-shirts: eato.tee...
Quickly Fix Excel FORMULAS Displaying as TEXT in Excel
Переглядів 9653 місяці тому
Are your Excel formulas showing as text, rather than calculating things? Can't find solution online? Here's a quick fix to resolve and remove this annoyance! I hope you find this helpful. Let me know your thoughts and questions in the comments, and feel free to suggest other topics to cover! Chapters 0:00 - Issue & quick solution 0:56 - Common "solutions" 1:51 - FIX with Text format 3:28 - Prev...
Easily Convert Speech into Text using MS Word: Transcribe AND Audio Files
Переглядів 3053 місяці тому
This could be a MASSIVE time saver! Here's how to convert spoken voice into written text using Microsoft Word's Dictation tool. Whether you want to dictate the text via a microphone or transcribe an audio file, this few minutes might change your entire working life. I'll demo how it works, the settings to use, how to dictate grammar, and even fix a common microphone access issue if yours doesn'...
AUDACITY 3.6 for Podcast and Voiceover - Noise, Amplify, Limiter, Filters and More
Переглядів 4403 місяці тому
I previously did a tutorial on Audacity 3.5, but with the release of 3.6 I've had to adapt my workflow. That's because Audacity have had the audacity (sorry!) to change several of the tools. After extensive research, I now use the normaliser, equaliser, limiter, noise reduction, amplifier, and other tools to enhance podcast voiceover audio. Here's how to edit your audio and the best settings to...
Quick and Easy PIVOT TABLES and SLICERS in Excel
Переглядів 724 місяці тому
Here's a brief video on how to create and use Excel Pivot Tables and Slicers. This will transform your workflow if you're not using these features already to analyse, summarise and interact with data. You'll understand the essentials in just 5 minutes. See my video series on creating dashboards if you'd like to learn more in-depth about the power of these and taking things to the next level. Li...
Excel Dynamic HR DASHBOARD - Part 7 FINAL TOUCHES!
Переглядів 5916 місяців тому
In the finale of how to create a dashboard in Excel, we'll put on the finishing touches for your audience. I show you how to create an introduction page, create buttons to aid navigation, hide technical sheets, remove the rulers and grid, insert update instructions, and more. You've done the hard work on the more technical dashboard in the videos so far, so why not make your Excel file feel lik...
How to Get Data from Picture into Excel Spreadsheet - MASSIVE Time Saver!
Переглядів 7716 місяців тому
Did you know that in Excel, there's an AI-driven tool allowing you to convert characters from any picture (e.g. JPEG, PNG) into useable spreadsheet data? Wow! In this quick video I show you how to import data from an image in Excel, how the AI works, plus how to make it work with good quality pictures. Just think about the potential uses: - You've found a table of data in an old book you want t...
Excel Dynamic HR DASHBOARD - Part 6 SLICERS
Переглядів 7827 місяців тому
In PART 6 of how to create a dashboard in Excel, we'll now insert the slicers to make the dashboard truly dynamic and interactive. I show you how to insert a slicer to filter the pivot data, custom format your slicer styles, use timeline slicers, link up to the pivots through 'report connections' and much more along the way to aid your workflow. It's a long-ish video but this stuff takes time t...
Excel Dynamic HR DASHBOARD - Part 5 MAKE CHARTS AND GRAPHS
Переглядів 3427 місяців тому
In PART 5 of how to create a dashboard in Excel, we'll now create all the nice charts and graphs which represent your data to the viewer. I show you how to create a mix of smart text boxes, pie charts, bar charts, donut charts, and stacked bars. Plus there's loads of workflow tips along the way as usual, including a quick hack to copy chart formats to new charts! It's a long-ish video but this ...
Create Excel Dynamic HR DASHBOARD - Part 4 DASHBOARD CANVAS PREP
Переглядів 4847 місяців тому
In PART 4 of how to create a dashboard in Excel, I demonstrate how you organise and prepare a clean canvas for the dashboard which will receive all your charts and slicers, which we'll cover in later videos. Having a clean design and clear page breaks are imperative for presenting your reports well. The work you do here will pay dividends later! I guide you through slowly and clearly, addressin...
Create Excel Dynamic HR DASHBOARD - Part 3 PIVOT TABLES
Переглядів 1,2 тис.7 місяців тому
In PART 3 of how to create a dashboard in Excel, I demonstrate how you create all the PIVOT TABLES which will feed your charts and slicers, which we'll cover later. Pivot tables are your first main step to automate your interactive analysis of the data. Excel pivot tables are such a time saver, many people stop here in terms of data summaries. This is an essential step to get right, so I guide ...
Create Stunning Dynamic HR DASHBOARD in Excel - Part 2 Data and Formulas
Переглядів 1,2 тис.7 місяців тому
Create Stunning Dynamic HR DASHBOARD in Excel - Part 2 Data and Formulas
BBC TV Licence Fee 2024 Analysis - Charts, Formats and Excel Workflow Follow-Along
Переглядів 1107 місяців тому
BBC TV Licence Fee 2024 Analysis - Charts, Formats and Excel Workflow Follow-Along
Create Stunning Dynamic HR DASHBOARD in Excel - Part 1 Intro and Demo
Переглядів 1,2 тис.8 місяців тому
Create Stunning Dynamic HR DASHBOARD in Excel - Part 1 Intro and Demo
How to Manage a Project in 3 Simple Steps and PRINCE2 Simplified
Переглядів 2978 місяців тому
How to Manage a Project in 3 Simple Steps and PRINCE2 Simplified
Make AMAZING Excel Charts like a PRO - Stacked Bars and Dumbbell Plot
Переглядів 1,1 тис.8 місяців тому
Make AMAZING Excel Charts like a PRO - Stacked Bars and Dumbbell Plot
How to Create PIVOT TABLES and PIVOT CHARTS in Excel (and then format nicely!)
Переглядів 1,7 тис.8 місяців тому
How to Create PIVOT TABLES and PIVOT CHARTS in Excel (and then format nicely!)
How to ADD NEW DATA to Excel Chart and AUTO UPDATE your Graphs
Переглядів 3,6 тис.9 місяців тому
How to ADD NEW DATA to Excel Chart and AUTO UPDATE your Graphs
Reduce File Size by COMPRESSING IMAGES in Word, PowerPoint - 3 Clicks!
Переглядів 3009 місяців тому
Reduce File Size by COMPRESSING IMAGES in Word, PowerPoint - 3 Clicks!
Fix Audio in AUDACITY: Background NOISE, ECHO, AMPLIFY, CLIP, LIMIT PEAKS, and more
Переглядів 5 тис.9 місяців тому
Fix Audio in AUDACITY: Background NOISE, ECHO, AMPLIFY, CLIP, LIMIT PEAKS, and more
STOP New Default Colour Palette in Word - Also works for Excel and PowerPoint (2 mins)
Переглядів 7459 місяців тому
STOP New Default Colour Palette in Word - Also works for Excel and PowerPoint (2 mins)
Reduce Voice ECHO and Amplify VOLUME of Audio with AUDACITY
Переглядів 10 тис.9 місяців тому
Reduce Voice ECHO and Amplify VOLUME of Audio with AUDACITY
Create New MS Word Document from Scratch: With IMPACTIVE Structure and Handy Tips!
Переглядів 4249 місяців тому
Create New MS Word Document from Scratch: With IMPACTIVE Structure and Handy Tips!
How to Keep Text Within MS Word Document Table Margins
Переглядів 2 тис.10 місяців тому
How to Keep Text Within MS Word Document Table Margins
Reduce Noise in Audio File Using AUDACITY - EASY
Переглядів 1,1 тис.10 місяців тому
Reduce Noise in Audio File Using AUDACITY - EASY
How to Get TEXT into Excel TABLE - From .txt file or website
Переглядів 1,1 тис.10 місяців тому
How to Get TEXT into Excel TABLE - From .txt file or website
How to Change Text from UPPERCASE to lowercase in MS Word
Переглядів 5 тис.11 місяців тому
How to Change Text from UPPERCASE to lowercase in MS Word

КОМЕНТАРІ

  • @tomcashman4123
    @tomcashman4123 18 годин тому

    perfect!! Thanks mate!

  • @elksalmon84
    @elksalmon84 День тому

    This is far easier to do on spectrogram. Unfortunately Audacity doesn't have good spectrogram capabilities. And spectrogram is very low resolution.

  • @Sunryft
    @Sunryft 4 дні тому

    Thanks dude, I got an exam/final over excel tomorrow and I did not understand this concept. You would think it would be under the the big box that says track changes, but no!! Its not why!!!

  • @chezer9236
    @chezer9236 5 днів тому

    Got one like this yesterday only seen it today though. I guess we'll find out in 48 hours whether my life's ruined 😂

  • @mansourhaidary7900
    @mansourhaidary7900 5 днів тому

    goated

  • @laurenhunter6973
    @laurenhunter6973 7 днів тому

    Thank you sir! You saved my final paper in grad school! You speak clearly, get straight to the point, and are very knowledgeable - I hope you keep making videos!

    • @excelattheoffice9012
      @excelattheoffice9012 5 днів тому

      Thanks for your most kind feedback @laurenhunter6973, and glad to have assisted I know how stressful it can be!

  • @Idkreally15
    @Idkreally15 8 днів тому

    Thank you I was nervous when I got one just like thsi

  • @alex_santacreu03
    @alex_santacreu03 9 днів тому

    from Spain, yesterday I received one of these emails, at first I said what the hell is this but watching these videos I already see that it is a scam hahaha

    • @alex_santacreu03
      @alex_santacreu03 8 днів тому

      And a question, don't you have any kind of access to my phone? It's just that a few days ago before I received this email, they tried to change my passwords and emails for many Google websites and apps.

  • @luvvshuu
    @luvvshuu 11 днів тому

    got this exact email last night and i was really panicked, but this video gave me a good laugh lol

    • @excelattheoffice9012
      @excelattheoffice9012 11 днів тому

      Glad to brighten your day. Now send me your monies, otherwise I'll dish the dirt on what you put in your tacos...

    • @Seanus32
      @Seanus32 6 днів тому

      @@excelattheoffice9012 Haked, lol. There's phishing and there's fishing :) Nice vid :)

  • @toxicdragon323
    @toxicdragon323 12 днів тому

    I got one of these yesterday. Joke was on that clown who sent it to me. I keep the camera lens of my laptop covered. So even in the off chance that they were able to gain access to my camera in an attempt to try to catch me doing...things, they're not going to get anything with the lens covered. I'm not paying those bums a penny. They want money, they can get a job like everyone else. 😆

  • @avazjonaminjonov
    @avazjonaminjonov 12 днів тому

    You saved me bro. Thanks.

  • @rnavarrorubio
    @rnavarrorubio 17 днів тому

    Thank you so much!

  • @leyrechinchilla3504
    @leyrechinchilla3504 18 днів тому

    thanksss

  • @ThisIsOurRetirement
    @ThisIsOurRetirement 19 днів тому

    Very useful, Thank you

  • @GoatOfTheWoods
    @GoatOfTheWoods 20 днів тому

    Thank you!

  • @work.rest.pray.6537
    @work.rest.pray.6537 22 дні тому

    Really helpful many thanks. Am new to Audacity and podcasting - got the basics of recording, editing but the rest baffled me so feel much more confident now. Thank you.

  • @lamontcranston5560
    @lamontcranston5560 Місяць тому

    AHH! I am trying to do exactly this, EXCEPT I'm inserting a new column at the beginning as new data comes out every day. So, in your example I'd be adding a today's date in column "AD" ahead of existing data in "AD" and every time i do, the chart shifts the plotted data 1 column right and only includes "AE" and onward (It does correctly compensate and shift the end to now "AP" as opposed to "AO") How do I get it to ALWAYS stay plotting from "AD" to the end? (I want the compensation to remain shifting the end of the data 1 column right still)

    • @excelattheoffice9012
      @excelattheoffice9012 28 днів тому

      I'd recommend having the chart look at data from AD. But keep AD blank, then insert column before AE each time (your latest day). Normally, I set stuff up so the new data is added as a new column on the right, not the left, to match a logical timeline. But let me know if you find a solution!

  • @emmbeech
    @emmbeech Місяць тому

    Thank you! Oh god, yes, you have saved lives.

  • @Harros-bb1
    @Harros-bb1 Місяць тому

    Super helpful! Is there a way to use this window presentation view but also have access to the slideshow notes/control center for PPT?

    • @excelattheoffice9012
      @excelattheoffice9012 Місяць тому

      Most welcome! Not sure about that bit, but will explore. Let me know if you find anything helpful on this too.

  • @hermandorfling4001
    @hermandorfling4001 Місяць тому

    This is awesome. Thank you!

  • @libzab
    @libzab Місяць тому

    THANK YOU!

  • @PeteMel1875
    @PeteMel1875 Місяць тому

    Hi, Is this for removing echo/reverb on something the at already has it on?

    • @excelattheoffice9012
      @excelattheoffice9012 Місяць тому

      Yes, removing/reducing the echo on an audio track to make it sound clearer.

  • @pclaw881
    @pclaw881 Місяць тому

    If you have multiple tracks, would you normalize and master each track individually? I get my recording from CraigBot on Discord and it gives me separate tracks for each player.

  • @monicaivy2497
    @monicaivy2497 Місяць тому

    Thank you for the video...great job!

  • @tkuzmic1
    @tkuzmic1 Місяць тому

    Yes, that is a workaround because excel obviously lacks that option. But in VS when I use chart control there is an option "reversed order" for legend...

    • @excelattheoffice9012
      @excelattheoffice9012 Місяць тому

      Thanks, good to know! What is VS please?

    • @tkuzmic1
      @tkuzmic1 Місяць тому

      @@excelattheoffice9012 Visual studio.

    • @tkuzmic1
      @tkuzmic1 Місяць тому

      ​@@excelattheoffice9012Visual Studio

  • @nosajselwonk9687
    @nosajselwonk9687 Місяць тому

    I am a Nigerian prince. Monies

  • @mikemayo4812
    @mikemayo4812 Місяць тому

    lol... What's so controversial about porn? If you're a guy, everyone already knows you watch porn. As long as you're not looking at children, you should have no shame.

    • @yung-megafone
      @yung-megafone Місяць тому

      @@mikemayo4812 "but my family will find out" Chances are high that even your innocent grandfather gets lost in the sauce every so often

  • @adamp9011
    @adamp9011 Місяць тому

    Chancers, even funnier when you don't have a web cam in the first place.

  • @LoadinGTX
    @LoadinGTX Місяць тому

    fuckin A , thanks man lol Christ bless you

  • @Mr.Bones.21
    @Mr.Bones.21 Місяць тому

    What a funny little scammer, too bad people fall for this kind of scams

    • @Rodhern
      @Rodhern Місяць тому

      Indeed, the scammer is into funny. Just like the UA-cam auto captions say: "I've recorded many videos of you joking."

  • @masakonamulanga2646
    @masakonamulanga2646 2 місяці тому

    Thanks that tool was being troublesome when dealing with my data.

  • @Daeon108
    @Daeon108 2 місяці тому

    What about pivot charts & slicers?

  • @ganeshs1360
    @ganeshs1360 2 місяці тому

    Does this apply to all the workbooks or just specific to the workbook where we are applying it?

    • @excelattheoffice9012
      @excelattheoffice9012 2 місяці тому

      Try doing the settings, then open up a new workbook to see if still applied there too.

  • @Couriosity
    @Couriosity 2 місяці тому

    Excellent❤

  • @zamanmakan2729
    @zamanmakan2729 2 місяці тому

    Thank you so much, you saved so much of my time 😃! It works perfectly!

  • @wrld-lain1629
    @wrld-lain1629 2 місяці тому

    Awesome work, finally a video that actually helps with removing echo, not clickbait. Thank you very much, I hope you get a lot more views :)

    • @excelattheoffice9012
      @excelattheoffice9012 2 місяці тому

      Yes, I created for that reason! Glad it helped and thank you.

  • @SucceedbyForce
    @SucceedbyForce 2 місяці тому

    Thanks!

  • @AndyMcKeeman
    @AndyMcKeeman 2 місяці тому

    Managed to fill a whole swear jar with this b*@$ard - there goes another £1. Top tip. Many thanks

  • @SALMAN-td9ez
    @SALMAN-td9ez 2 місяці тому

    You are lifesaver thanks

  • @yahyaayman5894
    @yahyaayman5894 2 місяці тому

    Thanks, the rest of youtube videos are about noise reduction

  • @Pinballtec
    @Pinballtec 2 місяці тому

    Thank you. Every reference I've come across dealing with this seemed to focus on rows, where I have all my moving data in columns.

  • @debbieday5812
    @debbieday5812 2 місяці тому

    Thank you very much!

  • @zobecookingcorner4391
    @zobecookingcorner4391 2 місяці тому

    tnx

  • @japeireland
    @japeireland 3 місяці тому

    Thank you ...I was going crazy with the stupid markups!

  • @jukkis6699
    @jukkis6699 3 місяці тому

    thank you very much!

  • @ne13abj
    @ne13abj 3 місяці тому

    thanks

  • @AprilWatters
    @AprilWatters 3 місяці тому

    Can it work for video files?

    • @excelattheoffice9012
      @excelattheoffice9012 3 місяці тому

      Audacity works on audio files only. I would recommend a video editing software (or online converter tool) to first separate the audio from the video, run that audio through Audacity, then create video again with that audio. Microsoft Clipchamp is quite good for video editing, or iMovie for Mac.

  • @JasenomadeTV
    @JasenomadeTV 3 місяці тому

    You are the best, thank you x

  • @rchandos
    @rchandos 3 місяці тому

    I have once again turned to this website for answers not found anywhere else. Thank you.

  • @DeepSkyChronicles-m8b
    @DeepSkyChronicles-m8b 3 місяці тому

    Thank you so much, as you said probably the most anoying feature ef this peace of software. Good job !