Terms
Cells, Columns, Rows, Axes, Gridlines
Function: set of calculations
Formula: function in action with arguments
Basics
Resizing columns
Selecting
Relative pasting
Auto-fill pasting
Home tab
Conditional Formatting
Highlight Cell Rules
Duplicate Values
Sort -> Selected Color on Top
Data Bars
Icon Sets
Format as Table
Table Tools tab
Table style options
Drop down options
Auto expand formula
Insert tab
Pivot Table
Pivot Chart
Which product was purchased the most? By which customer?
Formulas tab
Functions: http://office.microsoft.com/en-us/excel/CH100645021033.aspx
Trace Precedents
Show Formulas
Evaluate Formula
Data tab
Removing Duplicates
Data Validation
Status Bar
Right click
View Switcher
Insert Worksheet
Command Reference Guide: http://office.microsoft.com/en-us/excel/HA101491511033.aspx?pid=CH100648241033 |
