SOLVED: VIDEO: How To Create a Sunburst Chart In Excel

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 the tiered Excel sheet below into a much more meaningful sunburst graphic. Energy Stationary Combustion Mining & Upstream Oil & Gas Production 105253 Public Electricity…

Whats New In Word, Excel, PowerPoint, Outlook for 2019

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 and Outlook.  The coolest new Office feature demonstrated at Ignite 2018 was a simple but powerful suggestion to move text lists into dynamic graphics using…

New Functions in Excel For 2019

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 products in 2019 but Excel was a special case.  In addition to all the common functionality explained in THIS article, Excel has some new VERY…

SOLVED: How To Insert Video Into PowerPoint or Word 2010

It can appear that changes to Word and PowerPoint are few and far between, but there was some serious improvements made to handling embedded videos in Office 2013.  If you have Office 2007 or Office 2010 you will find inserting videos to be… not obvious. Fortunately there is an easy way to insert a video into Office 2010 products without using add-ins: Start Word, Excel or PowerPoint 2007 or 2010 Click the INSERT tab Click…

SOLVED: How To Disable SHARE Button in Office 2016 Using a GPO

If you have Office 2016 and you want to block your staff from easily saving content in the cloud, you can disable the SHARE button using the following Group Policy Object (GPO): User Configuration -> Administrative Templates -> “Office Product Name” -> Disable Items in User Interface -> Custom -> Disable Commands > ENABLE and enter 26594 26594 does seem like a random number and it probably is, however, Microsoft has made it possible to…

SOLVED: How To Invert a Table In Excel (Swap The Columns and Rows)

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 Select PASTE SPECIAL > PASTE SPECIAL > click TRANSPOSE > click OK I have seen TRANSPOSE be greyed out a number of times when I have…

SOLVED: Video: How to Separate Numbers From Letters In an Excel Text String

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, 2017 – Ezekiel from New Mexico pointed out that the code was not translating properly from HTML and that there was a missing file.   Both…

SOLVED: VIDEO: How to Select Copy Paste Only The Visible Cells in Excel

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 step 1 and click COPY Paste the cells wherever you want and you will see it took only the visible cells

SOLVED: How to Select, Copy and Paste Only The Visible Cells in Excel

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 or non-visible cells.  Fortunately, Excel 2007 and newer have an awesome feature named GOTO > VISIBLE CELLS and here is how you use it: Using…

SOLVED: How To Remove Links From Excel That No Longer Exist

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 work. After working on this for sometime and doing what I could to avoid downloading utilities to correct the problem, I gave up and downloaded…

SOLVED: Jet Reports: Does Not Show Anything in the COMPANY field or You Receive a NAV CLIENT FINSQL.EXE COULD NOT BE FOUND

If you are working with JET REPORTS in Excel and you find that the COMPANY field will not populate and you receive the following message when you click the TEST CONNECTION button: THE REQUIRED DYNAMICS NAV CLIENT EXECUTABLE (FINSQL.EXE) COULD NOT BE FOUND IN “. then you most likely have not populated your JET > DATA SOURCE > GENERAL > DYNAMICS NAV CLIENT FOLDER path.  When using Jet 32bit on Windows 7 64bit, you should use C:\PROGRAM FILES…

SOLVED: Excel Formulas Displaying As Text

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 first issue is easy to deal with, just click the SHOW FORMULAS button and see if the issue goes away. The second is only slightly…

Whats New In Office 15?

Office 15 (likely Office 2013) is in private beta now and will have a public beta your can play with next month, in June 2012.  The product should release to manufacturing (RTM) late this year and likely be available to buy very early in 2013.    Initially users will notice that the new products all use a Metro styled “washed out” look with only a few important items having colour but past that there are many changes. …