EXCEL Demonstration Topics

Take the time to learn EXCEL. The payoff will be huge! Using and naming multiple worksheets Formulas Locking columns and rows using $ Borders Coloring cells Centering text across multiple cells Aligning text Changing decimal places Changing number format Functions Financial PMT PV FV Statistical COUNT COUNTA COUNTIF LINEST AVERAGE MEDIAN MODE AVEDEV STDEV VAR Date and Time DAYS360 Math POWER SQRT EXP RAND MOD FLOOR CEILING Graphing Text boxes Importing data from the web - Text to Columns Paste special to remove formulas Shading cells to make a histogram or bar graph Headers and footers Freezing panes Cut and past between word and excel