The Workbook Numerically set the coloumn width II Numerically change the row height II Autofit cell width to fit contents AutoFit cell height to fit contents AutoFit column width to fit contents AutoFit row height to fit contents Changing the tab color IIA Changing the tab color IIB Turning of the gridlines Changing gridline color

Workbook Windows Create a Freeze pane Unfreeze frozen panes Create a split screen Remove a split screen Compare windows side by side Vertically arrange windows Horizontally arrange windows Cascade windows Tile Windows

Manipulating Cell Contents II Copy and paste II

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

Formatting Tables AutoFormatting a table I Using table AutoFormatting options Creating table borders II Drawing table borders Changing the table border colors Changing the table border style Set table color fills Clear table formatting I

Intermediate Functions Inserting functions from the menu Inserting function form the formula bar Typing functions directly into cells 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 SIGN() function The TRUNC() function The PRODUCT() function The QUOTIENT() function The LCM function The GCD function The LOWER() function The UPPER() function The VAUE() function

Functions Loading the Analysis Tool Pack The COUNT() function The COUNTA function The COUNBLANK function The COUNTIF() function The SUMIF function The SUMIFS fucntion The SUMPRODUCT() function The SUMSQ() function The SERIESSUM() function The SUBTOTAL function

Statistics Functions I The AVERAGE() function The MEDIAN() function The MODE() function The PERMUT() function The COMBIN() Function The STDEV() function The PERCENTILE() function The RANK() function The PERCENTRANK() function The NORMDIST() function The FREQUENCY() function The RSQ() function The PEARSON() function The TREND() function The GROWTH() 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/Financial Functions The INTRATE() function The RATE() function The NOMINAL() function The RECIEVED() function The PV() function The NPV() function The PMT() function The EFFECT() function The IPMT() function The IRR() function The PRICE() function The YEILD() function

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

Formatting Charts Add a title to a chart Add axis label to chart Add a legend to a chart Turn off text auto-size when resizing chart area

Line Charts How to make a line chart II How to make line chart III How to make an area chart

Bar/Column Charts How to make clustered bar charts II How to make a clustered bar charts III How to make a stacked bar chart How to make a clustered column chart II How to make a clustered column chart III How to make a stacked column chart How to make a pictogram Formatting bar charts Changing the bar color Changing the bar outline color Chanigng the bar separation

Scatter plots Creating a scatter chart II How to make multiple scatter plots Formatting scatter charts index Add a series to a scatter plot Add new data points to the same seires Change the starting point of the data series on the x axis Change the end point of the data series on the x axis Creating a dynamic ranges Creating dynamic ranges based on dates

Histograms How to make a histogram Formatting Histograms index How to change bin size How to color a histogram How to change line color How to add statisitical data

Using Advanced Formatting How to create a simple pivot table Customizing a pivot table Adding multiple variables Types of Sorting kb Types or Grouping kb Moving Category Data Copying

Formatting Pages Creating styles Applying styles Setting default page set up options Change page orientation Change page scaling Set margins and center Create page headers Create page footers Adding a file name or network path to a worksheet Removing a hyperlink II

Tools Inserting a hyperlink II Changing the autosave settings Showing the protextion toolbar Setting permissions I Setting permissions II Password protecting workbooks

Printing Document quick print formatting the print area using print preview Creating a print area Removing a print area