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
What We Do For the Local Southern California Community

What We Do For the Local Southern California Community   For the past 25 years Excel and Access, LLC has been committed to assisting local non-profit organizations, educational institutions, and governments in our SoCal community   We Are Committed To Serving Our Local Community At Excel and Access, LLC our team of Microsoft masters is […]

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
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 – 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 – 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
Free Excel Help – Named Ranges

Dynamic named ranges are one of the strongest aspects of Excel. It is commonly used in listing the controls, PivotTables, and charts. First thing is to formulate a list in column of A of your worksheet. Before anything else, there are still problems that could surface such as the updating or redefining of the named […]

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

The Microsoft Excel function we’ll learn in this Excel help article is the RANDBETWEEN function. So what does the RANDBETWEEN function do? RANDBETWEEN generates random numbers between a range of numbers. This Excel function is very useful if you want to generate numeric data in a spreadsheet for testing purposes.  The syntax of the function […]

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

Microsoft Excel is the most widely used spreadsheet application in the world, it is written by Microsoft for both the Mac OS X and for Windows. It is typically used to manipulate and display numerical data. In Microsoft Office, Excel is used to manipulate data via various tools for analysis and organization, enabling the user […]

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