SOLVED: How To Export a List of DHCP Reservations To An Excel File
Below is a very simple PowerShell command to export a list of IP address reservations in a DHCP server
SOLVED: Word Excel Error – Potentially Dangerous Macro Has Been Blocked
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 […]
SOLVED: Why Some Excel, PowerPoint and Word Templates Don’t Have Thumbnail Previews
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 […]
SOLVED: VIDEO: Separate Excel Rows Into Groups of 100
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 […]
SOLVED: How To Transpose Rows and Columns in Excel
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 […]
SOLVED: VIDEO: Keyboard Shortcut Shows Cells Referenced In An Excel Formula
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 […]
SOLVED: VIDEO: Count or Remove Duplicates & Consolidate Data in Excel
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 […]
SOLVED: VIDEO: PowerShell To Export Users From Active Directory Group To A CSV Excel
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 […]
SOLVED: How To Keep Your Computer In Excellent Condition
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 […]
SOLVED: VIDEO: How To Hide Worksheet Tabs In An Excel Workbook
In this short video we demonstrate three ways to hide the Worksheet tabs in an Excel Workbook:
SOLVED: Office365 Sorry, We Couldn’t Open Word Excel PowerPoint
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 […]
SOLVED: VIDEO: Return Sheet Name into a Cell – Excel Formula
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 […]
SOLVED: VIDEO: Determine If Specific Text Is In An Excel Cell
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 […]
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 […]
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 […]
SOLVED: What Browsers Do Microsoft 365 Apps (Word, Excel, Outlook…) Support?
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 […]