Office Apps like Word, Excel, Visio, Outlook, Project, Powerpoint, 2003, 2007 and 2010
If you are new to licensing Microsoft products you are no doubt overwhelmed by the similarity of names Microsoft uses for its cloud products. In someway all of these relate to what the industry calls VDI or Virtual Desktop Infrastructure and we have creates a free 30 minute “Zero to Read more…
How to return a sheet name into a cell in Excel. Excel does not have a variable for worksheet names but it does have a variable for file name that includes the worksheet tab name. If you want to return the sheet name into Excel this video tutorial demonstrates how Read more…
Sometime you have to work with large lists in Excel and you need to know if some specific text is in any of the cells. In this video we explore Microsoft Excel “Functions” to have it search the cells for you. Specifically, we explain and demonstrate the FIND and COUNTIF Read more…
We are all so busy it is easy to not notice new features that will make our lives easier. Here is a short explanation of just 8 improvements to Microsoft Teams that I think you will find value in: Teams Co-organizer Meeting Role added. “(Co-organizers are) …granted most of the Read more…
There are three easy ways you can add a graphic to a Microsoft Word document that allow you to type text over top: 1: INSERT PICTURE INSERT menu > PICTURE > select a picture / graphic you like PICTURE FORMAT menu > COLOR > WASHOUT LAYOUT OPTIONS > OVER TEXT Read more…
If you have launched Outlook and click the To Do checkmark to find that it errors out with something like Cannot Connect To Teams, Please Try Again Later, we have the answer. We have seen this ToDo error in Outlook several times and each time it had nothing to do Read more…
If you have ever worked with Microsoft Word you will know that one of the least understood functions are Headers and Footers. It is not that headers and footers are hard to use; it is that most people don’t use them frequently so when something happens to them, users don’t Read more…
In recent builds of Microsoft Outlook, Microsoft has added a MOST RECENT SIGN IN feature and that is very helpful if you think someone else may have been checking your email. To see the last time someone logged into your email, just click FILE and look at the INFO section Read more…
Historically you have needed to create an email signature in Outlook on every device you used, but now Microsoft has starting rolling out roaming signatures: We are running the prerelease versions of Outlook so the exact text may change for you but as you can see in the screenshot above, Read more…
Have you ever needed to proof a document but have re-read it so many times that you find yourself skipping obvious spelling, grammar or logic errors? Well, anyone who reads this site knows that I certainly do. I am a tech who wants to convey clear instructions but often find Read more…
If you want to add sample text to Word, PowerPoint or other Microsoft Office product, there are three simple commands to know: =rand() the new command that inserts real text about video “Video provides a powerful way…” =rand.old() the old rand command that only inserts the classic “THE QUICK BROWN Read more…
Do you need a drop box, a place where people from outside of your company upload files but can’t see the other files that are already there? Things like having forms sent in from field staff or invoices being sent from in vendors are great examples of where you might Read more…
We recently needed to print the same document 50 times but needed to clear a bizarre hardware error between each job. Every time the error was cleared, so was the print queue so the work around was to simply print the document separately 50 times. Because Office products like Word Read more…
If you are a Microsoft 365 user you know there has been an explosion of new apps including three that plan things todo in lists (see what I did there!). There are definitely similarities between the products but they each have different use cases. Lets start with the similarities. What Read more…
In this short video we explain and demonstrate how to easily swap / switch / rotate / transpose rows and columns in Excel. The process is to: Select the rows and columns you want Right click and select COPY Right click on a cell in an open area of the Read more…
Do you have garbage addins, like PDF tools, Printer tools, Camera tools or other junk cluttering the menus in your Office products like Word Excel and Outlook? Get rid of them. We demonstrate how to disable and how to permanently remove junk menu items in Word Excel and PowerPoint. These Read more…