Posts Tagged ‘excelisfun’
July 26th, 2010
See how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula. Link for file: flightline.highline.edu
Tags:
July 19th, 2010
See the functions ROWS, COLUMNS, and CHAR in a formula that will create a data set.
June 28th, 2010
See how to create a dynamic frequency table and histogram chart using Defined Name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic. This dynamic chart and table will update anytime that new data is added to column A.
June 15th, 2010
Use PivotTable to Group Numbers, calculate Frequency, % Total, Cumulative Total, % Cumulative Total. See how to: 1. PivotTable (Pivot Table) 2. Group Integers in PivotTable 3. Count numbers 4. use “% of Column Total” in “Value Field Settings” “Show values as” tab 5. use “Running Total in” in “Value Field Settings” “Show values as” tab 6. use “% Running Total in” in “Value Field Settings” “Show values as” tab, which is new to Excel 2010 New Excel 2010 PivotTable Pivot Table Feature “% Running Total in. Also see this video: Excel Statistics 26: Cumulative Freq. Dist w Pivot Table (Running Total)
April 27th, 2010
See how to count records that match 3 criteria and add conditional formatting to a database with three columns. Also see how to find errors in formulas.