Electrosonic

A New Microsoft Excel Client and Their Unique Need   We had a company call us with a request to document their Excel files. The person that wrote them, formulas and macros, left.   We documented two file consisting of over 20 sheets and 1,000 lines of VBA code by producing a 10 page PDF. […]

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

Free Excel help article on Microsoft Excel keyboard shortcuts. Navigating within a worksheet Keyboard shortcut                                          Action Tab, ->                                                             Skips to the next cell on the right Shft+Tab, <-                                                    Skips to the cell on the left ?                                                                     Move one cell up. ?                                                                     Move one cell down. Ctrl+->                                                             Move to the last occupied cell of a row of data Ctrl+<-                                                             Move to the […]

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

In mathematics, there are the so-called hyperbolic functions which are almost similar to the trigonometric functions. One of these functions is the hyperbolic sine. Hyperbolic functions are mostly used in solving mathematical problems or equations, specifically, trigonometric problems. They are most often used by students in engineering, mathematics and science or even the experts. Not […]

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