Dec 23 2015

This blog post just has a single, simple wish

The team at VBAExpress, Excel & Access, and Talon have a simple wish, we sincerely hope that you, your family and friends have a wonderful holiday season and a prosperous and healthy new year.

Jacob cfprofile

Christopher, Jacob, Team



Dec 22 2015

Meet Our Team: Jacob Hilderbrand














Jacob Hilderbrand, co-owner of this site and VBAExpress.Com founder is one of the premier Microsoft application developers, working in all of the Microsoft applications at the expert level, including the Mac versions as well as SQL Server and VB.Net.

Occupation: Premier Developer – Senior Excel, Access, SQL Server, Word, Outlook, VB.Net Developer

Bio: Jacob is one of our most prolific, powerful programmers at the Excel and Access, LLC group of companies. He is one of the core members of our outstanding team, and for good reason. After attending Mesa Verde High School in Citrus Heights, California, Jacob attended Sierra College in Rocklin, California. Throughout his schooling and independently, he became proficient in a wide range of programming languages, including:

  • VBA (Visual Basic for Applications) for a variety of Microsoft programs, including Excel, Access, Word, Outlook, PowerPoint, Video, and Project. VBA is a simple but effective code that, in the right hands (or at the right fingertips) can be used to customize the capabilities and functions of numerous applications.
  • VB.Net for Microsoft Visual Studio. Similar to VBA, this language allows Jacob to direct and modify data sets, structures, and their attributes.
  • SQL (Structured Query Language) for Microsoft SQL Server, Access, and MySQL Server. This code can be used to manipulate the information contained in relational database management systems, which are key for the information technology-related activities of many businesses.
  • HTML (Hypertext Markup Language). You can’t build websites without this ubiquitous code, which provides the details for the graphics and functions of pages.
  • PHP (Hypertext Preprocessor), an additional language used in synthesis with HTML to make pages more interesting, innovative, and useful.

Over the past 11 years, Jacob has used these skills to help thousands of clients solve their problems and achieve their goals. In 2004, he created VBA Express, a free self-help question and answer forum. He also developed an Excel VBA Training and Certification program to go along with this invaluable information technology resource. This program allows users to go through a series of lessons, ask the VBA Express experts any questions they may have, and earn a special certification upon passing an exam the team designed. This platform also hosts other paid services to help clients make the most of Microsoft. Jacob is the lead VBA Consultant on this site and has contributed more than 3,500 posts to date. He has also authored approximately 100 code samples for the Knowledge Base section of VBA Express, which visitors to the site can use to enhance their operations, and regularly publishes blogs. As a co-owner of VBA Express, Jacob also guides the direction of this platform and related sites.

Want to learn more about this maverick?

Dec 6 2015

Free Webinar on Power Tips for Using Microsoft Office – Moving Data Between Them


While this webinar is being sponsored by the Irvine Chamber of Commerce, for its members, in actuality anyone can attend and everyone is invited. You do not need to join the chamber, nor will this webinar have any selling going on. Rather we want to educate as many people as possible, and this webinar covers moving data between all of the Microsoft applications, such as moving Excel data into Access, without the use of code. So please join us.

Click Here to Attend This Free Webinar being held December 10th, at 12-1pm pst.

Power Tips for Using Microsoft Office:
Microsoft Office has been the dominant business productivity suite for many years now. As it has evolved, the various elements of the program (Word, Excel, PowerPoint, Access, Outlook and others) have become more intertwined and interconnected to increase the functionality of the entire suite. While many users know how to work within the different programs, few people understand how to use the different applications together to take maximum advantage of their combined powers. You will learn:
• How to automatically share data between Office applications
• Using the power of the Cloud to collaborate and increase efficiency
• Importing and exporting templates, tables, and other formatted content
• …Much more!

Join Paul Delke, President of Talon Computer Associates to explore Power Tips that you can use right away to enhance your Microsoft Office productivity. Talon has been a Microsoft Certified Partner since 1994.


We’ll begin by teaching you the most common (and useful) keyboard shortcuts, so you no longer have to click or find the right tab to complete everyday operations. Next, we’ll show you how to send emails from Office applications using filing and sharing. This can make office and client communications much simpler and more streamlined.

Paul will instruct you to how automatically share data between Office applications, linking from Word to Excel, Excel to Word, PowerPoint to Excel, and Excel to PowerPoint. We’ll explain how to get data from Word or Excel to Access and use Word mail merge from Excel or Access. We’ll also demonstrate how to import and export tables and other formatted content between applications, using copy/paste, special values, source formatting, and destination formatting. These functions will make analyzing your numbers, creating promotional materials, communicating with coworkers, and more a lot easier.

Click Here to see the agenda and to read more about this webinar

Hope to see you there.

Nov 3 2015

Free Microsoft Excel Webinar – November 5th at 12 noon pdt.

We are putting on a free Excel Training webinar for the Irvine Chamber of Commerce this Thursday. You are cordially invited to attend. You do not need to be a member. Just click on the link about 5 minutes before the webinar and you will benefit from Paul’s decades of experience providing Excel services to business.

This is not a webinar to sell our services, but rather a free webinar to teach you more ways to use Excel. This is a $375 value, if you were to pay to attend. So take full opportunity of the training.

Topic: “Use Excel Like a Pro and Master Your Data”.

Presenter: Paul Delke, Talon Computer Associates, Irvine California.

Date and Time: Thursday November 5th at 12 noon sharp, PDT.

You can attend the webinar by following this link, no registration needed: You can attend by clicking on the link at

Presented by: Excel and Access, LLC and Talon Computer Associates.

Oct 15 2015

We retooled our original site and we added a New blog, Videos, Webinars, and More!!!

We are excited to announce that our original site has been retooled and is now up and running! More than just a blog, there are videos, case studies, free downloads, free webinars, free reference cards and our NEW blog!!!!!

For those of you that do not know, at Excel and Access, LLC our team of programmers, instructors, and advisors truly enjoys getting to know our clients and partners. We’re glad we’ve been able to help you solve your technological troubles, streamline your systems, and make better use of Microsoft for your business. Thank you for giving us the opportunity to assist you with this ExcelHints.Com blog. We couldn’t do what we do without you.

As we know quite well, IT is a constantly evolving field—just when you think you’ve got it all figured out, something changes! We wanted to let you know that we’re always here to answer any questions you might have. You can check out our weekly blog updates for free tips and tricks for Excel, straight from our software specialists. If you need help with power pivot tables, macros, chart titles, and more, you know where to go.

Our blog can also give you an inside look at the latest news in IT. For example, you may have heard that Office 2016 was recently released. As you can imagine, this was big news for us Microsoft enthusiasts at the Excel Consultant offices, and we’ve published a post to help you decide if (or, more accurately, when) you should make the switch. Also, if you’ve ever wondered what a “Microsoft MVP” is, you can find out on our blog (hint: it’s not Most Valuable Player, but we do have one!).

If you need the answer to a more specific question or have a more complicated IT problem to handle, we would be delighted to help you out. We often complete multiple projects for our clients—in fact, we’ve got a repeat client rate of more than 80 percent! Our consultants love building long-term relationships with companies so we can really learn their needs and help them grow.

Has an annoying glitch been slowing you down? Are you thinking about upgrading your system but you aren’t sure what might be involved? Do your employees need more tech training? As you might remember, we offer comprehensive free consultations. During these appointments, we’ll answer all of your questions, address all of your concerns, and create a customized plan complete with all the important details so you can decide if you want to move forward with your next project or solution.

We’d love to stay in touch with your company and hear how you’re doing. You can follow us @ExcelandAccess on Twitter and connect with us on LinkedIn to see what we’re up to or get in touch. We also encourage you to check back for regular news and updates at our site,

Once again, thank you for being one of our wonderful members.

The Excel and Access, LLC Team and the Microsoft Office Experts at Vbaexpress.Com, lead by Jacob Hilderbrand, Microsoft Excel MVP

Page 1 of 21123451020...Last »

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks