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
How Small Businesses Use Microsoft Excel

How Small Businesses Use Microsoft Excel   For those that are familiar with business, the number one desktop productivity tool of choice is Microsoft Excel, it’s hard to imagine life without it. Microsoft Excel is a spreadsheet tool that is used in millions of large businesses across the world and provides tremendous value to small […]

Read More
Solutions: Custom Commercial Microsoft Solutions

We Build Custom Commercial Microsoft Solutions For Our Clients   Excel Consultant explains the growing field of custom commercial applications, their numerous advantages, and our successes with their custom Microsoft development       Excel Consultant’s team of Microsoft custom solution experts is committing to helping our clients maximize their potential with this essential suite […]

Read More
Measuring Your Success with Microsoft Power BI (Power Pivot)

Practical Problem Solving with Microsoft Power BI: Measuring Your Success   How well is your business doing? You can probably provide a general answer (“excellent,” “could be better,” “needs some help,” “growing quickly,” etc.) but how do you know? How do you measure success? Do the business tools you are using providing the answers in […]

Read More
Should You Hire A Local or Remote Microsoft Consultant?

Should You Hire A Local or Remote Microsoft Excel, Access & Power BI Consultant?   Excel Consultant describes the differences between local and remote Microsoft Excel, Access and Power BI consulting, highlighting the many benefits our team of specialists offers.   Remote, or local: that is the question. It may not be the original Shakespearean […]

Read More
Don’t Let This Happen To You

Don’t Let This Happen To You       Don’t Do It – Don’t Be The Upset Client On The Phone To Where? Make Sure You Know How To Hire The Right Corporation To Assist You   #1 – What you read below comes from an ongoing conversation with a new client. It is one […]

Read More
Practical Problem-Solving with Microsoft Power BI: Making Data Accessible

Practical Problem-Solving with Microsoft Power BI: Making Data Accessible   As most executives and managers know, information fuels an enterprise. Without client data, product specifications, inventory sheets, account ledgers, sales projections, and other crucial data sets, your business simply couldn’t function. These are, in many respects, your most valuable assets, since they allow you to […]

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
Microsoft Excel 2016 for Mac Versus Excel 2011 for Mac

Excel 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 More
How Businesses Become More Productive Using Microsoft Excel

How Businesses Become More Productive Using Microsoft Excel   Said another way, How Do Businesses “Excel Efficiently“   Fact: Did you know that 60% of the Excel 2013 templates that come within Microsoft Excel were done by our company. Yes, several of our Microsoft Excel MVP’s worked on our organization’s project for Microsoft. Some project! […]

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
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
Free Excel Help – Data Types

What you enter in a Microsoft Excel spreadsheets is read by the program as general data, text, or numeric data. But there are limitations to each, and you obviously have to suit your own needs and preferences while using Microsoft Excel. The cell data type can be interpreted by Microsoft in different ways: numeric, general […]

Read More
Free Excel Help – Slicers

Dealing with massive amounts of data on your Microsoft Excel 2010 worksheets can be really messy. Particularly when you want to select some values for financial analysis and skip other entries, the job can be really frustrating. In a long spreadsheet, one with hundreds of thousands of rows, where the entries to be skipped from […]

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 – Macros

Tired of repeating the same manual operations while managing data? It is very understandable. Repeating the very same action again and again, day in and day out, can be very frustrating not to mention expensive.  Excel spreadsheets can be managed effectively, repeating tasks and getting frustrated can be successfully prevented in Microsoft Excel using Macros. […]

Read More
Free Excel Help – Arrays

A variable which has is a similar type but holds a different value is what an array means. It is used in almost every programming language which can also be mixed or paired to different variables for a simple or more complicated structure of data. Due to the property of an array that it holds […]

Read More
Free Excel Help – XIRR Function

The Microsoft Excel XIRR function is a modified version of the IRR function, wherein one can also calculate internal rate of return even if the cash flow does not happen regularly. The Excel IRR function is only for calculating internal rate of return when there is a periodic flow of cash, and thus the XIRR […]

Read More
Free Excel Help – SumProduct Function

The Microsoft Excel application is one of the global leaders when it comes to financial computing and analyzing data, from an Excel consultant and financial analyst point of view at least. This iconic piece of software, ever since it was released by Microsoft, has been a the first choice among all the major business organizations […]

Read More
Free Excel Help – PV Function

The Microsoft Excel Present Value (PV) Function is used to determine the current status of an investment. This is calculated keeping in mind a constant interest rate within a constant payment schedule. his is an evaluation mechanism that is put to use keeping in mind a future payment that is due. The current value here […]

Read More
Free Excel Help – PPMT Function

The Microsoft Excel PPMT function is a tool that calculates the payment on a basic amount during a defined period of time. The amount may be upon a loan or just an investment in some business that is supposed to return a value at a pre-settled interest rate. The payment that is to be made […]

Read More
Free Excel Help – Date Function

In this free Excel help article we will look at some more of the Microsoft Excel date functions. To this list we will also add some of the Microsoft Excel time functions too as they both go hand-in-hand. EOMONTH  – The function stands for End Of the Month. It is a very useful Excel function […]

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 – Median Function

Microsoft Excel has been one of Microsoft’s iconic releases and even many years have passed since it first came into being but its popularity has only increased. Excel provides us with the power of tabulating and evaluating data of all sorts and types with main focus given to the operation asked for by the business […]

Read More
Free Excel Help – AVERAGE Function

Microsoft Excel is one of the leading analytical tools available in the market, and is the most used spreadsheet application in the world, being widely used by financial and analytical firms as well as students for calculating and analyzing data. Excel is known for its simple nature and high affectivity. Because of its easy to […]

Read More
Free Excel Help ISERROR Function

  If you are an experienced Excel consultant you know what this free Excel help article covers. If you are a small business owner looking for help on this topic, it means that you might have not come across this before. So exactly what is the problem and what does this article cover? A cell […]

Read More
Free Excel Help – SUMSQ Function

Microsoft Excel features built-in functions that have the ability to perform calculations. These mathematical functions are useful especially to Excel consultants. You can perform different mathematical operations with the use of these Excel’s functions. While there lots of functions in Excel, this free Excel help article will provide a detailed discussion of the SUMSQ function. […]

Read More
Free Excel Help – TRUNC Function

If you work in business you should know what Microsoft Excel is. Microsoft Excel is a spreadsheet application produced by the Microsoft Corporation. It allows businesses and its users to calculate, format and organize data using formulas and functions. Excel is part of the Office Suite, thus, it is compatible with other software applications in […]

Read More
Free Excel Help – SQRTPI Function

Microsoft Excel has lots of useful functions for Excel consultants to use, especially the mathematical functions which can be used by students and even the professional in their respective fields as well. These functions allow the Excel programmers to perform from simple to complex mathematical calculations. Also, they automate the calculation process for the users. […]

Read More
Free Excel Help – SQRT Function

Basic Description of the SQRT Function in Microsoft Excel The SQRT function in Microsoft Excel computes the positive square root of a given numeric value. The formula of the SQRTR function is: =SQRT (number) In this formula, the number argument is the number in which you want to calculate the square root of. This argument […]

Read More
Free Excel Help – SIGN Function

Microsoft Excel features numerous built-in functions for the average Excel consultant to use. This Excel help article will discuss just one of the functions of Microsoft Excel which is called the SIGN function. In order for you to learn the usage of this function easily, you will also be provided with a simple procedure on […]

Read More
Free Excel Help – QUOTIENT Function

When it comes to organizing and calculating data, one of the widely used computer programs is Microsoft Excel. In terms of calculation, Excel has so many functions, in order to be able to perform mathematical operations efficiently. One of the functions in Excel is quotient. This is very essential particularly in dividing the values entered […]

Read More
Free Excel Help – PI Function

Pi is a constant used in mathematics whose value is the ratio of the circumference of a circle to its diameter. This mathematical constant is approximately equivalent to 3.14159 in the normal decimal positional notation. There are lots of formulas in engineering, science and mathematics which involve Pi. Because of this, Pi is one of […]

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