SOLVED: VIDEO: Easily Swap Rows & Columns in Excel

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 worksheet (or a different worksheet) and select PASTE SPECIAL Select the TRANSPOSE option We also demonstrate that some of the instructions given, even by Microsoft,…

SOLVED: VIDEO: Easily Remove Third Party Menu Items From Word Excel PowerPoint

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 add menu items from Adobe, Samsung, Cannon, HP, … and others are: not helping your machines performance add visual clutter which slows YOU down most…

SOLVED: VIDEO: How to Install Version 2 Exchange Online Commandlets

Verison 2 of Exchange Online Commandlets (aka EXOv2 Cmdlets) are new commands that much simplify the command line administration of hosted Exchange.  In our case, we need these new commands to more quickly manage our Office365 Exchange Online implementation.  The problem is that EXO v2 commands are not included in the latest version of Windows 10 20H2 or in PowerShell 7.  Fortunately there is an easy way to add them: Launch a PowerShell as an…

SOLVED: How To Setup SCAN TO EMAIL Using Office 365 on Ricoh Copiers

If you have a Ricoh copier and you want to setup SCAN TO EMAIL against an Office 365 Hosted Exchange mail server, this is the right place for you: Surf to the Ricoh web management console Click LOGIN (top right corner) and enter your administrative credentials the default username is admin and the password is null/blank/empty Click EMAIL in the DEVICE SETTINGS section Enter the ADMINISTRATOR EMAIL ADDRESS This can be anything but is likely…

SOLVED: How to Remotely Wipe a Cell Phone from Exchange Online O365

If you need to wipe out a cell or tablet remotely using Exchange Online the process is quite simple: Login to the Exchange Management Console in Office 365 As an admin, login to portal.office.com as an administrator if you are a standard user you will need to contact your admin to perform this task Click the ADMIN link Expand the ADMIN CENTERS Click EXCHANGE link Alternately you could go directly to the Exchange Management Console:…

SOLVED: VIDEO: Manually Migrate a WordPress Website To A New Host

We explain and demonstrate how to manually migrate a WordPress website from one hosting company to a different one. It is a pretty easy process if you can understand at a high level you need to: backup the database on the original host backup the loose WordPress files on the original host on the new host, create new empty WordPress site Copy the loose WordPress copes from the old host overtop of the files on…

SOLVED: WordPress Home Page Works But All Others 404 Error Out

If the home page of your WordPress site is working but all other pages come back with 404 pages, you likely have a problem with your Permalinks.  Fortunately this is easy to fix. Permalinks are the address that your visitors see and there configuration is stored in the root of your site at the top of a file named .HTACCESS . The solution is to log into your sites admin page and modify the Permalinks…

SOLVED: phpBB Errors Out With – mysql_connect function does not exist, is mysql extension installed

If you have a phpBB bulletin board and have recently changed host companies, upgraded your hosting package or changed your PHP level, you may see: General Error SQL ERROR [ mysql4 ] mysql_connect function does not exist, is mysql extension installed? [] An sql error occurred while fetching this page. Please contact an administrator if this problem persists. In this case the likely problem is that your phpBB is running a command the no longer…

VIDEO: SOLVED: Easy Fix For Jetpack Errors In WordPress Like “failed to open stream” & “No such file”

After a WordPress upgrade you may find errors relating to Jetpack. The typical solution is to use an FTP program like FileZilla and rename the Jetpack folder. However, you may then be unable to log into the wp-admin page. You might see errors like: Warning: fopen(/home/content/22/7568022/html/YOUR SITE/wp-content/plugins/jetpack/jetpack.php): failed to open stream: No such file or directory in /home/content/22/7568022/html/YOUR SITE/wp-includes/functions.php on line 5974 The solution is to: Use an FTP program like FileZilla to rename any…

SOLVED: How To Properly Shut Down a Web Site So You Don’t Loose All Your Visitors

There are several easy steps to properly shut down a WordPress site: 1 – Migrate Your Posts and Pages to a New Site You worked hard on those old posts and it would be a waste to loose them all.  Without loosing your content migrate the posts and pages using the built in WordPress import/export tool: 2 – Set All of The Old Pages To Draft On the old WordPress sit: click POSTS > ALL…

SOLVED: VIDEO: Setup a File Share in the Microsoft Azure Cloud Map a Drive Letter, Use Azure Storage Explorer & Azure File Sync

We created this video to provide a full walk through of creating a drive letter mappable network share from Microsoft Azure to your computer. 02:35 Create a STORAGE GROUP 11:20 Create a SHARE 13:30 Access the share by Mapping a Drive Letter 16:50 Access the share using portal.azure.com 17:15 Access the share using Azure Storage Explorer 19:30 Access the share using Azure File Sync (your on-prem servers!) If you want to use NTFS permissions on…

FREE VIDEO: Learn Microsoft Azure In 1 Hour Boot Camp

If you are new to Microsoft Azure and want a crash course, we have what you are looking for.  Azure is a giant product from Microsoft that can be used for storing files, databases, security configurations and virtual machines.  So to get you started we created a free 6 part video with a total run time of 50 minutes that demonstrates all of the steps required to set up a Windows Server 2019 Domain Controller,…

SOLVED: VIDEO: How to connect to AzureAD AzureRM & AzureCLI using PowerShell

In this short video we explain and demonstrate how to connect PowerShell to AzureAD AzureRM & AzureCLI: How to Connect to AzureAD? Launch a PowerShell as an administrator Make sure you are running PowerShell 5.0 or newer: $PSVersionTable.PSVersion Install the required module: Install-Module MSOnline Sign into Azure: Connect-MsolService Run your commands: Get-Command -Module MSOnline How to Connect to AzureRM (aka. Azure Resource Manager – ARM)? Launch a PowerShell as an administrator Make sure you are…

SOLVED: VIDEO: PowerShell Command Line to List all available Azure Products in a Specific Data Center

In this video we explain and demonstrate how to connect to Microsoft Azure and list the services that are available at a specific data center. Azure PowerShell Commands: What version of PowerShell do I have? – You need to be at v5 $PSVersionTable.PSVersion Install Azure Command Line – You only need to install this once on each machine you work on Invoke-WebRequest -Uri https://aka.ms/installazurecliwindows -OutFile .\AzureCLI.msi; Start-Process msiexec.exe -Wait -ArgumentList ‘/I AzureCLI.msi /quiet’; rm .\AzureCLI.msi…

SOLVED: How To Record Audio PowerPoint

There are three ways to use PPT to add audio: INSERT tab > click AUDIO add what you want then RIGHT CLICK on the audio > select STYLE and select PLAY IN BACKGROUND.  This will set the audio to play through all slides INSERT > RECORD SCREEN (this will allow you to screen capture whatever is on the screen and the audio with it, including the very PPT you are working on – you can…