If you change the format of a cell from DATE to pretty much anything else, the date will be converted to a number, like 45731. You might as what that is. That date is the number of days since January 1, 1900. Here is the detailed explanation: This method ensures […]
Below is a very simple PowerShell command to export a list of IP address reservations in a DHCP server
When launching an Excel file on local computer that that contains a macro, all works as expected. However, when running that same file from an network drive or an Azure file Share your macros don’t work and you see a SECURITY RICK banner stating “A potentially dangerous macro has been […]
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 […]