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
Integration and Automation with Microsoft’s VBA

Integration and Automation with Microsoft’s VBA   If you want to get the most out of your Microsoft desktop productivity tools, such as Excel, Access, and Microsoft’s Power BI you will need to maximize both integration and automation with Microsoft’s VBA. VBA is the glue that binds the various Microsoft Office applications, in addition to […]

Read More
Making Microsoft’s Vision a Reality

Making 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 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
The Story of Microsoft Excel

The Story of Excel Today, only talk of an electronic spreadsheet and Microsoft Excel quickly comes to mind. You wonder whatever happened to Lotus 123 and other products that once seemed to rival Microsoft Excel. In its current format, Microsoft Excel 2016 (Both Windows & the Mac), delivers a game changing relational database via Microsoft’s […]

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, California, Jacob […]

Read More
Expand Your Excel Knowledge with VBA Express

Microsoft Experts At Excel Consultant, our team of expert instructors, programmers, and advisers is passionate about helping individuals and businesses harness the power of Microsoft technology. Many people merely skim the surface of what programs like Excel can accomplish, never realizing how useful they could truly be. Our cutting-edge consultants have devoted themselves to learning everything […]

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
Joseph Carrier, CTO and Project Manager, Promotion

Excel Consultant’s business is booming. Our team currently helps companies, organizations, and institutions throughout the United States, Canada, Europe, and Australia leverage Microsoft tools to their advantage. Our experienced programmers, instructors, and consultants use their expertise to design customized, sophisticated solutions that help businesses succeed in the digital age. As our company expands, we rely […]

Read More
What is a Microsoft Certified Partner?

At Excel Consultant, we are committed to helping your business, organization, or institution leverage the power of Microsoft products to your advantage. Our experts maintain an in-depth knowledge of these tools and use their expertise to design customized solutions to suit your needs. To keep up with the latest software developments and establish our credentials […]

Read More
Free Excel Help – Chart Titles

There are many features available in Microsoft Excel that could help you in making your presentations come to life. One of the features is that you can make use of are Microsoft Excel charts and graphs, which help you when it comes to presenting large amounts of numerical data. There are a lot of choices […]

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 – Named Ranges Vlookups

For those new to Microsoft Excel the Excel VLOOKUP can initially be difficult to understand, yet it is so useful that it is a requirement for anyone that wants to be an Excel consultant or financial analyst must master it. As you probably already know, Microsoft Excel is a powerful spreadsheet application that contains numerous […]

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 – 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
Microsoft Excel Pivot Tables

Microsoft 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
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 – Keyboard Shortcuts For Business

For most people, when it is your first time to work with Microsoft Excel, you will concentrate on just completing your task rather than learning how to work efficiently for a faster completion of your task. That can usually be said for any software application. However, when you are ready to learn about the keyboard […]

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 – 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 – Data Consolidation

For our example let us consider several Microsoft Excel worksheets say for the various months from January till December containing sales data spread across an array of cells ranging from B5 to E16. Now suppose we wish to do a sum function just on only the data for the months of January and February, i.e. […]

Read More
Free Excel Help – Remove Duplicates

There may be several occasions when you don’t want duplicate records in your Microsoft Excel spreadsheet. For instance you are preparing a list of employees in your company for the annual bonus payments and you certainly do not want an employee’s name occurring twice. In this article we’ll look at how duplicates can be detected […]

Read More
Free Excel Help – RAND Function

Microsoft Excel is a powerful spreadsheet application featuring formulas used for organizing, calculating and formatting data. It’s usually bundled by Microsoft in the Office Suite which is compatible with other Microsoft applications. In 1982, the earliest software program released was called the Multiplan, which has the same features as with Excel. With Excel an Excel […]

Read More
Free Excel Help – RADIANS Function

When talking about programs that can be used for calculations the number one option is Microsoft Excel. This program is used by companies engaged in huge computations such as finance companies, architectural companies, engineering companies and a lot more. The program provides different mathematical functions for it to accommodate different mathematical problems. In this free […]

Read More
Free Excel Help – POWER Function

The Basics of the POWER Function in Microsoft Excel The POWER functions in Microsoft Excel computes a given numerical value raise to a supplied exponent or power. The formula of the POWER function is: POWER (number, power) In this formula, the power and number arguments are number values. These arguments can be entered in the […]

Read More
Free Excel Help – MULTINOMIAL Function

Many people find it difficult to solve multinomial problems or equations. It’s really hard to do manually especially when you are working with large multinomial factorial equations in mathematics. Luckily, Microsoft Excel features a useful function to address that problem. This Excel function is called the MULTINOMIAL function. To begin with, try to read this […]

Read More
Free Excel Help – PRODUCT Function

One of the Microsoft programs mostly used is Microsoft Excel. It is used to organize data and information and to perform calculations. Using this program requires proper knowledge about the different functions for it to work efficiently. In connection with the different functions that Microsoft Excel has, this free Excel help article will talk about […]

Read More
Free Excel Help – ODD Function

The Excel’s ODD function rounds an entered number value to the nearest odd number away from zero. The function rounds up a positive number and it rounds down a negative number. The syntax of the Excel’s ODD function is: =ODD(number value) In this formula, the number argument is the numeric value that needs to be […]

Read More
Free Excel Help – String Functions

In an earlier free Excel help article we explained how you could use basic formatting of text to extract data from a cell, particularly when we import text and data from other files such as .csv files. In this article we’ll delve a bit deeper and study them more closely. Assuming we imported names of […]

Read More
Free Excel Help – Prevent Duplicates

In this free Excel help article we’ll discuss the various methods that will ensure that you do not have duplicate entries in your Excel spreadsheet. The method we are going to use is Data Validation where we can use a custom formula to prevent duplicates from being entered into the spreadsheet. Assume that we have […]

Read More