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 […]
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 […]
Word Online, Excel Online, PowerPoint Online and PowerPoint online have had continuous massive improvements since they were introduced a few year ago. Today they are nearing parody with their full version desktop equivalents. Notably, Microsoft announced that all new features for the desktop versions will also be available for the […]
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 […]
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 […]
This video demonstrates the Samsung DeX Pad with a Samsung S9 running Office 365 Mobile Word Excel PowerPoint Outlook as if it were a full ChromeBook. If you want to work from your cell phone all the time, it is now an option. When you are in office or at […]
“Screenshot-Microsoft Excel – Book1” (CC BY 2.0) by Collin Anderson In today’s world, everyone is focused on the latest technological innovation and how it will change our lives. However, when it comes to the value of technology, not everything has to be as complex or immersive as blockchain or virtual reality. For […]
If you have messy data that includes both numbers and letters in the same cell but want to separate the numbers from the letters, you can use Flash Fill. Flash Fill is built into Excel 2013, 2016 and presumably every future version. Flash Fill typically populates cells automatically (like and […]
If you want to invert (swap the columns for rows) using Excel 2007 through Excel 2016, you can use the TRANSPOSE function. In Excel, select all of the data you are interested in, right click select COPY Right click on an empty cell elsewhere in the same or a different worksheet […]
If you have an Excel table with a number of ROWS you want to have selected and removed based on the contents of a cell, you can use the SORT & FILTER editor. It is very easy to use. Simply click on the column you want to evaluate On the […]
UPDATE: Oct 6 2016 – Before you spend a lot of time on creating a formula to separate text from numbers in Excel, watch our two minute video on how to use Excel’s little used but totally awesome FLASH FILL function to do this work for you. UPDATE: Jan 18, […]
If you want to select copy paste only the visible cells in Excel: In Excel 2007, 2010, 2013 or Excel 2016, select the cells you are interested in On the HOME tab, click SELECT GOTO Click GOTO SPECIAL Click VISIBLE CELLS ONLY Right click on the cells you selected in […]
If you find that system windows and text (like the START menu, THIS PC, CONTROL PANEL) are perfectly clear, but some programs like Word and Outlook have fuzzy text, AND you are using a tablet (like a Microsoft Surface or Surface Book) we have the fix! This problem has dogged […]
If you have row or “Grouped” columns (or you have dragged rows or columns so they are too small to see on the screen) and you need to duplicate what you see on the screen somewhere else, you have a problem. Copy / Paste will include all of the hidden […]
If, when you open and Excel workbook, you receive an UPDATE LINKS message but the linked source no longer exists, you have a problem. You SHOULD be able to go to the DATA tab > EDIT LINKS button and choose DELETE LINK on the offender but that often does not […]
If you enter a formula / function in Excel but only see the text of that formula and not the result of that formula, there is likely one of two things happening: You have FORMULAS tab > SHOW FORMULAS button turned on You have the cell(s) formatted as TEXT The […]