![Paul O'Malley](/img/default-banner.jpg)
- Видео 193
- Просмотров 909 197
Paul O'Malley
Австралия
Добавлен 10 авг 2010
I'm a tech geek at heart, and I love discovering cool ways to get the most out of tools like Microsoft 365 and Google Workspace. I specialise in assisting others with maximising their productivity with these tools. Feel free to follow me for weekly tips and tricks!
AI Running on Your PC/Mac in Minutes! Complete Msty Walkthrough!
Welcome to this comprehensive walkthrough on how to use local LLMs with Msty! 🌟 Have you ever felt both excited and overwhelmed at the thought of using AI language models? Do you wish you had a ChatGPT app for your Windows PC?
These tech wonders can write stories, answer questions, and even generate code, but setting them up on your computer can feel like navigating a maze blindfolded. That's where Msty comes in to save the day!
In this video, I'll guide you through every step of the process-from downloading and installing Msty to using both local and online AI models effortlessly. You'll learn how to set up model instructions, create knowledge stacks, explore split chats, and manage your c...
These tech wonders can write stories, answer questions, and even generate code, but setting them up on your computer can feel like navigating a maze blindfolded. That's where Msty comes in to save the day!
In this video, I'll guide you through every step of the process-from downloading and installing Msty to using both local and online AI models effortlessly. You'll learn how to set up model instructions, create knowledge stacks, explore split chats, and manage your c...
Просмотров: 163
Видео
🤯 Translate ANYTHING in Excel!
Просмотров 24314 дней назад
Unlock the power of Excel's hidden language tools! In this tutorial, you'll learn how to translate text in Excel from any language to English (and vice versa!) using the amazing DETECTLANGUAGE and TRANSLATE functions. I cover: - Identifying unknown languages in your spreadsheets - Translating single cells and entire columns - Creating dynamic formulas for automatic multilingual translation - Pr...
Sync Google Sheets Like a Pro: IMPORTRANGE, QUERY, and ARRAYFORMULA Explained! 🚀
Просмотров 21921 день назад
Are you tired of manually copying and pasting data between Google Sheets? Say goodbye to the hassle and hello to seamless data syncing! In this video, I'll show you how to effortlessly sync your Google Sheets using powerful functions like IMPORTRANGE, QUERY, and ARRAYFORMULA. Whether you're a beginner or a spreadsheet ninja, this tutorial will transform the way you manage your data. You'll Lear...
Mastering Chat GPT: Best Practices for Creating Custom GPTs
Просмотров 1,1 тыс.Месяц назад
Welcome to my in-depth walkthrough guide on the best practices for creating custom GPTs! Have you ever wished ChatGPT could handle those hyper-specific tasks that take up your time? Whether it’s generating stunning images, drafting detailed reports, or coding in a specific style, custom GPTs can transform ChatGPT into your personal AI assistant tailored to your needs. In this comprehensive tuto...
Batch Create Folders in Windows with help from Excel! 🚀
Просмотров 103Месяц назад
Tired of creating folders one by one on your Windows PC? Say goodbye to the drudgery and hello to efficiency! In this video, I'll show you a powerful trick using Excel to batch create folders in Windows. Instead of manually creating each folder, we'll use Excel to help us automate the process, saving you a ton of time and effort. Follow along as we take you step-by-step through: 1. Setting up y...
Figma Slides Complete Walkthrough: Stunning Interactive Presentations! 🎨
Просмотров 2,7 тыс.Месяц назад
Welcome to this ultimate guide on how to use Figma Slides! If you're tired of wrestling with clunky presentation software and inconsistent designs, this video is for you. Discover how Figma Slides can revolutionise your presentation game by allowing you to design, collaborate, and present all within the familiar Figma environment. In this video, I'll walk you through: - Setting up your first Fi...
Unlock Amazing Excel Features with Python (No Coding Experience Needed) 📈
Просмотров 231Месяц назад
Tired of boring spreadsheets? 🤯 Unleash the power of Python in Excel! This beginner-friendly tutorial will teach you how to activate Python, write your first lines of code, analyse data, and create stunning charts - all without prior programming experience. Learn to harness the power of both tools for enhanced data manipulation, analysis, and visualisation. 📈 In this video, you'll discover: - H...
🔠 How to Embed Fonts in PowerPoint: Never Have Messed Up Slides Again!
Просмотров 168Месяц назад
Have you ever crafted the perfect PowerPoint presentation only to see it fall apart on another computer? Don't let missing fonts ruin your hard work! In this video, I'll show you how to embed fonts in PowerPoint, ensuring your slides look exactly as you intended, no matter where they're viewed. I'll guide you through: 1. Embedding fonts step-by-step 2. Choosing the right font embedding options ...
🚀 Elevate Your Group Projects: Mastering Collaboration with NotebookLM!
Просмотров 2292 месяца назад
Welcome to our ultimate guide on how to collaborate effectively using NotebookLM! 🌌 Are you and your team gearing up for a group project or research assignment? Navigating through heaps of data and research papers can feel like a cosmic maze, but fear not! NotebookLM is here to streamline your teamwork and launch your research into the stratosphere. In this tutorial, we’ll walk you through: 1. ...
Google's AI Powered Research Tool: NotebookLM Explained 🤯
Просмотров 2,6 тыс.2 месяца назад
Tired of sifting through endless research? Google's NotebookLM is your new AI-powered assistant! This tutorial dives into how NotebookLM can summarise complex documents, answer your burning questions, and even analyse images and charts. All powered by Gemini 1.5. Discover how to upload sources, get instant summaries, and verify information with ease. Perfect for students, researchers, and anyon...
🔓 Unlock ANY Password-Protected Excel File (No Software Needed!)
Просмотров 1,8 тыс.2 месяца назад
Tired of being locked out of your own Excel data? In this video, I reveal a simple trick to remove worksheet password protection from ANY Excel file, even if you don't know the password. No fancy software required! We'll use a quick text editing hack to unlock your sheets and regain access to your valuable information. Don't let forgotten passwords hold you back - unlock your Excel data today! ...
🔥 Free, Accurate, Offline Transcripts/Subtitles with Whisper AI from OpenAI (Mac)
Просмотров 1 тыс.2 месяца назад
Tired of inaccurate RUclips auto-captions and tedious manual transcription? 😩 In this video, I'll show you how to use Whisper Transcription for Mac to quickly generate accurate subtitles and transcripts - completely offline and for free! We'll cover: - Installing Whisper Transcription - Choosing the right language model - Importing your audio or video files - Using the live transcription featur...
Word's BRAND NEW Default Paste Options: Merge Formatting & More!
Просмотров 2983 месяца назад
Tired of pasting content into Microsoft Word only to have the formatting go haywire? 🤯 This video is your guide to the NEW paste options in Word for Microsoft 365 (both Consumer and Commercial)! We'll explore the powerful "Merge Formatting" option, the default setting that seamlessly blends pasted text with your document's style. Learn how to use it, plus discover all the other paste options li...
Goodbye Tab Chaos! 🤯 Organise Your Google Sheets Like a Pro!
Просмотров 5193 месяца назад
Tired of endlessly scrolling through tabs in your Google Sheets? 😩 This video is your ultimate guide to taming the tab chaos! We'll cover simple tricks like colour-coding and prefixes, plus advanced techniques like creating clickable tables of contents and linking separate Google Sheets files. Say goodbye to spreadsheet stress and hello to organised bliss! ✨ #googlesheets #spreadsheettips #orga...
Excel Magic: Mastering Snap to Grid for Perfect Layouts
Просмотров 4433 месяца назад
Tired of messy charts and misaligned tables in your Excel spreadsheets? Say goodbye to formatting frustrations with the power of Snap to Grid! This comprehensive tutorial unveils the secrets to aligning objects like a pro, from basic techniques to advanced tips and tricks using keyboard modifiers. Learn how to: - Activate and utilise Snap to Grid for precise object placement. - Combine Snap to ...
Mastering Google Keep for Ultimate Productivity
Просмотров 7633 месяца назад
Mastering Google Keep for Ultimate Productivity
Ditch Generic Emails! Learn Google Workspace Mail Merge!
Просмотров 3614 месяца назад
Ditch Generic Emails! Learn Google Workspace Mail Merge!
Google Sheets Secret: Count ONLY Visible Rows After Filtering (Works in Excel too!)
Просмотров 1 тыс.4 месяца назад
Google Sheets Secret: Count ONLY Visible Rows After Filtering (Works in Excel too!)
Closing Your Microsoft Account Made Easy: Step-by-Step Guide (2024)
Просмотров 1 тыс.4 месяца назад
Closing Your Microsoft Account Made Easy: Step-by-Step Guide (2024)
Word Editing Hack: Rearrange Text Like a Pro with Spike
Просмотров 3784 месяца назад
Word Editing Hack: Rearrange Text Like a Pro with Spike
Excel Trick: Named Ranges for Cleaner, Faster Formulas
Просмотров 1924 месяца назад
Excel Trick: Named Ranges for Cleaner, Faster Formulas
Protect Your Privacy: Generate Temporary Emails FAST!
Просмотров 5485 месяцев назад
Protect Your Privacy: Generate Temporary Emails FAST!
🤯 Checkboxes in Excel?! ✅ The Game-Changer for Data Entry
Просмотров 7495 месяцев назад
🤯 Checkboxes in Excel?! ✅ The Game-Changer for Data Entry
🤯 Game-Changing Microsoft Forms Update: Excel Sync is HERE!
Просмотров 1 тыс.5 месяцев назад
🤯 Game-Changing Microsoft Forms Update: Excel Sync is HERE!
Using Pivot Tables and Charts to build an Interactive Dashboard! (Easy Guide)
Просмотров 6505 месяцев назад
Using Pivot Tables and Charts to build an Interactive Dashboard! (Easy Guide)
Make Outlook Remind THEM for YOU (Easy Email Follow-Up Tip)
Просмотров 24 тыс.6 месяцев назад
Make Outlook Remind THEM for YOU (Easy Email Follow-Up Tip)
Install, Update and Manage all your Apps on Windows from one place!
Просмотров 1 тыс.6 месяцев назад
Install, Update and Manage all your Apps on Windows from one place!
Chrome's NEW Secret Weapon: The Side Panel!
Просмотров 5 тыс.6 месяцев назад
Chrome's NEW Secret Weapon: The Side Panel!
Backup Your Windows PC to OneDrive (Brand New Feature!)
Просмотров 3,4 тыс.6 месяцев назад
Backup Your Windows PC to OneDrive (Brand New Feature!)
Date Picker in Excel for the Web! No Add-Ins Needed!
Просмотров 28 тыс.6 месяцев назад
Date Picker in Excel for the Web! No Add-Ins Needed!
What a time saver. Thanks a lot.
We require Microsoft to enable the import of multiple-choice questions, including the ability to specify the correct answer. For our specific use case, we need to create a form with over 1000 questions. Manually inputting the correct answer for each question is highly inefficient. We propose a feature that allows us to import questions and their corresponding correct answers directly from a document or PDF file. Additionally, we would like the option to assign a specific point value to each question during the import process. How can we request this feature enhancement for the question import functionality?
This was superb! I appreciate that you did this very much. I had run into a couple of questions and you answered them.
Can I use this inside Claude Projects? Or is there too much difference between CustomGPTs and Claude Projects?
Unfortunately I haven't had a chance play around with Claude just yet, but I feel like following a similar structure should help to ensure consistency in outputs. There might need to be a couple of changes in language depending on how Claude handles things, but that should be easy to iterate on.
This is like a sales video. Not a how to video.
Excellent tutorial!
Nice. The world of PTT goes much beyond the PTT itself these days to many domains such as location based services, safety, sensors, tasks, critical communications, and many more. For these the POC's key value is on its mobile first experience with Dispatch Consoles (web based version for command and control). Teams is amazing, and is focused on the the desktop users, so PTT's value there is different.
not working on s22
Check out my pinned comment. I've covered why this is the case there.
Thank you for this, you might have saved my Visa application xD
My absolute pleasure then. I have dealt with that stuff before myself. I know how tough it can be. Good luck with the application!! ☺️
This is the most annoying, infuriating back up file system I have ever had to deal with
I am using follow ups for myself on received emails but did not know it is possible to include it in outgoing emails. Thank you.
Thanks man. Using windows and mac together is very difficult works as a designer.
Dont make a new outlook acc? Makes no damn sense
It does after you watch the full video. 😅 I explain the reasoning for it in the video.
Unfortunately Winnows cannot open the zipped file
It should be able to provided you are on Windows 10 or 11. Just make sure that the zipped file is not saved in a cloud storage location as that can sometimes cause that issue.
Is there a convenient way to use audacity to record system and microphone at the same time?
Creating custom GPTs is key to getting the most out of AI! Consider also experimenting with SmythOS and OpenAI to expand your capabilities even further. #AI #SmythOS
Thank you, so useful!
I want to schedule the shifts of the operating room personnel by applying restrictions with the software automatically? What software do you recommend?
What if it wasnt me that changed the email on my Microsoft account is there a email i can use to change it back
Unfortunately not. You would need to use the account recovery options to try and regain access to your account. If you are able to do so, you should absolutely be using a strong, unique password as well as setting up and using two factor authentication in order to protect your account against things like this.
The software is fantastic and very intuitive. Thank you for taking the time to showcase some of the features in this tutorial.
You're very welcome! I only recently found this software myself, but I could tell that it was going to be very useful for me (and others). It's great not needing to open multiple apps/browser tabs just to test a prompt against multiple AI Models.
Thank you!
Thanks sooo much for this!!!!
Opera and Edge side bar is so much better and more useful
Is there any way to change from CMD key to any other to pop up shortcut menu?
I could not locate such an option in the settings of Cheatsheet, but you do have the option to adjust the delay before the sheet pops up. If you hold the CMD key down so the sheet comes up, there is a settings icon in the lower right corner. Here you can change the delay time. You can also use the support option to send a feature request through regarding the ability to adjust the shortcut key.
@@paulomalley yes I saw these options they are pretty much useless and I think cheatsheet is discounted now!
Kindly add the Android 14 condition in your title.
It was very useful for me thanks
can you add all the people you are friends with without going one by one?
Unfortunately I haven't found a way to do that at this point in time, but that's not to say that it won't come at some point in the future.
Extremely helpful and concise, thank you so much!
What a complicated mess. Asked to login 14 times. Forced to change my password 4 times. Finally after subbing the monthly OneDrive cloud, it refuses to backup credentials and tells me to verify my identity yet again (15th time) but does not tell me how I am to do this. So incredibly sorry I tried to do anything with Microsoft. What a garbage can of needless complications.
Literally followed your tutorial also on a P8 Pro. TYSM for this!!!
whch device is this
In this video, I am using a Pixel 8 Pro, but any Pixel device running Android 14 (QPR1) can do it. Also, a lot of other Android devices on the latest Android 14 releases can also do it. Unfortunately, not all device makers have enabled this feature.
Sir, why not put team mates names in Required tab?
You don't specifically have to add your teammates to the required field. You can put them in the optional section if you prefer. It won't really matter for this type of "meeting". In my video here, the person I added to the required section was my "team mate" (who also has the name Paul O'Malley).
can you make a version for mac outlook 360 it seems to not be able to do it on recipient side
I'll take a look on my device in a little bit for you, but I'm fairly certain that when Outlook for Mac went through its recent revamp, a lot of those sorts of features that were lesser used were removed from the program entirely.
you are legend
These are for Office Insiders only, and are in beta. They are not available yet.
This is true for now, but it's expected that these will roll out to all users real soon.
@@paulomalley not soon, you gonna buy it
Ayo Paul if I change my mother bored am I gonna save my games? And if I can’t is there a way
If your games were purchased through the Microsoft Store or similar, your saved files are generally linked to your account. Even Steam has the ability to upload your saved files now. At that point, you would just need to log back into your account in order to access your games again.
my keyboard layout on both PC and phone is danish, but when i access my messages on PC and reply on a message with the PC keyboard, it is not danish.. can i change this someware?
That shouldn't be the case and honestly it sounds like a bug to me. I would suggest submitting feedback to the team that works on the app. You can do this by opening up the page that has the issue happening, in this case the messages page, and click Windows+F on your keyboard. This will then open up the windows feedback hub where you can let them know about this issue. Because the app should accept the language of your device and if your device is keyboard is in Danish it should work as you expect it to.
To have to install a third party app to reverse scrolling on a macbook in 2024 makes me question reality. Clearly apple engineers don't use their own products.
Thank you for sharing. So easy to follow
How to hyperlink a slide to jump to another slide?
Currently there is no option (that I can find) to make elements on a slide hyperlink to other slides. But with the updates that rolled out yesterday, you can now right click on a slide in the filmstrip to copy a link to a particular slide if you are needing to share a specific slide from your deck. The Figma team are iterating and adding new features all the time, so I assume the ability to turn slide elements into hyperlinks will arrive sooner rather than later.
is it possible to make shorter lines that would fit in a smartphones screen better for social media? or maybe that's done in the editing app?
There are options inside the whisper app where you can dictate what is the maximum number of characters that are allowed in a segment for the subtitles. You could look to use this and lower the number, which would then make the subtitle segments shorter. I haven't personally used that myself because I generally will do the breakup of my subtitles on RUclips, which is where I'm using it for the most part.
@@paulomalley Do you know where I could find this option? That is exactly what I need, because the lines are to short for me. But I could not find the option to increase the numbers of characters per segment
It's among the "Experimental" options in the apps settings. I'm not on my Mac at the moment so I can't note what the exact setting is called, but it is there.
thnk you was helpful
Is this different compared to win 10 sync settings?
Yeah, this is very different. It's a more robust backup option which not only has more granular control, but also helps you to back up more items than Windows 10 did.
@paulomalley okay but if im correct this one doesnt sync with other computers like the one on win10
Settings sync on Windows 10 only really "syncs" a very small amount of things. This app on Windows 11 allows you to choose what to sync and you can restore it to basically any Windows 11 PC.
@paulomalley ahh I see then so it syncs as well as backs it up then? Sorry for dumb questions they use confusing words
There's no such thing as a dumb question, there often the best ones in my experience 😜 Whilst OneDrive will sync the folders etc back and forth continuously, the sycing of settings is more of a backup for you to restore manually to a new PC. It's not a continuous sync from my experience, but that may change in the future since this is a new feature in Windows 11.
This was so incredibly helpful- Thank You! :)
Hi Paul In the video, you mentioned that the GPTs can be trained with feedback. However, there's something I'm not clear about. Every time a new user uses it, will it remember all the feedback given by users who have used it publicly, or is the training vertical within the single chat, like in a classic conversation with GPT?
There is a setting inside each user's account in ChatGPT. And the setting basically says to learn from the interactions with the chats that they have. This tailors the GPT for them the more they use it. So whilst it isn't across all users, it will learn across multiple chats by a single user provided they have this setting enabled. As each users chat are independent of each other, I don't think it's possible at the moment to have a GPT that learns based on multiple users interacting with it. But I will be perfectly honest and say that I haven't currently tried adding any instructions into the instruction set for a GPT to learn specifically from all users chats but this might be something for me to test out.
@@paulomalley Thank you, Paul. When you say, "So whilst it isn't across all users, it will learn across multiple chats by a single user provided they have this setting enabled," what do you mean? Is it a setting that I, as the creator of the custom GPT, need to enable, or is it the user who uses it? Where can I see if this feature is active?
Inside ChatGPT settings there's a personalisation option. If you open that up you'll see that there's a toggle for learning based on your chats. I believe this setting is actually toggled on by default for users.
Bro does there is any way to recover deleted alias or to get email from a deleted areas I got my really important data stuck
You should simply be able to re add that alias to your account as it is linked to the account it was originally created on. As for deleted emails, that's substantially harder, and honestly may not be possible.
@@paulomalley how can I do that
@@paulomalley will I be able to make Same address again
Yeah, follow the steps at the beginning of the video here on how to add the alias back to your account. Just keep in mind that it needs to be added back to the same account it was attached to originally.
@@paulomalley bro I am trying to say can you add back the same address which is removed it was my really important data which was on deleted alias
You know Which phone will be the best webcame the nothing phone 2 because the the camera In video mode can record at full HD 60 fps and 4k 60fps very smoth
hello I had some ideas about building custom aggpt but I don't know if these ideas are good and feasible, can you tell me what you think about it
What sort of ideas did you have? Custom GPT's can be used for quite a lot and I am learning new uses multiple times a week.
@paulomalley thank you for answering me, I watch lots of tutorials but I still can't understand the usefulness of a database and the actions, could we take examples so that I can understand
I'm going to assume, by the word database, you're referring to the knowledge area for the GPT. This is where you basically provide the additional context that the GPT may need. So if you want it to create a report in a very specific style following very specific sections, you should supply it with an example so it knows what it looks like. This way you don't need to constantly remind it of the order in which the report is supposed to be written. Actions are basically additional tools that you can make use of. So for example, if you have that report you're creating each week, and you want it to be automatically shared to a Slack channel in your team's workspace, you could do that via an action. It's basically a way of automating some of the things that you would have had to do manually otherwise.
@@paulomalley could I send you an email or a dm ?
@@paulomalley Hello can I send you an email
Will i lose anything i had?
No,. This process does not delete any of your emails or data. The only thing it does is change your primary sign in address for the account. Everything else stays the same.
Fantastic knowledge. Thank you A*