We recently spent an hour explaining thumbnail previews to a senior manager at a global company. Her question was, “Why don’t all document Templates, not all have thumbnail previews?” We explained that Microsoft introduced the concept of a preview thumbnail in way back with Microsoft Office 2007, and that it […]
We had a client that wanted to separate a very large Excel list of about 3000 rows into groups of 100 so that they could print off wrote lists for about thirty volunteers. We didn’t have a good answer to this and then one of our in-house text came up […]
Transposing cells in Excel is an easy process of rotating data from rows to columns or vice versa. Here are the simple steps to do it: The original and the transposed tables are completely unlinked. After rotating the data successfully, you can delete the original table without affecting data in […]
In this very basic Microsoft Excel Tutorial we show you an easy keyboard shortcut to expose all of the cells that are referenced in a formula. The key here is to have the cells become highlighted so you can simply look at your table and know what is included in […]
We demonstrate how to remove duplicate entries in Excel. Specifically, this Excel tips and tricks tutorial shows you how to use the consolidate function to count how many times an entry exists. Then we show you how to remove duplicates and count how many times an entry exists using the […]
In this tutorial, we’re diving into an EASY and straightforward command that will help you export users from an Active Directory group into a CSV Excel file. Whether you’re a seasoned IT professional or just getting started, this step-by-step guide will have you exporting user data in no time. 0:00 […]
Are you looking for ways to keep your computer running in optimal condition? Over time, computers can start to slow down and become prone to errors if they are not properly maintained. Fortunately, there are a few simple steps you can take to help ensure that your machine stays healthy […]
In this short video we demonstrate three ways to hide the Worksheet tabs in an Excel Workbook:
After working on a file for a few months I found this message: Office365 Sorry, We Couldn’t Open FILE NAME Word Excel PowerPoint The error did not appear when trying to open the file using the Word WebApp, but did appear when trying to open the file using the full […]
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 […]
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 […]
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 […]
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 […]
Below is the most current list of supported browsers for opening and editing Microsoft 365 Apps (formerly Office 365 webapps) like PowerPoint, Word, Excel, Outlook, Teams and more. We offer a free 30 day trial of Office 365 for up to 25 users directly from Microsoft HERE. Windows 10: Google […]
If you are working on Office 365 products (like Word, Excel, PowerPoint and Outlook) and find that some buttons relating to connected services are greyed out there is likely one of four problems: You are working on a older version of Office (circa 2015) that had a bug which is […]
This short video explains how you can easily and quickly remove every second row in an Excel worksheet using the Filter function.