Our Microsoft MVPs

A 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 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
Our Team: Meet Stan B.

Name: 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 More
Our Team: Meet Paul Delke

Name: 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 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 Dennis Taylor

Name: 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 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
Office 2016 is Here! How Excel Consultant Can Help

Today is an exciting day for the Microsoft community! Office 2016 is making its big debut. This release is the first major update Word, Excel, PowerPoint, and other applications since Microsoft launched Office 2013 over two years ago. At Excel Consultant, we understand that figuring out how to implement new programs can be both exciting […]

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
What is a Microsoft MVP?

When 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 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 – 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 – 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 – 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 – 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 – 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 – 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 – 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 – 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 – 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 – Nested IF Statements

We’ll  look at the nested ifs and how to enhance if formula using the “AND” and “OR” conditions. So what is a nested if? Nested if or Nested ifs (if there are more than two used in a nested fashion) is when you can use more than one or more if formula within another if […]

Read More
Free Excel Help – Index and Match Functions

For this free Excel help article, for our example let us assume we have a table of sales data for a year for 6 salespersons in a company. Now let us see how using match we can pull out sales data from this table when a month and a salesperson’s name is provided. The format […]

Read More