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
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 – If Statements

Microsoft Excel If functions are very useful in the flexibility and decision making aspects of your spreadsheets. It helps in generating and in testing if the data or the state of your spreadsheet is true or false. The function will carry out an action if the condition or state of your spreadsheet is true or […]

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

Microsoft Excel is one of the leading analytical software tools available in the international market and is widely used by Excel consultants, financial and analytical firms as well as small business for calculating and analyzing data. Microsoft Excel is known for its ease of use and sheer power. Most importantly, it possesses a wide array […]

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

The Microsoft Excel application is one of the greatest programs that Microsoft has ever been able to create and without a doubt a software without which you just can’t do without if you are an Excel consultant. Because of its easy to use and learn implementation, Excel has become hugely popular all over the world […]

Read More
Free Excel Help – RoundDown Function

For all the analysis that is being done by the Excel consultants at the major as well as small-scale business firms all around, Microsoft Excel is the primary tool used by almost all of them. It is known for its very easy to use features. Without a doubt, the best feature in Microsoft Excel is […]

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

Microsoft Excel is the most preferred data analysis tool in the market today. All the major analytical firms and business organizations have long back started using Excel as their major financial tool and it is no surprise that such a thing has happened. If you are an Excel consultant you live in Excel. If you […]

Read More
Free Excel Help – IRR Function

The Microsoft Office Suite has a wide range of software that is essential for any business to run properly and one such application in the suite is Microsoft Excel. Excel is the dominant spreadsheet application and business tool that almost every firm uses nowadays. Because of its easy to use features and host of functions […]

Read More
Free Excel Help – NPV Function

Microsoft Excel has been one of the most used applications in the Microsoft Office Suite and over the years has developed not just as a vital tool for Excel consultants and office workers but also for all data-related activity that is possible both at home, and business. So, with Excel there lies the power of […]

Read More
Free Excel Help – COUNTIF Function

The Microsoft Office Suite has a wide range of efficient and relevant software that is essential for any business to run properly and one such application in the Suite is Microsoft Excel. Excel is the widely preferred data business analysis and reporting tool that almost every firm uses nowadays. Because of its easy to use […]

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

  Microsoft Excel is a software program used to develop, create and organize data using the spreadsheet or worksheet interface. Excel users and businesses often use it to deal with calculating, organizing, graphing and formatting data. Microsoft Excel has basic features, which are used for organizing data and for data management. Excel is also used […]

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

Using Microsoft Excel, you can easily create a new spreadsheet. However, you have to be familiar with the different functions and formulas of Excel to make it useful. One of the available functions in Microsoft Excel is the SIN function. Not often used by Excel consultants, but still of importance, so we will cover it […]

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

When it comes to mathematical operations, one of the most efficient computer programs to use is Microsoft Excel. Lots of businesses, companies, professionals and students depend to this program for them to efficiently organize and compute data on a daily basis, especially professional Excel consultants. One of the vital Excel function in mathematical operation is […]

Read More
Free Excel Help – RANDBETWEEN Function

Microsoft Excel is a powerful spreadsheet application featuring formulas used for organizing, calculating and formatting data. It’s usually bundled by Microsoft in their Office Suite, which is compatible with other Microsoft Office applications such as Word and Outlook. Excel is used in almost every business, by almost every Excel consultant, in almost every part of […]

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