Tutorials

• Create a clustered bar chart
• Conditional statistics
• Correlation
• Counting observations
• Dispersion
• Frequencies
• IF statements
• Naming ranges
• Optimization
• Percentiles and quartiles
• Generate random data
• MIN, MAX, LARGE and SMALL
• Referencing sheets inside a workbook
• Sorting data
• Weighted averages