![TheOfficeExpert](/img/default-banner.jpg)
- 32
- 345 354
TheOfficeExpert
Australia
Приєднався 6 тра 2011
The Office Expert offers Customised Computer Training, Computer Lessons, Computer Courses, Administrative Support across all versions of Microsoft Office. We do this in the comfort of your very own home or office in the Cairns region of Far North Queensland, Australia. We can tailor a lesson plan to your exact needs and using our Gap Training technique, you no longer need to sit through lengthy lessons on topics you already are familiar with.
In addition to our personal training and administration services for you and your business, we also provide free tips and video tutorials on troublesome topics and software features. If there is something in particular you would like covered, please subscribe to our channel, then feel free to leave us a message in one of the comments section of our videos with the issues you would like resolved. We will do our best to address your issue. Alternatively, if you are in our region, book an appointment to receive our professional one-on-one service.
In addition to our personal training and administration services for you and your business, we also provide free tips and video tutorials on troublesome topics and software features. If there is something in particular you would like covered, please subscribe to our channel, then feel free to leave us a message in one of the comments section of our videos with the issues you would like resolved. We will do our best to address your issue. Alternatively, if you are in our region, book an appointment to receive our professional one-on-one service.
Windows Clipboard vs Word Clipboard - The Office Expert
Not many people know about the capacity to store more than one item they've copied on their computer and later access them to paste in another location. Windows' clipboard has the capability of remembering 24 items, but only if you turn it on!. I will show you how to do that. Also, if you are a Microsoft Word user, Word has its own clipboard which I will also introduce in this video.
Covered in this video:
0:08 Intro to the Windows Clipboard
0:32 Turn on the Clipboard (to remember things you copy)
1:47 Clearing the Windows Clipboard
1:57 Inserting Emojis, Symbols, Gifs and more...
2:56 Intro to the Word Clipboard (a whole different clipboard)
3:56 Clearing the Word Clipboard
Check out our website at www.theofficeexpert.com/
We have loads more free tutorials on our channel at: ua-cam.com/users/TheOfficeExpert
Need an Instructional Video for your office or an Administrative Assistant? we provide administrative assistance services and document formatting: www.theofficeexpert.com/administrative-support/ Enquire today.
To Book a lesson via Zoom contact us at: www.theofficeexpert.com/contact-us/
Hit the Subscribe button to stay up to date with all your Microsoft Office Skills or visit us at www.theofficeexpert.com
Covered in this video:
0:08 Intro to the Windows Clipboard
0:32 Turn on the Clipboard (to remember things you copy)
1:47 Clearing the Windows Clipboard
1:57 Inserting Emojis, Symbols, Gifs and more...
2:56 Intro to the Word Clipboard (a whole different clipboard)
3:56 Clearing the Word Clipboard
Check out our website at www.theofficeexpert.com/
We have loads more free tutorials on our channel at: ua-cam.com/users/TheOfficeExpert
Need an Instructional Video for your office or an Administrative Assistant? we provide administrative assistance services and document formatting: www.theofficeexpert.com/administrative-support/ Enquire today.
To Book a lesson via Zoom contact us at: www.theofficeexpert.com/contact-us/
Hit the Subscribe button to stay up to date with all your Microsoft Office Skills or visit us at www.theofficeexpert.com
Переглядів: 52
Відео
Copy File Names in a Folder - The Office Expert
Переглядів 2472 місяці тому
This simple tutorial covers the steps of how to Create a List of File Names that are inside a Folder. Once you have a copy of the list of files in the Folder you can paste it where ever you want. Check out our website at www.theofficeexpert.com/ We have loads more free tutorials on our channel at: ua-cam.com/users/TheOffic... Need an Instructional Video for your office or an Administrative Assi...
Draft Email cannot be changed or Sent in Microsoft Outlook - The Office Expert -
Переглядів 1,4 тис.6 місяців тому
This annoying issue in Microsoft Outlook resolves (or provides a work around while Microsoft fixes the error) for saved draft emails, which cannot be appended or changed in anyway. Check out our website at www.theofficeexpert.com/ We have loads more free tutorials on our channel at: ua-cam.com/users/TheOfficeExpert Need an Instructional Video for your office or Administrative Assistance? we pro...
Fix and Sort - Home Quick Access Directory in File Explorer - The Office Expert
Переглядів 6 тис.8 місяців тому
This video will show you how to : - Resolve the disappearing Home (Quick Access) Directory in Windows File Explorer after a Windows update - Restore the items you had pinned in the Quick Access folder and - Allow you to manually reorder the items in the folder however you want. Check out our website at www.theofficeexpert.com/ We have loads more free tutorials on our channel at: ua-cam.com/user...
Microsoft Outlook - Show as Conversations Emails out of Date Order - The Office Expert
Переглядів 2,3 тис.11 місяців тому
This video resolves the issue of emails displaying out of date order, when using the 'Show as Conversations' feature of Microsoft Outlook, which is part of the Office 365 package. ua-cam.com/video/xyNCtEBhp-s/v-deo.html Check out our website at www.theofficeexpert.com/ We have loads more free tutorials on our channel at: ua-cam.com/users/TheOfficeExpert Need an Instructional Video for your offi...
'Show more options' feature in File Explorer of Win 11 - Remove / Disable it - The Office Expert
Переглядів 7892 роки тому
This video covers how to easily disable or remove the new ''Show more options' feature in File Explorer of Windows 11. It reverts your Right-Click menu in File Explorer back to how it was in Windows 10 before you upgraded to Win 11. (0:00) disable "Show more options" (paste this code into the RUN app then Restart your System): reg add HKCU\Software\Classes\CLSID\{86ca1aa0-34aa-4e8b-a509-50c905b...
Turn on Power Query / Power Pivot (in 90secs) in Microsoft Office Excel 365 - The Office Expert
Переглядів 36 тис.2 роки тому
Please note, Power Query is no longer an "add-in" in Excel 2016 and later, it is available in the Data Tab of Excel's ribbon. For earlier versions of Excel though, you'll need to manually install Power Query. Here's how to turn on Power Pivot / Power Query in 90secs in Microsoft Office Excel 365 (from Excel 2016 and later) to unlock powerful tools to assist you in cleaning data and optimising d...
Correctly Remove a Shared Dropbox Folder without deleting it - The Office Expert - 2022
Переглядів 20 тис.2 роки тому
How to Correctly Remove a Dropbox Folder that someone else shared with you without deleting it or removing it for other users in Google Chrome 2022. Free up space in Dropbox now with this 45sec video. Safely remove a Dropbox folder without disturbing the folder for other users. Check out our website at www.theofficeexpert.com/ We have loads more free tutorials on our channel at: ua-cam.com/user...
Share and Unshare a Google Drive Folder (2 Methods in Chrome 2022) - The Office Expert
Переглядів 1,4 тис.2 роки тому
Share a Google Drive Folder and Unshare a Google Folder using two different methods. Also how to create a Google Drive Folder in Google Chrome 2022 00:06 Create a Google Drive Folder 00:23 Share Folder with Specific Email Addresses (Recipients) 01:17 UnShare Folder with Specific Email Addresses (Revoke Access/Remove Email Recipient) 01:27 Share Folder via a Google Drive Link (Anyone with a Link...
Bookmarks in Google Chrome - The Office Expert
Переглядів 1552 роки тому
Confused as to how to save a Bookmark or move a Bookmark to a new folder. Or maybe you can't see where your bookmarks are? This video will show you how to do all of those things: This video will explain: 0:27 How to display your Bookmark Toolbar 0:57 Save a Bookmark on the Toolbar 1:57 Move a Bookmark to a New Folder Check out our website at www.theofficeexpert.com/ We have loads more free tuto...
What to do if you spill a drink on your keyboard - The Office Expert
Переглядів 54 тис.3 роки тому
Spill a drink on your keyboard? Try this unconventional method to salvage your keyboard if you have spilt a creamy or sugary drink on your keyboard. You could possibly save the keyboard, so you don't have to go out and buy a new one. It's important to remove all the sugary or creamy residue as this attracts ants and can make the keys stick. Remember STEP 1 is to remove the batteries asap if you...
Outlook issue with Reading Pane and Compact Layout view - The Office Expert
Переглядів 36 тис.4 роки тому
Ever struggled with Microsoft Oultook's Compact View or Single-Line Layout of Mail items? Then this video is for you. This How-To video resolves the issue of Outlook automatically reverting to the obscure and bulky "Compact Layout" view when you increase the size of your Reading Pane situated at right. This results in loss of Column headers and an unhelpful stacked, space-wasting list of mail i...
The Office Expert - Excel Formulas not Calculating
Переглядів 1235 років тому
When your spreadsheet has formulas and the cells included in the formulas change, but the result does not change, you may need to visit the Calculation Options in Excel to see how they are configured. They may be set to Manual. In this case, you can simply change them by Clicking on the Formulas tab and to the right on the Calculations group select Calculate Now to force the spreadsheet formula...
The Office Expert - Create a Facebook Event Longer than 2 weeks
Переглядів 17 тис.5 років тому
This is how to Create a Facebook Event Longer than 2 weeks on a PC (note: you may experience a different layout if using a Phone or small Tablet device). UPDATE to FACEBOOK: New Facebook update has changed now, Click onto "Recurring Event" field, then click onto "Frequency" field and choose the "Custom" option to reveal the longer duration options as described in this video). Share this video w...
The Office Expert - How to Stop Spam at the Roots (Permanently)
Переглядів 2405 років тому
This instructional video details the steps necessary to stop spam at the roots. Continuation of these steps will eventually get spammers deregistered, suspended and/or blacklisted. Unlike creating filters to block spam, this method kills spam from its roots. Stopping spam using this method guarantees permanent eradication of any further emails from the spamming domain once the domain is deregis...
The Office Expert - Restore Missing Photoshop (PS CC) tools
Переглядів 795 років тому
The Office Expert - Restore Missing Photoshop (PS CC) tools
The Office Expert - Cancel Apple Music Trial Subscription (using iTunes)
Переглядів 1925 років тому
The Office Expert - Cancel Apple Music Trial Subscription (using iTunes)
The Office Expert - Setup or Configure Dual Monitors in Windows 10
Переглядів 4,9 тис.6 років тому
The Office Expert - Setup or Configure Dual Monitors in Windows 10
The Office Expert - Flash Fill in EXCEL 2013+
Переглядів 1607 років тому
The Office Expert - Flash Fill in EXCEL 2013
The Office Expert - Why use the Excel SUBTOTAL function?
Переглядів 5249 років тому
The Office Expert - Why use the Excel SUBTOTAL function?
The Office Expert - Select Hidden Objects in Word
Переглядів 3,1 тис.9 років тому
The Office Expert - Select Hidden Objects in Word
The Office Expert - Excel Sort by Date
Переглядів 14 тис.9 років тому
The Office Expert - Excel Sort by Date
The Office Expert - Subtotalling & Outlining in Excel
Переглядів 1,4 тис.12 років тому
The Office Expert - Subtotalling & Outlining in Excel
The Office Expert - Inserting Columns in Word
Переглядів 63 тис.13 років тому
The Office Expert - Inserting Columns in Word
The Office Expert - Configuring Document Properties in Excel
Переглядів 3,6 тис.13 років тому
The Office Expert - Configuring Document Properties in Excel
The Office Expert - Formatting and Non-Printing Characters in Word
Переглядів 1,9 тис.13 років тому
The Office Expert - Formatting and Non-Printing Characters in Word
The Office Expert - Absolute vs Relative Cell References in Excel
Переглядів 2,9 тис.13 років тому
The Office Expert - Absolute vs Relative Cell References in Excel
The Office Expert - Using Format Painter in Microsoft Office products
Переглядів 99313 років тому
The Office Expert - Using Format Painter in Microsoft Office products
The Office Expert - Formulas - Multiplication in Excel
Переглядів 13 тис.13 років тому
The Office Expert - Formulas - Multiplication in Excel
The Office Expert - Apply a Filter to a Spreadsheet in Excel
Переглядів 8 тис.13 років тому
The Office Expert - Apply a Filter to a Spreadsheet in Excel
Thank you for this! You saved my life! <3
The key is rinsing and drying the plastic films where the conductive tracks are. When water is there, some keys will permanently pressed. You can use sheets of paper to dry them quickly after washing and reduce the minerals left on them. Wash the keys if they are dirty, but that won't fix or break the functionality. They may need to be popped out with a teaspoon and individually wiped.
This need to be call expertise.. Thank You
See more options ❤❤❤❤❤
Amazing video. But I have a question for yoy ahhah, why windows always updates and makes things worst? Is it some sort of continuous downgrading program? We didnt need to do any of this before. Holy Molly! 🤣🤣🤣 Rant aside, thank you very much for your video.
thanks al lot
Thank you so much!.i coudlnt afford another 100$ for the keyboard
"I hope that is has helped" Yes it has 😁
Thanks so much for that demo... I didn't know about the Word clipboard, I was doing the laborious windows+V... that's so cool ☺️
Worth noting that i couldn't find this option in the new outlook version, but you can go to View settings > Layout and select "Switch between one and multiple rows based on screen size, under the Message height option.
kurwa freaking microsoft
Great it worked <3
Can this work on a corsair K70 keyboard as well?
Good info, thanks
Most welcome Ruthlyn. Thanks for supporting my channel.
Just a heads up - some screws might be located under the serial number sticker on the back (it was the case with my Logitech keyboard). You might have to scratch it off, which voids the warranty too I think.
Thanks, I was looking for a lap top keyboard cleaning vid, as my grandkids washed y Erazer with Pepsi, ut a nice idea, canr see myself hosing down a 2k laptop though. Leona
Sadly, as of May 2024, now Windows 11 makes some pinned folder disappear and also sort them alphabetically.
Wow~! God bless you.
Thank you! You too!
Дякую <3
Thank you, I have a file that I cannot remove, Its seems I don't have access to remove it. Do I need to contact the owner to have it removed?
flashbacks to when i got sum water on my keyboard nd used my old laptop to dry it lmao
Doesn't work for me. I still can't move items into Home and have them show up in the left pane.
Thanks now I can ruin my keyboard and buy a mechanical one
Thank you for this video! I had lost the ability to reorder Quick Access folders manually: there was no line between folders. Opening Explorer, navigating to Home, clicking Tools menu, Folder options, View tab, scrolling to the bottom, and clearing the Show all folders checkbox fixed the problem. I had remembered the View tab checkboxes, but couldn't remember where they were. They are not intuitive: the functionality needs to be easy to find and understand. I really appreciate the help! P.S. Another tip: clearing the Expand to open folder checkbox keeps the Quick Access in view on the left rather than switching focus to the expanded folder in the directory tree below.
Good stuff, glad it helped. Please subscribe to help me build my channel and stay up to date with more Microsoft Troubleshooting videos ;-) Cheers.
I simply wanted to sort folders in the Home Quick access folder. I must have watched 8 UA-cam videos and 2 Microsoft videos that looked promising, but alas no one addressed this particular issue. After 45 minutes I was getting frustrated. Then I clicked on your video and with in 20 secs you solved my problem. Previously I had enabled " Show All Folders " so I could add the " Recycle Bin " to quick access. Looks like I should have disabled "Show All Folders" after I had moved "Recycle Bin" up to quick access. Windows is such a pain in the butt sometimes. What I can say is, you are an enormous benefit to me ! Thank you for making this to the point succinct video. Subscribed. Bravo ! 😄👍✌
Most welcome and glad it helped. Please feel free to subscribe to stay up to date with more Microsoft Troubleshooting videos ;-)
Thank you for sharing this info... couldn't figure this out easily without your help.
Most welcome, glad it helped. Please subscribe to help me build my channel and stay up to date with more Microsoft Troubleshooting videos ;-)
THANK you so very, very much!!!
Most welcome, glad it helped. Please subscribe to help me build my channel and stay up to date with more Microsoft Troubleshooting videos ;-) Cheers.
@@TheOfficeExpert thanks again and I did subscribe 🥰👍🏾
Thank you so much for this!! The "Show More Options" feature was so inconvenient (and annoying). I like having the full menu available all at once. 😁
Thank you!
Thanks to you my reorder items problem in QA solved! ❤
Great to hear, glad it helped. Please subscribe to help me build my channel and stay up to date with more Microsoft Troubleshooting videos ;-) Cheers.
Thanks alot that was very helpful🙏🏻
Thank you!
thanks worked just fine
Great, glad it helped. Please subscribe to help me build my channel and stay up to date with more Microsoft Troubleshooting videos ;-) Cheers.
You are a ROCK STAR - Thanks. Trying to adjust views without knowing this was an epic frustration.
Thank you for your help!
Rip my fking 140$ keyboard
Hi, I spilled beer on a Logitech wireless K540. I turned it off, dried it up, and left it overnight. In the morning it worked fine, but Space and a few other buttons started sticking, not going up again, so I was like, it must glued because of beer. I turned it off, removed the batteries, and I wash the keyboard with warm water to remove beer traces. I know you can wash even the whole PC, if you do not turn it on for 10 hot days, until all dries up like dessert. The thing is, I was damn inpatient, and I was like, this keyboard looks waterproof, it is for sure OK to turn it on after 2 hrs. of drying. I put the batteries in, turned it on and it become buggy. Buttons went crazy, W started typing itself and many buttons stop working. Did I damage it completely now? I removed the batteries and left the keyboard. I will try if it works after few days again. Will it maybe work after gets dry like desert, or I permanently fcked it up and destroyed the keyboard forever? What do you guys think? I know it is silly to ask, but who knows? Perhaps nothing died, but the button stopped working because of moisture.
anyone has repaired a logitech slim folio pro keyboard? looking to know how to open it for cleaning as there was liquid spilled on it. some keys are not working. i tried to use a flat knife to release the snaps but it is not giving working. any idea? thanks
it is a keyboard for an ipad pro. forgot to mention.
💕 'Promo sm'
Even thought this is a good solution for some reason sometimes some keys don't work anymore
This is great for a "Shared" file, but how would I remove my access to a file folder that is owned by someone else and has given me permission to have access to it and edit it? My understanding is that if I "delete" this file from my dropbox account (which I need to do in order to free up storage space) then I will also delete it from everyone else's dropbox accounts that also have access to the particular file. Then, the painstaking process of recovering the deleted file has to be taken and I'm back in the same boat. Several of us work as a team and this is how we share files, but don't actually place them in the "Shared Files" folder.
I still can't figure this out and it's why i came to this link
Dropbox will sync any changes you make across all of your devices. Therefore, this means that if you add a file to Dropbox on your computer, it's added everywhere. If you Delete a file, it is deleted everywhere. This video describes how to correctly remove your access to a file/folder. I would suggest looking into the Selective Sync feature of Dropbox for your issue to what this video covers. Basically, to remove the local copy of a file/folder from your computer (to free up space) which you want to leave in Dropbox, use Selective Sync. Just be sure that the folder in question is fully synced BEFORE you remove it with the Selective Sync options, otherwise it will be lost.
Thank you!
Thank you, just what I was looking for.
The captions is not correct. Power Pivot not Power Query.
What i am looking for is power query not power pivot. @poster pls help
Thank you, going crazy trying to fix this! Works for Office 365.
I SOOOOOOO NEEDED THIS, THANK YOU
Thank you!!
Glad to help. 🙂
I Fixed my hyperx keyboard using this method< i spilled a full cup of coffee on it tysm legend
So simple, so helpful! Thank you!
Thank you! This was incredibly helpful!