Next to Staples PepsiCo is our most active repeat client

Next to Staples, PepsiCo is our most active repeat client   We have had the opportunity and pleasure to have worked/work with PepsiCo on multiple simultaneously projects with several divisions (R&D, Beverages), only having more work with Staples. For Staples we have completed over 650 projects and counting. Sure, many of those are smaller projects, […]

Read More
How to Use Microsoft Access 2019 to Improve Efficiency

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
What Makes Excel Consultant Different from Discount Contractors on Freelancer Websites

What Makes Excel Consultant’s Dedicated Staff Different from Discount Contractors on Freelancer Websites   Discount Freelancer Website contractors’ are most often simply the lowest bidders, the low end of the consulting services market, unqualified, unreliable, not guaranteed. Find out what sets Excel Consultant’s Microsoft masters apart; “The Smarter Microsoft Solutions Provider”.   Discount low quality […]

Read More
Introduction to Practical Problem-Solving with Microsoft Power BI

Introduction to Practical Problem-Solving with Microsoft Power BI   In this twenty-first century of business, we’ve come to expect that computerized technology will be the panacea for our problems. Well, the good news is that, in virtually every case, it is! Disorganized? There’s an Excel spreadsheet for that! Need information at your fingertips? There’s a […]

Read More
Constructing Custom CRMs with Microsoft VBA

Constructing Custom CRMs with Microsoft VBA   ♦ We recently published a handful of blog posts centered around Microsoft VBA (Visual Basic for Applications, aka macros) and how the various Microsoft desktop productivity applications that make up Microsoft Office can use this code to get the maximum power and ease of use out of the […]

Read More
What You Might Not Know About Microsoft’s Vision

What You Might Not Know About Microsoft’s Vision It’s absolutely undeniable: Microsoft is a company of mammoth proportions. What You Might Not Know About Microsoft’s Vision is what Microsoft the powerhouse it is today. It’s a household name throughout the United States and even in the global marketplace. It is also how we at Excel […]

Read More
Yes, We Work With Educational Institutions (Colleges)

Yes, we work with dozens of Educational Institutions (Colleges) across the country   Last week we received a phone call from a university that was looking for a professional Microsoft Excel consulting services firm to help them with their Microsoft Excel applications. They were specifically looking to hire an Excel consultancy that had experience working […]

Read More
Meet Our Team: Jacob

Name: Jacob Hildebrand. Position: Premier Developer – Senior Excel, Access, SQL Server, Word, Outlook, VB.Net Developer     Bio: Jacob is one of our most prolific, powerful programmers at Excel Consultant. He is one of the core members of our outstanding team, and for good reason. After attending Mesa Verde High School in Citrus Heights, […]

Read More
Our Team: Meet Helen Feddema

Name: 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 More
Free Excel Help – Power Pivot Tables

Through Microsoft Excel’s 2010 PowerPivot (Power Pivot) service application you give meaning to your data recorded in your Microsoft Excel worksheets. With Excel’s PowerPivot you can stay connected as a group and get help in running your business smoothly and keep an eye on the progress throughout, no matter how much data you have.  Creating […]

Read More
Free Excel Help – Updating Pivot Tables

A Pivot Table is very useful in visually deriving meaning from data. It is also very helpful in analyzing the relationships between the data’s columns and the rows. Manipulation of data, viewing of data in different perspectives, and other data related actions can be done in the Pivot Table, dynamically. After creating the Pivot Table […]

Read More
Free Excel Help – DGET Function (Part 2)

This free Excel help article on the Microsoft Excel DGET function is a part 2, or continuation of the article, Excel DGET function. Please read the first article so that you may understand the DGET function better and then follow up with this one. In the previous free Excel help article you learned how to […]

Read More
Free Excel Help – Pivot Tables Data

In Microsoft Excel, Pivot Tables are interactive tables allowing the user to summarize and group numbers of data in a tabular concise format for easy analysis and reporting. Excel Pivot Tables aim is to count, total and sort the data, thus, this table is also available in Microsoft Access. It was originally called Pivot Tables […]

Read More
Free Excel Help – DVAR Function

The DVAR function is one of several database functions available in MS Excel. If you are not an Excel consultant, but rather a business users, you might be wondering how a Microsoft function in Excel is being called a database function when Microsoft Excel is only a worksheet and not an actual database, such as […]

Read More
Free Excel Help – DSTDEV Function

The DSTDEV function is one of the database functions in Microsoft Excel. You might be asking yourself how a function in Excel is being called a database function when Excel is only a spreadsheet and not a database, such as Microsoft Access. We’ll see that in a moment. As the name suggests DSTDEV or Database […]

Read More
Free Excel Help – DPRODUCT Function

The DPRODUCT function is one of several database functions in Microsoft Excel. You might be wondering how a function in Excel is being called a database function when Excel is only a spreadsheet. We’ll see that in a moment. As the name suggests DPRODUCT or Database Product multiplies numeric field values in a column. This […]

Read More
Free Excel Help – DGET Function (Part 1)

You might recall in an earlier free Excel help article we wrote where we discussed about the Microsoft Excel VLOOKUP function how we explained fetching data from one worksheet into another.  In this article we’ll look at another function that fetches data, the DGET function. The DGET function is one of the several database functions […]

Read More
Free Excel Help – AutoFilter

Have you ever used a Microsoft Excel AutoFilter? If not have you at least heard of it? No, well let me give you a quick overview of the Excel AutoFilter. The Excel AutoFilter allows you to filter and sort records based on one or more criteria. You do so using a simple interface, a drop-down […]

Read More