Moving data around a spreadsheet

Pivoting rows & columns

Creating a pivot chart reports

Modifying a pivot chart report a what if analysis

Using smart tags

Opening multiple windows

Advanced Data Display

how to use data markers

using error bars

using trend lines

summarizing data in lists

Work Book Settings

Sharing workbooks
Routing workbooks
Merging workbooks
Publishing work books to the internet. 
Linking workbooks with formulas Limitations of shared workbooks or Grouping worksheets

File compatibility

Formatting Data III

Formatting Decimals III
Formatting to Fractions III Formatting to Percentages III

Formatting Dates III
Merge and center text III

Cell Formatting II

Apply conditional formatting
How to Remove conditional formatting.

Apply more than one conditional format
View conditional formatting in a sheet
View cell with the same conditional formats for a row or column.

How to use the format painter

mapping your spreadsheet
does cell have formula function.

creating and advanced lookup table

conditional formatting

vlookup when setting ranges of user defined functions.

Customizing Excel

Creating custom buttons  Customizing tools bars

Using If Statements

Validating cell entries Filtering data

Sorting data

Using Advanced Formulas

Creating user defined constants

Advanced Math Functions

IMAGINARY()
COMPLEX()

QUOTIENT()
MOD()
PRODUCT()
SIGN()

RANK()

MMULT()
MINVERSE()
MDETERM()

Advanced Stats Functions

linear regression equations NORMSDIST
VAR
STDEV
continuous distribustion

Inverse functions
CHIINV,
FINV,
NORMSIV
TINV

Discrete functions
BINOMDIST()
QUARTILE()
POISSON
CONFIDENCE()
RAND()
non repeating random numbers

RANDBETWEEN()

Advanced Trig Functions

The ACOS() function
The ATAN() function
The ASIN() function

The COSH() function
The SINH() function
The TANH() function

The ACOSH() function
The ASINH() function
The ATANH() function

Reference Functions

Creating Excel Templates working with templates Protecting data Importing data Exporting data

Exporting data from Excel into a database (Access)

Advanced Charts

Creating a water fall chart
2-axis logarithmic charts
Creating a 4 quadrant chart
Creating a Bubble chart
Creating a Gantt chart
Creating an organizational chart/diagram
Printing charts

Editing chart data
Changing a chart's data range
creating a dynamic range based on dates
Showing error margins
Examples of different types for error display demo

Advanced Fortmatting
changing axis locations
adjusting scale
axis view data with chart
creating dual axis charts
show hide legend

3D Charts
3D pie charts
3D scatter graphs
3D buble plots
3D bar charts
contour map

User defined functions & Plugins

How to create your own function

Downloading and using custom functions

Working with Macros

What is a macro
recording and running a macro
the relative nature of macros
editing a macro
debugging a macro
animating a chart with a macro animating a line chart
controlling charts with buttons

controlling charts with list boxes

Tools

Inserting a hyperlink III