Agenda
*Where to get help.
*Modeling
​*Project Work

• Getting Help with Lynda
• Download working sheet here
• Gathering data from other sheets or cell
• Review basic formulas and add a couple more
  • Count, Countif, Rank, Concatenate, 
  • Text to Columns
  • Using search to find additional formulas or functions

• Formulas to Values
• Conditional Formatting
• Freeze Panes
• QAT; Customize Your Quick Access Toolbar
• Creating Bar and Pie Charts 

Referencing Cells and Sheets

Copy Pages

• Select a page that has been completed and copy it over to one of the blank teacher pages.
• Be sure to change some of the numbers in at least every column to teachers will have different totals.
• Link ranges on Totals sheet.

Link Teacher Data into a Comprehensive Totals Sheet 

Formulas, Functions and More

Conditional Formatting

Charts

Find and Replace 

Text-to-Columns

​

Concatenate and TextJoin

​

Converting Formulas to Values

Sunburst Charts

​

Fundraiser



​