Gary Eckstein Microsoft Office 1 COUNTA, excel, Function (mathematics), Microsoft Excel, Microsoft Excel 2007, SUMPRODUCT
I recently had the need to count the number of rows in a Microsoft Excel 2007 workbook. Normally I’d be able to use the ROWS function that ‘Returns the number of rows in a reference or array’. ROWS wouldn’t meet my needs as I required to calculate the number of rows where any value besides [...]
Gary Eckstein Management 0 analysis, AQF, Australia, Australian, bubble chart, data, data analysis, data values, excel, graphs, Histogram, NCVER, New South Wales, NSW, Pie chart, Treemap, visual representation, visual representations, Visualization, Vocational education, vocational education and training
Visualization of data and information can take many forms. Data in the form of text and numbers often don’t convey the obvious conclusions that may be reached from the data. Visual representations of data however may make data far more simple to understand and, particularly with large and complex data-sets, quicker from which to draw [...]
Gary Eckstein Microsoft Office 0 excel, Software, tutorial
A Microsoft Excel 2003 or Excel 2007 workbook may contain multiple Spreadsheets (commonly known as Sheets or Tabs). Occasionally it is desired that the sheets are hidden from view. An example is where charts need to be displayed however the underlying data is not required to be seen. There are two options available for assigning [...]
