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
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
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