Sep 15 2017

Excel Hint – Benefits of Integration and Automation with Microsoft’s VBA

Excel Hint – What Are The Benefits Benefits of Integration and Automation with Microsoft’s VBA


Excel Hint - What Are The Benefits of Integration and Automation with Microsoft's VBA


Chances are, if you are reading this post, you are passionate about Microsoft Excel. But with that said, are you passionate about or even aware of Microsoft Excel VBA? I ask that because there are so many Excel enthusiasts that have no idea how to write VBA, nor do they know how to benefits from the integration and automation with Microsoft’s VBA.


Take your Microsoft applications to the next level with the integration and automation with Microsoft’s VBA.


The purpose of this Excel hint is to make you more aware of Microsoft VBA (Visual Basic for Applications, often referred to as Macros), even if you are not currently interested in learning it. It is important to understand that all of the Microsoft Office applications support VBA, and that you can integrate and automate one or more of the desktop productivity applications via VBA. Take that one step further, Microsoft Excel VBA can manipulate all of the Microsoft applications, having the code in just one file, versus each of the files.


Why would you care? Simple, if you want to get the most our of your applications by letting them do most of the work, then VBA/Macros are required, period. When I say have your files do the work what I mean is this, VBA will manipulate all of your files, their data, their update processes, etc. You can basically build a simple push-button user-interface powered by VBA.


5 Examples of Taking Your Microsoft Applications to the Next Level, with the use Microsoft VBA:

  1. Integrate Microsoft Excel, Microsoft Access, and Microsoft PowerPoint into a point and click application
  2. Automate Microsoft Excel via a custom user interface
  3. Use Excel as a tool to distribute monthly reports via Outlook and your company network
  4. Use Excel VBA to run the monthly updates in both the Window’s and Mac versions
  5. Automate an Excel front-end with a SQL Server back-end


These are just a few of the reasons to consider the benefits of integration and automation with Microsoft’s VBA. We could go on-and-on this subject, but this is supposed to be an Excel hint, so to see the full post, please visit our Excel Consultant website.


Is Your Organization Ready to Leverage The Power of VBA, To Integrate and Automate Your Microsoft Applications? Excel Consultant can help with VBA macros. Contact us today to find out more and schedule an appointment!


If your organization needs to integrate and automate one or more of your Microsoft applications, but lacks the skill to do so, we are here to assist you. Please contact us so that we may discuss how we may integration and automation with Microsoft's VBA


Sep 8 2017

Making Microsoft’s Vision a Reality

Last week’s post discussed Microsoft’s vision for its products: Their vision was to design their desktop productivity tools (Microsoft Office) so that the user could fully integrated and automated any and all of those applications, such as Microsoft Excel and Microsoft Access.


But how do professional Microsoft Excel consultants and programmers for example meet this imagined future? What can these Excel users do with the Microsoft Office applications?

This post is not about saving hours or days per week that were previously spent on mundane tedious tasks, such as copying and pasting data by leveraging Excel VBA. This post is about using VBA to integrate two or more Microsoft Office applications.

If you as an Excel consultant, a staff accountant or a financial systems analyst for example take the time and effort to integrate and automate your work, the benefits are large:
• You can put the VBA in one or more files to be integrated and automated. Best to put into one app, such as Excel
• Use VBA to take data from Access, into Excel, then off to PowerPoint, and us Outlook to distribute, via the click of a button
• If you are really good, have your work completed before you walk in the door each day
• The sky is the limit on how good you can become, and soon you will find yourself being the office Guru.

This is an Excel Hint: These are just a few of the advantages attaining Microsoft’s vision would offer. If you would like to learn more, read the full blog post at our Excel Consultant website.

If you are looking to hire an Excel consultant, we are available, you can work with Jacob Hilderbrand (Microsoft Excel MVP), VBA guru, reach out to learn more.

Sep 1 2017

What You Might Not Know About Microsoft’s Vision

What You Might Not Know About Microsoft’s Vision




When Microsoft decided to build a suite of desktop productivity tools, aka Microsoft Office, they did so with one thing in mind, call it Microsoft’s vision if you will. That vision was to develop the MS Office applications so that they could be funny integrated and automated. So instead of individual applications, you can work with them as one application.


Excel Hint: Microsoft Office Integration and Automation


How do you do that? Simple, VBA/Macros, Visual Basic for Applications. The code behind the Microsoft Office applications. With this code a user can push a button in a Microsoft Excel spreadsheet, and that click would set of a series of actions across a series of applications, ultimately ended up with the desired output, from the provided input.


What took hours or days now takes seconds or minutes. Take the user out of the equation. Microsoft’s vision takes what sounds complicated and makes it actually simple.


If you would like to know more, click on the link below which will take you to the full post.


Aug 11 2017

29 Excel Keyboard Shortcuts – #1 Select All Cells


Top 29 Microsoft Excel Keyboard Shortcuts – #1 Select All


If you use Microsoft Excel on a regular basis, using keyboard shortcuts can increase your efficiency and keep your hands off of the mouse. Perhaps you already know a few, perhaps you know none. Either way we have an easy to reference chart to teach you the 29 most used Microsoft Excel keyboard shortcuts. You can get your copy today, for free.


#1 – Microsoft Excel Keyboard Shortcut, Select All.

  • “Ctrl + A” for Windows
  • “Command + A” for Apple


If you Google “Select all cells in Microsoft Excel” you may get the graphic below.


Google search, select all cells in Microsoft Excel


This Excel keyboard shortcut is a huge time saver. Manually selecting all and not missing anything can take 10 or more seconds, while the keyboard shortcut would take a mere fraction of a second.


Typically if you are selecting all there is a very good chance your next action will be to copy what you have selected. Doing that is just as easy, another Excel keyboard shortcut, “Ctrl + C“, which is mostly likely shortly followed by another MS Excel keyboard shortcut, “Ctrl + V“, to paste what you copied. So doing this manually could take you a handful of seconds if you are fast when you work in Excel, or minute if you are slow. But if you used the three keyboard shortcuts, you could do this in a second or less.


Would you like to see a long list of Excel keyboard shortcuts? If so visit our sister site, ExcelConsultant.Net, Free Excel help article on Microsoft Excel keyboard shortcuts.


29 Excel Hacks-1-select-all-cells


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


What are your favorite and most used Microsoft Excel keyboard shortcuts? If you would like to see a post on them, send us an email and let us know what they are.


If you are a data scientist or visualization expert chances are you know all of the primary Excel keyboard shortcuts and that you really do not use the mouse that much. Just like people who used to work in Lotus 123, using keyboard shortcuts is a sign of a master. I know when I was an Excel consultant I was extremely fast in Excel, and much of that speed came via keyboard shortcuts. But anyone using Excel can master these, and while you work on memorizing them, use the free cheat sheet being offered here.


Stay tuned for more Microsoft Excel keyboard shortcuts.

Aug 4 2017

Excel University – Free Microsoft Excel Training Webinars

Earn CPE's learning Microsoft Excel


Jeff Lenning of Excel University is an Excel PowerHouse. Jeff is one of the nation’s top Microsoft Excel trainers. In addition to live onsite training for his clients, Jeff sells a series of books on Microsoft Excel training on Just search for “Jeff Flenning” and you will find them.



Jeff has something to offer that most Microsoft Excel trainers do not, and that is CPE’s for CPAs. That is why companies such as Disney hire Jeff. Jeff is a CPA. But the training you will receive with Jeff is the same for both CPA’s and us regular folk. I mean Excel is Excel, and a VLookup is a Vlookup. Excel does not have special functions or features for CPAs. And the same can be said when our firm provides free Excel training.


In this complimentary 90-minute webinar, he’ll present 3 Excel topics that will help you get your work done the fast way, and he’ll also talk about getting certified in Excel with the Excel University Graduate Certification program. Registration for the free webinar is limited, so, use the link below to hold your spot.


The free webinar dates are:
• August 14
• August 17
• August 21
• August 22
• August 24

The registration page has times and a time zone converter to see your local time zone.


Learning Microsoft Excel is hard for most, but Jeff makes it easy.


In the webinar, he’ll talk about the traditional approach to 3 common tasks, and show how the traditional approach is the slow way. Then, he shares the fast way. Plus, he’ll introduce the Excel University Graduate Certification program, which is a comprehensive certification specifically designed for accounting and finance professionals. Hope you decide to check it out!


Look, no matter if you are a CPA or if you are a college student, this is quality Microsoft Excel training from one of the biggest names in the game. The webinar is free and the information being taught has value. So make the time to take your Excel game to the next level.


Page 1 of 26123451020...Last »

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks