- 68
- 156 142
Excel at the Office
United Kingdom
เข้าร่วมเมื่อ 3 ม.ค. 2022
I aim to help you save time and advance your career, by better finding your way round Microsoft Office and other work-related skills. Whether it's apps like MS Excel, PowerPoint, Word, or even Audacity, or skills like project management, dashboards, and report writing.
I hope you find the content useful and let me know if you'd like to commission bespoke training, templates, or dashboards for your company. See my blog for more info and support at eato dot blog.
I hope you find the content useful and let me know if you'd like to commission bespoke training, templates, or dashboards for your company. See my blog for more info and support at eato dot blog.
Easily Compress Video File Size, Keeping HD Quality!
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!
TH-cam's advanced video compression technology is something you can use too! Upload your video in any format, let the TH-cam sausage machine do its thing, then you can download a far smaller file size (but at the same resolution) as an MP4!
This is great if you want to keep copies of your videos without taking up too much space, or want to more easily share them with others.
____________________________
Chapters
0:00 - Intro
0:20 - Problem of big video files
1:20 - Why using TH-cam is good
3:10 - How to reduce file size
5:10 - Recap & 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
TH-cam's advanced video compression technology is something you can use too! Upload your video in any format, let the TH-cam sausage machine do its thing, then you can download a far smaller file size (but at the same resolution) as an MP4!
This is great if you want to keep copies of your videos without taking up too much space, or want to more easily share them with others.
____________________________
Chapters
0:00 - Intro
0:20 - Problem of big video files
1:20 - Why using TH-cam is good
3:10 - How to reduce file size
5:10 - Recap & 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
มุมมอง: 13
วีดีโอ
"You've Been Hacked, Pervert" - Run Through of 'Pegasus' Email Scam (Don't Worry)
มุมมอง 93521 วันที่ผ่านมา
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
มุมมอง 18หลายเดือนก่อน
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
มุมมอง 564หลายเดือนก่อน
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
มุมมอง 104หลายเดือนก่อน
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
มุมมอง 3672 หลายเดือนก่อน
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
มุมมอง 553 หลายเดือนก่อน
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!
มุมมอง 5755 หลายเดือนก่อน
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!
มุมมอง 5025 หลายเดือนก่อน
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
มุมมอง 7315 หลายเดือนก่อน
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
มุมมอง 3076 หลายเดือนก่อน
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
มุมมอง 4286 หลายเดือนก่อน
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.1K6 หลายเดือนก่อน
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.1K6 หลายเดือนก่อน
Here I outline the first steps to creating an Excel dashboard: Setting up your tabs, colours, and most importantly sorting data and creating category formulas. It's a long-ish video but this stuff takes time to do right and be assured you can learn dashboards within a day. I take you through each step slowly and methodically, with lots of Excel tips along the way. I cover: - Setting up your wor...
BBC TV Licence Fee 2024 Analysis - Charts, Formats and Excel Workflow Follow-Along
มุมมอง 806 หลายเดือนก่อน
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
มุมมอง 1K6 หลายเดือนก่อน
Create Stunning Dynamic HR DASHBOARD in Excel - Part 1 Intro and Demo
How to Manage a Project in 3 Simple Steps and PRINCE2 Simplified
มุมมอง 2337 หลายเดือนก่อน
How to Manage a Project in 3 Simple Steps and PRINCE2 Simplified
Make AMAZING Excel Charts like a PRO - Stacked Bars and Dumbbell Plot
มุมมอง 9827 หลายเดือนก่อน
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.5K7 หลายเดือนก่อน
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
มุมมอง 3K8 หลายเดือนก่อน
How to ADD NEW DATA to Excel Chart and AUTO UPDATE your Graphs
Reduce File Size by COMPRESSING IMAGES in Word, PowerPoint - 3 Clicks!
มุมมอง 2748 หลายเดือนก่อน
Reduce File Size by COMPRESSING IMAGES in Word, PowerPoint - 3 Clicks!
Fix Audio in AUDACITY: Background NOISE, ECHO, AMPLIFY, CLIP, LIMIT PEAKS, and more
มุมมอง 4.7K8 หลายเดือนก่อน
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)
มุมมอง 6788 หลายเดือนก่อน
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
มุมมอง 9K8 หลายเดือนก่อน
Reduce Voice ECHO and Amplify VOLUME of Audio with AUDACITY
Create New MS Word Document from Scratch: With IMPACTIVE Structure and Handy Tips!
มุมมอง 3518 หลายเดือนก่อน
Create New MS Word Document from Scratch: With IMPACTIVE Structure and Handy Tips!
How to Keep Text Within MS Word Document Table Margins
มุมมอง 1.6K8 หลายเดือนก่อน
How to Keep Text Within MS Word Document Table Margins
Reduce Noise in Audio File Using AUDACITY - EASY
มุมมอง 1K9 หลายเดือนก่อน
Reduce Noise in Audio File Using AUDACITY - EASY
How to Get TEXT into Excel TABLE - From .txt file or website
มุมมอง 7829 หลายเดือนก่อน
How to Get TEXT into Excel TABLE - From .txt file or website
How to Change Text from UPPERCASE to lowercase in MS Word
มุมมอง 4.1K10 หลายเดือนก่อน
How to Change Text from UPPERCASE to lowercase in MS Word
PowerPoint: Maximise Text with Multiple Columns and Bespoke Line Spacing
มุมมอง 31010 หลายเดือนก่อน
PowerPoint: Maximise Text with Multiple Columns and Bespoke Line Spacing
Thank you! Oh god, yes, you have saved lives.
Lol, awesome!
Super helpful! Is there a way to use this window presentation view but also have access to the slideshow notes/control center for PPT?
Most welcome! Not sure about that bit, but will explore. Let me know if you find anything helpful on this too.
This is awesome. Thank you!
You're very welcome!
THANK YOU!
Hi, Is this for removing echo/reverb on something the at already has it on?
Yes, removing/reducing the echo on an audio track to make it sound clearer.
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.
Thank you for the video...great job!
My pleasure.
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...
Thanks, good to know! What is VS please?
@@excelattheoffice9012 Visual studio.
@@excelattheoffice9012Visual Studio
I am a Nigerian prince. Monies
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.
@@mikemayo4812 "but my family will find out" Chances are high that even your innocent grandfather gets lost in the sauce every so often
Chancers, even funnier when you don't have a web cam in the first place.
fuckin A , thanks man lol Christ bless you
What a funny little scammer, too bad people fall for this kind of scams
Indeed, the scammer is into funny. Just like the TH-cam auto captions say: "I've recorded many videos of you joking."
Thanks that tool was being troublesome when dealing with my data.
What about pivot charts & slicers?
Does this apply to all the workbooks or just specific to the workbook where we are applying it?
Try doing the settings, then open up a new workbook to see if still applied there too.
Excellent❤
Thank you so much, you saved so much of my time 😃! It works perfectly!
You're welcome!
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 :)
Yes, I created for that reason! Glad it helped and thank you.
Thanks!
Managed to fill a whole swear jar with this b*@$ard - there goes another £1. Top tip. Many thanks
Brilliant, glad to help save you some cash!
You are lifesaver thanks
Happy to help
Thanks, the rest of youtube videos are about noise reduction
You're welcome!
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.
Awesome, glad it helped!
Thank you very much!
You're welcome!
tnx
Thank you ...I was going crazy with the stupid markups!
Most welcome!
thank you very much!
Very welcome!
thanks
Can it work for video files?
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.
You are the best, thank you x
You’re welcome 😊
I have once again turned to this website for answers not found anywhere else. Thank you.
Welcome back and glad to help!
Thank you so much, as you said probably the most anoying feature ef this peace of software. Good job !
Most welcome.
Adrian, thank you, nice clear instructions, you saved my day.
Ideal, glad to help
You the best bro. TH-cam need to push this
Thanks, yes I don't think YT bumps my stuff yet!
Great video! Thank you.
Most welcome, glad you liked!
Did a search for this only to find videos using the noise reduction tool which was useless. This video was exactly what I needed. Many thanks.
Glad to help!
U are great
super helpful, the only thing that helped ! thank you !
Glad it helped!
Those suggested settings worked well for me. Thanks!
Glad it helped!
unchecking those boxes does not resolve my formatting issue when using slicers.
Yeah, same issue... I was so excited when i found this solution then que the sad trombone
I'll try that soon. Thank you!
Thank you sooo much sir .......❤❤❤
Most welcome!
god bless you, i thank you VERY, VERY much, have a great day.................
Most welcome!
This is pure gold. Thanks for the video
Glad you enjoyed it!
Came here looking for ideas. I’ve got a combo graph of line and clustered column. I can reorder the line parts of the legend or reorder the bar parts of the legend. But for the life of me can’t find a way to choose whether the bar or line entries appear first or second. Currently it is showing all bar ones first and I want the bar entries to be second in the legend - my search continues.
Hi @Ironbuket, I'm not sure I totally understand the question but my first instinct is it probably has something to do with the order of each series under 'Select Data', try moving them up or down. If you do find a good answer elsewhere, I'd be interested to know anyway!
@@excelattheoffice9012 Nope, its not the series order already tried that before watching your video as that is the more common solution suggested
Thank you so much for posting this. I accidently hit the short cut to turn track changes on. Why on earth is a short cut needed for track changes??
I know, frustrating, hence why I did video. Glad it helped!
Thank you. this was so helpful 😊
Most welcome! Note that Audacity v3.6 does things slightly different, so watch out for another video in due course.
Hi Thanks for the video. Say you have a chart for the USA and a Chart for the UK separately. What would you do to have Excel update those charts when you add a new column? This differs from what you described in the video because you have to update every chart separately now. Thanks.
I would probably go for having my measures feeding my UK chart on one row, then the USA on an equivalent row underneath lined up, then I only need to inset a column once (rather than have for example on separate sheets). Hope that helps!
So simple!! And other searches turned up multi-step processes that didn't even work. You made my day! Thanks!
I know, right? Such a 'doh!' moment when you know, but completely unintuitive how this works and no easy explainers elsewhere. Glad to help!