Learning Pathway: Microsoft Excel
Our Microsoft Certified Trainers will help you enhance your productivity and streamline your data management with comprehensive Excel training!
Designed for these job roles
- School Administrator
- School-Based Data Specialist
- School-Based Administrator
Unlock the full potential of Excel with our specialized sessions for system administrators! Master the essentials, from organizing and formatting data to using advanced functions. Dive into data analysis, conditional formatting, and learn to clean and prepare data efficiently.
- Option 1 : Onsite day with 2 sessions per day (3 hours per session, 2 days total)
- Option 2 : All 4 sessions delivered remotely (3 hours per session, 12 hours total)
- Option 3 : Pick one session, repeat 2x for one full day (24 remote hours or 4 onsite days)
Expected Outcomes
- Understand the importance of using research-based instructional practices
- Experience instructional practices that promote student engagement
- Develop a toolbox of engagement strategies that can be used in the classroom immediately
- Reflect on professional growth and use data to plan future instruction
Learning Pathway
Getting Started
This session covers the fundamentals of Excel, including terminology. organizing and formatting data, using common tools and shortcuts, building basic formulas, and preparing an Excel file for printing.
Adapting Data
This session covers using Excel to clean, prepare, and format data, as well as using formulas to manipulate and combine different types of data.
Analyzing Data
This session covers using Excel to review, organize, and analyze data, including formatting and filtering data, using AutoSum tools, creating and using PivotTables, and applying conditional formatting
Using Advanced Functions
This session covers advanced Excel functions, including tables, logical functions (IF, AND, OR), lookup and reference functions (VLOOKUP, MATCH), mathematical functions (COUNTIF, SUMIF), data validation, and field protection.
Table of Contents
- Designed for these job roles
- Expected Outcomes
- Learning Pathway
Designed for these job roles
- Instructional Coach
- Teacher
Scan the QR code to view our course catalog! For more information, feel free to contact us at ServicesSolutions@powerschool.com to schedule a time to discuss your professional services needs
