Excel Help Blog

There are 1,048,576 rows by 16,384 columns in a single worksheet. The total number of characters that one cell can contain is 32,767. There are 16 million colors to choose from in a workbook. The most limiting aspect of Excel is the available memory on a computer, something the system has no control over. With […]

Do you use Office 365 in your business? Now might be the time to either start, or to consult with an expert on how best to use the “anywhere, anytime, on any device” system. Why?  Office 365, Microsoft’s cloud-based version of the Office software, has a whole set of features that cater to business needs: […]

The average management position has become as numbers-driven as finance. Big data is driving more decisions in strategy and development at every level. As a result, Microsoft has been enhancing Excel software to make it more of a data analysis tool for managers who aren’t techies. PowerPivot, one of the most popular add-ons over the […]

According to an article from ZDNet, a breach of Australian Department of Immigration and Border Protection data was the result of human error.

A recent article from Breaking Views, a financial insight blog, makes that case that whenever you are creating such a data heavy report, there are going to be some errors.

A recent article from Microsoft lays out several major benefits that companies have been able to reap because of Excel.

At a press event earlier today, Microsoft CEO Satya Nadella spoke about the company's mobile and cloud strategy and the event was headlined by Office for iPad.

With the right Excel consulting service and/or Excel training, even the most complicated spreadsheets can be streamlined and automated.

Custom applications written in VBA for Excel enable you to leverage Microsoft Office Software that is likely already loaded on your computer. These applications can analyze large data sets using powerful analytic techniques and generate summaries with understandable visuals that give healthcare providers insights into patient health, patient care, and practice performance like never before. […]

Dynamic tables provide you with a host of additional features that a simple manual data list will not. For instance, look at the first section (A1:F6). This is how most manual lists are maintained within a simple Microsoft Excel worksheet. By simply selecting the range, in this example: (A9:F14), selecting the Insert Tab in the […]