SOLVED: VIDEO: 25 PowerPoint 2019 Tips & Tricks In 20 Minutes

In this video we very quickly run through 25 PowerPoint Tips and Tricks in just 20 minutes: There are many more we could have shown including fabulous new IDEAS but we decided to show the day to day hidden gems:   FORMAT PAINTER > Double Click TO HOLD CONTROL + DRAG to duplicate SHIFT + DRAG = straight line Use Templates and Ideas RESET INSERT > HEADER & FOOOTER change date INSERT > ICONS (SHAPES)…

SOVLED: What’s the Difference Between Office 2019 Home, Student, Pro & Enterprise?

We have received a number of questions about the differences in Micosoft Office 2019 bundles so we decided to produce a grid showing all of the critical differences. To answer a few questions directly: We offer a FREE Office 365 Business Premium Trial for up to 25 user for one month HERE Office 2019 IS Office 365 Pro Plus.  For a more detailed explanation of this see our: What’s The Difference Between Office 2019 &…

SOLVED: VIDEO: How To Set Office 365 Pro Plus To Run on a Kiosk with Shared Activation

In this video we explain how to set Office 365 Pro Plus (Office 2016, Office 2019) to run on a kiosk by using Office Shared Activation.  We also also show how to verify it. Shared Office Activation lets you to deploy Office 365 ProPlus to computers that are accessed by multiple users.  Some examples of supported scenarios for using what Microsoft calls “shared computer activation” (and I call Kiosk Mode) are: More than one employee…

SOLVED: Scrub Office License, Credentials & Identity To Solve Sorry, Another account from your organization is already signed in on this computer

When starting an Office 365 Pro Plus (Office 2016, Office 2019) product like Word, Excel, PowerPoint or Outlook you may be prompted to log in.  At that point you may see: Sorry, another account from your organization is already signed in on this computer   There are two ways to solve this but each one starts with closing ALL Office products including Skype and Teams.  For some reason, you also need to close Internet Explorer…

SOLVED: 64Bit Office Cannot Be Installed

If you are trying to deploy 64bit Office 365 Pro Plus or Office 2019 using a command line from the Office Deployment Toolkit (ODT) you may see no error message but it just doesn’t install: C:\Windows\system32>\\cal-s2\office365$\setup.exe /configure semiannual-targeted-64Bit.xml C:\Windows\system32> or if you are using a deployment tool with PDQ Deploy, you might see: Command script returned error code 1603 which is a generic ‘didn’t work’ error. We spent several embarrassing hours on this one.  The…

SOLVED: Command Line To Uninstall Office365 Pro Plus

PROBLEM: For several years we have uninstalled Office using a command like: \\cal-s2\office365$\Office365ProPlus\setup.exe /uninstall ProPlus /config \\cal-s2\office365$\uninstall-Office365ProPlus.xml but it now errors out with: Office Deployment Tool SETUP [mode] [path] SETUP /download [path to configuration file] SETUP /configure [path to configuration file] SETUP /packager [path to configuration file] [output path] SETUP /customize [path to configuration file] /download Downloads files to create an Office installation source /configure Adds, removes, or configures an Office installation /packager Produces an Office…

SOLVED: How To Remove A Unwanted GUEST Account From Teams

If you have previously accepted an invitation to join a Team as a “Guest” from outside your organization, it is far from obvious how to remove that account when you are done with it. To remove an unwanted Guest account in Teams: Surf to https://myapps.microsoft.com Click you icon in the top right corner and then the ORGANIZATIONS cog Click  SIGN IN TO LEAVE ORGANIZATION beside the organization you don’t want to be connected to anymore…

SOLVED: VIDEO: How To Create a Sunburst Chart In Excel

If you want to get a bunch of data that you need to get into peoples heads, you need to convert that data to information.  The best way to accomplish this is with a graphic.  In this video we will show you how to very easily convert the information in the tiered Excel sheet below into a much more meaningful sunburst graphic. Energy Stationary Combustion Mining & Upstream Oil & Gas Production 105253 Public Electricity…

VIDEO: How To Easily & Legally Use Microsoft Office For Free

If you need to edit or create some Excel, Word or PowerPoint documents, Microsoft has created an easy and free way to give you that access. On any PC or Mac, just surf to www.Office.com and either sign in with your Microsoft account (or create a new one as we demonstrate in the video).  Then you can easily work in the most current versions of Word, Excel PowerPoint, Outlook, OneNote, Sway and more completely for free.

SOLVED: VIDEO: Easy Way To Plot Cities on a Map Using Excel

If you have tried to use Excel’s new(ish) chart to map feature you will find how easy it is to use.  However, it does only supports Countries and Provinces/States, so if you try to INSERT > CHART > MAP with city data you will see: MAP CHART NEEDS GEOGRAPHICAL DATA SUCH AS COUNTRY/REGION, STATE/PROVINCE OR POSTAL CODE. CHECK YOUR DATA AND TRY AGAIN However, there is a very simple way around this problem as shown…

SOLVED: Outlook – Something Went Wrong And Your Search Couldn’t Be Completed

If your Outlook returns a yellow box saying “Something went wrong and your search couldn’t be completed” the most likely issue is your Windows Search Service is damaged. You can verify this in two ways: Click the START button and type something.  If it shows SEARCH INDEXING WAS TURNED OFF.  TURN INDEXING BACK ON, this is likely your issue Click the START button and type SERVICES.MSC to start the Services management console and see if…

SOLVED: What is Microsoft Office Lens Camera & How To Use It

Microsoft Office Lens is a free program for mobile devices (like your cell phone) that does many super useful task but the one I use the most is “straightening photos” on the fly.  For example, instead of using the stock camera app on my Samsung Galaxy S9 I used the Office Lens camera app and with litterally no work on my part it calculated the angle of the screen, that the screen was what I…

SOLVED: What’s New in Microsoft Teams & When Will Teams Replace Skype?

Microsoft Teams started as little more than a web only SharePoint Template that encouraged: Inviting specific people and groups to the Team Note taking and comment making But that was 2017.  At the recent Microsoft Ignite conference in Florida Microsoft likely mentioned Teams more than any other product.  It was drilled on in the keynote, in demonstrations, in Teams sessions, in Stream sessions, in Office 365 sessions, in OneDrive sesssions, in OneNote sessions, and in…