Blog: Excel Release notes, how-tos and statistical explainers from the Analyse-it team, newest first.
- 2019
-
Latest Analyse-it improvements – round-up
We’ve been busy over the last few months adding various new features and improvements to Analyse-it.
- 2018
-
Microsoft Windows, Office 2016, multiple monitor DPI awareness - and Analyse-it's missing user interface
Update 19-Sep-2019: Unfortunately this continues to be an issue for some users and unfortunately there is currently no solution from Microsoft except to suggest the use of compatibility mode as detailed below.
- 2015
-
Analyse-it 4.20 released: Support for Excel 2016
Microsoft officially released Office 2016 a couple of days ago, and Analyse-it version 4.20 now adds support for Excel 2016.
- 2008
-
Numbers stored as text in Excel, and why SUM ignores them
In clearly titling this blog post, we’ve probably already revealed the answer, but... Can you spot the difference between the two rows of values in the Excel spreadsheet shown below?
-
Using INDIRECT to refer to cells on Analyse-it analysis reports
A customer contacted us last week to ask how to refer to cells on an Analyse-it report worksheet, from a formula on another worksheet. The customer often used Analyse-it's refresh feature, to repeat the statistical analysis and update the statistics, and direct references to…
-
How to print a chart on a full page in Excel
Although the charts in Analyse-it are large so they’re easy to read when printed, sometimes you need to print a chart to fill the full page. You can do so easily, without resizing the chart, in just a few steps: