The Application Window

Acessing the control menu I
Acessing the control menu shortcut

The Workbook

Numerically set the coloumn width II
Numerically change the row height II
Changing the tab color IIA
Changing the tab color IIB
Turning of the gridlines

Using  formulas

Compound operations and Parenthesis

How to use the functions  in the Formula bar  
How to use arrays
controlling calculations
auto complete formula
Autofill formula
when new data is added you can get Excel to autofill a new line of formula

using formulas across sheets

Referencing information

Relative referencing
Absolute referenccing colums
Absolute referencing rows
Absolute referencing of row and column
Relative & Absolute Referencing kb Naming Cells
Naming Ranges
3d referencing

=SUM(sheet2:sheet11!D5)

Display Settings

Hiding rows (for no print kb)
Hiding columns
Unihinding rows
Unhiding columns

Zoom settings

Opening multiple windows

Working with Worksheets

The concept of sheets kb
Add worksheets
Delete worksheets
Move worksheets

Copy  worksheets

Preparing Your Data

Creating a tables
formatting tables

Labeling Cells

Labeling your pages in color

Ordering data

Sorting data

Filtering data

Consolidating data

Finding data

Finding and replacing data

Formatting Data II

Formatting Decimals II
Formatting to Fractions II
Formatting to Percentages II Formatting to Currency II
Using Commas II
Formatting as time II
Formatting as dates II

Formatting Dates to date values II

Formatting Text

Changing the size of text II

Changing the text font II

Changing the text color II

Changing the style of text to bold II

Changing the style of text to italic II

Changing the style of text to bold italic II

Underlining text II

Double underlining text II

Underlining text for accounting II

Double underlining text for accounting II

Formatting to subscript II

Formatting to superscript II

Formatting to strikethrough II

Positing text in the middle of a cell II

Positioning text in the top of a cell II

Positioning text in the bottom of a cell II

Aligning text to the left II

Aligning text to the right II

Aligning text in the center II

Indenting text II

Wrapping text

Changing the orientation of text

Sticky keys

Merge cells
Merge and center text II

Formatting Cells

inserting & deleting cells

merging and splitting cells

applying built in formats and styles

auto formatting
Creating cell borders II

Comment Boxes

Creating a Comment Box from an auto shape
Rotating text in a comment box

Showing results in a comment box

Formatting Rows & Columns

Inserting & deleting rows

Inserting & deleting columns

Modifying the size of columns

Modifying the size of rows

Intermediate Functions
The SUM() function with different ranges
The SLOPE() function
The LINEST() function
Using the FORECAST() function How to use the CORREL() function Interpolation
The Intercept() function
The Intersect()Function

The LOG() function
The LOG10() function
The LN() function

The EXP() function
The POWER() function The ROMAN()function
The EVEN() function
The ODD() function
The MOD() function
The TRUNC() function

The LOWER() function
The UPPER() function

The VAUE() function

Statistics Functions

The AVERAGE() function

The MEDIAN() function

The MODE() function

The PERMUT() function
The COMBIN() Function

The STDEV() function

The PERCENTILE() function

The PERCENTRANK() function

The POSSION() function

The NORMDIST() function

The FREQUENCY() function

Linear regression

Line of least squares fit

Using Trigonometric Functions

Trigonometric functions index
Using constants such as Pi
The RADIANS() function
The DEGREES() function
The SIN() function
The COS() function
The TAN() function

Date & Time Functions

Time stamping
Date stamping

The NOW() function
The TODAY()

function

The TIME() function
The TIMEVALUE() function
The HOUR() function
The MINUTE() function
The SECOND() function

The DAY() function
The MONTH() function
The YEAR() function
The YEARFRAC() function

The WEEKDAY() function
The WEEKNUM() function
The WORKDAY() function
The NETWORKDAYS() function

The DATEVALUE() function
The DATE() function

The DAYS360 funvtion
The EOMONTH() funvtion
The EDATE function

Business/Finalncial Functions

Logical Functions

The TRUE function
The FALSE function

The AND function
The OR function
The NOT function

The IF function
Nested IF functions
The IFERROR() function

Types of Charts

How to make a multiple line chart

How to make an area chart

How to make a cartogram

How to make a pictogram

Bar Charts

How to make multiple bar charts
How to make a horizontal bar chart
How to make a clustered bar chart

How to make a stacked column chart

How to make a cluster column chart

How to make a stacked bar chart

Scatter plots

How to make multiple scatter plots

Formatting scatter charts index
How to make a Trendline
Using exponential line of best fit

Using polynomial lines of best fit

Histograms

How to make a histogram
How to make a 3d Histogram

Formatting Histograms index
How to change bin size

How to color a Histogram
How to change line color