Excel 2003 2007 2010 related
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 Read more…
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 Read more…
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 Read more…
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 Read more…
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 -> Read more…
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 Read more…
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 Read more…
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, Read more…
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 Read more…
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 Read more…
If you have a user account at the top right of your Office 2013 product and SWITCH ACCOUNT does not work, you can perform a simple registry change to correc the problem: Close all of your Office products (i.e. Word, Excel, Outlook…) Start REGEDIT.EXE Find HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Identity\Identities Delete any of the Read more…
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 Read more…
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 Read more…
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 Read more…
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 Read more…
Have you ever had data in two different Excel tables and need them joined / merged into one table? If so, this short video is for you.