Structured Solutions Educational Consulting, LLC
  • Home
  • About
  • Services
  • Workshops
  • Blog
  • Contact
  • Home
  • About
  • Services
  • Workshops
  • Blog
  • Contact
Search

Making the Most of Microsoft Excel

7/13/2020

0 Comments

 
I love a good spreadsheet. I mean, I really get excited about it. You may have read on the About page how my business evolved from the development of a really fancy spreadsheet. True story. Now I get to help others learn to use Excel to improve their work and watch them get excited about it too.

One positive thing to come out of the pandemic is an increased appetite for online professional development. Recently, I've gotten to connect with old friends and colleagues by providing a three-part Excel workshop series for the Family League of Baltimore. So on top of hanging out with my old network, I've gotten to teach them about all the fun stuff Excel can do. Win-win!

Here's an overview of the series:

Part 1: Excel Basics
A lot of educators just haven't been trained in how to use data. They may be consumers of it, using someone else's spreadsheet to glean information, but often, they just don't know how to utilize Excel's features for themselves. The Excel Basics workshop starts from the top and discusses formatting, functions, and formulas that beginners can use to build their Excel capacity. 

Part 2: Creating and Using Templates in Excel
In the engagement world, there is so much to track! This session built on what was covered in the Basics session and walked participants through the process of designing their own customized tracking sheets. We used breakout rooms to discuss how to track different topics, and we walked through some more advanced features and functions to make these tools as automated as possible.

Part 3: Reporting and Visualizing Data in Excel
Data visualization is a hot topic in evaluation right now, and I get why. When you're able to effectively show your data graphically, you can make your results accessible for a much wider audience. In this session, we talked about so many fun parts of Excel - PivotTables, creating charts and tables for reporting, and ... drumroll, please ... creating interactive dashboards! Did you know you can create dashboards like the one below to share with your team? 
Picture
Here's what some of my past workshop participants had to say about their experience: 
  • "Practical examples applicable to daily work. Presented at the right pace. Great content."
  • "My approach will be to allow my understanding of the various features to help me work smarter not harder. I am encouraged to continue to use excel, not run away from it."
  • "I feel more aware of how to efficiently organize my data! This will be helpful for reporting, and analyzing data for my own outreach strategies."
  • "I really enjoyed this session. They did a great job reaching participants of many levels."
​
Besides my obvious bias towards using Excel for ... well, everything ... I think it is even more important now for schools and districts to be effectively tracking their work. As we navigate through so many unknowns with school reopening, it will be critical to keep an eye on students who are at risk of falling through the cracks.

​Good news - Excel can help (and so can I!). 


I'd love to bring this workshop series to more places, so if your team could use a bit of an Excel boost, let's talk! 
0 Comments



Leave a Reply.

    About

    The goal of this blog is to highlight relevant issues that impact students, families, and communities and spark engaging discussions about how to address those issues through evaluation.

    Sign up here to receive blog posts in your email. 

    Categories

    All
    Attendance
    Barriers To Success
    Community Partnerships
    Community Schools
    Education
    Evaluation
    Family Engagement
    Inequality
    Microsoft Excel
    News And Media
    Opportunity
    Professional Learning
    Root Causes
    Social Capital
    Surveys

    Archives

    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    January 2019
    April 2018
    February 2018
    November 2017
    August 2017
    May 2017
    February 2017
    November 2016
    September 2016
    July 2016
    May 2016
    April 2016
    February 2016
    January 2016
    December 2015
    November 2015

    RSS Feed

Get in touch:

Free resources:

Download: 
Engage with Excel: Track Your Engagement Data in 4 Simple Steps

Join: 
Evidence for Engagement Mini-Course

Get insights and updates right in your inbox. 

Thank you!

You'll be hearing from me soon!

.
Photo used under Creative Commons from intoruth
  • Home
  • About
  • Services
  • Workshops
  • Blog
  • Contact