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…

Whats New In Microsoft Advanced Threat Protection?

Microsoft is using the term Advanced Threat Protection with several products so it can be difficult to find the information you need.  In this article we are referring to Office 365 Advanced Threat Protection which is unrelated to Windows Defender Advanced Threat Protection. In case you want to play along at home, you can get to Office 365 ATP by: Logging into Portal.Office.com and clicking ADMIN (if you are not already there) Scroll to the bottom and…

SOLVED: Where Is the ADMX Template for OneDrive?

Microsoft removed the OneDrive GPO’s from the core ADMX’s (i.e. from Win10 or Office or…) and it is now it’s own thing.  To be more confusing, you can’t download the OneDrive ADMX files directly from Microsoft; you need to install the OneDrive client and then pull the ADMX from a local PC . After you have run a Windows Update, you can find the ADMX ADML files from: %localappdata%\Microsoft\OneDrive \<highest number>\adm HERE, from us using…

Whats New In Word, Excel, PowerPoint, Outlook for 2019

I recently attended Microsoft Ignite 2018 in Florida which presented many new useful features and function for Office products. What’s New In Word, Excel, PowerPoint, Outlook Desktop LIST TO GRAPHICS Microsoft want out of its way to show of the Artificial Intelligence that is built into desktop Word, Excel, PowerPoint and Outlook.  The coolest new Office feature demonstrated at Ignite 2018 was a simple but powerful suggestion to move text lists into dynamic graphics using…

New Functions in Excel For 2019

You would not expect much new in Excel after 30 years of development but you would be wrong if you think there is nothing highly useful and new in Excel for 2019.  I recently attended Microsoft Ignite 2018 in Florida which presented many new useful features and function for Office products in 2019 but Excel was a special case.  In addition to all the common functionality explained in THIS article, Excel has some new VERY…

SOLVED: Why Is 64 Bit MS Office Now Recommended?

Microsoft has changed their guidance to state that from September 2018 on, they recommend the 64 bit version of Office be installed.  This is a departure from the 32bit guidance Microsoft provided previously. After Microsoft first compiled a 64 bit version of MS Office in June 2010, they immediately told consumers and companies not to use it.  The issue was not cost, stability or features; they were all the same as the 32 bit version. …

SOLVED: What’s The Difference Between Office 2019 & Office 365 Pro Plus

For many (most?) corporate users, Office 2019 would be a step down from what the Office 365 Pro Plus they are using now.  Office 2019 is a non-subscription based version of Office 365 ProPlus from October 2018 (yes, that is next month).  If you have Office 365 Pro Plus, you already have Office 2019. Microsoft emphatically claims that Office 2019 is the very last version of MS Office that consumers or companies will be able…