4GAEOP
  • Home
  • Resources
  • Shortcuts and Timesavers
  • Microsoft 365
  • Excel One
  • Excel Two
  • EXCEL THREE
  • The Art of Sway
  • PowerPoint
  • OneNote
  • Publisher
  • Google
    • Google
    • Google Draw and Forms
  • Adobe Forms
  • Word Basics
  • Outlook Basics
  • Outlook Advanced / Google Surveys
  • Contact Us
  • Social Media
  • Calendar Tricks
Picture

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 
Picture

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 
Picture

Formulas, Functions and More

Picture
Conditional Formatting
Picture
Picture

Charts

Picture
Picture
Picture

Find and Replace 

Picture

Text-to-Columns




​
Picture

Concatenate and TextJoin




​
Picture

Converting Formulas to Values

Sunburst Charts





​
Fundraiser



​
  • Home
  • Resources
  • Shortcuts and Timesavers
  • Microsoft 365
  • Excel One
  • Excel Two
  • EXCEL THREE
  • The Art of Sway
  • PowerPoint
  • OneNote
  • Publisher
  • Google
    • Google
    • Google Draw and Forms
  • Adobe Forms
  • Word Basics
  • Outlook Basics
  • Outlook Advanced / Google Surveys
  • Contact Us
  • Social Media
  • Calendar Tricks