Nov 17 2017

Should You Upgrade to Microsoft Excel 2016 or Wait for the Release of Excel 2019?


Should You Upgrade to Microsoft Excel 2016 or Wait for the Release of Excel 2019?




Here is the Excel “HINT”:If you are using Microsoft Excel 2013 or older, and if you are considering an upgrade, you have a tough decision on your hands; do you bite the bullet and install the problematic Excel 2016 or do you wait 9 months and get Excel 2019?


Note, if you have Office 365 you could upgrade to 2016 now, and then to 2019 in nine months, no extra cost.


If you work for a large corporation you might always be one version behind, as that is the way large corporations typically do it, but if you are an individual, using Excel 2013, not using Microsoft Power BI, I would recommend waiting for 2019.




So this ends our Excel “HINT”: If you want to read the full post, click here to visit our main blog at ExcelConsultant.Net.



Nov 13 2017

Get Ready for Microsoft Excel 2019


Here is an Excel Hint for you, Get Ready for Microsoft Excel 2019!




The next version of Microsoft Office is coming to a computer near you soon. The company announced today that Office 2019 will be released sometime in the second half next year. Previews will ship in mid-2018. It will include the applications we’re used to, such as Word, Excel and Powerpoint, as well as servers such as Skype for Business and Exchange. Source: Microsoft


According to Jared Spataro, general manager for Office: Today, at Microsoft Ignite in Orlando, we announced Office 2019—the next perpetual update for Office. This release, scheduled for the second half of 2018, will include perpetual versions of the Office apps (including Word, Excel, PowerPoint, and Outlook) and servers (including Exchange, SharePoint, and Skype for Business). Previews of the new products will start shipping mid-year 2018.




Microsoft Says This About Excel 2019: Some of the new features in Office 2019 that it highlights are new formulas and charts for Excel, inking features that are both new and improved and visual animation for presentations. Additionally, Office 2019 will focus on IT manageability, usability, voice and security for server updates. Microsoft will release more information about Office 2019 over the next few months.


Are you one of those countless Microsoft Excel users that are upset with the problems encountered when you work in Excel 2016? Are you one of those peopled that uninstalled Excel 2016 for the PC and went back to Excel 2013? Or from Excel Mac 2016 back to 2011? Are you a full-time Excel developers and Microsoft Excel MVPs that hate Excel 2016 PC or Mac. If you are you are not alone.


The good news is that we get another chance to get Excel/Office software that works well for us. Forget how it works for everyone else, does your version of Excel do what you want it to, without workarounds and such, but straight out of the Cat6 cable into your machine. Hopefully Excel/Office 2019 is a leap in the right direction.


There is not a lot of news out there on the software,, but we have the top links below so that you can take a deeper dive and decide if Excel/Office 2019 is right for you and your organization. If your group uses the Mac versions of Excel, that is even more vague; will there a Mac version.


Here are the top sources covering Microsoft Excel 2019.


As new information comes out on MS Excel/Office 2019 we will update this post.


If you or the organization you work for needs to hire a firm that works in all of the Microsoft applications, including Microsoft Power BI, give us a call so we can discuss how we may assist you.


Nov 3 2017

Keyboard Shortcut – How To Add A Worksheet To Excel


Microsoft Excel Keyboard Shortcuts


If you have worked in Microsoft Excel for any amount of time you undoubtedly have at least heard of keyboard shortcuts. Hopefully you know a good number of them. Any keyboard shortcut that can prevent you from grabbing the mouse or using the mouse-pad makes you quicker and more efficient in Excel, Word, etc.


The image below shows you how to add a worksheet to Excel via a keyboard shortcut. It covers the PC version of Excel as well as the Mac versions of Excel. Give it a try.


29 Excel Hacks IG-number-2-add-a-worksheet-Recovered


Have you ever seen an old school Microsoft Excel user that flies through the program without reaching for the mouse? If you are not one of those people, no worries, you can become one. It just takes your taking the opportunity to learn say 20 – 25 of them. Ctrl C, Ctrl X, Ctrl V, Ctrl Z, etc.


If you do not mind, what are your favorite Excel keyboard shortcuts? Either email them to us or enter them as comments and we will post them.


If you have questions on how to use any of the Microsoft applications, including VBA, visit our Microsoft Help Forum, VBAExpress.Com. If you want to ask questions on Excel VBA, you possibly have code that will not work, get help for free, Free Microsoft Excel Help Forum.


If you would like to get a free copy of the 29 Microsoft Excel Keyboard Shortcuts chart please send us an email and we will get that right out to you, provided by


Oct 27 2017

Microsoft Power BI – Practical Problem Solving Series


Microsoft Power BI – Practical Problem Solving Series

If you have been on this site before you will know that this site is mostly about Microsoft Excel. Not full posts but short Excel Hints, as the URL implies. Nice small nuggets of useful information/content intended to be of interest to our Excel community. Since the release of Microsoft Office 2010 nothing has been more powerful or more important in the Microsoft world than Microsoft Power BI. Period.


We are running a series of four posts on our sister site, ExcelConsultant.Net. The series will start with an introduction of practical problem solving with Microsoft Power BI. The tree following posts will cover “Making Data Accessible“, “Presentation Preparation“, “Measuring Your Success“.


If you would like an introduction to Microsoft Power BI to get you started, here is the link to a previous highly informative blog post on Microsoft Power BI, ADVANTAGES OF MICROSOFT POWER BI.


Each week as we publish the next blog post in the series you will be able to access the full post directly using the links below as they are made active. We will also post an Excel Hint here on each of the posts. We hope you enjoy the series, it contains some useful insights to the usefulness of Microsoft’s latest and greatest, Microsoft Power BI.


Microsoft Power BI – Practical Problem Solving with Microsoft BI:

  1. Introduction – Posted
  2. Making Data Accessible – Coming Soon
  3. Presentation Preparation – Coming Soon
  4. Measuring Your Success – Coming Soon


If you would like to read the first in the series of posts, please click (Introduction)


If Power BI is of interest to you and/or your organization we do offer full-service Microsoft Power BI consulting and training solutions. You can learn more by visiting our father-site’s Power BI pages, ExcelAndAccess.Com.


If you have questions or comments, please contact us via our simple to use contact form.


What is Power BI?


Oct 20 2017



Microsoft Excel 2016 Versus 2013 For Windows




This Excel Hint quickly goes over the two most current versions of Microsoft Excel. Yes, there are holdouts working in Excel 2003, 2007 and 2010, but the majority of people are working in 2013 or 2016. As such this post will quickly go over Microsoft Excel 2016 Versus 2013 For Windows.


There are many reasons companies do not upgrade as soon as a new version of Excel comes out. For many it is simply the cost, for others it is the fear of the unknown, what wont work, and what bugs are in the software itself.




For those companies that are stuck in 2003 or 2007, or firms that want to use Power BI, an upgrade to one of the two most recent versions would be a good idea. But there is something you need to know before you upgrade. If you want to work in the most ‘recent’ version of Microsoft Excel, and if you don’t want to upgrade twice in a year, then you should consider waiting for Excel 2019 (Click here to learn more). Yes, there is a new version of MS Office coming out, didn’t you know?


Okay, so if you are even considering an upgrade anytime soon, you will want to read our full post which has more than enough info and links to quality posts to help you decide.


If you were to ask me, I would say wait until the 3rd quarter of 2018, and upgrade to Excel 2019.




Page 1 of 27123451020...Last »

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks