How to Use Microsoft Access 2019 to Improve Efficiency Find out more about Microsoft Access and learn how the Excel Consultant team can use its functions to develop databases that enhance efficiency Read Gregg’s complete post here: With Office 2019 Currently Pending release, is this perhaps the perfect time to update your version […]
Read More
Experience
White Paper: Microsoft Office VBA References in Microsoft Microsoft Access 2016 Below is a document Helen Feddema wrote about 12 years ago. She says that the process is the same for 2010/2016 as for 2000/2002 – uncheck the references marked MISSING and reselect the Excel, Outlook and Word references for the version of […]
Read MoreShould You Upgrade to Microsoft Excel 2016 or Wait for the Release of Excel 2019? The question is whether should you take the plunge with Excel 2016 or wait it out? Take Excel Consultant’s quiz to find out which software system may be right for you. Chances are, you have Microsoft Excel on your […]
Read MoreWhat You Need to Know About Freelancing Websites Before You Hire a Tech Consultant In our digital landscape, any service, person, or product you require is quite literally at your fingertips. Do you need a handyman? There’s a website for that. Are you looking for a babysitter? Just log on to the online portal. Do […]
Read MoreMicrosoft Excel 2013 to Excel 2016 for Windows: What’s the Difference? Are you considering making the change from Microsoft Excel 2013 to Excel 2016 for Windows? If so, what’s the difference between the two? How do you decide? Read on to learn more about this new software from Excel Consultant’s experts. It’s that […]
Read MoreExcel 2016 for Mac Versus Excel 2011 for Mac: The Inside Scoop from Excel Experts It’s a common computerized conundrum: the latest software is out, but is it what you want? Is it something IT will approve and support? Should you switch from your reliable, existing program to the flashy, new, exciting, and supposedly […]
Read MoreMaking Microsoft’s Vision a Reality We’ve revealed Microsoft’s vision of integration and automation for its suite of software in our earlier post (Making Microsoft’s Vision a Reality). Find out how Excel Consultant fulfills this imagined future. In our previous post, we revealed Microsoft’s true vision for its products: a seamless, unified system of software […]
Read MoreWhy Having Over Two Decades Of Microsoft Certification Matter So Much In This Industry In an industry where we making our living assisting clients with their Microsoft applications, such as Excel, Access, Office, SQL Server and Power BI, having that Microsoft Certification for an amazing 23 consecutive years is that much more meaningful than […]
Read MoreA Look Back at Our Microsoft MVP’s Work Over the years our clients have had the opportunity to work with the numerous Microsoft MVPs that have been a major component of our team of Microsoft Excel and Access experts. Their contributions have lead to our raising the bar in our niche and have been nothing […]
Read MoreName: Stan B. Position: Senior Access Consultant, Project Manager, Senior Access Trainer Bio: Excel Consultant is delighted to have Stan B. as a member of our team. While he is a multitalented Microsoft master, his prowess lies particularly in Access, the relational database management system. Those with the proper skills can use this powerful tool to […]
Read MoreName: Paul Delke Position: Senior Project Manager and Programmer (Irvine Office) Bio: Paul Delke has been a spreadsheet specialist for the past three decades. Since 1989, he has served as President of Automated PC Systems, Incorporated. As an independent consultant, he provides software solutions to major corporate clients using spreadsheets from Lotus and Excel. He joined […]
Read MoreName: Dennis Taylor Position: Senior Excel Trainer (PC and Mac Cross-Platform Expertise) Bio: Simply put, Dennis Taylor is an Excel expert. He has worked extensively with Microsoft products (especially spreadsheet programs) since the mid-1990s. He’s traveled the United States and Canada giving seminars to help his students unlock the full potential of Excel (so far, […]
Read MoreName: Helen Feddema Position: Senior Access, Word, Outlook, and Excel Developer Bio: Helen is a New York City native who has been dedicated to digital software for nearly as long as it’s existed. While she waited for computer technology to catch up with her coding skills, Helen passed her time as an Ivy League student. She […]
Read MoreWhen you bring specialists onto your project or into your office, you want to know you’re working with the best. In a technical field like Microsoft programming, it can be difficult for executives and project managers to tell which consultants really know their stuff. When you work with a Microsoft MVP (Most Valuable Professional), you […]
Read MoreMicrosoft Excel Pivot Tables are used in the user’s spreadsheet to present quantitative data in an easy and user-friendly manner to allow the user to quickly analyze large amounts of data. To manipulate data in an Excel PivotTable it must have data that is capable of being able to be categorized or grouped. To create […]
Read More