Concepts you will master:

• Clear vs. delete
• Contiguous range
• Non-contiguous range
• Series
• Conditional formatting
• Comments
• Workbook protection
• Arrays
• Frequency distribution
• What If tables
• Lookup tables
• Nested function
• Goal Seek
• XY charts
• Pie charts
• Data series
• Value axis
• Category axis
• Legend
• Tickmarks
• Gridlines
• Sheet tabs
• Data table
• Scatter chart
• Radar chart
• Donus chart
• Bubble chart
• High-Low-Close chart

• Writing a formula using the IF() function
• Clearing the contents of a range, row or column
• Deleting the contents of a range, row or column
• Selecting multiple, contiguous rows or columns
• Selecting multiple, non-contiguous rows or columns
• Inserting rows and columns
• Finding and replace spreadsheet data
• Using the spell checker
• Using the Format Painter to format cells
• Using the NOW() and TODAY() functions
• Using the DATE() function to compute a date
• Performing date calculations
• Using the DATEVALUE() function to convert a text date
• Using AutoFill to copy formulas
• Using AutoFill to create a series
• Using conditional formatting to format a cell
• Hiding rows and columns
• Freezing portions of the screen so the cell data doesn't scroll
• Splitting the screen into two or four panels
• Creating a re-usable custom view
• Adding comments to a worksheet
• Protecting a worksheet from unauthorized editing
• Creating a simple array formula
• Creating a frequency distribution table
• Creating "What-If" tables to analyze variables
• Using the PMT() function to compute a mortgage payment
• Using the VLOOKUP() and HLOOKUP() functions to create lookup tables
• Nesting multiple functions to create complex computations
• Using AutoFormat to apply a custom format to a worksheet
• Adding a text box to a worksheet
• Using the Paste Function button to build a function
• Creating a 30-year loan amortization schedule
• Using Goal Seek to find a result for a cell by adjusting the value of another cell
• Graphing worksheet numbers
• Printing a graph