Alt+=
Ctrl+=
Shift+=
Alt+S
Lock Cells
Freeze Panes
Split Sheet
Protect Sheet
Line Chart
Bar Chart
Pie Chart
Scatter Chart
SUM
COUNT
AVERAGE
MEAN
Drawing charts
Summarizing large datasets
Formatting sheets
Printing reports
4
20
25
50
Doughnut Chart
Radar Chart
Deletes unwanted data
Hides records not matching criteria
Sorts data automatically
Creates reports
=ADD(A1:A10)
=TOTAL(A1:A10)
=SUM(A1:A10)
=SUM(A1,A10)
DCOUNT
DCOUNTA
COUNTA
COUNTIF
Evaluating different scenarios
Creating charts
Goal Seek
Sort
Filter
Sorts data
Adjusts row/column size automatically
Creates formulas
Protects cells
Validation
Protection
Formatting
Column Chart
Pivot Table
Data Validation
AutoFill